Using AAPLs historical data (provided as a picture) but you can access the file at yahoo finance historical data apple 5 years. Once you have the adjusted close price, calculate the following:

-Monthly Returns

-Average

-Variance

-Standard Deviation

-95% confidence interval for the monthly returns

MUST BE DONE IN EXCEL. I WILL PROVIDE WHAT IT SHOULD LOOK LIKE

RUM WITH WORD DSCHAP wer ROS TO MA OLIE SOFIE WE GUE cm IV we WEB w TRE ET Ple turt WEB INTER SEO WEB OSSER NA WWE MAAL WIND ENGET MER WERE MINTON SALS w US w ME w COM BRE MORE WE MA JH8.3. HOTEL BE MENE ... ull HHMA/ WAHILIH PETER Dan ... ww we todo . . et 2002/1/IT TIT 2008//6 It // Weber 1/2/2008 301.69.16 12/2007 1081 GE . 10/2007 110 12 . 04 . 7/2/2007 11065 6/1/2007 10525 04 71/2007 006 42/2007 10021 . 2/1/2007 929 . 11/2007 09:15 Soured Return the Avg My from DW Core Devo TI CH 100 . . FO . 10// 26 G AAPL Low R2501 35.014999 36.067101 2009 35.602501 32.102401 37 290001 30.115002 41.320000 41 16000 41.174999 Cla 15015 35.91249 3BT 16. 3712290 41 000000 18599999 12259 962502 Adi Cine non 33.907543 36057461 799 35251129 3.2002 36 67 40.727229 40 PORSR an 41213 34 982342 56130 46.229075 39 05053 ALE 485721 15.02.12 71 SERE215400 2515200 2727 16THOD 2640 979 2017155200 24 919 21717800 20 75 000 26617200 41 65749 211 1574716600 4 271SRAROON 315299.00 20160000 CORO 2014 298 RONDO Date 2017-01-01 2017-04-01 2017-05-01 2017.04.01 2017-07-01 2017-08-01 2017-09.00 2017-10-01 2017-11-01 2017.12.01 2018-01-01 901.01 2018-03-01 2018-04-01 2018.05.01 2010-06-01 2018-07-01 2018.01.01 2018-09-01 2016-10-01 2018.01.01 2011-12-01 2010.01.01 2010-02-01 2019-03-01 2010.M. 2019-06-01 2019.06.01 2012-07-01 2019-08-01 2019-09-01 2010.10.05 2019-11-01 2019.12.01 2020-01-01 2020-02-01 990-03.01 2020-04-01 2020-05-01 2020.06.01 2020-07-01 2020-08-01 2020.01.01 2020-10-01 2020-11-01 2020-12-01 2021-01-01 2021.00.0 2021-03-01 2021-04-01 2021.04.01 2021-06-01 2021-07-01 2021-06-01 2021-09-01 2021-10-01 2021-11-01 2021-12-01 2099.01.01 2022-02-01 2022-02-22 Gaan Hich 214720 16 1250m 35.927502 36.365002 35275002 39.16248 ARONA ARRO 36.220001 38.497501 37 22 41.520005 41 2000 412001 38.564999 42.412498 42 467499 44.00 49 ARTAR 14 PARA 42 540001 45.025002 417 45 1.400 44834998 45.000 41.60000 44.785001 4151 47 599.99 46 TOT ARS 45.955002 48.990002 49001 7317400 57 10211 5741750 56.987499 58.317500 54.762501 56 46110002 16.23001 - 792500 1225 41.740002 13.967499 42 57000 49 429501 471000 59 119999 52.470001 58827499 4300002 50.292502 ATRI 56422499 53 474 54.507500 51.60749 56.000 SR 267509 1948750 62.38499 67.000000 RA17497 7.49250 74 ASR 21.9.2012 7607497 R1 RSD 70.67 76 51 AM 78.220 71.562500 11.059998 794790 99. 91279999 106415001 108.1997 131.000000 1307 127 117 489999 125.3 100 15000 121 RADAR 121010002 138.789993 120320004 145 123750 137 RAM 123.750000 128.720001 122.660004 137 0700 12002999 14 TOT 125.000002 137 410004 12 DOO 150000000 14A 10 15849 152.32 157.25095 141 RARA 151699 14 000 165 AZ 167 479097 182.13000 177 AM 10 na 174 09 176.40 164.97999 166. RADOS TRA 2720 217096400 rn 41.735001 40.157501 413171 45.187499 45.855000 49307400 58 5001 51-529499 42.1999 M7490 35 an 41.487496 42375000 4750 43.747501 17567501 49 250 4R. 145000 51.00 53789501 2.290001 RED 73.1677100 HAMA 53.192500 59.24 71.462502 79 207498 144907 102492502 108 102 720001 107 annon 120.010000 126 37 118 115.20900 122 49 122. non 123.129997 135 144 Son 141.270004 1302200 147 470006 15700000 164.AZ 172.149864 162.140 41.914500 41.31 167179 46.2771 47.5729 600 56435001 54.715000 14. 3R 4001 4100 432749 47 4874 50 1750 42 49 400 24999 5215001 SD 9 100 1612 12 413 77377502 R99 A3522 73.44999 79.4AS1 91 1990ST 10R 2002 129.099993 115 AGO 108 0000 11 132 002 131 SOY 14 PRO 122.15000 131 460007 1941 138.960007 145 AR1 151 R2 141.500000 14 A 165 177 57000T 11477 164 320002 154.320007 54 55 5905 43134712 3.23 an 1 41 SERO55 46.236 R RR 42.113 46027 59 51.007 54 SRCA 1.151 6556001 79 78.147942 67756044 711 72.45621 TA 0753 2017209 105.10M01 127625460 1141 107 RABOLT 117 131.709218 ARTS 78.6870400 301902900 FOR 2800000 2422 CORO 4070061100 SRO2510 200 22 2802129600 2000 TREERSSON 2450400 0000 12 521.428091 130 RON 193 R756 596 2095 14.44 151 101 14111 149291967 M MD1 177 4.55 574 154 110916 *54 320007 ST10 179744500 SRO 24450300 21 121058200 9116975

Question

Using AAPLs historical data (provided as a picture) but you can access the file at yahoo finance historical data apple 5 years. Once you have the adjusted close price, calculate the following:

-Monthly Returns

-Average

-Variance

-Standard Deviation

-95% confidence interval for the monthly returns

MUST BE DONE IN EXCEL. I WILL PROVIDE WHAT IT SHOULD LOOK LIKE

RUM WITH WORD DSCHAP wer ROS TO MA OLIE SOFIE WE GUE cm IV we WEB w TRE ET Ple turt WEB INTER SEO WEB OSSER NA WWE MAAL WIND ENGET MER WERE MINTON SALS w US w ME w COM BRE MORE WE MA JH8.3. HOTEL BE MENE ... ull HHMA/ WAHILIH PETER Dan ... ww we todo . . et 2002/1/IT TIT 2008//6 It // Weber 1/2/2008 301.69.16 12/2007 1081 GE . 10/2007 110 12 . 04 . 7/2/2007 11065 6/1/2007 10525 04 71/2007 006 42/2007 10021 . 2/1/2007 929 . 11/2007 09:15 Soured Return the Avg My from DW Core Devo TI CH 100 . . FO . 10// 26 G AAPL Low R2501 35.014999 36.067101 2009 35.602501 32.102401 37 290001 30.115002 41.320000 41 16000 41.174999 Cla 15015 35.91249 3BT 16. 3712290 41 000000 18599999 12259 962502 Adi Cine non 33.907543 36057461 799 35251129 3.2002 36 67 40.727229 40 PORSR an 41213 34 982342 56130 46.229075 39 05053 ALE 485721 15.02.12 71 SERE215400 2515200 2727 16THOD 2640 979 2017155200 24 919 21717800 20 75 000 26617200 41 65749 211 1574716600 4 271SRAROON 315299.00 20160000 CORO 2014 298 RONDO Date 2017-01-01 2017-04-01 2017-05-01 2017.04.01 2017-07-01 2017-08-01 2017-09.00 2017-10-01 2017-11-01 2017.12.01 2018-01-01 901.01 2018-03-01 2018-04-01 2018.05.01 2010-06-01 2018-07-01 2018.01.01 2018-09-01 2016-10-01 2018.01.01 2011-12-01 2010.01.01 2010-02-01 2019-03-01 2010.M. 2019-06-01 2019.06.01 2012-07-01 2019-08-01 2019-09-01 2010.10.05 2019-11-01 2019.12.01 2020-01-01 2020-02-01 990-03.01 2020-04-01 2020-05-01 2020.06.01 2020-07-01 2020-08-01 2020.01.01 2020-10-01 2020-11-01 2020-12-01 2021-01-01 2021.00.0 2021-03-01 2021-04-01 2021.04.01 2021-06-01 2021-07-01 2021-06-01 2021-09-01 2021-10-01 2021-11-01 2021-12-01 2099.01.01 2022-02-01 2022-02-22 Gaan Hich 214720 16 1250m 35.927502 36.365002 35275002 39.16248 ARONA ARRO 36.220001 38.497501 37 22 41.520005 41 2000 412001 38.564999 42.412498 42 467499 44.00 49 ARTAR 14 PARA 42 540001 45.025002 417 45 1.400 44834998 45.000 41.60000 44.785001 4151 47 599.99 46 TOT ARS 45.955002 48.990002 49001 7317400 57 10211 5741750 56.987499 58.317500 54.762501 56 46110002 16.23001 - 792500 1225 41.740002 13.967499 42 57000 49 429501 471000 59 119999 52.470001 58827499 4300002 50.292502 ATRI 56422499 53 474 54.507500 51.60749 56.000 SR 267509 1948750 62.38499 67.000000 RA17497 7.49250 74 ASR 21.9.2012 7607497 R1 RSD 70.67 76 51 AM 78.220 71.562500 11.059998 794790 99. 91279999 106415001 108.1997 131.000000 1307 127 117 489999 125.3 100 15000 121 RADAR 121010002 138.789993 120320004 145 123750 137 RAM 123.750000 128.720001 122.660004 137 0700 12002999 14 TOT 125.000002 137 410004 12 DOO 150000000 14A 10 15849 152.32 157.25095 141 RARA 151699 14 000 165 AZ 167 479097 182.13000 177 AM 10 na 174 09 176.40 164.97999 166. RADOS TRA 2720 217096400 rn 41.735001 40.157501 413171 45.187499 45.855000 49307400 58 5001 51-529499 42.1999 M7490 35 an 41.487496 42375000 4750 43.747501 17567501 49 250 4R. 145000 51.00 53789501 2.290001 RED 73.1677100 HAMA 53.192500 59.24 71.462502 79 207498 144907 102492502 108 102 720001 107 annon 120.010000 126 37 118 115.20900 122 49 122. non 123.129997 135 144 Son 141.270004 1302200 147 470006 15700000 164.AZ 172.149864 162.140 41.914500 41.31 167179 46.2771 47.5729 600 56435001 54.715000 14. 3R 4001 4100 432749 47 4874 50 1750 42 49 400 24999 5215001 SD 9 100 1612 12 413 77377502 R99 A3522 73.44999 79.4AS1 91 1990ST 10R 2002 129.099993 115 AGO 108 0000 11 132 002 131 SOY 14 PRO 122.15000 131 460007 1941 138.960007 145 AR1 151 R2 141.500000 14 A 165 177 57000T 11477 164 320002 154.320007 54 55 5905 43134712 3.23 an 1 41 SERO55 46.236 R RR 42.113 46027 59 51.007 54 SRCA 1.151 6556001 79 78.147942 67756044 711 72.45621 TA 0753 2017209 105.10M01 127625460 1141 107 RABOLT 117 131.709218 ARTS 78.6870400 301902900 FOR 2800000 2422 CORO 4070061100 SRO2510 200 22 2802129600 2000 TREERSSON 2450400 0000 12 521.428091 130 RON 193 R756 596 2095 14.44 151 101 14111 149291967 M MD1 177 4.55 574 154 110916 *54 320007 ST10 179744500 SRO 24450300 21 121058200 9116975

Accepted Answer

The Answer is in the image, click to view ...

Question

Using AAPLs historical data (provided as a picture) but you can access the file at yahoo finance historical data apple 5 years. Once you have

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Options Futures And Other Derivatives

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question