this has to be done in excel Complete the chi-square test and analysis in Excel,

Question

this has to be done in excel

Complete the chi-square test and analysis in Excel, using the data provided in the assignment. Assume 10 equally spaced intervals over the range of 0 to 100. Assume the data are IID,

the data points are the following

23.79
29.72
94.96
30.45
12.46
35.25
14.89
50.95
51.95
65.36
75.51
84.69
22.68
69.64
8.42
80.75
54.8
40.47
65.45
34.27
29.89
45.66
86.99
17.09
65.57
94.62
95.37
90.58
11.17
66.53
2.47
61.46
90.84
33.87
96.72
95.83
93.76
37.95
32.58
78.64
32.37
67.23
56.49
98.04
33.56
38.07
83.64
62.42
85.89
58.24

50 sample sample that represents the time (in seconds) a hematology cell ide Cs takes to complete a test on a blood sam counter 75.51 29.89 23.79 29.72 94.96 30.45 2.47 61.46 90.84 33.87 96.72 95.83 93.76 37.95 32.58 78.64 84.69 22.68 69.64 8.42 80.75 45.66 86.99 17.09 65.57 94.62 95.37 90.58 32.37 67.23 56.49 98.04 33.56 38.07 83.64 62.42 85.89 58.24 12.46 35.25 54.80 14.89 50.95 51.95 65.36 40.47 65.45 34.27 66.53 that these data are drawn from a uniform distribution at a 95% Test the hypothesis confidence level, given the following information: (a) The interval of the distribution is between 0 and 100. (b) The interval of the distribution is between a and b, where a and b are unknown parameters

Explanation / Answer

p-value = 0.122 > 0.05

hence we fail to reject the null and conclude that the data follow uniform distribution

Oi Ei (Oi-Ei)^2/Ei 0-10 2 5 1.8 10-.20 4 5 0.2 20-30 4 5 0.2 30-40 9 5 3.2 40-50 2 5 1.8 50-60 5 5 0 60-70 8 5 1.8 70-80 2 5 1.8 80-90 5 5 0 90-100 9 5 3.2 0 50 50 14 critical value 16.9189776 p-value 0.122325228

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.