Question

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 |
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
2016 |
2017 |
2018 |

Sales Revenue TJX | $ 14,860,000.75 | $ 15,955,000.94 | $ 17,104,000.01 | $ 18,336,000.73 | $ 18,999,000.51 | $ 20,288,000.44 | $ 21,942,000.19 | $ 23,191,000.46 | $ 25,878,000.37 | $ 27,422,000.70 | $ 29,078,000.41 | $ 30,944,000.94 | $ 33,183,000.74 | $ 35,864,000.66 |

Answer #1

Regression Analysis

x (MACYS) | y (TJX) |

15776000 | 14860000.75 |

22390000 | 15955000.94 |

26970000 | 17104000.01 |

26313000 | 18336000.73 |

24892000 | 18999000.51 |

23489000 | 20288000.44 |

25003000 | 21942000.19 |

26405000 | 23191000.46 |

27686000 | 25878000.37 |

27931000 | 27422000.7 |

28105000 | 29078000.41 |

27079000 | 30944000.94 |

25778000 | 33183000.74 |

24837000 | 35864000.66 |

Sum of *X* = 352654000

Sum of *Y* = 333044007.85

Mean *X* = 25189571.4286

Mean *Y* = 23788857.7036

Sum of squares (*SS _{X}*) = 131665317428571

Sum of products (

Regression Equation = y =

y = 1.06587

Please use SPSS for analysis if available
Will give positive feedback for answering all
questions!
Question:
The sales data of a company's sales records is
provided.
a. Plot a time-series plot of the data
b. Fit a Linear trend line to these data
c. Conduct a hypothesis test of the linear trend model developed
in part b. Use significance level of 0.05
d. State the predicted value of sales from 2005 to 2020
e. Calculate MAD and MSE for the...

The following information is from General Electric Corporation
annual reports.
YearRevenue ($ million)Employees
Year
Revenue ($ million)
Employees (000)
2004
134
298
2005
152
302
2006
157
316
2007
168
323
2008
177
336
2009
183
324
2010
150
297
2011
147
290
2012
147
300
2013
146
308
2014
149
302
2015
151
326
Compute a simple index for the number of employees for GE using
the period 2004−06 as the base. (Round your answers to 1
decimal place.)...

The following data is provided for a market 500 Index: Year
Total return Year Total return 2000 16.0% 2010 2.0% 2001 8.0% 2011
3.0% 2002 -3.0% 2012 3.0% 2003 1.0% 2013 4.0% 2004 5.0% 2014 5.0%
2005 21.0% 2015 4.0% 2006 43.0% 2016 3.0% 2007 4.9% 2017 3.5% 2008
-7.0% 2018 4.5% 2009 0.1% 2019 5.8% Calculate the last 10 -year
arithmetic average annual rate of return on the market Index.
3.78%
2.69%
0.37%
3.93%

The following data is provided for a market 500 Index: Year
Total return Year Total return 2000 16.0% 2010 2.0% 2001 8.0% 2011
3.0% 2002 -3.0% 2012 3.0% 2003 1.0% 2013 4.0% 2004 5.0% 2014 5.0%
2005 21.0% 2015 4.0% 2006 43.0% 2016 3.0% 2007 4.9% 2017 3.5% 2008
-7.0% 2018 4.5% 2009 0.1% 2019 5.8% Calculate the 20 -year
geometric average annual rate of return on the market Index.
5.91%
3.32%
3.77%
0.28%

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

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

Analyzing Unearned Revenue Changes
Electronic Arts Inc. (EA) is a developer, marketer, publisher and
distributor of video game software and content to be played on a
variety of platforms. There is an increasing demand for the ability
to play these games in an online environment, and EA has developed
this capability in many of its products. In addition, EA maintains
servers (or arranges for servers) for the online activities of its
customers. When customers purchase online subscriptions, revenue is
recognized...

The table below displays returns associated with a company's
shares over the last 15 years.
Year
Return
(% pa)
2005
23
2006
17
2007
11
2008
15
2009
12
Year
Return
(% pa)
2010
31
2011
2
2012
16
2013
8
2014
31
Year
Return
(% pa)
2015
29
2016
5
2017
26
2018
6
2019
1
Based on this historic data, calculate the expected return on
the shares and its standard deviation. Give your answers as a
percentage per...

The table below displays returns associated with a company's
shares over the last 15 years.
Year
Return
(% pa)
2005
9
2006
-2
2007
20
2008
-4
2009
18
Year
Return
(% pa)
2010
8
2011
19
2012
1
2013
13
2014
-2
Year
Return
(% pa)
2015
35
2016
-3
2017
28
2018
18
2019
31
Based on this historic data, calculate the expected return on
the shares and its standard deviation. Give your answers as a
percentage per...

Suppose you are given the following end of year stock price data
for Random Inc. stock. Assume the returns are normally distributed,
calculate the standard deviation of the annual returns. (Enter
percentages as decimals and round to 4 decimals). Year Price 2005
43.65 2006 44.01 2007 45.77 2008 53.04 2009 45.67 2010 59.05 2011
46.88 2012 49.24 2013 43.99 2014 42.67 2015 48.14

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 16 minutes ago

asked 21 minutes ago

asked 29 minutes ago

asked 32 minutes ago

asked 38 minutes ago

asked 41 minutes ago

asked 45 minutes ago

asked 47 minutes ago

asked 54 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago