JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,676
- Office Version
- 365
- Platform
- Windows
What is the formula for calculating the maximum value of normal distribution given the std dev?
The tables below generate several normal distributions with different standard deviations. Each generates a different maximum.
The bigger the std dev, the smaller the maximum. This leads me to wonder if the maximum is caluclated so that the total area under the curve equals 1.
Thanks
The tables below generate several normal distributions with different standard deviations. Each generates a different maximum.
The bigger the std dev, the smaller the maximum. This leads me to wonder if the maximum is caluclated so that the total area under the curve equals 1.
Thanks
Cell Formulas | ||
---|---|---|
Range | Formula | |
D4:G4 | D4 | =MAX(D$5:D$25) |
D5:G25 | D5 | =NORM.DIST($C5,D$2,D$3,FALSE) |
C6:C25 | C6 | =C5+1 |