Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The manager ofa trendy downtown cafe' in Columbus, Ohio, collects weekly data on the number of customers it serves. A portion of the data is
The manager ofa trendy downtown cafe' in Columbus, Ohio, collects weekly data on the number of customers it serves. A portion of the data is shown in the accompanying table. Week Customers 1 963 2 10 1 7 52 1392 pictureClick here for the Excel Data File a. Use the simple exponential smoothing technique with a = 0.2 to make a forecast for Week 53. (Do not round intermediate calculations. Round final answer to 2 decimal places.) b. Use the simple exponential smoothing technique with a = 0.4 to make a forecast for Week 53. (Do not round intermediate calculations. Round final answer to 2 decimal places.) c-1. Which is the preferred technique for making the forecast based on MSE, MAD, and MAPE? (Do not round intermediate calculations. Round final answers to 2 decimal places.) Technique MSE MAD MAPE (%) a = 0.2 90.16 8.36 a = 0.4 70.72 6.68 c-2. Which is the preferred technique for making the forecast? a = 0.4 because it has the smallest 3 out of 3 performance measures
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started