| lower | upper | p | Oi | EI | (Oi- Ei)^2/Ei |
| 0 | 90 | 0.252493 | 10 | 25.24925 | 9.209767 |
| 90 | 100 | 0.247507 | 18 | 24.75075 | 1.841261 |
| 100 | 110 | 0.247507 | 23 | 24.75075 | 0.123839 |
| 110 | 120 | 0.161281 | 22 | 16.12813 | 2.137807 |
| 120 | 130 | 0.068461 | 18 | 6.846109 | 18.17226 |
| 130 | 10000 | 0.02275 | 9 | 2.275013 | 19.8792 |
| 1 | 100 | 100 | 51.36414 |
Formula in Excel
| lower | upper | p | Oi | EI | (Oi- Ei)^2/Ei |
| 0 | 90 | =NORMDIST(B2,100,15,1)-NORMDIST(A2,100,15,1) | 10 | =100*C2 | =(D2-E2)^2/E2 |
| =B2 | =10+B2 | =NORMDIST(B3,100,15,1)-NORMDIST(A3,100,15,1) | 18 | =100*C3 | =(D3-E3)^2/E3 |
| =B3 | =10+B3 | =NORMDIST(B4,100,15,1)-NORMDIST(A4,100,15,1) | 23 | =100*C4 | =(D4-E4)^2/E4 |
| =B4 | =10+B4 | =NORMDIST(B5,100,15,1)-NORMDIST(A5,100,15,1) | 22 | =100*C5 | =(D5-E5)^2/E5 |
| =B5 | =10+B5 | =NORMDIST(B6,100,15,1)-NORMDIST(A6,100,15,1) | 18 | =100*C6 | =(D6-E6)^2/E6 |
| =B6 | 10000 | =NORMDIST(B7,100,15,1)-NORMDIST(A7,100,15,1) | 9 | =100*C7 | =(D7-E7)^2/E7 |
| =SUM(C2:C7) | =SUM(D2:D7) | =SUM(E2:E7) | =SUM(F2:F7) |
df = 5
critical value = =CHISQ.INV.RT(0.05,5)
| 11.0705 |
since TS = 51.364 > critical value (11.07)
we reject the null hypothesis
we conclude that there is evidence that data does not follow N(100,15^2)
2.10 It is often assumed that the L.Q. scores of human beings are Normally distributed. On...
2.12 On the basis of the following scores, appropriately taken, test whether there are gender-associated differences in mathematical ability (as is often claimed!). Take α 0.05, and use the appropriate χ 2 goodness-of-fit test. Boys: 80969887 7583 7092 9782 Girls: | 82 | 90 | 84 | 70 | 80 | 97 | 76 | 90 | 88 | 86 Hint. Group the grades into the following intervals: [70, 75), [75, 80), [80, 85), [85, 90), [90, 95), [95, 100),...
1.) The scores for the final exam in Math 2250 is normally distributed with a mean of 60 and standard deviation of 15. Given that 120 students wrote the final exam, i.) State and test the hypothesis that the mean score is greater than 65 at a 10% level of significance. Include a p-value in your answer. 141 ii.) Construct and interpret 90% confidence level for the mean score. [3] Using the same level of significance, determine how many students...
Two processes for manufacturing large roller bearings are under study. In both cases, the diameters (in centimeters) are being examined. A random sample of 26 roller bearings from the old manufacturing process showed the sample variance of diameters to be s2 = 0.231. Another random sample of 28 roller bearings from the new manufacturing process showed the sample variance of their diameters to be s2 = 0.146. Use a 5% level of significance to test the claim that there is...
Suppose we toss a coin 100 times and get 48 heads. Clearly pˆ = X¯ = 0.48 A) Derive the (large sample) confidence interval for p, assuming the confidence level is 90% B) Test whether it is a fair coin assuming the significance level α = 0.05. Please write down the null hypothesis, the alternative hypothesis and the test statistics.
To test the efficacy of three different brands of fertilizer, you grow seedlings on each of the brands, plus a control with no fertilizer, for a total of four treatments. At the end of two months, you weigh each seedling. Here are the data, in grams: fertilizer A fertilizer B fertilizer C control 12 15 11 9 15 16 13 11 11 14 17 10 14 18 14 13 12 18 12 9 14 13 14 11 The question of...
Assume that the differences are normally distributed. Complete parts (a) through (d) below Observation 1 2 3 45 678 44.1 52.2 44.5 483 433 516 522438 45.2 537 48.7 534 45.1 548 533459 (a) Determine d X-Y for each pair of data Observation 34567 (Type integers or decimals.) (b) Compute d and sa d(Round to three decimal places as needed) sa Round to three decimal places as needed.) (c) Test if Ha 0 at the a 0.05 level of significance...
Suppose that you are testing the following hypotheses: Ho: = 10 and 11: > 10. If the null hypothesis is rejected at the 1% level of significance, what statement can you make about the confidence interval on the mean? a) The lower bound of a 95% one-sided confidence interval on the mean exceeds 10. b) 9 sus 13 c) No statement can be made. d) The lower bound of a 95% one-sided confidence interval on the mean exceeds zero. If...
Bonus (5 points) Suppose that you are testing the following hypotheses: Ho: 4 = 10 and H :> 10. If the null hypothesis is rejected at the 1% level of significance, what statement can you make about the confidence interval on the mean? a) The lower bound of a 95% one-sided confidence interval on the mean exceeds 10. b) 9 <u< 13 c) No statement can be made. d) The lower bound of a 95% one-sided confidence interval on the...
Professor Fair believes that extra time does not improve grades on exams. He randomly divided a group of 300 students into two groups and gave them all the same test. One group had exactly 1 hour in which to finish the test, and the other group could stay as long as desired. The results are shown in the following table. Test at the 0.01 level of significance that time to complete a test and test results are independent. Time A...
Question Completion Status: QUESTION 2 The Null Hypothesis (HO): O The two categorical variables are independent Op1 = P2 = ... = Pg, where g = 4 Homogeneity of distribution of a categorical response Goodness-of-fit test QUESTION 3 Significance level: a = a=0.05 Which test statistic would we use for the test? X-MO 2 = P - Po po(1-P) F = t= MSG MSE x-1 (0-1) E s/n (a) 72 (b) (c) (d) O 1.a O2.b O3.c 04.0 QUESTION 4...