Question

Perform the Overall F-test to show that your model is not a good fit using the following data

subject's height (Y)	mother's height (x1)	father's height (x2)
64	66	70
64	61	69
67	60	69
63	64	70
66	64	72
75	66	71
67	61	69
64	65	65
74	69	69
72	63	72

Answer 1

Answer Date: 10/04/2019 To test the hypothesis is that the overall regression model is significant at 5% level of significance. The null and alternative hypothesis is, The F-test statistics is, By using Excel software, find F-test statistics with the help of following steps: 1) Import the data. 2) Select Data Analysis from Data menu. 3) Select Regression and click Ok. 4)Input Y Range and Input X range. 5) Click Ok.

ANOVA df MS F SignificanceF Regression Residual Total 2 55.70429061 27.85215 1.589013 0.269786889 7 122.6957094 17.52796 9 178.4000000 From the Excel output, the F-test statistics is |1.59 Thep-value for this test is From the Excel output, thep value for this test is [0.2698 Decision The conclusion is that p-value in this context is higher than 0.05 which is 0.2698, so the null hypothesis is not rejected at 5% level of significance. There is insufficient evidence to indicate that the overall regression model is significant. The result is not statistically significant. So, the regression model is not good fit