Statistics questions

angelface
Lesson12Examples15Excelversion-1.xlsx

#6

x P(x) xP(x) x^2P(X)
0 0 0 0
1 0 0 0
2 0.003 0.006 0.012
3 0.021 0.063 0.189
4 0.079 0.316 1.264
5 0.261 1.305 6.525
6 0.266 1.596 9.576
7 0.283 1.981 13.867
8 0.087 0.696 5.568
1.000 5.963 37.001
1.443631
1.2015119642

Examples 1 & 5

x P(x) x*P(x) (x^2)*P(x)
0 0.250 0.000 0.000
1 0.500 0.500 0.500
2 0.250 0.500 1.000
1.000 μ = 1.000 1.5 <-- sum of column E
(^ sum of σ2 = 0.5 <-- sum of column E - μ2
column D) σ = 0.7071067812 <-- standard deviation (square root of σ2)