Q1; you are working in investment company , Ahmed come to you and ask to advise him about investing his wealth, he wants to invest in next firms in the table. in doing so, you are required to compute; monthly returns ( for individual asset and Portfolio) , risk, ( for individual asset and Portfolio). beta , standard deviation , variance, covariance ( between assets and between assets and market index) correlation between individual assets and between assets and market index. he believes that weights for individuals assets inside portfolio like that; AAPL 40% WMT 35% FB 25%. after that explain to him your calculation as report. Show your steps in your calculation

Date AAPL WMT 1/1/2015 26.59675 73.16325 2/1/2015 29.16199 72.25925 3/1/2015 28.35861 70.81284 4/1/2015 28.5227 67.60051 5/1/2015 29.69186 64.32658 6/1/2015 28.70592 61.82145 7/1/2015 27.76073 62.73661 8/1/2015 25.80627 56.41763 9/1/2015 25.35753 56.89939 10/1/2015 27.47258 50.23012 11/1/2015 27.1967 51.63418 12/1/2015 24.30244 53.79292 1/1/2016 22.47387 58.72101 2/1/2016 22.3238 58.70332 3/1/2016 25.30017 60.60584 4/1/2016 21.76014 59.61038 5/1/2016 23.1807963.09586 6/1/2016 22.32702 65.56928 7/1/2016 24.33785 65.52438 8/1/2016 24.77926 64.15049 9/1/2016 26.54543 65.20445 10/1/2016 26.66048 63.30581 11/1/2016 25.95136 63.67648 12/1/2016 27.33548 62.49211 1/1/2017 28.64066 60.77219 2/1/2017 32.33197 64.58753 3/1/2017 34.0532 65.6347 4/1/2017 34.05083 68.96086 5/1/2017 36.2102772.09795 6/1/2017 34.27944 69.88405 7/1/2017 35.40052 73.86398 8/1/2017 39.03506 72.09103 9/1/2017 36.82749 72.60954 10/1/2017 40.39268 81.13049 11/1/2017 41.06413 90.34839 12/1/2017 40.58344 91.76083 1/1/2018 40.15179 99.57727 2/1/2018 42.71537 84.0802 3/1/2018 40.39977 83.1087 4/1/2018 39.7929783.12496 5/1/2018 44.99645 77.562 6/1/2018 44.74454 80.9915 7/1/2018 45.99663 84.37677 8/1/2018 55.02241 90.64616 9/1/2018 54.75693 89.318 FB Nasdaq 75.91 4635.24 78.97 4963.53 82.22 4900.88 78.77 4941.42 79.19 5070.03 85.77 4986.87 94.01 5128.28 89.43 4776.51 89.9 4620.16 101.975053.75 104.24 5108.67 104.66 5007.41 112.21 4613.95 106.92 4557.95 114.1 4869.85 117.58 4775.36 118.81 4948.05 114.28 4842.67 123.94 5162.13 126.12 5213.22 128.27 5312 130.99 5189.14 118.42 5323.68 115.05 5383.12 130.325614.79 135.54 5825.44 142.05 5911.74 150.25 6047.61 151.466198.52 150.986140.42 169.25 6348.12 171.97 6428.66 170.876495.96 180.06 6727.67 177.18 6873.97 176.46 6903.39 186.89 7411.48 178.32 7273.01 159.79 7063.45 172 7066.27 191.78 7442.12 194.32 7510.3 172.58 7671.79 175.73 8109.54 164.46 8046.35 Arab Open University 10/1/2018 53.08807 95.37651 151.79 7305.9 11/1/2018 43.31751 92.87512 140.61 7330.54 12/1/2018 38.39592 88.59516 131.09 6635.28 1/1/2019 40.51361 91.6415 166.697281.74 2/1/2019 42.14691 94.66337 161.45 7532.53 3/1/2019 46.43454 93.26718 166.697729.32 4/1/2019 49.05512 98.87426 193.4 8095.39 5/1/2019 42.79703 97.52825 177.47 7453.15 6/1/2019 48.56918 106.7936 193 8006.24 7/1/2019 52.2796 106.6873 194.23 8175.42 8/1/2019 51.2244 | 110.4375 185.67 7962.88 9/1/2019 55.17063 115.2742 178.08 7999.34 10/1/201961.27716 113.895 191.65 8292.36 11/1/2019 65.8318 | 115.6725 201.64 8665.47 12/1/201972.55209 115.4296 205.25 8972.6 Date AAPL WMT 1/1/2015 26.59675 73.16325 2/1/2015 29.16199 72.25925 3/1/2015 28.35861 70.81284 4/1/2015 28.5227 67.60051 5/1/2015 29.69186 64.32658 6/1/2015 28.70592 61.82145 7/1/2015 27.76073 62.73661 8/1/2015 25.80627 56.41763 9/1/2015 25.35753 56.89939 10/1/2015 27.47258 50.23012 11/1/2015 27.1967 51.63418 12/1/2015 24.30244 53.79292 1/1/2016 22.47387 58.72101 2/1/2016 22.3238 58.70332 3/1/2016 25.30017 60.60584 4/1/2016 21.76014 59.61038 5/1/2016 23.1807963.09586 6/1/2016 22.32702 65.56928 7/1/2016 24.33785 65.52438 8/1/2016 24.77926 64.15049 9/1/2016 26.54543 65.20445 10/1/2016 26.66048 63.30581 11/1/2016 25.95136 63.67648 12/1/2016 27.33548 62.49211 1/1/2017 28.64066 60.77219 2/1/2017 32.33197 64.58753 3/1/2017 34.0532 65.6347 4/1/2017 34.05083 68.96086 5/1/2017 36.2102772.09795 6/1/2017 34.27944 69.88405 7/1/2017 35.40052 73.86398 8/1/2017 39.03506 72.09103 9/1/2017 36.82749 72.60954 10/1/2017 40.39268 81.13049 11/1/2017 41.06413 90.34839 12/1/2017 40.58344 91.76083 1/1/2018 40.15179 99.57727 2/1/2018 42.71537 84.0802 3/1/2018 40.39977 83.1087 4/1/2018 39.7929783.12496 5/1/2018 44.99645 77.562 6/1/2018 44.74454 80.9915 7/1/2018 45.99663 84.37677 8/1/2018 55.02241 90.64616 9/1/2018 54.75693 89.318 FB Nasdaq 75.91 4635.24 78.97 4963.53 82.22 4900.88 78.77 4941.42 79.19 5070.03 85.77 4986.87 94.01 5128.28 89.43 4776.51 89.9 4620.16 101.975053.75 104.24 5108.67 104.66 5007.41 112.21 4613.95 106.92 4557.95 114.1 4869.85 117.58 4775.36 118.81 4948.05 114.28 4842.67 123.94 5162.13 126.12 5213.22 128.27 5312 130.99 5189.14 118.42 5323.68 115.05 5383.12 130.325614.79 135.54 5825.44 142.05 5911.74 150.25 6047.61 151.466198.52 150.986140.42 169.25 6348.12 171.97 6428.66 170.876495.96 180.06 6727.67 177.18 6873.97 176.46 6903.39 186.89 7411.48 178.32 7273.01 159.79 7063.45 172 7066.27 191.78 7442.12 194.32 7510.3 172.58 7671.79 175.73 8109.54 164.46 8046.35 Arab Open University 10/1/2018 53.08807 95.37651 151.79 7305.9 11/1/2018 43.31751 92.87512 140.61 7330.54 12/1/2018 38.39592 88.59516 131.09 6635.28 1/1/2019 40.51361 91.6415 166.697281.74 2/1/2019 42.14691 94.66337 161.45 7532.53 3/1/2019 46.43454 93.26718 166.697729.32 4/1/2019 49.05512 98.87426 193.4 8095.39 5/1/2019 42.79703 97.52825 177.47 7453.15 6/1/2019 48.56918 106.7936 193 8006.24 7/1/2019 52.2796 106.6873 194.23 8175.42 8/1/2019 51.2244 | 110.4375 185.67 7962.88 9/1/2019 55.17063 115.2742 178.08 7999.34 10/1/201961.27716 113.895 191.65 8292.36 11/1/2019 65.8318 | 115.6725 201.64 8665.47 12/1/201972.55209 115.4296 205.25 8972.6