QUESTION 16NewLast YearSample SizeSample MeanSample Standard Deviation363677.888969.611114.11546.9004df50Confidence Interval (in terms of New - Last Year)Confidence Coefficient0.80Lower Limit4.8769Upper Limit11.6786Hypothesis Test (in terms of New - Last Year)Hypothesized ValueTest Statistic3.1611p-value (Lower Tail)p-value (Upper Tail)p-value (Two Tail)New - Last YearSample Size36Cample Meanסרל 0"lick Save and Submit to save and submit. Click Save All Answers to save all answers.MacBo seconds.Question Completion Status:Sample SizeSample MeanSample Standard Deviation368.277817.1591Confidence Interval (in terms of New - Last Year)Confidence Coefficient0.80Lower Limit4.5422Upper Limit12.0133Hypothesis Test (in terms of New - Last Year)Hypothesized ValueTest Statistic2.8945p-value (Lower Tail)p-value (Upper Tail)p-value (Two Tail)IBM is interested in comparing the average project completion time using last year's software versus using the new software. So, a ceselected 36 projects using last year's software and 36 projects using the new software. The completion time (in hours) for each projeentered into Excel. Can IBM conclude the average project completion time using the new software is greater than the average projecyear's software at a=.025? Based on this paragraph of text, use the correct excel output above to answer the following question.What would the P-value be for Ha: PLast Year - PNew < 0?a. .995 < P-value <.9975b. .9975 < P-value < ,999C. None of the answers is correctd. .0025 < P-value < .005e. .001 < P-value <.0025* Save and Submit to save and submit. Click Save All Answers to save all answers.MacBook Air

Name: QUESTION 16NewLast YearSample SizeSample MeanSample Standard Deviatio
Uploaded: 2024-03-20T07:06:41.000Z
Channel: Bartleby
Description: QUESTION 16NewLast YearSample SizeSample MeanSample Standard Deviation363677.888969.611114.11546.9004df50Confidence Interval (in terms of New - Last Year)Confidence Coefficient0.80Lower Limit4.8769Upper Limit11.6786Hypothesis Test (in terms of New -

Given: Test statistic for New - Last year= 3.1611 α=0.025 df = 50Here, the null and alternate hypotheses are H0 : μLast year-μNew≥0Ha : μLast year-μNew<0 Thus, the test value for last year - New will be - 3.1611 (reversing ) The test is left tailed. So, P value will be P (tdf < test value) Using Excel to find p value Looking from the given options, the p value will lie between 0.001 and 0.0025 Option e is the correct choice