1.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.
2. 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.
3. The Excel file Vacation Survey provides information about 34 respondents’ age, gender, relationship status, number of children and vacations per year.
a. Develop a multiple regression model for predicting vacations per year as a function of the other variables.
b. Explain how age, gender, relationship status and number of children affect the number of
