This question is using excel- testing a population mean I’m not to worried about

Question

This question is using excel- testing a population mean

I’m not to worried about the explanation because when submitted Aplia gives me an explanation for each question. There’s a total of 10 Questions to be answered

Here are the choices Aplia provides me with for the three blank spaces at the end of the document.

The p value is _______ A) greater B) Less

Therefore, you_____ A) cannot B) can

Null hypothesis and you_______ A) cannot B) can

Please answer correctly I know its a hard question but I need the corect formulas to calculate each of the following using excel

Also I left an example for the options on p-value(two Tail) on the document.

Please and thank you having a hard time with this problem.

1 Horizontal Error, Hypothesis Test about a Population Mean: 0.0091 0.0036 0.0288 0.0193 0.0012 0.0019 0.0052 0.0033 0.0072 0.0101 Known Case Sample Size Sample Mean 4 Population Standard Deviation Hypothesized Value 0.008 10 Standard Error Test Statistic z 12 p-value (Lower Tail) p-value (Upper Tail) p-value (Two Tail) 13 15 2*(MIN(D13,D14)) =D14-1 16 T.DIST(D11,D12,TRUE) MIN(D14,D15) 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 = 0.05: Ho: = The p-value is conclude the sighting mechanism, on average, is hitting off target. than = 0.05. Therefore, you reject the null hypothesis and you

Explanation / Answer

not enough information.

in order to answer the D15, other parts are needed .

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.