Question

Statistics 300 L.C. Larsen Fall 2019 Name: Exam #3 of 4 (9 points: 10 minutes) 3. A random sample of 100 students at a large collene spent an average of $500 per semester on books, with a standard deviation of S200 The distribution of the 100 values for book money was bell-shaped. Use this information to make a confidence interval for the standard deviation of the amounts spent on books by all of the 48.000 students at the college. Expression (formula) Do any extra work here. Expression with values in place Final interval What EXCEL functions did you use? Based on your interval, is it reasonable for the college administration to say that the study shows that the "range" of student spending for books is limited to $400. Circle YES or NO and explain: YES Why? Γ NO

Answer 1

Expression is: CONFIDENCE.NORM(alpha,standard_dev,size) Expression with values in place A 1 CONFIDENCE.NORM (0.1,200, 100) 2 500-A1 3 -500+A1 The output is: 1 32.897 2 467.103 532.897 The confidence interval is 467.103 to 532.897 Excel function: CONFIDENCE.NORM No. Because the confidence interval does not contain 400 Good luck with your studies!!!