Use the InsurancePremium sheet. Develop a multiple linear regression model to predict the monthly car insurance premium based on the age of the driver and the type of car (sedan, SUV, or sports car). Use sedan as the baseline. What is the estimated monthly insurance premium for a 17-year-old driver with a sports car? Please round your answer to the nearest integer.

If the total sum of squares (SST) is 2,640.5 and the sum of squares due to error (SSE) is 715.3, what is the r-squared value? Please round your answer to four decimal places.

If the total sum of squares (SST) is 2,850.1 and the sum of squares due to error (SSE) is 600.2, what is the r-squared value? Please round your answer to four decimal places.

[Continued] Use the Enrollment sheet. Based on your regression model from the previous question, what is the predicted enrollment in Year 19? One decimal place.

Save your Excel file as “FirstInitialLastName – Midterm Exam.xlsx” For example, mine would be named “TLekwijit – Midterm Exam.xlsx” Submit Your Excel File. Failure to submit your Excel file for the Midterm Exam will result in an automatic 50% penalty on your final score.

[Continued] Use the InsurancePremium sheet. Based on the regression model you estimated previously, how would you interpret the coefficient for SUV?

Use the Logit sheet. The Department of Health Services aims to predict whether an individual will receive an annual flu shot using a logistic regression model based on community health survey data. As predictors, the model considers age (in years), income (in thousands), health insurance coverage (1 if insured, 0 otherwise), and length of residence (measured by the number of years the person has lived in their current zip code). What is the marginal effect of “length of residence” at the mean? Report as a percent without the % sign, four decimal places.

Use the RestaurantTraffic Sheet. Use a multiple regression model to estimate daily visitors to a restaurant that is open Monday through Friday. You will need to account for: Day-of-week seasonal effect. Use Monday as your baseline. Time (a period variable, which increases by 1 each day) to capture the overall trend over time. What is the value of the coefficient on Wednesday? One decimal place.

If all forecast errors are negative, which of the following statements must be true?

Use the WideAwakeCoffee sheet. What is the covariance between Advertising Budget and Cups Sold? Please round your answer to two decimal places.