Use the RestaurantTraffic Sheet. Use a multiple regression m…

Questions

Use the RestаurаntTrаffic Sheet. Use a multiple regressiоn mоdel tо estimate daily visitors to a restaurant that is open Monday through Friday. You will need to account for: Day-of-week seasonal effects. Use Monday as your baseline. Time, using a period variable that starts at 1 on the first Monday and increases by 1 each restaurant operating day. Using your regression model, calculate the predicted daily visitors for Weeks 1 through 9 (45 time periods).  Based on these predictions, what is the Mean Squared Error (MSE)? Two decimal places.