Question

eBook Video The exercise involving data in this and subsequent sections were designed to be solved using Excel The following estimated regression equation is based on 10 observations was presented. ý=29.1270+0.5906, +0.4980ry Here SST 6,891.125, SSR-6,315.000, 0.0848, and a-0.0634. a. Compute MSR and MSE (to 3 decimals). MSR MSE b. Compute the P test statistic (to 2 decimals). Use F table. What is the p-value? Select your answer At a 05, what is your conclusion? Select your answer c. Compute the t test statistic for the significance of B (to 2 decimals), Use t table. The p-value is Select your answer At a 05, what is your conclusion? Select your answer d. Compute the t test statistic for the significance of B (to 2 decimals). Use t table The p-value is Select your answer 05, what is your conclusion? At a Select your answer OAcen ry

Answer 1

Volation, The Holecoing alohen megression Cronion is halted Pescuired information is gi vorm) (051: 6841.105 GSR: 6915.000 (bis 0.0848 , Cb. 0.0694 ond, dogrelasion Erwelion is Во Р 1. P2 09.1010 +0.590621+ o.(19 801) Calculate in © Compute MSR and MOSES = = we have to oblained the MCR and MASE Values by eising I gilas lata is Stere. MSR is MSR GSR -0 MASR= dfk MOUSE- = sse - dFE SSE = 86T- CSR -6891.125 – 6315.000 CSSE - 576.1251

T= D- afk =RK = 10-1 -B-1 laft =9) (afkaa] and aft=n-k 10-3 dife = 1) - Then, tasks Egalta5 MOP - ASR afk 6315 Rask = 0157.5 MSE = dfe OSE 576.05 MUSE 80.30 Cherefore, MASR = 0157.5 MSE - 80-30 6 Compute Etest (statistici We have to Odained the F-test (Statistic 64 casing gilas data is,

Flest i 19CR Masc 80.30 IF - 138.136 ) - what is p. Valoir P- Vahel = [F-tast, dfk df c) [ 38.36.211) (pvalue = 0.0002 ] > AN=0.05 , cohat is your conclusion p Kakee and significance 250.05 IS coe have to compared (fer pokalu 0.0000 0 0.05 at 230.05. there is a coe rejected the call hypothesis Statistically significant. © Compute t-test it test statistic and blake Coe have to obtained the

tell Glaxdicis, There 0.5906 0.08018 11 B1 = 6.9646 ) + plado. As) p-valko = [+pu #ft) B = [6.9646, I f Vallee CO.000 ] -> AQ=0.05, what conclusion's p-value and significance level we have to compared the Q=0.05 ios Efere p-value <x 0.0002 0.05 supothesils at 2=0.05, thes Gtatilstically we rejected hull bypothesis Significanti @ Computer test (statistic + B2 i cue balé to oblained the test (Statistic thi is,

Cere (Sb Sb. 0.0980 0.0604 +B, = 7-85418 -> p-value is : plabus Chez, afe] =[7-85418, +J prake = 0.0002) - At dto. 05) what conclusions and 2=0.05 is, pualue we have to compared Gere, P-Calue 2 0.0001 x 0.05 Rejected bull bypothesis at 220.05, is this Statistically E = significant.