Multiple linear regression model

1. Call centers typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank’s call centers in the Excel file Call Center Data . In writing an article about call center working conditions, a reporter has claimed that the average tenure is no more than two years. Formulate and test a hypothesis using these data to determine if this claim can be disputed. Solution Tip: You need to write mathematical test of hypothesis statements and apply the test of hypothesis steps.
2. 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.