please complete

Use monthly total returns for the S&P 500 index, Xcel Energy (XEL), and NVIDIA (NVDA) from July 2012 through June 2017. You can download the monthly return data. a) Create an XY (Scatter) plot to show the relationship between the returns on each individual stock and the S&P 500. Estimate the slope of a regression equation of this data (SLOPE function). b) Add a linear trend line to each chart, and place the equation and R2 on each chart. How much of the variability in each stock's returns can be explained by variability in the S&P 500? c) Using the Analysis ToolPak add-in, run two regression models using returns from Xcel Energy and NVIDIA. Your dependent variable will be the Xcel Energy or NVIDIA monthly returns, and the independent variable will be the S&P 500 returns. After you have finished all the requirements, name your file as Exercise 4.3_LastNameFirstInitial.xlxs. Upload your Excel spreadsheet and answer all the questions below from your spreadsheet. 7/31/12 8/31/12 9/28/12 10/31/12 11/30/12 12/31/12 1/31/13 2/28/13 3/29/13 4/30/13 5/31/13 6/28/13 7/31/13 8/30/13 9/30/13 10/31/13 11/29/13 12/31/13 1/31/14 2/28/14 3/31/14 4/30/14 5/30/14 6/30/14 7/31/14 8/29/14 9/30/14 3 10/31/14 0 11/28/14 1 12/31/14 2 1/30/15 3 2/27/15 4 3/31/15 . Date 3 S&P 500 XEL NVDA 1.39% 3.13% -2.03% 2.25% -4.81% 3.62% 2.59% 0.34% -4.92% -1.84% 1.94% -10.24% 0.57% -4.24% 0.61% 0.91% -0.27% 2.42% 5.18% 4.02% 0.00% 1.35% 3.31% 3.89% 3.75% 4.46% 1.35% 1.92% 7.03% 7.33% 2.34% -9.66% 5.61% -1.34% -0.37% -2.97% 5.08% 5.68% 2.81% -2.90% -6.78% 2.70% 3.14% -0.09% 5.49% 4.60% 4.53% -2.39% 3.04% -2.91% 3.27% 2.54% 0.70% 2.70% -3.46% 3.47% -2.00% 4.57% 4.78% 17.60% 0.84% 1.22% -2.55% 0.74% 4.97% 3.12% 2.34% -3.48% 3.35% 2.06% 5.80% -2.42% -1.38% -4.44% -5.61% 4.00% 4.06% 11.63% -1.40% -4.24% -5.15% 2.44% 10.10% 5.91% 2.69% 1.40% 7.77% -0.25% 6.73% -4.39% -3.00% 4.48% -4.21% 5.75% -5.99% 15.30% -1.58% -0.39% -5.14% 30 11/28/14 31 12/31/14 32 1/30/15 33 2/27/15 34 3/31/15 35 4/30/15 36 5/29/15 37 6/30/15 38 7/31/15 39 8/31/15 40 9/30/15 41 10/30/15 42 11/30/15 43 12/31/15 44 1/29/16 45 2/29/16 46 3/31/16 47 4/29/16 48 5/31/16 49 6/30/16 50 7/29/16 51 8/31/16 52 9/30/16 53 10/31/16 54 11/30/16 55 12/30/16 56 1/31/17 57 2/28/17 58 3/31/17 59 4/28/17 60 5/31/17 61 6/30/17 62 2.69% 1.40% 7.77% -0.25% 6.73% -4.39% -3.00% 4.48% -4.21% 5.75% -5.99% 15.30% -1.58% -0.39% -5.14% 0.96% -2.58% 6.07% 1.29% 0.41% 0.17% -1.94% -4.56% -9.13% 2.09% 7.74% -0.79% -6.03% -2.71% 13.16% -2.47% 5.99% 9.65% 8.43% 0.62% 15.09% 0.29% 0.08% 12.22% -1.58% 1.61% 3.91% -4.96% 6.43% -11.13% -0.14% 3.46% 7.46% 6.78% 6.65% 13.62% 0.39% -4.28% -0.28% 1.79% 3.35% 31.83% 0.26% 9.10% 0.62% 3.69% -1.79% 21.46% 0.14% -5.96% 7.62% 0.02% 0.30% 11.71% -1.82% 1.00% 3.85% 3.70% -6.11% 29.76% 1.98% 5.21% 15.77% 1.89% 1.52% 2.29% 3.97% 5.78% -6.93% 0.11% 2.54% 7.34% 1.03% 1.35% -4.25% 1.41% 6.35% 38.54% 0.63% -3.51% 0.14% Use monthly total returns for the S&P 500 index, Xcel Energy (XEL), and NVIDIA (NVDA) from July 2012 through June 2017. You can download the monthly return data. a) Create an XY (Scatter) plot to show the relationship between the returns on each individual stock and the S&P 500. Estimate the slope of a regression equation of this data (SLOPE function). b) Add a linear trend line to each chart, and place the equation and R2 on each chart. How much of the variability in each stock's returns can be explained by variability in the S&P 500? c) Using the Analysis ToolPak add-in, run two regression models using returns from Xcel Energy and NVIDIA. Your dependent variable will be the Xcel Energy or NVIDIA monthly returns, and the independent variable will be the S&P 500 returns. After you have finished all the requirements, name your file as Exercise 4.3_LastNameFirstInitial.xlxs. Upload your Excel spreadsheet and answer all the questions below from your spreadsheet. 7/31/12 8/31/12 9/28/12 10/31/12 11/30/12 12/31/12 1/31/13 2/28/13 3/29/13 4/30/13 5/31/13 6/28/13 7/31/13 8/30/13 9/30/13 10/31/13 11/29/13 12/31/13 1/31/14 2/28/14 3/31/14 4/30/14 5/30/14 6/30/14 7/31/14 8/29/14 9/30/14 3 10/31/14 0 11/28/14 1 12/31/14 2 1/30/15 3 2/27/15 4 3/31/15 . Date 3 S&P 500 XEL NVDA 1.39% 3.13% -2.03% 2.25% -4.81% 3.62% 2.59% 0.34% -4.92% -1.84% 1.94% -10.24% 0.57% -4.24% 0.61% 0.91% -0.27% 2.42% 5.18% 4.02% 0.00% 1.35% 3.31% 3.89% 3.75% 4.46% 1.35% 1.92% 7.03% 7.33% 2.34% -9.66% 5.61% -1.34% -0.37% -2.97% 5.08% 5.68% 2.81% -2.90% -6.78% 2.70% 3.14% -0.09% 5.49% 4.60% 4.53% -2.39% 3.04% -2.91% 3.27% 2.54% 0.70% 2.70% -3.46% 3.47% -2.00% 4.57% 4.78% 17.60% 0.84% 1.22% -2.55% 0.74% 4.97% 3.12% 2.34% -3.48% 3.35% 2.06% 5.80% -2.42% -1.38% -4.44% -5.61% 4.00% 4.06% 11.63% -1.40% -4.24% -5.15% 2.44% 10.10% 5.91% 2.69% 1.40% 7.77% -0.25% 6.73% -4.39% -3.00% 4.48% -4.21% 5.75% -5.99% 15.30% -1.58% -0.39% -5.14% 30 11/28/14 31 12/31/14 32 1/30/15 33 2/27/15 34 3/31/15 35 4/30/15 36 5/29/15 37 6/30/15 38 7/31/15 39 8/31/15 40 9/30/15 41 10/30/15 42 11/30/15 43 12/31/15 44 1/29/16 45 2/29/16 46 3/31/16 47 4/29/16 48 5/31/16 49 6/30/16 50 7/29/16 51 8/31/16 52 9/30/16 53 10/31/16 54 11/30/16 55 12/30/16 56 1/31/17 57 2/28/17 58 3/31/17 59 4/28/17 60 5/31/17 61 6/30/17 62 2.69% 1.40% 7.77% -0.25% 6.73% -4.39% -3.00% 4.48% -4.21% 5.75% -5.99% 15.30% -1.58% -0.39% -5.14% 0.96% -2.58% 6.07% 1.29% 0.41% 0.17% -1.94% -4.56% -9.13% 2.09% 7.74% -0.79% -6.03% -2.71% 13.16% -2.47% 5.99% 9.65% 8.43% 0.62% 15.09% 0.29% 0.08% 12.22% -1.58% 1.61% 3.91% -4.96% 6.43% -11.13% -0.14% 3.46% 7.46% 6.78% 6.65% 13.62% 0.39% -4.28% -0.28% 1.79% 3.35% 31.83% 0.26% 9.10% 0.62% 3.69% -1.79% 21.46% 0.14% -5.96% 7.62% 0.02% 0.30% 11.71% -1.82% 1.00% 3.85% 3.70% -6.11% 29.76% 1.98% 5.21% 15.77% 1.89% 1.52% 2.29% 3.97% 5.78% -6.93% 0.11% 2.54% 7.34% 1.03% 1.35% -4.25% 1.41% 6.35% 38.54% 0.63% -3.51% 0.14%