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 October 17, 2018, 11:41 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.
Use of Simple-Linear and Multiple Regression Analysis
1. Can you think of an example where analysis of simple-linear and multiple regression analysis can be used? How is regression analysis being used in the financial industry, or how should it be used to formulate strategies?
2. What are examples in which regression analysis is used for forecasting?
3. What is correlation analysis? How can correlation analysis be used in a business decision or examples specifically related to strategy formulation and implementation?
4. What are some primary and secondary sources of data that may be used in correlation and regression analysis?
5. What is the difference between correlation and causation? Give examples