Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The table named Sales to the right, shows the sales of a supermarket (in thousand dollars) in the last 12 months. Note: to facilitate answering

image text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribed
The table named "Sales" to the right, shows the sales of a supermarket (in thousand dollars) in the last 12 months. Note: to facilitate answering the questions in the next two sheets, use Excel Data Analysis Tool Pack (except for questions 1b and 2d); 1 2 3 4 5 6 7 8 9 H 0 H H H N a) Develop the 2-month and 3-month moving averages for the supermarket sales. Note: use data analysis tool pack. b) Which moving average appears to provide more accurate forecasts based on MAE? Explain. Note: show your MAE calculations. a) Use a = .2 to compute the exponential smoothing forecast for the supermarket sales. b) Use a = .3 to compute the exponential smoothing forecast for the supermarket sales. c) Use t! = .4 to compute the exponential smoothing forecast for the supermarket sales. d) Does a smoothing constant of .2, .3 or .4 appear to provide more accurate forecasts based on MSE? Explain. Note: show y-Iaur MSE calculations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

University Calculus Early Transcendentals, Multivariable

Authors: Joel R Hass, Maurice D Weir, George B Thomas Jr

2nd Edition

0321830849, 9780321830845

More Books

Students also viewed these Mathematics questions

Question

Be straight in the back without blowing out the chest

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago