Question

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 |

Answer #1

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

DETROIT (Y) ANN ARBOR (X)
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
h0 :There
is a statistical correlation between the temperatures in two
different Michigan cities.
Please show all five steps of hypothesis testing for
regression and correlation analysis. Make sure you show all five
steps with...

Year
Quarter
Sales (in Billions)
2009
1
2.62
2009
2
2.33
2009
3
2.4
2009
4
2.42
2010
1
2.72
2010
2
2.53
2010
3
2.61
2010
4
2.84
2011
1
2.95
2011
2
2.79
2011
3
2.93
2011
4
3.03
2012
1
3.44
2012
2
3.2
2012
3
3.3
2012
4
3.36
2013
1
3.79
2013
2
3.56
2013
3
3.74
2013
4
3.8
2014
1
4.24
2014
2
3.87
2014
3
4.15
2014
4
4.18
2015
1
4.8...

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

Calculate the annual dividend growth rate for the last
10 years. Kindly provide excel formulas.
Based on the annual dividend growth rate for data
provided, will you forecast a constant or non-constant growth in
dividends? Please explain.
Date
Dividends
8/11/2010
0.303
12/8/2010
0.303
3/9/2011
0.365
5/11/2011
0.365
8/10/2011
0.365
12/7/2011
0.365
3/8/2012
0.398
5/9/2012
0.398
8/8/2012
0.398
12/5/2012
0.398
3/8/2013
0.47
5/8/2013
0.47
8/7/2013
0.47
12/4/2013
0.47
3/7/2014
0.48
5/7/2014
0.48
8/6/2014
0.48
12/3/2014
0.48
3/11/2015
0.49
5/6/2015
0.49
8/5/2015...

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

A company’s sales for the years 2010 to 2018 were as follows: (
x N$ 10 000 )
Year
2010
2011
2012
2013
2014
2015
2016
2017
2018
Sales
324
296
310
305
295
347
348
364
370
2.1) Derive, by using the method of least squares, an equation
of linear trend for the sales of the company. (Use sequential
numbering with x = 1 in 2010) (8)
2.2) Use the trend line equation obtained in Question 2.1 to
compute...

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

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 9 minutes ago

asked 37 minutes ago

asked 39 minutes ago

asked 46 minutes ago

asked 48 minutes ago

asked 52 minutes ago

asked 55 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago