After running a multiple regression, we obtain the following ANOVA table:ANOVA
In the above table, some numbers in shaded cells are hidden and cells with “--“ have nonumbers originally. Hint: the significance F can be obtained using Excel function fdist (F, dfof regression, df of residual).Question:3-1: What percent of variance of the dependent variable is explained? Please show thedetailed steps.3-2: Do you think the model is acceptable at the 0.05 level? Please show the detailed steps.
3. After running a multiple regression, we obtain the following ANOVA table: ANOVA anovaDfSsMsFSignificance f Regression2 XXXXXXXXXXResidual XXXXXXXXXX----Total8------ In the above table, some numbers in shaded cells are hidden and cells with “--“ have no numbers originally. Hint: the significance F can be obtained using Excel function fdist (F, df of regression, df of residual). Question: 3-1: What percent of variance of the dependent variable is explained? Please show the detailed steps. 3-2: Do you think the model is acceptable at the 0.05 level? Please show the detailed steps.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here