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?
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 4 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman