Question: x i Frequency Relative Frequency (Probability) x i * P(x i ) x i - E(x) (x i - E(x))^2 (x i - E(x))^2* P(x)

xi Frequency Relative Frequency (Probability) xi* P(xi) xi- E(x) (xi- E(x))^2 (xi- E(x))^2* P(x)
1 13 0.0619
2 12 0.0571
3 9 0.0429
4 15 0.0714
5 32 0.1524
6 24 0.1143
7 21 0.1000
8 5 0.0238
9 11 0.0524
10 17 0.0810
11 11 0.0524
12 1 0.0048
13 2 0.0095
14 1 0.0048
15 4 0.0190
16 0 0.0000
17 10 0.0476
18 2 0.0095
19 8 0.0381
20 2 0.0095
21 6 0.0286
22 4 0.0190
12. In cell I72, find the expected frequency (average) using the data ranges B49:B70 and D49:D70.
13. In cells F49:F70, find xi- E(x).
14. In cells G49:G70, square the values in cells F49:F70.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!