Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
coefficient std. error t-ratio p-value const 1.4620 0.2535 5.7661 0.0000 X1 -0.0681 0.1580 -0.4310 0.6678 X2 0.7567 0.1415 5.3464 0.0000 Mean...
Q5: The regression model：Yi=β0+β1X1i+β2X2i+ui has been estimated using Gretl. The output is below.
Model 1: OLS, using observations 1-72
Use EXCEL to build a complete "ANOVA" table for this regression (including the columns for 'Sum of squares', 'df' and 'Mean square'). In your answer, you should present the ANOVA table and show all your working.
coefficient std. error t-ratio p-valueconst1.46200.2535 5.7661 0.0000X1-0.06810.1580 -0.4310 0.6678X20.75670.1415 5.3464 0.0000Mean dependent var 1.54S.D. dependent var2.46323Sum squared resid304.55 S.E. of regression2.1009R-squared0.29305 Adjusted R-squared 0.27256F(2, 69)14.301 P-value(F)1e-05Log-likelihood154.08 Akaike criterion314.16Schwarz criterion320.99 Hannan-Quinn316.88