7) Below is a multiple regression in which the dependent variable is market value of houses and the independent variables are the age of the house and square footage of the house. The regression was estimated for 42 houses. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total df 2 39 41 0.745495 0.555762 0.532981 7211.848 42 SS 2537650171 2028419591 4566069762 MS 1.27E+09 52010759 Coefficients Standard Error F 24.39544 t Stat P-value Lower 95% Upper 95% Intercept 47331.38 13884.34664 3.408974 0.001528 19247.6673 75415.0958 House Age -825.161 607.3128421 -1.35871 0.182046 -2053.5662 403.243744 Square Feet 40.91107 6.696523994 6.109299 3.65E-07 27.3660835 54.4560534 7A. What is the estimated regression equation for determining the market value of houses? 7B. Discuss tests of significance of the regression 7C. What percentage of the variation in the dependent variable, Market Value, is explained by the regression model? Significance F 1.3443E-07 7D. If the age of a house increases by 1 year given that the square feet is held constant, what is the impact on the house's market value?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
7) Below is a multiple regression in which the dependent variable is market value of houses and
the independent variables are the age of the house and square footage of the house. The
regression was estimated for 42 houses.
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Regression
Residual
Total
df
2
39
41
0.745495
0.555762
0.532981
7211.848
42
SS
2537650171
2028419591
4566069762
Coefficients Standard
Error
MS
1.27E+09
52010759
F
24.39544
Significance F
1.3443E-07
Upper 95%
t Stat
P-value Lower 95%
Intercept 47331.38 13884.34664 3.408974 0.001528 19247.6673
House Age -825.161 607.3128421 -1.35871 0.182046 -2053.5662
Square Feet 40.91107 6.696523994 6.109299 3.65E-07 27.3660835
7A. What is the estimated regression equation for determining the market value of houses?
7B. Discuss tests of significance of the regression
7C. What percentage of the variation in the dependent variable, Market Value, is explained by
the regression model?
75415.0958
403.243744
54.4560534
7D. If the age of a house increases by 1 year given that the square feet is held constant, what is
the impact on the house's market value?
Transcribed Image Text:7) Below is a multiple regression in which the dependent variable is market value of houses and the independent variables are the age of the house and square footage of the house. The regression was estimated for 42 houses. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total df 2 39 41 0.745495 0.555762 0.532981 7211.848 42 SS 2537650171 2028419591 4566069762 Coefficients Standard Error MS 1.27E+09 52010759 F 24.39544 Significance F 1.3443E-07 Upper 95% t Stat P-value Lower 95% Intercept 47331.38 13884.34664 3.408974 0.001528 19247.6673 House Age -825.161 607.3128421 -1.35871 0.182046 -2053.5662 Square Feet 40.91107 6.696523994 6.109299 3.65E-07 27.3660835 7A. What is the estimated regression equation for determining the market value of houses? 7B. Discuss tests of significance of the regression 7C. What percentage of the variation in the dependent variable, Market Value, is explained by the regression model? 75415.0958 403.243744 54.4560534 7D. If the age of a house increases by 1 year given that the square feet is held constant, what is the impact on the house's market value?
Expert Solution
Step 1: Define the variables

7A.

The independent variables are House Age, and Square Feet.

The dependent variable is the market value of houses.

steps

Step by step

Solved in 6 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman