Question 1 - USE EXCEL OUTPUT a. Whatare the null and alternative hypotheses? b. At a 90% confidence level, what is the value of alpha (ª), c. What is the critical value (CV comes from the Excel...


Question 1 - USE EXCEL OUTPUT


a. Whatare the null and alternative hypotheses?


b. At a 90% confidence level, what is the value of alpha (ª),


c. What is the critical value (CV comes from the Excel outputbelow)


d. What is the value of the test statistic (from the Excel outputbelow)


e. What is the p-value associated with the sample statistic?(from the Excel outputbelow)


f. Compare PV to alpha (include values in comparison) and TS to CV (include values from output in your comparison)


g. What is your Decision? (reject/fail to reject Ho)h.What is your conclusion (in everyday terms)


Use the Excel Output below to answer the questions above for Part I<br>Excel Output<br>t-Test: Two-Sample Assuming Unequal Variances<br>With<br>No Pool<br>Рol<br>Mean<br>204.1316 231.4851<br>Variance<br>1305.727 2557.258<br>Observations<br>38<br>67<br>Hypothesized Mean Difference<br>df<br>97<br>t Stat<br>P(T<=t) one-tail<br>t Critical one-tail<br>P(T<=t) two-tail<br>t Critical two-tail<br>-3.21186<br>0.000895<br>1.29034<br>0.00179<br>1.660715<br>

Extracted text: Use the Excel Output below to answer the questions above for Part I Excel Output t-Test: Two-Sample Assuming Unequal Variances With No Pool Рol Mean 204.1316 231.4851 Variance 1305.727 2557.258 Observations 38 67 Hypothesized Mean Difference df 97 t Stat P(T<=t) one-tail="" t="" critical="" one-tail=""><=t) two-tail="" t="" critical="" two-tail="" -3.21186="" 0.000895="" 1.29034="" 0.00179="">

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here