1) What is the average return for Home Depot, Inc. (HD)?

2) What is the standard deviation for Costo Wholesale Corporation (COST)?

3)What is the correlation between BBY and MSFT?

4) What is the beta for Costo Wholesale Corporation (COST)?

 

Transcribed Image Text:

Date S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price 1/1/2015 $ 30.34 $ 36.39 $ 75.91 $ 2/1/2015 $ 32.84 $ 39.50 $ 78.97 $ 3/1/2015 $ 32.58 $ 36.89 $ 82.22 $ 30.41 $ 78.77 $ 30.45 $ 79.19 $ 28.62 $ 4/1/2015 $ 5/1/2015 $ 6/1/2015 $ 7/1/2015 $ 8/1/2015 $ 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 $ 1,994.99 $ 2,104.50 $ 2,067.89 $ 2,085.51 $ 2,107.39 $ 2,063.11 $ 2,103.84 $ 1,972.18 $ 1,920.03 $ 2,079.36 $ 2,080.41 $ 2,043.94 $ 1,940.24 $ 1,932.23 $ 2,059.74 $ 2,065.30 $ 2,096.95 $ 2,098.86 $ 2,173.60 $ 2,170.95 $ 2,168.27 $ 2,126.15 $ 2,198.81 $ 2,238.83 $ 2,278.87 $ 2,363.64 $ $ 2,362.72 2,384.20 $ 28.53 $ 32.46 $ 32.80 $ 31.14 $ 28.25 $ 27.07 $ 25.02 $ 29.01 $ 29.06 $ 29.38 $ 29.46 $ 28.02 $ 31.06 $ 35.57 $ 35.29 $ 36.23 $ 42.55 $ 39.73 $ 41.71 $ 41.34 $ 46.04 $ 48.90 $ 94.43 $ 103.78 $ 102.75 $ 97.25 $ 101.28 $ 101.02 $ 106.95 $ 106.43 $ 105.54 $ 113.56 $ 122.97 $ 121.47 $ 116.02 $ 114.51 $ 123.10 $ 124.20 $ 122.56 $ 119.06 $ 128.90 125.06 $ $ 120.60 $ 114.35 $ 121.28 $ 126.33 $ 129.63 $ 136.53 $ 138.34 $ 147.97 $ 44.13 $ 42.51 $ COST Adj Close Price 40.31 $ 42.64 $ 39.74 $ 40.68 $ 48.38 $ 49.9 $ 51.34 $ 50.98 $ 47.08 $ 51.47 $ 46.48 $ 49.39 $ 48.02 $ 53.19 $ $ 53.93 54.39 $ 56.59 56.91 $ $ 59.08 $ 61.46 $ 60.83 $ 62.99 $ 65.48 $ 85.77 $ 94.01 $ 89.73 $ 89.90 $ 101.97 $ 104. $ 104.66 $ 112.21 $ 106.92 $ 114.10 $ 117.58 $ 118.81 $ 114.28 $ 123.94 $ 126.12 $ 128.27 $ 130.99 $ 118.42 $ 115.05 $ 130.32 $ 135.54 $ 142.05 $ 150.25 $ 126.33 129.84 138.62 130.88 130.82 123.91 133.31 128.49 133.00 145.47 148.50 148.96 139.39 138.38 145.74 137.00 138.00 145.67 155.11 150.35 141.85 137.53 139.62 149.37 152.96 165.30 156.87 166.06 Date S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price 1/1/2015 $ 30.34 $ 36.39 $ 75.91 $ 2/1/2015 $ 32.84 $ 39.50 $ 78.97 $ 3/1/2015 $ 32.58 $ 36.89 $ 82.22 $ 30.41 $ 78.77 $ 30.45 $ 79.19 $ 28.62 $ 4/1/2015 $ 5/1/2015 $ 6/1/2015 $ 7/1/2015 $ 8/1/2015 $ 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 $ 1,994.99 $ 2,104.50 $ 2,067.89 $ 2,085.51 $ 2,107.39 $ 2,063.11 $ 2,103.84 $ 1,972.18 $ 1,920.03 $ 2,079.36 $ 2,080.41 $ 2,043.94 $ 1,940.24 $ 1,932.23 $ 2,059.74 $ 2,065.30 $ 2,096.95 $ 2,098.86 $ 2,173.60 $ 2,170.95 $ 2,168.27 $ 2,126.15 $ 2,198.81 $ 2,238.83 $ 2,278.87 $ 2,363.64 $ $ 2,362.72 2,384.20 $ 28.53 $ 32.46 $ 32.80 $ 31.14 $ 28.25 $ 27.07 $ 25.02 $ 29.01 $ 29.06 $ 29.38 $ 29.46 $ 28.02 $ 31.06 $ 35.57 $ 35.29 $ 36.23 $ 42.55 $ 39.73 $ 41.71 $ 41.34 $ 46.04 $ 48.90 $ 94.43 $ 103.78 $ 102.75 $ 97.25 $ 101.28 $ 101.02 $ 106.95 $ 106.43 $ 105.54 $ 113.56 $ 122.97 $ 121.47 $ 116.02 $ 114.51 $ 123.10 $ 124.20 $ 122.56 $ 119.06 $ 128.90 125.06 $ $ 120.60 $ 114.35 $ 121.28 $ 126.33 $ 129.63 $ 136.53 $ 138.34 $ 147.97 $ 44.13 $ 42.51 $ COST Adj Close Price 40.31 $ 42.64 $ 39.74 $ 40.68 $ 48.38 $ 49.9 $ 51.34 $ 50.98 $ 47.08 $ 51.47 $ 46.48 $ 49.39 $ 48.02 $ 53.19 $ $ 53.93 54.39 $ 56.59 56.91 $ $ 59.08 $ 61.46 $ 60.83 $ 62.99 $ 65.48 $ 85.77 $ 94.01 $ 89.73 $ 89.90 $ 101.97 $ 104. $ 104.66 $ 112.21 $ 106.92 $ 114.10 $ 117.58 $ 118.81 $ 114.28 $ 123.94 $ 126.12 $ 128.27 $ 130.99 $ 118.42 $ 115.05 $ 130.32 $ 135.54 $ 142.05 $ 150.25 $ 126.33 129.84 138.62 130.88 130.82 123.91 133.31 128.49 133.00 145.47 148.50 148.96 139.39 138.38 145.74 137.00 138.00 145.67 155.11 150.35 141.85 137.53 139.62 149.37 152.96 165.30 156.87 166.06

Answer rating: 100% (QA)

To answer the questions we need to calculate the average return standard deviation correlation and beta for the given stock data First lets organize the data Date SP 500 Adj Close Price BBY Adj Close ... View the full answer