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...
Provide a statistical trend analysis including a visual graph
from Excel with the following information comparing...
Provide a statistical trend analysis including a visual graph
from Excel with the following information comparing Toys R Us,
Target, and Amazon.
Net Sales in Millions
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Toys R
Us
13,794
13,724
13,568
13,864
13,909
13,543
12,543
12,361
11,802
11,540
Amazon
19166
24509
34204
48077
61093
74452
88988
107006
135987
177866
Target
62884
63435
65786
68466
71960
71279
72618
73785
69495
71879
DETROIT
ANN ARBOR
2008
59 &n
DETROIT
ANN ARBOR
2008
59
2008 61
2009
60
2009 58
2010
61
2010 60
2011
69
2011 68
2012
66
2012 67
2013
62
2013 64
2014
64
2014 66
2015
71
2015 70
2016
69
2016 72
2017
66
2017 64
What is the mean, median, mode, range, midrange, variance, and
standard deviation for both cities?
Detroit
Mean
Median
Mode
Range
Midrange
Variance
Standard Deviation
Ann Arbor
Mean
Median
Mode
Range
Midrange
Variance
Standard Deviation
Make sure...
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...
If plotted, the following sales series would appear curvilinear.
This indicates that sales are increasing at...
If plotted, the following sales series would appear curvilinear.
This indicates that sales are increasing at a somewhat constant
annual rate (percent). To fit the sales, therefore, a logarithmic
equation should be used.
Year
Sales
($ millions)
2007
8.0
2008
10.4
2009
13.5
2010
17.6
2011
22.8
2012
29.3
2013
39.4
2014
50.5
2015
65.0
2016
84.1
2017
109.0
1) Determine the logarithmic equation.
y = _____ + ______t
2) Determine the coordinates of the points on the
logarithmic straight...
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
TYPE THIS - DO NOT WRITE. DO NOT ANSWER IF YOU DO NOT KNOW, I
have...
TYPE THIS - DO NOT WRITE. DO NOT ANSWER IF YOU DO NOT KNOW, I
have had so many people get this test statistic wrong!
The following table lists a portion of the data representing the
annual returns (in percent) over a 10-year period for the Balanced
mutual fund, a top-performing mutual fund from the Janus Capital
Group. (You may find it useful to reference the z
table.).
Year
Return
2007
10.15
2008
-15.22
2009
24.28
2010
7.83
2011
1.44...