Question
In: Statistics and Probability
The following times series shows the demand for a particular product over the past 10 months....
The following times series shows the demand for a particular product over the past 10 months. Month Value
1 324
2 311
3 303
4 314
5 323
6 313
7 302
8 315
9 312
10 326
a. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE, MAPE and a forecast for month 11.
b. Calculate MSE and MAPE for three month moving average ?
c. Compare the three-month moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE?
Solutions
orchestra answered 1 year agoRelated Solutions
The following times series shows the demand for a particular product over the past 10 months....
The following times series shows the demand for a particular
product over the past 10 months.
Month
1
2
3
4
5
6
7
8
9
10
Value
324
311
303
314
323
313
302
315
312
326
a. Use α = 0.2 to compute the
exponential smoothing values for the time series. Compute MSE and a
forecast for month 11.
b. Develop a three-week moving average for
this time series. Compute MSE and a forecast for month 11.
c. ...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(a)
Construct a time series plot.
(b)
Use α = 0.3 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(a)
Construct a time series plot.
A time series plot contains a series of 12 points connected by
line segments. The horizontal axis ranges from 0 to 13 and is
labeled: Month. The vertical axis ranges from 0...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a
particular product over the past 12 months. can be found in the
below excel file.
https://drive.google.com/file/d/1gIpr0IBYUGgCIRSO7g3mqZ84F89vJU_P/view?usp=sharing
1. Using the three-month moving average, what is the Mean
Squared Error (MSE)?
(Round your answer to 2 decimal places. Negative values
should be indicated by a minus sign.)
2. Using the three-month moving average, what is the
forecast for month 13 ?
(Round your answer to 2 decimal places. Negative values
should be indicated by...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
Use α = 0.5 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105
2
135
3
120
4
105
5...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a particular
product over the past 12 months.
Month
Sales
1
105
2
135
3
120
4
105
5
90
6
120
7
145
8
140
9
100
10
80
11
100
12
110
(b)
Use α = 0.4 to compute the exponential smoothing
forecasts for the time series. (Round your answers to two decimal
places.)
Month t
Time Series Value
Yt
Forecast
Ft
1
105
2
135
3
120
4
105...
The following time series shows the sales of a particular product over the past 12 months....
The following time series shows the sales of a
particular product over the past 12 months. can be found in the
below excel file.
https://drive.google.com/file/d/1gIpr0IBYUGgCIRSO7g3mqZ84F89vJU_P/view?usp=sharing
1. Using the three-month moving average, what is the Mean
Squared Error (MSE)?
(Round your answer to 2 decimal places. Negative values
should be indicated by a minus sign.)
2. Using the three-month moving average, what is the
forecast for month 13 ?
(Round your answer to 2 decimal places. Negative values
should be indicated by...
The time series showing the sales of a particular product over the past 12 months is...
The time series showing the sales of a particular product over
the past 12 months is contained in the Excel Online file below.
Construct a spreadsheet to answer the following
questions.
Use a=0.2 to compute the exponential smoothing forecasts for the
time series (to 2 decimals).
Month
Time-Series
Value
Forecast
1
105
2
130
3
125
4
100
5
90
6
120
7
150
8
135
9
95
10
75
11
100
12
105
13
Use a smoothing constant of...
1. The demand data for a product over the past 5 months are shown below: MONTH...
1. The
demand data for a product over the past 5 months are shown
below:
MONTH
DEMAND
(number of units sold)
Five months ago
51
Four months ago
58
Three months ago
63
Two months ago
71
Last month
77
a. Plot
the monthly demand data using a software OR on a sheet of graph
paper.
b. Use
TREND PROJECTIONS method to determine the equation of the trend
line estimating the linear relationship between time (in
months) and demand (in...
The following schedules shows the demand and supply for a product. Schedule 1: Demand of individual...
The following schedules shows the demand and supply for a
product.
Schedule 1: Demand of individual consumers
Schedule 2: Supply from individual
producers
Schedule 1
Schedule 2
Price
Consumer X
Consumer Y
Consumer Z
Price
Producer A
Producer B
Producer C
10
40
40
60
10
20
20
20
20
35
35
50
20
25
30
25
30
30
30
40
30
30
40
30
40
25
25
30
40
35
50
35
50
20
20
20
50
40
60...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You must evaluate a proposal to buy a new milling machine. The base price is $175,000,...
- “Triangle Guessing” game in Python The program accepts the lengths of three (3) sides of a...
- THIS PROGRAM HAS TO BE WRITTEN IN C Single function to perform the parity computation on...
- Consider a buffer system consisting of Benzoic acid (pKa = 4.20) and sodium benzoate, a) Would...
- Decision Variables S T Minimize 1.8S + 2.20T Subject to: Potassium 5S + 8T >= 200...
- A neurologist needs to counsel a stroke victim and her husband about possible outcomes, treatment options,...
- Case Study: Personal Beliefs in the Workplace Don Shakow was a prominent professional who worked in...
ADVERTISEMENT