FlexPro
HistoryBase
Engineering
Training
Downloads
FlexPro-Support
Wissen
Community
Über Uns
Referenzen
Jobs
Allgemeiner Kontakt
Händlerverzeichnis
FlexPro-Support
DE
EN
FR
Placeholder
Produkte und Lösungen
Support und Downloads
Unternehmen
Magazin
Kontakt
Sprache
MyWeisang

Account Einstellungen

Topic

Error in standard deviation calculation

Startseite ' Community ' Allgemein ' Error in standard deviation calculation

Anzeigen von 4-Stellen - 1 bis 4 (von insgesamt 4)
  • Autor
    Beiträge
  • #34103
    Norbert Bakkers
    Teilnehmer

    When converting a standard deviation calculation (from the statistics menu) into a formula I noticed the following:
    The first part of the formula consists of ‘SQRT(n/(n-1))’, should this not be ‘SQRT(1/(n-1))’?

    #34106
    Norbert Bakkers
    Teilnehmer

    When converting a standard deviation calculation (from the statistics menu) into a formula I noticed the following:
    The first part of the formula consists of ‘SQRT(n/(n-1))’, should this not be ‘SQRT(1/(n-1))’?

    #34104
    Bernhard Kantz
    Teilnehmer

    The formula is correct. The standard deviation can be written in to forms. One uses a factor 1/(n-1) and the other one a factor n/(n-1). If you convert the first formula into the second formula, you make use of the equation Sum(X) = n * Mean(X). This is where the factor n comes in.

    #34105
    Norbert Bakkers
    Teilnehmer

    Thank you for the explanation, it makes perfect sense now. I also made a formula using the standard deviation equation I know and they did indeed give identical results

Anzeigen von 4-Stellen - 1 bis 4 (von insgesamt 4)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.