Question
Month Year Sales JAN 2014 372012 FEB 2014 377748 MAR 2014 382915 APR 2014 387140 MAY...
|
Month |
Year |
Sales |
|
JAN |
2014 |
372012 |
|
FEB |
2014 |
377748 |
|
MAR |
2014 |
382915 |
|
APR |
2014 |
387140 |
|
MAY |
2014 |
388205 |
|
JUN |
2014 |
390346 |
|
JUL |
2014 |
391052 |
|
AUG |
2014 |
394458 |
|
SEP |
2014 |
394025 |
|
OCT |
2014 |
396158 |
|
NOV |
2014 |
398452 |
|
DEC |
2014 |
399105 |
|
JAN |
2015 |
400299 |
|
FEB |
2015 |
398314 |
|
MAR |
2015 |
404358 |
|
APR |
2015 |
405678 |
|
MAY |
2015 |
407867 |
|
JUN |
2015 |
407959 |
|
JUL |
2015 |
410540 |
|
AUG |
2015 |
411860 |
|
SEP |
2015 |
412791 |
|
OCT |
2015 |
412002 |
|
NOV |
2015 |
414260 |
|
DEC |
2015 |
416186 |
- Create a time series plot with the following bullet points
below. Paste your chart under the bullet points.
- Time is on the x-axis
- Open is on the y-axis
- Forecast is on the y-axis
- 4 chart attributes
Homework Answers
Answer #1
So due to the unavailable of uploading the calculation and forecasting value in the excel sheet, I am uploading the chart only.
here the first 4 months forecasting has been given as it making the chart more clumsy.
the value for next year 4 month forecasting is
2016 forecasted value
Jan 419582.3
| 420002.6 |
| 423257.1 |
| 425247.3 |
feb
mar
apr
Not the answer you're looking for?
Similar Questions
Use the data below to answer this questions. Period Employment Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30...
Use the data below to answer this questions.
Period
Employment
Jan-01
1,879.50
Feb-01
1,901.00
Mar-01
1,925.30
Apr-01
1,914.60
May-01
1,961.50
Jun-01
1,960.60
Jul-01
1,953.40
Aug-01
1,940.20
Sep-01
1,928.00
Oct-01
1,909.20
Nov-01
1,896.40
Dec-01
1,881.40
Jan-02
1,880.20
Feb-02
1,884.00
Mar-02
1,902.60
Apr-02
1,913.40
May-02
1,937.40
Jun-02
1,990.90
Jul-02
1,994.80
Aug-02
2,013.10
Sep-02
2,002.30
Oct-02
1,982.50
Nov-02
1,969.00
Dec-02
1,959.20
Jan-03
1,928.20
Feb-03
1,952.40
Mar-03
1,980.40
Apr-03
1,972.00
May-03
1,987.80
Jun-03
2,018.70
Jul-03
2,027.80
Aug-03
2,030.20
Sep-03
2,012.20
Oct-03
2,032.30
Nov-03
2,008.30...
Year Month Return Year Month Return 2006 Jan 3.95 2008 Jul 3.29 2006 Feb 3.77 2008...
Year
Month
Return
Year
Month
Return
2006
Jan
3.95
2008
Jul
3.29
2006
Feb
3.77
2008
Aug
4.62
2006
Mar
5.29
2008
Sep
4.81
2006
Apr
3.77
2008
Oct
5.16
2006
May
4.47
2008
Nov
3.69
2006
Jun
5.2
2008
Dec
5.15
2006
Jul
3.9
2009
Jan
5.29
2006
Aug
4.33
2009
Feb
3.19
2006
Sep
4.41
2009
Mar
3.89
2006
Oct
5.14
2009
Apr
4.48
2006
Nov
3.24
2009
May
5.27
2006
Dec
4.13
2009
Jun
3.93
2007
Jan...
Month time Sales Jan 1 200 Feb 2 203 March 3 210 Mar 4 218 April...
Month
time
Sales
Jan
1
200
Feb
2
203
March
3
210
Mar
4
218
April
5
230
May
6
245
Jun
7
346
Jul
8
376
Aug
9
389
Sep
10
231
Oct
11
200
Nov
12
189
Dec
13
155
Jan
14
178
Feb
15
193
Mar
16
192
Apr
17
201
May
18
212
Jun
19
367
Jul
20
391
Aug
21
401
Sep
22
204
Oct
23
201
Nov
24
183
Dec
25
145
Jan
26...
Given the following history, use a three-quarter moving average to forecast the demand for the third...
Given the following history, use a three-quarter moving average
to forecast the demand for the third quarter of this year. Note,
the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun;
3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec.
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Last year
165
185
200
230
240
265
210
200
195
265
290
315
This year
175
200
165
260
260
200
Forecast...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year
Treasury Bonds from 2006–2010.
Date
Return
Jan-06
5.39
Feb-06
4.83
Mar-06
5.41
Apr-06
4.64
May-06
4.05
Jun-06
3.41
Jul-06
3.92
Aug-06
3.46
Sep-06
5.06
Oct-06
5.44
Nov-06
4.96
Dec-06
4.17
Jan-07
3.48
Feb-07
4.7
Mar-07
4.38
Apr-07
3.82
May-07
4.19
Jun-07
4.35
Jul-07
3.83
Aug-07
5.42
Sep-07
3.29
Oct-07
4
Nov-07
3.42
Dec-07
3.24
Jan-08
5.21
Feb-08
4.84
Mar-08
4.59
Apr-08
3.82
May-08
3.61
Jun-08
4.34
Jul-08
4.94
Aug-08...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year
Treasury Bonds from 2006–2010.
Date
Return
Jan-06
3.13
Feb-06
4.15
Mar-06
3.18
Apr-06
4.94
May-06
4.34
Jun-06
4.19
Jul-06
5.12
Aug-06
5.26
Sep-06
3.81
Oct-06
3.1
Nov-06
3.87
Dec-06
4.89
Jan-07
3.94
Feb-07
3.42
Mar-07
4.13
Apr-07
3.54
May-07
4.58
Jun-07
4.19
Jul-07
4.62
Aug-07
3.89
Sep-07
3.62
Oct-07
3.92
Nov-07
4.46
Dec-07
3.23
Jan-08
4.78
Feb-08
4.71
Mar-08
5.05
Apr-08
3.46
May-08
3.15
Jun-08
4.82
Jul-08
3.87
Aug-08...
Use the data below to answer this questions. a.) Generate a scatter of the data b....
Use the data below to answer this questions.
a.) Generate a scatter of the data
b. ) Report the monthly averages (January for all years,
February for all years etc.)
c.) Is there seasonality? Is there a trend?
d.) How can you forecast the value for March 2020? Generate that
forecast.
e.) (Not technical) This forecast will for sure be wrong.
Why?
Reference period
Employment 3
Persons
Jan-01
1,879.50
Feb-01
1,901.00
Mar-01
1,925.30
Apr-01
1,914.60
May-01
1,961.50
Jun-01
1,960.60
Jul-01...
FOR4. The Excel file Unemployment Rates provides data on monthly rates for 4 years. (8 pts)...
FOR4. The Excel file Unemployment Rates provides data
on monthly rates for 4 years. (8 pts)
a.
Develop 3- and 6-months
moving average forecasts, and exponential smoothing forecasts (use
alpha of your choice)
b. Using MAD as a
criterion, explain which model yields better forecast?
DATA:
Unemployment
Rates
Year
Month
Rate (%)
2009
Jan
7.8
2009
Feb
8.3
2009
Mar
8.7
2009
Apr
9.0
2009
May
9.4
2009
Jun
9.5
2009
Jul
9.5
2009
Aug
9.6
2009
Sep...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data:
Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12
Jun-12 Jul-12 Aug-12 Sep-12
Profit ($) 6,400 6,153 5,454 5,277 5,395 6,198 7,919
6,364 6,068
Step 3 of 5: Determine the exponentially smoothed forecast for
the next time period using a smoothing constant, α, of 0.35. If
necessary, round your answer to one decimal place.
The marketing department needs to forecast the number of complaints arising from a particular defect in...
The marketing department needs to forecast the number of
complaints arising from a particular defect in a product. The data
for several months is supplied below. Be careful since the data is
listed beginning with the most recent. The forecasting method to be
used here is exponential smoothing accounting for seasonality with
a smoothing constant of 0.75 and a previous forecast (with
seasonality) of 390. Please round your forecast to the nearest
whole number.
Jul 2020: 424
Jun 2020: 472...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 2 minutes ago
asked 5 minutes ago
asked 7 minutes ago
asked 10 minutes ago
asked 13 minutes ago
asked 30 minutes ago
asked 34 minutes ago
asked 45 minutes ago
asked 50 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago