The owner of a convenience store near Salt Lake City in Utah has been tabulating weekly sales at the store, excluding gas. The accompanying data file contains the sales for 30 weeks. Week Sales 1 5387 2 5522 3 5307 4 5503 5 5391 6 5500 7 5283 8 5178 9 4833 10 5013 11 5040 12 5420 13 5114 14 5076 15 4929 16 5231 17 4998 18 4920 19 4974 20 4889 21 5062 22 4727 23 5111 24 5385 25 5036 26 4868 27 5037 28 5354 29 5018 30 5206   1. Use the 3-period moving average to forecast sales for the 31st week. Note: Do not round intermediate calculations. Round final answer to 2 decimal places.   2. Use simple exponential smoothing with α = 0.3 to forecast sales for the 31st week. Note: Do not round intermediate calculations. Round final answer to 2 decimal places.   3. Report the performance measures for the techniques in parts a and b. Note: Do not round intermediate calculations. Round final answers to 2 decimal places.   4. What is the preferred technique for making the forecast?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

The owner of a convenience store near Salt Lake City in Utah has been tabulating weekly sales at the store, excluding gas. The accompanying data file contains the sales for 30 weeks.

Week Sales
1 5387
2 5522
3 5307
4 5503
5 5391
6 5500
7 5283
8 5178
9 4833
10 5013
11 5040
12 5420
13 5114
14 5076
15 4929
16 5231
17 4998
18 4920
19 4974
20 4889
21 5062
22 4727
23 5111
24 5385
25 5036
26 4868
27 5037
28 5354
29 5018
30

5206

 

1. Use the 3-period moving average to forecast sales for the 31st week.

Note: Do not round intermediate calculations. Round final answer to 2 decimal places.

 

2. Use simple exponential smoothing with α = 0.3 to forecast sales for the 31st week.

Note: Do not round intermediate calculations. Round final answer to 2 decimal places.

 

3. Report the performance measures for the techniques in parts a and b.

Note: Do not round intermediate calculations. Round final answers to 2 decimal places.

 

4. What is the preferred technique for making the forecast?

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman