Question: 1. What is the average return for Microsoft Corporation (MSFT)? 2. What is the standard deviation for Home Depot, Inc. (HD),? 3. What is the

1. What is the average return for Microsoft Corporation (MSFT)?

2. What is the standard deviation for Home Depot, Inc. (HD),?

3. What is the correlation between BBY and COST?

1. What is the average return for Microsoft Corporation (MSFT)? 2. What is the standard deviation for Home Depot, Inc. (HD),? 3. What is

Date S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price COST Adj Close Price 1/1/2015 $ 1,994.99 $ 30.34 $ 94.43 $ 36.39 $ 75.91 $ 126.33 2/1/2015 $ 2,104.50 $ 32.84 $ 103.78 $ 39.50 $ 78.97 $ 129.84 3/1/2015 $ 2,067.89 $ 32.58 $ 102.75 $ 36.89 $ 82.22 $ 138.62 4/1/2015 $ 2,085.51 $ 30.41 97.25 $ 44.13 $ 78.77 $ 130.88 5/1/2015 $ 2,107.39 $ 30.45 $ 101.28 $ 42.51 $ 79.19 $ 130.82 6/1/2015 $ 2,063.11 $ 28.62 101.02 $ 40.31 $ 85.77 $ 123.91 7/1/2015 $ 2,103.84 $ 28.53 106.95 $ 42.64 $ 94.01 $ 133.31 8/1/2015 $ 1,972.18 $ 32.46 106.43 $ 39.74 $ 89.73 $ 128.49 9/1/2015 $ 1,920.03 $ 32.80 105.54 $ 40.68 $ 89.90 $ 133.00 10/1/2015 $ 2,079.36 $ 31.14 113.56 $ 48.38 $ 101.97 $ 145.47 11/1/2015 $ 2,080.41 $ 28.25 122.97 $ 49.96 $ 104.24 $ 148.50 12/1/2015 $ 2,043.94 $ 27.07 121.47 $ 51.34 $ 104.66 $ 148.96 1/1/2016 $ 1,940.24 $ 25.02 116.02 $ 50.98 $ 112.21 $ 139.39 2/1/2016 $ 1,932.23 $ 29.01 114.51 $ 47.08 $ 106.92 $ 138.38 3/1/2016 $ 2,059.74 $ 29.06 123.10 $ 51.47 $ 114.10 $ 145.74 4/1/2016 $ 2,065.30 $ 29.38 $ 124.20 $ 46.48 $ 117.58 $ 137.00 5/1/2016 $ 2,096.95 $ 29.46 $ 122.56 $ 49.39 $ 118.81 $ 138.00 6/1/2016 $ 2,098.86 $ 28.02 119.06 $ 48.02 $ 114.28 $ 145.67 7/1/2016 $ 2,173.60 $ 31.06 128.90 $ 53.19 $ 123.94 $ 155.11 8/1/2016 $ 2,170.95 $ 35.57 125.06 $ 53.93 $ 126.12 $ 150.35 9/1/2016 $ 2,168.27 $ 35.29 120.60 $ 54.39 $ 128.27 $ 141.85 10/1/2016 $ 2,126.15 $ 36.23 114.35 $ 56.59 $ 130.99 $ 137.53 11/1/2016 $ 2,198.81 $ 42.55 121.28 $ 56.91 $ 118.42 $ 139.62 12/1/2016 $ 2,238.83 $ 39.73 $ 126.33 $ 59.08 $ 115.05 $ 149.37 1/1/2017 $ 2,278.87 $ 41.71 $ 129.63 $ 61.46 $ 130.32 $ 152.96 2/1/2017 $ 2,363.64 $ 41.34 $ 136.53 $ 60.83 $ 135.54 $ 165.30 3/1/2017 $ 2,362.72 $ 46.04 $ 138.34 $ 62.99 $ 142.05 $ 156.87 4/1/2017 $ 2,384.20 $ 48.90 $ 147.97 $ 65.48 $ 150.25 $ 166.06 5/1/2017 $ 6/1/2017 $ 7/1/2017 $ 8/1/2017 $ 9/1/2017 $ 10/1/2017 $ 11/1/2017 $ 12/1/2017 $ 1/1/2018 $ 2/1/2018 $ 3/1/2018 $ 4/1/2018 $ 5/1/2018 $ 6/1/2018 $ 7/1/2018 $ 8/1/2018 $ 9/1/2018 $ 10/1/2018 $ 11/1/2018 $ 12/1/2018 $ 1/1/2019 $ 2/1/2019 $ 3/1/2019 $ 4/1/2019 $ 5/1/2019 $ 6/1/2019 $ 7/1/2019 $ 2,411.80 $ 2,423.41 $ 2,470.30 $ 2,471.65 $ 2,519.36 $ 2,575.26 $ 2,584.84 $ 2,673.61 $ 2,823.81 $ 2,713.83 $ 2,640.87 $ 2,648.05 $ 2,705.27 $ 2,718.37 $ 2,816.29 $ 2,901.52 $ 2,913.98 $ 2,711.74 $ 2,760.17 $ 2,506.85 $ 2,704.10 $ 2,784.49 $ 2,834.40 $ 2,945.83 $ 2,752.06 $ 2,941.76 $ 2,980.38 $ 56.05 $ 54.11 $ 55.39 $ 51.52 $ 54.08 $ 53.46 $ 56.93 $ 65.39 $ 70.16 $ 69.56 $ 67.21 $ 73.96 $ 65.96 $ 72.08 $ 72.96 $ 77.36 $ 77.17 $ 68.62 $ 63.17 $ 51.79 $ 58.37 $ 67.83 $ 70.02 $ 73.84 $ 62.19 $ 69.20 $ 76.53 $ 145.52 $ 146.25 $ 142.63 $ 142.89 $ 156.86 $ 158.99 $ 172.46 $ 182.69 $ 193.65 $ 175.69 $ 171.81 $ 179.15 $ 180.84 $ 190.19 $ 192.55 $ 195.72 $ 202.97 $ 172.33 $ 176.68 $ 169.36 $ 180.90 $ 182.49 $ 189.14 $ 202.28 $ 188.53 $ 206.52 $ 213.69 $ 66.80 $ 66.31 $ 69.94 $ 71.93 $ 72.04 $ 80.44 $ 81.40 $ 83.14 $ 92.35 $ 91.14 $ 89.13 $ 91.32 $ 96.52 $ 96.71 $ 104.04 $ 110.17 $ 112.60 $ 105.16 $ 109.17 $ 100.43 $ 103.26 $ 110.77 $ 117.12 $ 129.69 $ 122.81 $ 133.52 $ 135.82 $ 151.46 $ 150.98 $ 169.25 $ 171.97 $ 170.87 $ 180.06 $ 177.18 $ 176.46 $ 186.89 $ 178.32 $ 159.79 $ 172.00 $ 191.78 $ 194.32 $ 172.58 $ 175.73 $ 164.46 $ 151.79 $ 140.61 $ 131.09 $ 166.69 $ 161.45 $ 166.69 $ 193.40 $ 177.47 $ 193.00 $ 194.23 $ 168.79 156.11 154.72 152.99 160.88 157.73 180.60 182.79 191.39 187.49 185.56 194.15 195.22 206.39 216.00 230.24 232.55 226.36 228.98 202.17 213.00 217.08 240.95 244.33 238.41 263.68 275.02 Date S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price COST Adj Close Price 1/1/2015 $ 1,994.99 $ 30.34 $ 94.43 $ 36.39 $ 75.91 $ 126.33 2/1/2015 $ 2,104.50 $ 32.84 $ 103.78 $ 39.50 $ 78.97 $ 129.84 3/1/2015 $ 2,067.89 $ 32.58 $ 102.75 $ 36.89 $ 82.22 $ 138.62 4/1/2015 $ 2,085.51 $ 30.41 97.25 $ 44.13 $ 78.77 $ 130.88 5/1/2015 $ 2,107.39 $ 30.45 $ 101.28 $ 42.51 $ 79.19 $ 130.82 6/1/2015 $ 2,063.11 $ 28.62 101.02 $ 40.31 $ 85.77 $ 123.91 7/1/2015 $ 2,103.84 $ 28.53 106.95 $ 42.64 $ 94.01 $ 133.31 8/1/2015 $ 1,972.18 $ 32.46 106.43 $ 39.74 $ 89.73 $ 128.49 9/1/2015 $ 1,920.03 $ 32.80 105.54 $ 40.68 $ 89.90 $ 133.00 10/1/2015 $ 2,079.36 $ 31.14 113.56 $ 48.38 $ 101.97 $ 145.47 11/1/2015 $ 2,080.41 $ 28.25 122.97 $ 49.96 $ 104.24 $ 148.50 12/1/2015 $ 2,043.94 $ 27.07 121.47 $ 51.34 $ 104.66 $ 148.96 1/1/2016 $ 1,940.24 $ 25.02 116.02 $ 50.98 $ 112.21 $ 139.39 2/1/2016 $ 1,932.23 $ 29.01 114.51 $ 47.08 $ 106.92 $ 138.38 3/1/2016 $ 2,059.74 $ 29.06 123.10 $ 51.47 $ 114.10 $ 145.74 4/1/2016 $ 2,065.30 $ 29.38 $ 124.20 $ 46.48 $ 117.58 $ 137.00 5/1/2016 $ 2,096.95 $ 29.46 $ 122.56 $ 49.39 $ 118.81 $ 138.00 6/1/2016 $ 2,098.86 $ 28.02 119.06 $ 48.02 $ 114.28 $ 145.67 7/1/2016 $ 2,173.60 $ 31.06 128.90 $ 53.19 $ 123.94 $ 155.11 8/1/2016 $ 2,170.95 $ 35.57 125.06 $ 53.93 $ 126.12 $ 150.35 9/1/2016 $ 2,168.27 $ 35.29 120.60 $ 54.39 $ 128.27 $ 141.85 10/1/2016 $ 2,126.15 $ 36.23 114.35 $ 56.59 $ 130.99 $ 137.53 11/1/2016 $ 2,198.81 $ 42.55 121.28 $ 56.91 $ 118.42 $ 139.62 12/1/2016 $ 2,238.83 $ 39.73 $ 126.33 $ 59.08 $ 115.05 $ 149.37 1/1/2017 $ 2,278.87 $ 41.71 $ 129.63 $ 61.46 $ 130.32 $ 152.96 2/1/2017 $ 2,363.64 $ 41.34 $ 136.53 $ 60.83 $ 135.54 $ 165.30 3/1/2017 $ 2,362.72 $ 46.04 $ 138.34 $ 62.99 $ 142.05 $ 156.87 4/1/2017 $ 2,384.20 $ 48.90 $ 147.97 $ 65.48 $ 150.25 $ 166.06 5/1/2017 $ 6/1/2017 $ 7/1/2017 $ 8/1/2017 $ 9/1/2017 $ 10/1/2017 $ 11/1/2017 $ 12/1/2017 $ 1/1/2018 $ 2/1/2018 $ 3/1/2018 $ 4/1/2018 $ 5/1/2018 $ 6/1/2018 $ 7/1/2018 $ 8/1/2018 $ 9/1/2018 $ 10/1/2018 $ 11/1/2018 $ 12/1/2018 $ 1/1/2019 $ 2/1/2019 $ 3/1/2019 $ 4/1/2019 $ 5/1/2019 $ 6/1/2019 $ 7/1/2019 $ 2,411.80 $ 2,423.41 $ 2,470.30 $ 2,471.65 $ 2,519.36 $ 2,575.26 $ 2,584.84 $ 2,673.61 $ 2,823.81 $ 2,713.83 $ 2,640.87 $ 2,648.05 $ 2,705.27 $ 2,718.37 $ 2,816.29 $ 2,901.52 $ 2,913.98 $ 2,711.74 $ 2,760.17 $ 2,506.85 $ 2,704.10 $ 2,784.49 $ 2,834.40 $ 2,945.83 $ 2,752.06 $ 2,941.76 $ 2,980.38 $ 56.05 $ 54.11 $ 55.39 $ 51.52 $ 54.08 $ 53.46 $ 56.93 $ 65.39 $ 70.16 $ 69.56 $ 67.21 $ 73.96 $ 65.96 $ 72.08 $ 72.96 $ 77.36 $ 77.17 $ 68.62 $ 63.17 $ 51.79 $ 58.37 $ 67.83 $ 70.02 $ 73.84 $ 62.19 $ 69.20 $ 76.53 $ 145.52 $ 146.25 $ 142.63 $ 142.89 $ 156.86 $ 158.99 $ 172.46 $ 182.69 $ 193.65 $ 175.69 $ 171.81 $ 179.15 $ 180.84 $ 190.19 $ 192.55 $ 195.72 $ 202.97 $ 172.33 $ 176.68 $ 169.36 $ 180.90 $ 182.49 $ 189.14 $ 202.28 $ 188.53 $ 206.52 $ 213.69 $ 66.80 $ 66.31 $ 69.94 $ 71.93 $ 72.04 $ 80.44 $ 81.40 $ 83.14 $ 92.35 $ 91.14 $ 89.13 $ 91.32 $ 96.52 $ 96.71 $ 104.04 $ 110.17 $ 112.60 $ 105.16 $ 109.17 $ 100.43 $ 103.26 $ 110.77 $ 117.12 $ 129.69 $ 122.81 $ 133.52 $ 135.82 $ 151.46 $ 150.98 $ 169.25 $ 171.97 $ 170.87 $ 180.06 $ 177.18 $ 176.46 $ 186.89 $ 178.32 $ 159.79 $ 172.00 $ 191.78 $ 194.32 $ 172.58 $ 175.73 $ 164.46 $ 151.79 $ 140.61 $ 131.09 $ 166.69 $ 161.45 $ 166.69 $ 193.40 $ 177.47 $ 193.00 $ 194.23 $ 168.79 156.11 154.72 152.99 160.88 157.73 180.60 182.79 191.39 187.49 185.56 194.15 195.22 206.39 216.00 230.24 232.55 226.36 228.98 202.17 213.00 217.08 240.95 244.33 238.41 263.68 275.02

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The excel file needed for four quiz problems is attached here. Note: use this excel file when the question says, "Refer to the Excel file". In the attached excel file, you will find the Adjusted...

Note: Enter your answer in percentages rounded off to two decimal points. Do not enter % in the answer box. If your answer is negative, do enter the negative sign. Refer to the excl spreadsheet 1....

Detective Activity Use the notes below, the company descriptions, the Common Size Income Statement & Balance Sheet, and Financial Ratio Comparisons to determine which company goes with which data in...

the question of financial management is on doc file i need useful solutions to get . so provide me solutions Set A 1. The Narayani Corporation manufactures only one product : Flour packed in bags....

This is the Table I need to complete These are the files that were provided to solve the problem This is an example of a completed Table All bonds issued by HomeDepot Inc. Project-Part 2 (Total 15...

Please see attached file. This assignment for Investment Management or Finance 6310 course. Excel file with calculations would be best. Thank you very much. FIN Problem Set #2 1. On January 3, 2005,...

Please review attached documents and answer the following question. Format should be 1 page and a half, doubled space in times new roman. What is your summary of this company?s financial condition?...

1.Yourassetallocationbenchmarkhas 5assetclasses: USlargestocks, USsmallstocks, EAFEEquity, EMEquity,andREITS.Thecorrespondingbenchmarkweightsare: USlargestocks: 35% USsmallstocks: 5% EAFEequity: 40%...

I need these problems worked out because I can't grab the concept , is their any possible way it can be done in 5 hours please! I never had to use this extra feature up until now so I was wondering...

The comptroller of a company is interested in determining whether the average length of long-distance calls by managers varies according to type of telephone. A randomized block design experiment is...

How does service play a part in attention to detail and a part of theater? What things make service providers like actors? How do we create an image in the hospitality industry?

My sister owns a small bakery and takes out several loans to open a second location. Unfortunately, due to unexpected competition and rising ingredient costs, her sales have dropped significantly....

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...