write my assignment 3869

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