Question: Please show how to do this in Excel step-by-step!! Thank you! Using these data perform the the following steps: - Calculate weekly total - Do

Please show how to do this in Excel step-by-step!! Thank you!Please show how to do this in Excel step-by-step!! Thank you! Using

Using these data perform the the following steps: - Calculate weekly total - Do MA3 forecast for week 10 . - Do expontial smoothing forecast for week 10 (use alpha identified here) - Do adjusted exponential smoothing forecast for week 10 (use alpha and beta identified here). - Plot three forecasts and actual data (weekly-total) against week number. Which forecast out of three is more reliable? Why? (1 sentence) - calculate seasonal weights for each day of week (using data for 9 full weeks) - Using seasonal weights, forecast expected death on Mo of week 10. Compare to actual data. - What is your forecast for Saturday of 11/07/2021 ? Find data in thr internetto compare

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!