Exhibit 2 shows the MS EXCEL output for a hypothesis testing of the difference b
ID: 3320584 • Letter: E
Question
Exhibit 2 shows the MS EXCEL output for a hypothesis testing of the difference between two population means with unknown population standard deviation and (alpha)=0.05.
Please answer Question 27-30.
27. For some reason, the number of Sample 1’s observations is missing. Could you obtain the number from the other information provided in the output?
Yes, the number is 10.
Yes, the number is 12.
Yes, the number is 14.
No. It must be given.
28. If the test is two-tailed, can you reject the null hypothesis?
Yes.
No.
I cannot answer it because the t critical value for two-tailed test is missing.
I cannot answer it because we don’t have the hypotheses.
29. If the test is one-tailed, can you reject the null hypothesis?
A. Yes.
No.
It will depend on the test is right-tailed or left-tailed.
I cannot answer it because the t critical value for two-tailed test is missing.
30
Can you get the missing value of t critical two-tail value without MS EXCEL operation?
No. Excel operation is necessary.
Yes, it should be 2*(1.710882316).
Yes, it should be 2.797.
Yes, it should be 2.064.
t-Test: Two-Sample Assuming Unequal Variances Sample 1 Sample 2 Mean 30.51666667 27 Variance 11.20515152 6.975384615 Observations ? 14 Pooled Variance 8.914027778 Hypothesized Mean Difference 0 Df 24 t Stat 2.994071589 P(T<=t) one-tail 0.00314687 t Critical one-tail 1.710882316 P(T<=t) two-tail 0.00629374 t Critical two-tail ?Explanation / Answer
27. Given total degrees of freedom = 24
Hence,
n1 + n2 - 2 = 24
n1 + 14 - 2 = 24
n1 = 24 - 12
n1 = 12
Option B is correct.
28. p - value for two tail = 0.006 < 0.05,
Hence,
Yes, we can reject Ho.
Option A is correct.
29. p - Value = 0.003 < 0.5
Hence,
Yes, we can reject Ho.
Option A is correct.
30. Yes, it should be 2.064.
Option D is correct.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.