Business performance can be affected various economic factors. Data on Autozone revenue (in million $) and disposable income (in million $) are collected in an effort to study the relationship between company revenue and industry revenue. See data file Revenue 1. Estimate a simple linear regression using Autozone revenue as the dependent variable and disposable income as the independent variables

1. Report the estimated regression line.
2. Test the slope coefficient to determine the validity of the model. Use =0.05.

The data should be pasted into excel.

Date Revenue Disposable income 3/30/1990 133.5 6414.640 6/29/1990 155.0 6417.037 9/28/1990 239.9 6366.168 12/31/1990 165.5 6379.730 3/29/1991 153.6 6423.863 6/28/1991 185.0 6447.210 9/30/1991 313.9 6502.332 12/31/1991 215.8 6641.922 3/31/1992 197.1 6711.357 6/30/1992 239.8 6740.671 9/30/1992 349.7 6763.811 12/31/1992 252.5 6801.742 3/31/1993 242.3 6813.697 6/30/1993 282.8 6817.701 9/30/1993 439.2 6862.515 12/31/1993 322.8 6910.602 3/31/1994 303.2 6983.806 6/30/1994 358.2 7025.314 9/30/1994 523.8 7122.963 12/30/1994 389.8 7190.901 3/31/1995 364.1 7207.255 6/30/1995 425.5 7271.651 9/29/1995 628.8 7313.742 12/29/1995 463.0 7383.717 3/31/1996 425.8 7454.301 6/30/1996 524.2 7513.727 9/30/1996 829.6 7552.887 12/31/1996 569.1 7628.691 3/31/1997 538.0 7693.917 6/30/1997 637.9 7785.460 9/30/1997 946.3 7897.061 12/31/1997 675.3 8065.328 3/31/1998 607.1 8178.007 6/30/1998 743.7 8261.362 9/30/1998 1217.0 8328.480 12/31/1998 900.9 8403.080 3/31/1999 852.5 8423.895 6/30/1999 970.2 8480.303 9/30/1999 1393.0 8605.081 12/31/1999 1006.0 8774.569 3/31/2000 924.2 8865.621 6/30/2000 1059.0 8969.157 9/30/2000 1493.0 8999.501 12/31/2000 1064.0 9076.223 3/31/2001 974.0 9068.234 6/30/2001 1140.0 9282.636 9/30/2001 1641.0 9167.785 12/31/2001 1176.0 9390.812 3/31/2002 1081.0 9438.448 6/30/2002 1225.0 9426.253

9/30/2002 1843.0 9471.610 12/31/2002 1219.0 9498.000 3/31/2003 1121.0 9635.544 6/30/2003 1288.0 9793.433 9/30/2003 1829.0 9833.026 12/31/2003 1282.0 9904.677 3/31/2004 1159.0 10002.264 6/30/2004 1360.0 10054.941 9/30/2004 1836.0 10180.633 12/31/2004 1286.0 10082.492 3/31/2005 1204.0 10162.278 6/30/2005 1338.0 10214.447 9/30/2005 1882.0 10298.739 12/31/2005 1338.0 10533.962 3/31/2006 1254.0 10549.798 6/30/2006 1417.0 10579.888 9/30/2006 1939.0 10718.365 12/31/2006 1393.0 10788.663 3/31/2007 1300.0 10809.538 6/30/2007 1474.0 10837.871 9/30/2007 2003.0 10846.991 12/31/2007 1456.0 10925.264 3/31/2008 1339.0 11155.661 6/30/2008 1517.0 10899.245 9/30/2008 2211.0 10969.231 12/31/2008 1478.0 10948.502 3/31/2009 1448.0 11026.432 6/30/2009 1658.0 10905.429 9/30/2009 2232.0 10891.014 12/31/2009 1589.0 10902.018 3/31/2010 1506.0 11043.804 6/30/2010 1822.0 11098.757 9/30/2010 2445.0 11176.156 12/31/2010 1792.0 11312.927 3/31/2011 1661.0 11295.233 6/30/2011 1978.0 11355.094 9/30/2011 2642.0 11362.033 12/31/2011 1924.0 11547.786 3/31/2012 1804.0 11636.654 6/30/2012 2112.0 11630.759 9/30/2012 2764.0 11936.122 12/31/2012 1991.0 11437.747 3/31/2013 1855.0 11504.416 6/30/2013 2206.0 11571.732 9/30/2013 3095.0 11596.613 12/31/2013 2094.0 11720.446 3/31/2014 1990.0 11871.513 6/30/2014 2342.0 11995.295 9/30/2014 3050.0 12169.576 12/31/2014 2260.0 12297.642 3/31/2015 2144.0 12414.199

6/30/2015 2493.0 12470.797 9/30/2015 3290.0 12561.187 12/31/2015 2386.0 12567.688 3/31/2016 2257.0 12627.206 6/30/2016 2594.0 12649.232 9/30/2016 3399.0 12590.849 12/31/2016 2468.0 12680.434 3/31/2017 2289.0 12765.604 6/30/2017 2619.0 12780.616