could you please show me how to put the data into data analysis step by step ? how to select the data to do thw graphics, please ? also discuss the findings in 10 lines . thank you so much .

Download the Excel File provided with the assignment. I have provided you monthly pricedata from April 2016 to March 2021 (5 years of data) on closing prices for the S&P500 index, Walmart Stock (WMT) and Target Stock (TGT). a Compute the monthly return for the S&P500, WMT and TGT (no need to report the entire table). Recall that return is the price change divided by the starting price. Report and compute the monthly average return for each asset and the standard deviation of returns and the correlation between each asset return, using Excel. b. Discuss your findings in 10 lines- Which asset has the highest monthly return? Which asset has the highest standard deviation? What is the total risk, systematic component of risk and unsystematic component of risk of each asset? C. Explain in less than 5 lines the reasons for your findings. Run two separate regressions between the returns on each stock vs the S&P500 stock to compute their respective betas (WMT and TGT). (i) Report the graph that shows the regression line. Report the Beta for each stock and its T-Stat. (ii) Discuss your findings - which stock has a higher beta? Why? (iii) If the CAPM applies and the risk-free rate is 3%, the market risk premium is 6%, what is the expected return for each stock? Date 1-Apr-16 1-May-16 1-Jun-16 1-Jul-16 1-Aug-16 1-Sep-16 1-Oct-16 1-Nov-16 1-Dec-16 1-Jan-17 1-Feb-17 1-Mar-17 1-Apr-17 1-May-17 1-Jun-17 17--1 1-Aug-17 1-Sep-17 1-Oct-17 1-Nov-17 1-Dec-17 1-Jan-18 1-Feb-18 1 Mar 18 1-Apr-18 1-May-18 1 Jun-18 Jul 1-Aug-18 1-Sep-18 1-Oct-18 1-Nov-18 1-Dec-18 1-Jan-19 1-Feb-19 1-Mar-19 1-Apr-19 1-May-19 1-Jun-19 1-Jul-19 1-Aug-19 1-Sep-19 1-Oct-19 1-Nov-19 1-Dec-19 1 Jan 20 1-Feb-20 1 Mar 20 1-Apr-20 1-May-20 1-Jun-20 1-Jul-20 1-Aug-20 1-Sep-20 1-Oct-20 1-Nov-20 1-Dec-20 1-Jan-21 1-Feb-21 1-Mar-21 S&P500 Walmart Target 2,065.30 59.84 68.20 2,096.95 6334 59.00 2,098.86 65.83 60.35 2.173.60 65.78 65.12 2.170.95 64.40 60.67 2.168.27 65.46 59.84 2,126.15 63.55 59.89 2,198.81 63.93 67.30 2.238.83 62.74 63.47 2 278.87 61.01 56.66 2,363.64 64.84 51.64 2,362.72 65.89 48.94 2.384.20 69.23 49.53 2,411.80 72.38 48.91 2.423.41 70.16 46.88 2,470.30 74.15 50.80 2,471.65 72.37 48.88 2,519.36 72.89 53.50 2,575.26 81.45 53.52 2,647.58 90.70 54.30 2,673.61 92.12 59.77 2,823.81 99.97 68.90 2,713.83 69.07 2.640.87 83.44 54.12 2,648.05 83.45 67.05 2,705.27 77.87 67.32 2.718.37 81.31 70.90 2,816.29 84.71 75.15 2.901.52 91.00 81.50 2,913.98 89.67 82.81 2.711.74 95.75 78.51 2.760.17 93.24 66.61 2,506.85 88.94 62 56 2.704.10 92.00 69.10 2,784.49 95.04 68.76 2.834.40 93.63 76.64 2,945.83 99.26 73.93 2.752.06 97.91 76.82 2,941.76 107.21 83.45 2.980.38 107.11 83.25 2,926.46 110.87 103.14 2,976.74 115.73 103.80 3,037.56 114 34 103.80 3,140,98 116.13 121.38 SECRET 3.230.78 115.88 125.22 3.225.52 112.14 106.16 2.954.22 105.47 100.60 2,584.59 111.29 91.32 2.912.43 119.58 107.79 3,044.31 122.05 120.16 3,100.29 118.36 118.43 3,271.12 127.87 124.30 3,500 31 137.21 149.31 3,363.00 13882 156 22 3.269.96 137.67 151.05 3,621.63 151.60 178.16 3,756.07 143.03 175.90 3,714.24 139.91 180.53 3,811.15 129.38 182.79 3,943.34 131.82 188.04 Download the Excel File provided with the assignment. I have provided you monthly pricedata from April 2016 to March 2021 (5 years of data) on closing prices for the S&P500 index, Walmart Stock (WMT) and Target Stock (TGT). a Compute the monthly return for the S&P500, WMT and TGT (no need to report the entire table). Recall that return is the price change divided by the starting price. Report and compute the monthly average return for each asset and the standard deviation of returns and the correlation between each asset return, using Excel. b. Discuss your findings in 10 lines- Which asset has the highest monthly return? Which asset has the highest standard deviation? What is the total risk, systematic component of risk and unsystematic component of risk of each asset? C. Explain in less than 5 lines the reasons for your findings. Run two separate regressions between the returns on each stock vs the S&P500 stock to compute their respective betas (WMT and TGT). (i) Report the graph that shows the regression line. Report the Beta for each stock and its T-Stat. (ii) Discuss your findings - which stock has a higher beta? Why? (iii) If the CAPM applies and the risk-free rate is 3%, the market risk premium is 6%, what is the expected return for each stock? Date 1-Apr-16 1-May-16 1-Jun-16 1-Jul-16 1-Aug-16 1-Sep-16 1-Oct-16 1-Nov-16 1-Dec-16 1-Jan-17 1-Feb-17 1-Mar-17 1-Apr-17 1-May-17 1-Jun-17 17--1 1-Aug-17 1-Sep-17 1-Oct-17 1-Nov-17 1-Dec-17 1-Jan-18 1-Feb-18 1 Mar 18 1-Apr-18 1-May-18 1 Jun-18 Jul 1-Aug-18 1-Sep-18 1-Oct-18 1-Nov-18 1-Dec-18 1-Jan-19 1-Feb-19 1-Mar-19 1-Apr-19 1-May-19 1-Jun-19 1-Jul-19 1-Aug-19 1-Sep-19 1-Oct-19 1-Nov-19 1-Dec-19 1 Jan 20 1-Feb-20 1 Mar 20 1-Apr-20 1-May-20 1-Jun-20 1-Jul-20 1-Aug-20 1-Sep-20 1-Oct-20 1-Nov-20 1-Dec-20 1-Jan-21 1-Feb-21 1-Mar-21 S&P500 Walmart Target 2,065.30 59.84 68.20 2,096.95 6334 59.00 2,098.86 65.83 60.35 2.173.60 65.78 65.12 2.170.95 64.40 60.67 2.168.27 65.46 59.84 2,126.15 63.55 59.89 2,198.81 63.93 67.30 2.238.83 62.74 63.47 2 278.87 61.01 56.66 2,363.64 64.84 51.64 2,362.72 65.89 48.94 2.384.20 69.23 49.53 2,411.80 72.38 48.91 2.423.41 70.16 46.88 2,470.30 74.15 50.80 2,471.65 72.37 48.88 2,519.36 72.89 53.50 2,575.26 81.45 53.52 2,647.58 90.70 54.30 2,673.61 92.12 59.77 2,823.81 99.97 68.90 2,713.83 69.07 2.640.87 83.44 54.12 2,648.05 83.45 67.05 2,705.27 77.87 67.32 2.718.37 81.31 70.90 2,816.29 84.71 75.15 2.901.52 91.00 81.50 2,913.98 89.67 82.81 2.711.74 95.75 78.51 2.760.17 93.24 66.61 2,506.85 88.94 62 56 2.704.10 92.00 69.10 2,784.49 95.04 68.76 2.834.40 93.63 76.64 2,945.83 99.26 73.93 2.752.06 97.91 76.82 2,941.76 107.21 83.45 2.980.38 107.11 83.25 2,926.46 110.87 103.14 2,976.74 115.73 103.80 3,037.56 114 34 103.80 3,140,98 116.13 121.38 SECRET 3.230.78 115.88 125.22 3.225.52 112.14 106.16 2.954.22 105.47 100.60 2,584.59 111.29 91.32 2.912.43 119.58 107.79 3,044.31 122.05 120.16 3,100.29 118.36 118.43 3,271.12 127.87 124.30 3,500 31 137.21 149.31 3,363.00 13882 156 22 3.269.96 137.67 151.05 3,621.63 151.60 178.16 3,756.07 143.03 175.90 3,714.24 139.91 180.53 3,811.15 129.38 182.79 3,943.34 131.82 188.04