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.