A В E F G H K L M 105 HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN 117 Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125...


 Given the accompanying sample data, use Excel’s formula options to find the 90% confidence interval for the population mean. Assume that the population is normally distributed.



Can someone please explain to me what to input!


A<br>В<br>E<br>F<br>G<br>H<br>K<br>L<br>M<br>105<br>HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN<br>117<br>Given the accompanying sample data, use Excel's formula options to determine if the<br>population mean is less than 125 at the 5% significance level. Assume that the population is<br>normally distributed and that the population standard deviation equals 12.<br>112<br>148<br>144<br>106<br>124<br>Complete the following analysis. Do not hard code values in your calculations.<br>137<br>Но: и2<br>Ha: u <<br>125<br>125<br>0.05<br>12<br>20<br>128<br>133<br>1<br>107<br>a =<br>123<br>108<br>n =<br>4<br>106<br>138<br>Sample Mean<br>Mean can only be calculated using values in cells A1 through A20<br>121<br>129<br>Z test Statistic<br>Z Statistic can only be calculated using E9, E10, E11, E12, E13, and E15<br>130<br>102<br>p value<br>Compute the probability that Z is less than the Z Statistic.<br>141<br>1<br>Conclusion<br>P.<br>

Extracted text: A В E F G H K L M 105 HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN 117 Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125 at the 5% significance level. Assume that the population is normally distributed and that the population standard deviation equals 12. 112 148 144 106 124 Complete the following analysis. Do not hard code values in your calculations. 137 Но: и2 Ha: u < 125="" 125="" 0.05="" 12="" 20="" 128="" 133="" 1="" 107="" a="123" 108="" n="4" 106="" 138="" sample="" mean="" mean="" can="" only="" be="" calculated="" using="" values="" in="" cells="" a1="" through="" a20="" 121="" 129="" z="" test="" statistic="" z="" statistic="" can="" only="" be="" calculated="" using="" e9,="" e10,="" e11,="" e12,="" e13,="" and="" e15="" 130="" 102="" p="" value="" compute="" the="" probability="" that="" z="" is="" less="" than="" the="" z="" statistic.="" 141="" 1="" conclusion="">

Jun 01, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here