Creating multiple linear regressions
Using the data in the Excel file "Home Market Value," develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 square feet and a 95% prediction interval for a house that is 30 years old with 1,800 square feet.
© BrainMass Inc. brainmass.com March 22, 2019, 1:44 am ad1c9bdddfhttps://brainmass.com/statistics/descriptive-statistics/creating-multiple-linear-regressions-549076
Attachments
Solution Preview
Please see the attachments.
Creating multiple linear regressions
Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 square feet and a 95% prediction interval for a house that is 30 years old with 1,800 square feet.
Answer
The estimated regression equation is given by,
Home Market Value = 47331.3815 - 825.1612 * House Age + 40.9111 * Square Feet
Details
Coefficients Standard ...
Solution Summary
The expert creates multiple linear regressions.