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. Predict the value of a house that is 30 years old and has 1,800 square feet, and one that is 5 years old and has 2,800 square feet.
- The Excel file Cereal Data provides a variety of nutritional information about 67 cereals and their shelf location in a supermarket. Use regression analysis to find the best model that explains the relationship between calories and the other continuous variables. Try taking out the non-significant predictors one by one. Which model is the most parsimonious model? Which model fit the data the best? Explain your conclusions.
- The Excel file Vacation Survey provides information about 34 respondents’ age, gender, relationship status, number of children and vacations per year.
- Develop a multiple regression model for predicting vacations per year as a function of the other variables.
- Explain how age, gender, relationship status and number of children affect the number of