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

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

#### Earn Coins

Coins can be redeemed for fabulous gifts.