1 -9| CONFIDENCE INTERVAL FOR μ WHEN σ IS UNKNOWN 2 5 3 8 4 -4 5 -7 6 -10 7 8 Given the accompanying sample data, use Excel's formula options to find the 99% confidence interval for the population mean. Assume that the population is normally distributed. Complete the following analysis. Do not hard code values in your calculations. 8 -3 9 -2 Confidence Coefficient 10 -1 Sample Size n 11 -6 df 0.99 20 19 12 4 a/2 0.005 13 -4 14 8 15 4 Lower Limit of Confidence Interval Compute the lower limit of the confidence Interval using A1:A20, E10, E11, AND E12. 16 6 17 -7 Upper Limit of Confidence Interval Compute the upper limit of the confidence Interval using A1:A20, E10, E11, and E12. 18 -6 19 1 20 10

1 -9| CONFIDENCE INTERVAL FOR μ WHEN σ IS UNKNOWN 2 5 3 8 4 -4 5 -7 6 -10 7 8 Given the accompanying sample data, use Excel's formula options to find the 99% confidence interval for the population mean. Assume that the population is normally distributed. Complete the following analysis. Do not hard code values in your calculations. 8 -3 9 -2 Confidence Coefficient 10 -1 Sample Size n 11 -6 df 0.99 20 19 12 4 a/2 0.005 13 -4 14 8 15 4 Lower Limit of Confidence Interval Compute the lower limit of the confidence Interval using A1:A20, E10, E11, AND E12. 16 6 17 -7 Upper Limit of Confidence Interval Compute the upper limit of the confidence Interval using A1:A20, E10, E11, and E12. 18 -6 19 1 20 10

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.3: Measures Of Spread

Problem 26PFA

See similar textbooks