Question

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 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
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

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 (SSX) = 131665317428571
Sum of products (SP) = 140337846929431

Regression Equation = y = bX + a

b = SP/SSX = 140337846929431/131665317428571 = 1.06587

a = MY - bMX = 23788857.7 - (1.07*25189571.43) = -3059900.10449

y = 1.06587X - 3059900.10449

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question:...
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 ($...
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...
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...
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...
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...
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...
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...
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...
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....
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT