The attached Excel sheet contains the data that you need to complete this assignment.

1. Calculate the beta of Wal-Mart and Apple. Use five years of monthly stock data. You may use the Exchange Traded Fund Spyders (Ticker SPY) as the proxy for the market.
2. Calculate the Standard Deviation and the Coefficient of Variation for the data given for Wal-Mart, Apple as well as for the ETF Spyders.
3. Calculate the Standard Deviation and the Coefficient of Variation for a portfolio that consists of a 40% weighting in Wal-Mart and a 60% weighting in Apple.
4. 

Adjusted Closing Stock Prices Date SPY AAPL WMT 15-12-01 184.7905 24.18211 54.14414 16-01-01 176.6355 22.36259 59.10441 16-02-01 176.4895 22.21326 59.0866 16-03-01 187.3948 25.17489 61.00152 16-04-01 189.1037 21.6524 59.99956 16-05-01 192.3206 23.06602 63.50782 16-06-01 191.9907 22.21647 65.99738 16-07-01 200.0276 24.21734 65.95219 16-08-01 200.2672 24.65656 64.56935 16-09-01 199.2722 26.41399 65.63018 16-10-01 196.8066 26.52848 63.71914 16-11-01 204.0566 25.82286 64.09225 16-12-01 206.9733 27.20013 62.90013 17-01-01 211.9188 28.49884 61.16897 17-02-01 220.2454 32.17187 65.00923 17-03-01 219.5655 33.88459 66.06323 17-04-01 222.7096 33.88223 69.4111 17-05-01 225.8527 36.03097 72.56868 17-06-01 226.1894 34.10971 70.34034 17-07-01 231.9643 35.22523 74.34624 17-08-01 232.6411 38.84178 72.56171 17-09-01 236.1567 36.64514 73.0836 17-10-01 242.9211 40.19267 81.66021 17-11-01 250.3462 40.86081 90.93829 17-12-01 252.0938 40.3825 92.35993 18-01-01 267.6628 39.95298 100.7527 18-02-01 257.9305 42.50388 85.07267 18-03-01 249.8598 40.19973 84.08971 18-04-01 252.157 39.59594 84.10614 18-05-01 258.2867 44.77365 78.47753 18-06-01 258.6108 44.52298 81.9475 18-07-01 269.3957 45.76888 85.37273 18-08-01 277.9948 54.74997 91.71613 18-09-01 278.3874 54.4858 90.3723 18-10-01 260.3228 52.82521 96.50231 18-11-01 265.1516 43.10302 93.97139 18-12-01 240.4015 38.2058 89.64091 18-12-01 240.4015 38.2058 89.64091 19-01-01 261.1657 261.1657 40.31301 92.7232 19-02-01 269.6315 41.93822 95.78075 19-03-01 273.3082 46.20462 94.36809 19-04-01 285.7265 48.81222 100.0414 19-05-01 267.5054 267.5054 42.58512 98.67945 19-06-01 284.7353 48.3287 108.0541 19-07-01 290.4461 52.02074 107.9466 19-08-01 285.583 50.97076 111.741 19-09-01 289.8016 54.89745 116.6349 19-10-01 297.5754 60.97374 117.0477 19-11-01 308.3472 65.50584 117.0378 19-12-01 315.7539 72.19286 116.7921 20-01-01 317.1782 76.092 113.0218 20-02-01 292.0685 67.20463 106.2991 20-03-01 254.1034 62.66471 112.1629 20-04-01 288.0543 72.40115 120.5222 20-05-01 301.778778.34998 123.0109 20-06-01 305.7849 90.87907 119.2896 20-07-01 325.2181 105.8861 128.8702 20-08-01 347.9173 128.5859 138.2815 20-09-01 333.5548 115.6105 139.91 20-10-01 326.54 108.6725 138.75 20-11-01 355.33 117.1379 150.24 Adjusted Closing Stock Prices Date SPY AAPL WMT 15-12-01 184.7905 24.18211 54.14414 16-01-01 176.6355 22.36259 59.10441 16-02-01 176.4895 22.21326 59.0866 16-03-01 187.3948 25.17489 61.00152 16-04-01 189.1037 21.6524 59.99956 16-05-01 192.3206 23.06602 63.50782 16-06-01 191.9907 22.21647 65.99738 16-07-01 200.0276 24.21734 65.95219 16-08-01 200.2672 24.65656 64.56935 16-09-01 199.2722 26.41399 65.63018 16-10-01 196.8066 26.52848 63.71914 16-11-01 204.0566 25.82286 64.09225 16-12-01 206.9733 27.20013 62.90013 17-01-01 211.9188 28.49884 61.16897 17-02-01 220.2454 32.17187 65.00923 17-03-01 219.5655 33.88459 66.06323 17-04-01 222.7096 33.88223 69.4111 17-05-01 225.8527 36.03097 72.56868 17-06-01 226.1894 34.10971 70.34034 17-07-01 231.9643 35.22523 74.34624 17-08-01 232.6411 38.84178 72.56171 17-09-01 236.1567 36.64514 73.0836 17-10-01 242.9211 40.19267 81.66021 17-11-01 250.3462 40.86081 90.93829 17-12-01 252.0938 40.3825 92.35993 18-01-01 267.6628 39.95298 100.7527 18-02-01 257.9305 42.50388 85.07267 18-03-01 249.8598 40.19973 84.08971 18-04-01 252.157 39.59594 84.10614 18-05-01 258.2867 44.77365 78.47753 18-06-01 258.6108 44.52298 81.9475 18-07-01 269.3957 45.76888 85.37273 18-08-01 277.9948 54.74997 91.71613 18-09-01 278.3874 54.4858 90.3723 18-10-01 260.3228 52.82521 96.50231 18-11-01 265.1516 43.10302 93.97139 18-12-01 240.4015 38.2058 89.64091 18-12-01 240.4015 38.2058 89.64091 19-01-01 261.1657 261.1657 40.31301 92.7232 19-02-01 269.6315 41.93822 95.78075 19-03-01 273.3082 46.20462 94.36809 19-04-01 285.7265 48.81222 100.0414 19-05-01 267.5054 267.5054 42.58512 98.67945 19-06-01 284.7353 48.3287 108.0541 19-07-01 290.4461 52.02074 107.9466 19-08-01 285.583 50.97076 111.741 19-09-01 289.8016 54.89745 116.6349 19-10-01 297.5754 60.97374 117.0477 19-11-01 308.3472 65.50584 117.0378 19-12-01 315.7539 72.19286 116.7921 20-01-01 317.1782 76.092 113.0218 20-02-01 292.0685 67.20463 106.2991 20-03-01 254.1034 62.66471 112.1629 20-04-01 288.0543 72.40115 120.5222 20-05-01 301.778778.34998 123.0109 20-06-01 305.7849 90.87907 119.2896 20-07-01 325.2181 105.8861 128.8702 20-08-01 347.9173 128.5859 138.2815 20-09-01 333.5548 115.6105 139.91 20-10-01 326.54 108.6725 138.75 20-11-01 355.33 117.1379 150.24