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. What is the average return for Facebook, Inc. (FB)? 2. What is the standard deviation for Microsoft Corporation (MSFT)? 3. What is the correlation between HD and COST? 4. What is the beta for Home Depot, Inc. (HD)?

Date S&P S00 Ad dose Price BBY Ad Cose Price HD Ad Close Price MSFT Ad Close Price FB Ad Cose Price COST Ad dose Price Source: Yahoo! Finance website 1/1/15 $ 1994.99 $ 30.34 $ 3639 $ 75.91 $ 126.33 The Adj Close Price is adjusted for dividends and stock splits 94.43 2/1/15 $ 2,104.50 $ 39 50 129.84 32.84 103.78 78.97 2,067.89 32.58 S 3/1/15 102.75 $ 82.22 3689 138.62 4/1/15 $ 3041 $ 97.25 $ 101 28 130 88 2,085 51 $ 44.13 78.77 30.45 $ 42 51 5/1/15 $ 2,107.39 79.19 130.82 40 31 $ 6/1/15 $ 2,063.11 $ 28.62 $ 28 53 85.77 $ 101.02 123.91 7/1/15 106.95 $ 94.01 $ 133.31 2,103.84 42.64 8/1/15 $ 1972.18 $ 106.43 S 39.74 89.73 3246 128.49 9/1/15 1,920.03 2,079.36 3280 $ 105.54 89.90 4068 133.00 10/1/15 $ 48.38 $ 3114 113.56 10197 145.47 122 97 $ 148 50 11/1/15 $ 2,080.41 $ 28.25 49.96 104.24 S 12/1/15 2,04394 1940 24 1,932.23 $1 34 $ 121.47 $ 27.07 104.66 14896 1/1/16 $ 25.02 116.02 $ 50.98 $ 112.21 139.39 2/1/16 $ 106.92 $ 29.01 114.51 47.08 138.38 3/1/16 $ 2,059.74 29.06 $ 123.10 $ 114.10 $ 5147 145.74 4/1/16 $ 2,065.30 $ 2938 $ 124.20 $ 46.48 117.58 $ 137.00 122 56 5/1/16 $ 2,09695 $ 29.46 $ 49.39 118.81$ 138.00 2,098.86 6/1/16 $ 48.02 $ 114.28 $ 123 94 S 28.02 119.06 145.67 128.90 $ 7/1/16 31.06 2,173.60 53.19 155.11 8/1/16 $ 3557 $ 125.06 $ 126.12 $ 150.35 2,170.95 53.93 120.60 S 9/1/16 2,168 27 35.29 5439 128.27 14185 10/1/16 $ 114.35 $ 130.99 $ 137.53 2,126.15 3623 5659 11/1/16 $ 42.55 121 28 $ 118.42 139.62 2,198.81 56.91 2,238.83 2,278 87 12/1/16 $ 39.73 149.37 126.33 59.08 115.05 130 32 $ 1/1/17 4171 $ 41 34 129.63 $ 152.96 6146 136 53 $ 138 34 2/1/17 2,363.64 $ 6083 135.54 165.30 3/1/17 $ 2362.72 2384.20 $ 4604 62.99 $ 142.05 $ 156.87 4/1/17 $ 4890 14797 65.48 150.25 166.05 145 52 5/1/17 $ $6.05 $ 6680 151.46 2,41180 168.79 6/1/17 $ S4.11 $ 146.25 $ 150.98 $ 2,423.41 6631 156.11 2470.30 7/1/17 $ s5.39 $ 142.63 $ 142 89 $ 69.94 169.25 154.72 8/1/17 $ 5152 7193 $ 2,47165 17197 152.99 9/1/17 2,519.36 54.08 $ 156.86 $ 72.04 170.87 160.88 10/1/17 2,575.26 $ $3.46 158.99 $ 80.44 $ 180.06 157.73 11/1/17 $ 172.46 $ 8140 180.60 2,584.84 56.93 177.18 12/1/17 $ 2,673.61 $ 182.69 $ 83.14 $ 182.79 65.39 176.46 1/1/18 $ 193.65 92.35 186.89 2,823.81 70.16 19139 2/1/18 69.56 $ 175.69 $ 2,713.83 9114 178.32 187.49 3/1/18 $ 89.13 $ 2,64087 67.21 17181 159.79 185.56 4/1/18 $ 2,648.05 $ 73.96 $ 179.15 $ 194.15 9132 172.00 5/1/18 $ 2,705.27 $ 65.96 96 52 19178 $ 180.84 195.22 6/1/18 $ 190.19 $ 192 55 $ 2,718.37 72.08 96.71 194.32 206.39 2,816 29 172 58 7/1/18 $ 72.96 $ 104.04 216.00 230 24 8/1/18 $ 2,90152 $ 7736 $ 110.17 $ 175.73 $ 195.72 202 97 $ 9/1/18 164.46 $ 2,913.98 77.17 112.60 232.55 10/1/18 $ 2,71174 68.62 172.33 105.16 15179 226.36 11/1/18 176.68 $ 109.17 140.61 $ 228.98 2,760.17 63.17 2,506.85 202 17 12/1/18 $ 131.09 $ $179 169.36 100.43 180 90 $ 1/1/19 $ 2,704.10 $ 103.26 $ 166.69 58.37 213.00 2,784.49 2/1/19 $ 67.83 $ 16145 $ 166.69 $ 18249 110.77 217.08 3/1/19 $ 70.02 $ 189.14 2,834.40 $ 117.12 240.95 202 28 $ 2,945.83 2,752.06 4/1/19 $ 73.84 129.69 193.40 $ 24433 188 53 5/1/19 $ 62.19 238.41 12281 177.47 133 52 $ 6/1/19 2,94176 $ 263.68 69.20 205.52 193.00 2,980 38 7/1/19 76.53 $ 213.69 135.82 194.23 275.02 Date S&P S00 Ad dose Price BBY Ad Cose Price HD Ad Close Price MSFT Ad Close Price FB Ad Cose Price COST Ad dose Price Source: Yahoo! Finance website 1/1/15 $ 1994.99 $ 30.34 $ 3639 $ 75.91 $ 126.33 The Adj Close Price is adjusted for dividends and stock splits 94.43 2/1/15 $ 2,104.50 $ 39 50 129.84 32.84 103.78 78.97 2,067.89 32.58 S 3/1/15 102.75 $ 82.22 3689 138.62 4/1/15 $ 3041 $ 97.25 $ 101 28 130 88 2,085 51 $ 44.13 78.77 30.45 $ 42 51 5/1/15 $ 2,107.39 79.19 130.82 40 31 $ 6/1/15 $ 2,063.11 $ 28.62 $ 28 53 85.77 $ 101.02 123.91 7/1/15 106.95 $ 94.01 $ 133.31 2,103.84 42.64 8/1/15 $ 1972.18 $ 106.43 S 39.74 89.73 3246 128.49 9/1/15 1,920.03 2,079.36 3280 $ 105.54 89.90 4068 133.00 10/1/15 $ 48.38 $ 3114 113.56 10197 145.47 122 97 $ 148 50 11/1/15 $ 2,080.41 $ 28.25 49.96 104.24 S 12/1/15 2,04394 1940 24 1,932.23 $1 34 $ 121.47 $ 27.07 104.66 14896 1/1/16 $ 25.02 116.02 $ 50.98 $ 112.21 139.39 2/1/16 $ 106.92 $ 29.01 114.51 47.08 138.38 3/1/16 $ 2,059.74 29.06 $ 123.10 $ 114.10 $ 5147 145.74 4/1/16 $ 2,065.30 $ 2938 $ 124.20 $ 46.48 117.58 $ 137.00 122 56 5/1/16 $ 2,09695 $ 29.46 $ 49.39 118.81$ 138.00 2,098.86 6/1/16 $ 48.02 $ 114.28 $ 123 94 S 28.02 119.06 145.67 128.90 $ 7/1/16 31.06 2,173.60 53.19 155.11 8/1/16 $ 3557 $ 125.06 $ 126.12 $ 150.35 2,170.95 53.93 120.60 S 9/1/16 2,168 27 35.29 5439 128.27 14185 10/1/16 $ 114.35 $ 130.99 $ 137.53 2,126.15 3623 5659 11/1/16 $ 42.55 121 28 $ 118.42 139.62 2,198.81 56.91 2,238.83 2,278 87 12/1/16 $ 39.73 149.37 126.33 59.08 115.05 130 32 $ 1/1/17 4171 $ 41 34 129.63 $ 152.96 6146 136 53 $ 138 34 2/1/17 2,363.64 $ 6083 135.54 165.30 3/1/17 $ 2362.72 2384.20 $ 4604 62.99 $ 142.05 $ 156.87 4/1/17 $ 4890 14797 65.48 150.25 166.05 145 52 5/1/17 $ $6.05 $ 6680 151.46 2,41180 168.79 6/1/17 $ S4.11 $ 146.25 $ 150.98 $ 2,423.41 6631 156.11 2470.30 7/1/17 $ s5.39 $ 142.63 $ 142 89 $ 69.94 169.25 154.72 8/1/17 $ 5152 7193 $ 2,47165 17197 152.99 9/1/17 2,519.36 54.08 $ 156.86 $ 72.04 170.87 160.88 10/1/17 2,575.26 $ $3.46 158.99 $ 80.44 $ 180.06 157.73 11/1/17 $ 172.46 $ 8140 180.60 2,584.84 56.93 177.18 12/1/17 $ 2,673.61 $ 182.69 $ 83.14 $ 182.79 65.39 176.46 1/1/18 $ 193.65 92.35 186.89 2,823.81 70.16 19139 2/1/18 69.56 $ 175.69 $ 2,713.83 9114 178.32 187.49 3/1/18 $ 89.13 $ 2,64087 67.21 17181 159.79 185.56 4/1/18 $ 2,648.05 $ 73.96 $ 179.15 $ 194.15 9132 172.00 5/1/18 $ 2,705.27 $ 65.96 96 52 19178 $ 180.84 195.22 6/1/18 $ 190.19 $ 192 55 $ 2,718.37 72.08 96.71 194.32 206.39 2,816 29 172 58 7/1/18 $ 72.96 $ 104.04 216.00 230 24 8/1/18 $ 2,90152 $ 7736 $ 110.17 $ 175.73 $ 195.72 202 97 $ 9/1/18 164.46 $ 2,913.98 77.17 112.60 232.55 10/1/18 $ 2,71174 68.62 172.33 105.16 15179 226.36 11/1/18 176.68 $ 109.17 140.61 $ 228.98 2,760.17 63.17 2,506.85 202 17 12/1/18 $ 131.09 $ $179 169.36 100.43 180 90 $ 1/1/19 $ 2,704.10 $ 103.26 $ 166.69 58.37 213.00 2,784.49 2/1/19 $ 67.83 $ 16145 $ 166.69 $ 18249 110.77 217.08 3/1/19 $ 70.02 $ 189.14 2,834.40 $ 117.12 240.95 202 28 $ 2,945.83 2,752.06 4/1/19 $ 73.84 129.69 193.40 $ 24433 188 53 5/1/19 $ 62.19 238.41 12281 177.47 133 52 $ 6/1/19 2,94176 $ 263.68 69.20 205.52 193.00 2,980 38 7/1/19 76.53 $ 213.69 135.82 194.23 275.02