(49) using the data below answer the following questions 1. Write the regression
ID: 3430979 • Letter: #
Question
(49) using the data below answer the following questions 1. Write the regression equation. 2. Interpret the regression constant and regression coefficient, 3. Forecast a value for the dependent variable,4 Test the significance of the regression coefficient at an alpha level of .05, 5.Test the overall significance of the regression model,6. Interpret the coefficient of determination 7.Are there any indications of violations of the general linear model? You must address each assumption separately and explain. Yes and no answers are unacceptable.(must use excel or minitab)
recent family home sales in San Antonio provided the following data
Square footage price$
1580 142500
1572 145000
1352 115000
2224 155900
1556 95000
1435 128000
1438 100000
1089 55000
1941 142000
1698 115000
1539 115000
1364 105000
1979 155000
2183 132000
2096 140000
1400 85000
2372 145000
1752 155000
1386 80000
1163 100000
Explanation / Answer
1. Write the regression equation.
price$ =22,635.9491 +58.9595*Square footage
-------------------------------------------------------------------------------------------------------------
2. Interpret the regression constant and regression coefficient,
There is no meaningful for the regression constant.
When the regression coefficient increases, the regression line increases.
-------------------------------------------------------------------------------------------------------------
3. Forecast a value for the dependent variable,
22,635.9491 +58.9595*1400=105179.2
-------------------------------------------------------------------------------------------------------------
4 Test the significance of the regression coefficient at an alpha level of .05,
Since the p-value of Square footage variable is less than 0.05, we can conclude that the regression coefficient is significant.
-------------------------------------------------------------------------------------------------------------
5.Test the overall significance of the regression model,
Since the p-value of F test is less than 0.05, we can conclude that the regression model is significant.
-------------------------------------------------------------------------------------------------------------
6. Interpret the coefficient of determination
R^2=0.5695
56.95% of variance can be explained by the regression line.
-------------------------------------------------------------------------------------------------------------
7.Are there any indications of violations of the general linear model? You must address each assumption separately and explain.
Assume:
Regression output confidence interval variables coefficients std. error t (df=18) p-value 95% lower 95% upper Intercept 22,635.9491 20,460.0712 1.106 .2831 -20,349.0653 65,620.9636 Square footage 58.9595 12.0814 4.880 .0001 33.5775 84.3416Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.