How can I do regression analysis for Sales Revenue for Macys
comparing it to TJX? Please...
How can I do regression analysis for Sales Revenue for Macys
comparing it to TJX? Please show work and example in Excel if it's
easier.
Net Profit Margin
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
Sales Revenue - MACYS
$
15,776,000.00
$
22,390,000.00
$
26,970,000.00
$
26,313,000.00
$ 24,892,000.00
$
23,489,000.00
$
25,003,000.00
$
26,405,000.00
$
27,686,000.00
$
27,931,000.00
$
28,105,000.00
$
27,079,000.00
$
25,778,000.00
$
24,837,000.00
Net Profit Margin
2005
2006
2007...
Create the following forecasts:
a 4-period moving average
forecast,
an exponential smoothing forecast
with alpha=0.2,
and...
Create the following forecasts:
a 4-period moving average
forecast,
an exponential smoothing forecast
with alpha=0.2,
and a linear trend forecast for your
data.
Calculate the MSE and MAPE for each.
Plot the original series, and each of the forecasts.
Create forecasts for 2017 Q1, 2017 Q2, 2017 Q3 and 2017 Q4 using
each of these three techniques. If you had to choose one of these,
which would you choose and why?
Given your data, and this time period, would you...
JetBlue Airlines Revenue,
2008–2015 (millions)
Year
Revenue
Year
Revenue
2008
3,388
2012
4,982
2009
3,286
2013...
JetBlue Airlines Revenue,
2008–2015 (millions)
Year
Revenue
Year
Revenue
2008
3,388
2012
4,982
2009
3,286
2013
5,441
2010
3,779
2014
5,817
2011
4,504
2015
6,416
Click here for the Excel Data File
(a) Use Excel, MegaStat, or MINITAB to fit both a
linear and an exponential trend to the time series. (Round
your answers to 2 decimal places.)
Linear
yt = t +
Exponential
yt
= e t
(b) Make annual forecasts for 2016–2018, using the
linear and exponential trend models. (Do not...
Provide Ho & Ha for hypothesis testing. What type of
hypothesis testing could be used to...
Provide Ho & Ha for hypothesis testing. What type of
hypothesis testing could be used to analyze the data and what do
the results show?
The information is 10 years worth of net sales in the
millions.
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
13,794
13,724
13,568
13,864
13,909
13,543
12,543
12,361
11,802
11,540
19166
24509
34204
48077
61093
74452
88988
107006
135987
177866
62884
63435
65786
68466
71960
71279
72618
73785
69495
71879
JetBlue Airlines Revenue,
2008–2015 (millions)
Year
Revenue
Year
Revenue
2008
3,388
2012
4,982
2009
3,286
2013...
JetBlue Airlines Revenue,
2008–2015 (millions)
Year
Revenue
Year
Revenue
2008
3,388
2012
4,982
2009
3,286
2013
5,441
2010
3,779
2014
5,817
2011
4,504
2015
6,416
(a) Use Excel, MegaStat, or MINITAB to fit both a
linear and an exponential trend to the time series. (Round
your answers to 2 decimal places.)
Linear
yt = t +
Exponential
yt
= e t
(b) Make annual forecasts for 2016–2018, using the
linear and exponential trend models. (Do not round the
intermediate calculations. Round your final...
U.S. Civilian Labor Force, 2007-2016
Year
Labor Force
2007
153,918
2008
154,655
2009
153,111
2010
153,650...
U.S. Civilian Labor Force, 2007-2016
Year
Labor Force
2007
153,918
2008
154,655
2009
153,111
2010
153,650
2011
153,995
2012
155,628
2013
155,151
2014
156,238
2015
157,957
2016
159,640
(d) Make forecasts using the following fitted
trend models for years 2017-2019. (Round your answers to
the nearest whole number.)
t
Linear
Quadratic
Exponential
11
158608
161301
12
159192
163354
13
159776
165653