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...
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...
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...
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...