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...
Trends and Regression
Calculate the Linear Trend Line for the following data
Using the Liner Trend...
Trends and Regression
Calculate the Linear Trend Line for the following data
Using the Liner Trend Line, what sales do you forecast for July
2016 (plot the values)
Using the Linear Trend Line, what sales do you forecast for
July 2017 (plot the values)
Comment on the quality/reliability of your forecasts - what
concerns should you have regarding the accuracy of your linear
trend line forecast?
Select an alternative Trend Line that you think best fits the
historical data. Make...
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...
A local bookstore recorded their revenue (in thousands) for the
last 36 months starting in September,...
A local bookstore recorded their revenue (in thousands) for the
last 36 months starting in September, as provided below.
a. find the deseasonalized line of best fit
b. use the additive model of seasonal forecasting to predict the
revenue for each month of the next academic year
c. use the multiplicative model of seasonal forecasting to
predict the revenue for each month of the next academic year
d. what is the predicted total profit for the academic year for
each...
Rounded to the nearest whole number, what is the standard
deviation for Google weekly closing prices...
Rounded to the nearest whole number, what is the standard
deviation for Google weekly closing prices from December 12, 2008
to December 4, 2009?
4-Dec-09 585.01
27-Nov-09 579.76
20-Nov-09 569.96
13-Nov-09 572.05
20-Nov-09 551.1
30-Oct-09 536.12
23-Oct-09 553.69
16-Oct-09 549.85
9-Oct-09 516.25
2-Oct-09 484.58
25-Sep-09 492.48
18-Sep-09 491.46
11-Sep-09 472.14
4-Sep-09 461.3
28-Aug-09 464.75
21-Aug-09 465.24
14-Aug-09 460
7-Aug-09 457.1
31-Jul-09 443.05
24-Jul-09 446.72
17-Jul-09 430.25
10-Jul-09 414.4
2-Jul-09 408.49
26-Jun-09 425.32
19-Jun-09 420.09
12-Jun-09 424.84
5-Jun-09 444.32
29-May-09 417.23...
Rounded to the nearest whole number, what is the standard
deviation for Google weekly closing prices...
Rounded to the nearest whole number, what is the standard
deviation for Google weekly closing prices from December 12, 2008
to December 4, 2009? Use the data set Google Closing Prices.xlsx
(in section 11 of this module) to determine your answer. NOTE: The
standard deviation function in Excel (for recent versions) has .p
for a population and .s for a sample. we're treating everything as
a sample!
4-Dec-09
585.01
27-Nov-09
579.76
20-Nov-09
569.96
13-Nov-09
572.05
6-Nov-09
551.1
30-Oct-09
536.12
23-Oct-09...