The weekly demand (in cases) for a particular brand of automatic dishwasher detergent for a chain of grocery stores located in Columbus, Ohio, follows. Week Demand 1 22 2 18 3 23 4 21 5 17 6 24 7 20 8 19 9 18 10 21 (a) Construct a time series plot. -A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10 and appear to vary randomly between 15 and 25 on the vertical axis.   -A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10. They start on the left around 17 on the vertical axis and go up and to the right to around 24 on the vertical axis.   -A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10. They start on the left around 24 on the vertical axis and go down and to the right to around 17 on the vertical axis.   -A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10 and appear to vary randomly between 10 and 20 on the vertical axis. What type of pattern exists in the data? -The time series plot indicates a cyclical pattern. -The time series plot indicates a horizontal pattern.     -The time series plot indicates a seasonal pattern. -The time series plot indicates a trend pattern.   (b)Use a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) F11 = (???) cases   (c)Use exponential smoothing with a smoothing constant of ? = 0.4 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) F11 =  (?????)cases

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter10: Sequences, Series, And Probability
Section10.2: Arithmetic Sequences
Problem 67E
icon
Related questions
Question
The weekly demand (in cases) for a particular brand of automatic dishwasher detergent for a chain of grocery stores located in Columbus, Ohio, follows.
Week Demand
1 22
2 18
3 23
4 21
5 17
6 24
7 20
8 19
9 18
10 21
(a)
Construct a time series plot.
-A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10 and appear to vary randomly between 15 and 25 on the vertical axis.
 
-A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10. They start on the left around 17 on the vertical axis and go up and to the right to around 24 on the vertical axis.
 
-A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10. They start on the left around 24 on the vertical axis and go down and to the right to around 17 on the vertical axis.
 
-A time series plot contains a series of 10 points connected by line segments. The horizontal axis is labeled Week and ranges from 0 to 10. The vertical axis is labeled Demand (in cases) and ranges from 0 to 30. The points are plotted at regular increments of 1 week starting at week 1 and ending at week 10 and appear to vary randomly between 10 and 20 on the vertical axis.
What type of pattern exists in the data?
-The time series plot indicates a cyclical pattern.
-The time series plot indicates a horizontal pattern.    
-The time series plot indicates a seasonal pattern.
-The time series plot indicates a trend pattern.
 
(b)Use a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.)
F11 = (???) cases
 
(c)Use exponential smoothing with a smoothing constant of ? = 0.4 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.)
F11 =  (?????)cases
Expert Solution
steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage