Calculate the following variables (*Use population functions):

(a) Actual returns for the index (monthly)

(b) Actual returns for the stock of your company (monthly)

(c) Expected (average) return on the index

(d) Expected (average) return on your company's stock

(e) Variance of the index*

(f) Variance of the stock*

(g) Standard deviation of the index*

(h) Standard deviation of the stock*

(i) Covariance between the index and the stock*

(j) Excess returns for the stock

(k) Excess returns for the index

(l) Beta of the stock by cov-var function*

(m) Beta of the stock by slope function

Draw a scatter chart to show the actual returns of the market index and your stock.

(a) The Y-axis is the return

(b) The X-axis is the time

(c) One line represents the market index

(d) One line represents the common stock

GSPC Actual Returns GSPC There are 84 data points for each. GSPC Excess Returns GSPC There are 84 data points for each. TB GSPC Raw Data Date There are 85 (12*7 plus 1) data points for each. 1/1/15 32.53828 0.03 2/1/15 34.221695 0.02 3/1/15 32.048264 0.03 4/1/15 32.32217 0.02 5/1/15 32.640923 0.02 6/1/15 31.262281 0.02 7/1/15 33.00663 0.03 8/1/15 31.592514 0.07 9/1/15 32.235287 0.02 10/1/15 34.321835 0.02 11/1/15 34.540638 0.12 12/1/15 35.083206 0.23 1/1/16 35.050541 0.26 2/1/16 35.222034 0.31 3/1/16 37.884308 0.29 4/1/16 36.871143 0.23 5/1/16 36.706554 0.27 6/1/16 37.307358 0.27 7/1/16 36.183598 0.30 8/1/16 36.017727 0.30 9/1/16 35.097172 0.29 10/1/16 35.450806 0.33 11/1/16 33.736786 0.45 12/1/16 34.957924 0.51 1/1/17 35.050663 0.51 2/1/17 35.379513 0.52 3/1/17 35.784237 0.74 4/1/17 36.704014 0.80 1994.99 2104.50 2067.89 2085.51 2107.39 2063.11 2103.84 1972.18 1920.03 2079.36 2080.41 2043.94 1940.24 1932.23 2059.74 2065.30 2096.95 2098.86 2173.60 2170.95 2168.27 2126.15 2198.81 2238.83 2278.87 2363.64 2362.72 2384.20 4/1/17 5/1/17 6/1/17 7/1/17 8/1/17 9/1/17 10/1/17 11/1/17 12/1/17 36.704014 38.677444 38.150059 39.313057 39.064342 38.601227 39.746887 39.565357 39.9856 41.475918 1/1/18 2/1/18 3/1/18 37.667343 37.850372 37.991058 4/1/18 5/1/18 37.806431 0.80 0.89 0.98 1.07 1.01 1.03 1.07 1.23 1.32 1.41 1.57 1.70 1.76 1.86 1.90 1.96 2.03 2.13 2.25 2.33 2.37 2.37 2.39 2.40 2.38 2.35 2.17 2.10 6/1/18 38.56255 41.363125 39.535801 7/1/18 8/1/18 9/1/18 10/1/18 2384.20 2411.80 2423.41 2470.30 2471.65 2519.36 2575.26 2584.84 2673.61 2823.81 2713.83 2640.87 2648.05 2705.27 2718.37 2816.29 2901.52 2913.98 2711.74 2760.17 2506.85 2,704.10 2,784.49 2,834.40 2,945.83 2,752.06 2,941.76 2,980.38 2,926.46 2,976.74 3.037.56 40.972816 42.833202 11/1/18 45.087574 42.694019 12/1/18 1/1/19 2/1/19 3/1/19 4/1/19 5/1/19 6/1/19 7/1/19 43.397327 40.881668 42.252209 44.622047 44.685715 46.313789 48.24279 50.451893 49.901901 50.257526 1.95 8/1/19 9/1/19 10/1/19 1.89 1.65 48.24279 50.451893 7/1/19 8/1/19 9/1/19 10/1/19 11/1/19 49.901901 50.257526 49.30648 51.488747 54.325985 12/1/19 1/1/20 2/1/20 3/1/20 49.758503 41.16309 4/1/20 43.063068 43.804401 5/1/20 41.927605 44.732639 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 1/1/21 2/1/21 3/1/21 4/1/21 5/1/21 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 46.901089 46.749577 45.877499 49.256744 52.760075 46.323807 47.13195 50.710854 52.364944 53.635754 52.491058 55.740555 55.036839 51.283661 55.511295 51.651012 58.760201 2.10 1.95 1.89 1.65 1.54 1.54 1.52 1.52 0.29 0.14 0.13 0.16 0.13 0.10 0.11 0.10 0.09 0.09 0.08 0.04 0.03 0.02 0.02 0.04 0.05 0.05 0.04 0.05 0.05 0.06 2,980.38 2,926.46 2,976.74 3,037.56 3,140.98 3,230.78 3,225.52 2,954.22 2,584.59 2,912.43 3,044.31 3,100.29 3,271.12 3,500.31 3,363.00 3,269.96 3,621.63 3,756.07 3,714.24 3,811.15 3,972.89 4,181.17 4,204.11 4,297.50 4,395.26 4,522.68 4,307.54 4,605.38 4,567.00 4,766.18 Beta (B) Expected (Avg.) Returns Your Ticker GSPC 1.99% Your Ticker SGSPC By Var-Cov By Slope HD VS GSPC 20.00% Covariance (Your Ticker Symbol, GSPC) 15.00% 10.00% 5.00% Variances 0.00% Your Ticker GSPC -5.00% Monthly Annualized -10.00% - 15.00% -20.00% Standard Deviations Your Ticker SGSPC Monthly Annualized HD GSPC Your Ticker GSPC* (*:use data/data analysis/descriptive statistic/summary statistics) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count GSPC Actual Returns GSPC There are 84 data points for each. GSPC Excess Returns GSPC There are 84 data points for each. TB GSPC Raw Data Date There are 85 (12*7 plus 1) data points for each. 1/1/15 32.53828 0.03 2/1/15 34.221695 0.02 3/1/15 32.048264 0.03 4/1/15 32.32217 0.02 5/1/15 32.640923 0.02 6/1/15 31.262281 0.02 7/1/15 33.00663 0.03 8/1/15 31.592514 0.07 9/1/15 32.235287 0.02 10/1/15 34.321835 0.02 11/1/15 34.540638 0.12 12/1/15 35.083206 0.23 1/1/16 35.050541 0.26 2/1/16 35.222034 0.31 3/1/16 37.884308 0.29 4/1/16 36.871143 0.23 5/1/16 36.706554 0.27 6/1/16 37.307358 0.27 7/1/16 36.183598 0.30 8/1/16 36.017727 0.30 9/1/16 35.097172 0.29 10/1/16 35.450806 0.33 11/1/16 33.736786 0.45 12/1/16 34.957924 0.51 1/1/17 35.050663 0.51 2/1/17 35.379513 0.52 3/1/17 35.784237 0.74 4/1/17 36.704014 0.80 1994.99 2104.50 2067.89 2085.51 2107.39 2063.11 2103.84 1972.18 1920.03 2079.36 2080.41 2043.94 1940.24 1932.23 2059.74 2065.30 2096.95 2098.86 2173.60 2170.95 2168.27 2126.15 2198.81 2238.83 2278.87 2363.64 2362.72 2384.20 4/1/17 5/1/17 6/1/17 7/1/17 8/1/17 9/1/17 10/1/17 11/1/17 12/1/17 36.704014 38.677444 38.150059 39.313057 39.064342 38.601227 39.746887 39.565357 39.9856 41.475918 1/1/18 2/1/18 3/1/18 37.667343 37.850372 37.991058 4/1/18 5/1/18 37.806431 0.80 0.89 0.98 1.07 1.01 1.03 1.07 1.23 1.32 1.41 1.57 1.70 1.76 1.86 1.90 1.96 2.03 2.13 2.25 2.33 2.37 2.37 2.39 2.40 2.38 2.35 2.17 2.10 6/1/18 38.56255 41.363125 39.535801 7/1/18 8/1/18 9/1/18 10/1/18 2384.20 2411.80 2423.41 2470.30 2471.65 2519.36 2575.26 2584.84 2673.61 2823.81 2713.83 2640.87 2648.05 2705.27 2718.37 2816.29 2901.52 2913.98 2711.74 2760.17 2506.85 2,704.10 2,784.49 2,834.40 2,945.83 2,752.06 2,941.76 2,980.38 2,926.46 2,976.74 3.037.56 40.972816 42.833202 11/1/18 45.087574 42.694019 12/1/18 1/1/19 2/1/19 3/1/19 4/1/19 5/1/19 6/1/19 7/1/19 43.397327 40.881668 42.252209 44.622047 44.685715 46.313789 48.24279 50.451893 49.901901 50.257526 1.95 8/1/19 9/1/19 10/1/19 1.89 1.65 48.24279 50.451893 7/1/19 8/1/19 9/1/19 10/1/19 11/1/19 49.901901 50.257526 49.30648 51.488747 54.325985 12/1/19 1/1/20 2/1/20 3/1/20 49.758503 41.16309 4/1/20 43.063068 43.804401 5/1/20 41.927605 44.732639 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 1/1/21 2/1/21 3/1/21 4/1/21 5/1/21 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 46.901089 46.749577 45.877499 49.256744 52.760075 46.323807 47.13195 50.710854 52.364944 53.635754 52.491058 55.740555 55.036839 51.283661 55.511295 51.651012 58.760201 2.10 1.95 1.89 1.65 1.54 1.54 1.52 1.52 0.29 0.14 0.13 0.16 0.13 0.10 0.11 0.10 0.09 0.09 0.08 0.04 0.03 0.02 0.02 0.04 0.05 0.05 0.04 0.05 0.05 0.06 2,980.38 2,926.46 2,976.74 3,037.56 3,140.98 3,230.78 3,225.52 2,954.22 2,584.59 2,912.43 3,044.31 3,100.29 3,271.12 3,500.31 3,363.00 3,269.96 3,621.63 3,756.07 3,714.24 3,811.15 3,972.89 4,181.17 4,204.11 4,297.50 4,395.26 4,522.68 4,307.54 4,605.38 4,567.00 4,766.18 Beta (B) Expected (Avg.) Returns Your Ticker GSPC 1.99% Your Ticker SGSPC By Var-Cov By Slope HD VS GSPC 20.00% Covariance (Your Ticker Symbol, GSPC) 15.00% 10.00% 5.00% Variances 0.00% Your Ticker GSPC -5.00% Monthly Annualized -10.00% - 15.00% -20.00% Standard Deviations Your Ticker SGSPC Monthly Annualized HD GSPC Your Ticker GSPC* (*:use data/data analysis/descriptive statistic/summary statistics) Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count