Explore BrainMass
Share

Creating multiple linear regressions

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 25, 2018, 8:41 am ad1c9bdddf
https://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.

$2.19
See Also This Related BrainMass Solution

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

View Full Posting Details