Two Pictures are attached, please see both to review all data before answering.

For this question, calculate all 60 monthly returns for both S&P 500 and Stock using the adjusted closing prices in blue. This is just the percentage change from the prior period by calculating the holding period return. After calculating the return, use that information to fill out the table in the first picture. Calculate the monthly average returns and standard deviation for the two data series. Then calculate the correlation coefficient between the monthly returns of the securities, annualized Return, and annualized standard deviation for each data series. There is only one average return, one standard deviation, and one correlation coefficient for each series. For the annualized return just multiply the average monthly return by 12. For the annualized standard deviation, multiply the monthly standard deviation by the square root of 12.

Year Date Range Examined Beginning End Month September September 2015 2020 Ticker Symbol A S&P 500 B Stock Average Monthly Return Standard Deviation (Monthly) Annualized Return Annualized Standard Deviation Correlation coefficient Adjusted closing values for selected stock and S&P 500 Index for 61 months are shown below. 60 months of returns are shown. Date 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016 1/1/2017 2/1/2017 3/1/2017 4/1/2017 5/1/2017 6/1/2017 Adjusted Closing Prices (Input) Total Return S&P 500 Stock S&P 500 Stock 1920.030029 57.270893 2079.360107 50.558086 2080.409912 51.971306 2043.939941 54.144138 1940.23999 59.104412 1932.22998 59.086597 2059.73999 61.001522 2065.300049 59.999561 2096.949951 63.507816 2098.860107 65.997383 2173.600098 65.952194 2170.949951 64.569351 2168.27002 65.63018 2126.149902 63.719135 2198.810059 64.092247 2238.830078 62.900127 2278.870117 61.168968 2363.639893 65.009232 2362.719971 66.063232 2384.199951 69.411102 2411.800049 72.56868 2423.409912 70.34034 7/1/2017 18/1/2017 9/1/2017 10/1/2017 | 11/1/2017 12/1/2017 1/1/2018 12/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 18/1/2018 9/1/2018 10/1/2018 11/1/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 14/1/2019 5/1/2019 6/1/2019 7/1/2019 18/1/2019 9/1/2019 | 10/1/2019 11/1/2019 12/1/2019 1/1/2020 12/1/2020 3/1/2020 4/1/2020 5/1/2020 6/1/2020 7/1/2020 8/1/2020 9/1/2020 2470.300049 2471.649902 2519.360107 2575.26001 2584.840088 2673.610107 2823.810059 2713.830078 2640.870117 2648.050049 2705.27002 2718.370117 2816.290039 2901.52002 2913.97998 2711.73999 2760.169922 2506.850098 2704.100098 2784.48999 2834.399902 2945.830078 14.346237 72.561714 73.083603 81.66021 90.938293 92.359932 100.752655 85.07267 4.089714 4.10614 78.477531 81.947502 85.372734 91.716125 90.372299 96.502312 93.97139 89.640907 92.723198 95.780754 94.368088 100.041351 98.679451 108.054138 107.946556 111.74102 116.634895 115.239372 117.037827 116.79213 113.02179 106.299118 112.162949 120.522179 123.010948 119.289581 128.870193 138.281509 139.910004 2752.060059 2941.76001 2980.379883 2926.459961 2976.7399 3037.560059 3140.97998 3230.780029 3225.52002 2954.219971 2584.590088 2912.429932 3044.310059 3100.290039 3271.120117 3500.310059 3363 Year Date Range Examined Beginning End Month September September 2015 2020 Ticker Symbol A S&P 500 B Stock Average Monthly Return Standard Deviation (Monthly) Annualized Return Annualized Standard Deviation Correlation coefficient Adjusted closing values for selected stock and S&P 500 Index for 61 months are shown below. 60 months of returns are shown. Date 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016 1/1/2017 2/1/2017 3/1/2017 4/1/2017 5/1/2017 6/1/2017 Adjusted Closing Prices (Input) Total Return S&P 500 Stock S&P 500 Stock 1920.030029 57.270893 2079.360107 50.558086 2080.409912 51.971306 2043.939941 54.144138 1940.23999 59.104412 1932.22998 59.086597 2059.73999 61.001522 2065.300049 59.999561 2096.949951 63.507816 2098.860107 65.997383 2173.600098 65.952194 2170.949951 64.569351 2168.27002 65.63018 2126.149902 63.719135 2198.810059 64.092247 2238.830078 62.900127 2278.870117 61.168968 2363.639893 65.009232 2362.719971 66.063232 2384.199951 69.411102 2411.800049 72.56868 2423.409912 70.34034 7/1/2017 18/1/2017 9/1/2017 10/1/2017 | 11/1/2017 12/1/2017 1/1/2018 12/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 18/1/2018 9/1/2018 10/1/2018 11/1/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 14/1/2019 5/1/2019 6/1/2019 7/1/2019 18/1/2019 9/1/2019 | 10/1/2019 11/1/2019 12/1/2019 1/1/2020 12/1/2020 3/1/2020 4/1/2020 5/1/2020 6/1/2020 7/1/2020 8/1/2020 9/1/2020 2470.300049 2471.649902 2519.360107 2575.26001 2584.840088 2673.610107 2823.810059 2713.830078 2640.870117 2648.050049 2705.27002 2718.370117 2816.290039 2901.52002 2913.97998 2711.73999 2760.169922 2506.850098 2704.100098 2784.48999 2834.399902 2945.830078 14.346237 72.561714 73.083603 81.66021 90.938293 92.359932 100.752655 85.07267 4.089714 4.10614 78.477531 81.947502 85.372734 91.716125 90.372299 96.502312 93.97139 89.640907 92.723198 95.780754 94.368088 100.041351 98.679451 108.054138 107.946556 111.74102 116.634895 115.239372 117.037827 116.79213 113.02179 106.299118 112.162949 120.522179 123.010948 119.289581 128.870193 138.281509 139.910004 2752.060059 2941.76001 2980.379883 2926.459961 2976.7399 3037.560059 3140.97998 3230.780029 3225.52002 2954.219971 2584.590088 2912.429932 3044.310059 3100.290039 3271.120117 3500.310059 3363