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 |
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
Not the answer you're looking for?
Similar Questions
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...
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...
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
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%
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...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...
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...
Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for...
Listed below is the number of movie tickets sold at the Library
Cinema-Complex, in thousands, for the period from 2004 to 2016.
Compute a five-year weighted moving average using weights of 0.12,
0.11, 0.25, 0.14, and 0.38, respectively. Describe the trend in
yield. (Round your answers to 3 decimal places.) 2004 8.8 2005 8.34
2006 7.71 2007 6.75 2008 7.38 2009 6.96 2010 6.81 2011 6.8 2012
5.82 2013 5.86 2014 5.74 2015 5.31 2016 5.25 Click here for the...
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...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 2 minutes ago
asked 5 minutes ago
asked 5 minutes ago
asked 33 minutes ago
asked 45 minutes ago
asked 46 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago