{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

NormalDistribution

# NormalDistribution - 3 14 0 2 1 8 3 4 5 6 6 8 2 9 8 11 4 13...

This preview shows pages 1–3. Sign up to view the full content.

©  2004  Vertex42, LLC Wittwer, J. W., "Graphing a Normal Distribution in Excel" From Vertex42.com, November 1, 2004 10 Generate Random Normal 2 NORMINV(rand(),mean,standard_dev) 6.2 Graph Limits -4 Cumulative Probability 4 8 11 15.87% 30.85% 53.28% z x F(x) -4 2 0 0 -3.8 2.4 0 0 -3.6 2.8 0 0 -3.4 3.2 0 0 -3.2 3.6 0 0 Cumulative Probability Graph -3 4 0 0 -2.8 4.4 0 0 z -0.88 39 -2.6 4.8 0.01 0 x 8.24 -2.4 5.2 0.01 0.01 F(x) 18.94% -2.2 5.6 0.02 0.01 -2 6 0.03 0.02 -1.8 6.4 0.04 0.04 -1.6 6.8 0.06 0.05 -1.4 7.2 0.07 0.08 -1.2 7.6 0.1 0.12 -1 8 0.12 0.16 -0.8 8.4 0.14 0.21 -0.6 8.8 0.17 0.27 -0.4 9.2 0.18 0.34 -0.2 9.6 0.2 0.42 0 10 0.2 0.5 0.2 10.4 0.2 0.58 0.4 10.8 0.18 0.66 0.6 11.2 0.17 0.73 0.8 11.6 0.14 0.79 1 12 0.12 0.84 1.2 12.4 0.1 0.88 1.4 12.8 0.07 0.92 1.6 13.2 0.06 0.95 1.8 13.6 0.04 0.96 2 14 0.03 0.98 Normal  Distribution http://vertex42.com/ExcelArt Mean,  μ Standard Deviation,  σ z min z max x min x max Pr(x<x min ) Pr(x>x max ) Pr(x min <x<x max ) f ( x ) Graphics 1 2 2 2 ) ( 2 2 1 ) ( σ μ π σ - - = x e x f σ μ - = x z 0.05 0.1 0.15 0.2 0.25 0.2 0.4 0.6 0.8 1 Normal (Gaussian) Distribution ability Density ative Probability 0 2 4 6 8 10 12 0 0.05 0.1 0.15 0.2 0.25 0 2 4 6 8 10 12 14 0 0.05 0.1 0.15 0.2 0.25 18.94% Probability Density 0 2 4 6 8 10 12 0 0.05 0.1 0.15 0.2 0.25

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2.2 14.4 0.02 0.99 2.4 14.8 0.01 0.99 2.6 15.2 0.01 1 2.8 15.6 0 1 3 16 0 1 3.2 16.4 0 1 3.4 16.8 0 1 3.6 17.2 0 1 3.8 17.6 0 1 4 18 0 1 z x F(x) -4 2 0 2.15 0 2.3 0 2.45 0 2.6 0 2.75 0 2.9 0 3.05 0 3.2 0 3.35 0 3.5 0 3.65 0 3.8 0 3.95 0 4.1 0 4.25
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}