Question

Please help with solving this population mean problem.

Note: The function STDEV is used for Excel versions 2007 and earlier. For later versions, STDEV was replaced by STDEV.S. However, STDEV can still be used in later versions of Excel. Similarly, TDIST and NORM SDIST were replaced by T.DIST and NORM.S.DIST. 1 AB Vertical Error, x Hypothesis Test about a Population Mean: 0.0101 o Unknown Case 0.0003 0.0029 Sample Size -0.0186 Sample Mean 0.001 Sample Standard Deviation 0.0072 Hypothesized Value -0.0026 Standard Error 0.0115 Test Statistic t 0.0067 Degrees of Freedom 0 = D4-1 p-value (Lower Tail) p-value (Upper Tail) p-value (Two Tail) =1-01 Suppose the rifle manufacturer suspects that the sighting mechanism, on average, is hitting off target. Use the values produced by the proper formulas in your Excel sheet to conduct the following hypothesis test at a significance level of a = 0.05: Ho: p = 0 Ha: H 0 reject the null hypothesis and you The p-value is than a = 0.05. Therefore, you conclude the sighting mechanism, on average, is hitting off target.

Answer 1

ST the given deta... Sample size, n=10 Sample mean, n = 0.00 18 Sample std deviation S= 0.008 61 Standald Error 0.002719 Test statistic - t- - M - SE t = 0.662 of freedom - no1-9 P-value for two-tailed test = 0.5246 the p-value is less than a 60.05), che fail to reject Ho...