Given the accompanying sample data, use Excel’s formula options to determine if the population mean is greater than 116 at the 5% significance level. Assume that the population is normally...

 Given the accompanying sample data, use Excel’s formula options to determine if the population mean is greater than 116 at the 5% significance level. Assume that the population is normally distributed.

Extracted text: A В E F G H K 105 HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS UNKNOWN 117 112 Given the accompanying sample data, use Excel's formula options to determine if the population mean is greater than 116 at the 5% significance level. Assume that the population is normally distributed. 148 144 106 124 Complete the following analysis. Do not hard code values in your calculations. Use E9 thru E12 and A1:A20 to compute the values 137 Но: иS На: и> 116 116 0.05 20 128 133 107 a = 123 n = 108 106 Sample Mean Mean can only be calculated using values in cells A1 through A20 138 121 Std Deviation Mean can only be calculated using values in cells A1 through A20 129 130 t test Statistic t Statistic can only be calculated using E9, E10, E11, E12, E14, and E16 102 141 p value Compute the probability that t is greater than the t test Statistic. Conclusion Since the p-value is > 0.05, we do not reject Ho. At the 5% significance level the population mean is less than or equal to 116. Since the p-value is < 0.05, we reject ho. at the 5% significance level the population mean is greater than to 116. sheet1 0.05,="" we="" reject="" ho.="" at="" the="" 5%="" significance="" level="" the="" population="" mean="" is="" greater="" than="" to="" 116.="">