Exam 0/1 pts Question5 For Questions 5 and 6: Consider a two-taled test at the ?
ID: 2946621 • Letter: E
Question
Exam 0/1 pts Question5 For Questions 5 and 6: Consider a two-taled test at the ?-0.01 significance level, withan F test statistic of P test-2.03. numerator degrees of freedom df-35. and denominator degrees of freedom d-31. What Excel function should you use to calculate the p-value? 21 dist t2.03 35. 31 2t distrt2.03 33 35 1/ 1 pts Question 6 Suppose the Excel function from the previous question returned the p-ealue 0.04843. You should: ail to reject the nuil hypothesis and accept the alternative hwpothesis Reject the null hypothesis and accept the altemative hypotes Reject the null hypothesis and conclade that the alternative hypothersis is nsupported Fall to reject the null hypothesis and conclade that the alternative hypothesis is unsupported 8 4 8 2Explanation / Answer
Q 5) For two tail: F =2.03, df1= 35 and df2= 31
One tail P-value: F.DIST.RT(x,df1,df2) = F.DIST.RT(2.03,35,31)= 0.024216093(Only right tail)
Two tail P-value: 2*F.DIST.RT(x,df1,df2) = 2*F.DIST.RT(2.03,35,31)= 0.048432186(Two tail)
Q 6)At 0.01 significant level, fail to reject null hypothesis and alternative hypothesis is unsupported.
Because P-value is greater than significant value.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.