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...
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...
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...
I have the following data
Week of
Expenses
Revenues
Profit
6-Dec-04
103,084
122,533
19,449
13-Dec-04
99,584...
I have the following data
Week of
Expenses
Revenues
Profit
6-Dec-04
103,084
122,533
19,449
13-Dec-04
99,584
131,036
31,452
20-Dec-04
94,936
137,813
42,877
27-Dec-04
100,757
114,495
13,738
3-Jan-05
102,736
120,579
17,843
10-Jan-05
94,866
182,122
87,256
17-Jan-05
96,158
137,983
41,825
24-Jan-05
97,013
104,668
7,655
31-Jan-05
97,796
117,807
20,011
7-Feb-05
106,315
157,735
51,420
14-Feb-05
92,307
145,685
53,378
21-Feb-05
89,923
129,758
39,835
28-Feb-05
100,546
130,642
30,096
7-Mar-05
99,270
85,895
(13,375)
14-Mar-05
98,632
125,994
27,362
21-Mar-05
100,273
113,194
12,921
28-Mar-05
100,006
127,209
27,203
4-Apr-05
105,531...