V E14 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 20 0027 4 5 6 7 0 stocks 8 9) Portfolio 10 11 12 13 14 4 ; X fx 100% - - - F G n names and registration numbers and upload it within the Student's details +- Monthly statistics Average standard deviation Covariance Correlation Annual statistics Average standard deviation Portfolio calculations Proportion of AA Proportion of JNJ __ TTT1 Assignment + [E] Portfolio mean return Portfolio standard deviation H CKX ? ? ? ? CKX ? 0.5 ? ? ? - Assignment 2.xlsx -00 000 - % - - CKX AND EKCO INSERT FORMULATEXT HERE PORTFOLIO (CKX - EKCO) INSERT FORMULATEXT HERE INSERT FORMULATEXT HERE += = K EKCO ? ? EKCO ? = = A A A L ( ) Arial 12 INSERT FORMULATEXT HERE INSERT FORMULATEXT HERE INSE FORMULATEXT HERE INSERT FORMULATEXT HERE M U I B N 0 P Y 0 It
A nankes and rogianation aambars and uplend in witin the \begin{tabular}{|c|c|c|c|c|c|} \hline & & & CK & & \\ \hline & Menthly statistics & ckx & & EKCO & \\ \hline O stocks & Average & ? & & 3 & INSERT FORMULATEXT HERE \\ \hline & standard deviation & ? & & ? & INSERT FORMUUTEXT HERE \\ \hline Pertfolio & Cavariance & ? & & & \\ \hline & Corratation & ? & & & \\ \hline & & & & & \\ \hline & Manuat statisties & ckx & & EKco & \\ \hline & Average & 7 & & & INSERT FORMULATEXT HERE \\ \hline & starisard deviation & ? & & 71 & INSERT FORMUUATEXT HERE \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & PORTFO & & \\ \hline & & & & & \\ \hline & Portfolio calcuiations & & & & \\ \hline & Proportion of M & 0.5 & & & \\ \hline & Preportion of JNy & ? & INSERT EORMUATEXT HERE & & \\ \hline & Portbolo mean return & 7 & INSERT FOAMULATEXT HERE & & \\ \hline & Portolo standard deviation & 71 & INSERT FOASIUATLXT HERE & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Dats & COX & EKCO \\ \hline & 169.40 & 173 a \\ \hline 12m21 & 162.12 & 3cos72 \\ \hline 1Mrr21 & 166.12 & \\ \hline ithor21 & 14128 & \\ \hline 5. Mar 25 & 142 & 152.22 \\ \hline 1.Feb-21 & 133.80 & 3Ts, 12. \\ \hline & 120.56 & 3956 \\ \hline 1. Des:20 & 1+94 & 194.25 \\ \hline & 122.20 & 102AC \\ \hline 2.0420 & 11340 & 107.20 \\ \hline 1.5ap-20 & 116.2B & 382.69 \\ \hline 1. Aug 20 & 1:2.44 & 181.6F \\ \hline 1.1.20 & 117.16 & 304.4 \\ \hline 1-tintaco & 126.00 & istion \\ \hline 1+ Mar 20 & 124.86 & 162.68 \\ \hline 3Ag20 & 131.46 & 141.29 \\ \hline 1. Mar:20 & 1+9.94 & \\ \hline 1. reb-20 & 144.20 & \\ \hline 1.14200 & 122,12 & 132.11 \\ \hline 1. Dests & 1.4.44 & 34.0% \\ \hline Howets & 100.24 & 357.54 \\ \hline 20410 & no.eo & 103.72 \\ \hline 1. Eap-15 & M:ce & \\ \hline t. Aagagte & 10024 & \\ \hline 1.14.19 & 107.57 & \\ \hline 13ast 10 & 100.16 & 3x2+4 \\ \hline 2Mrrss & 10048 & 384.54 \\ \hline 1.Apon & 1+048 & 195,24 \\ \hline 1 Marte & 144an & \\ \hline I Fub is & 12.48 & 174,18 \\ \hline 2.tur-10 & & tet.se \\ \hline 1. Des 16 & & 103,12 \\ \hline & & MR.41 \\ \hline & 12.7 & 19294 \\ \hline coas of & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ CKX AND EKCO } \\ \hline Monthly statisties & CKX & & \\ \hline Arerage & ? & & \\ \hline standard deviation & ? & & \\ \hline Covanance & ? & & \\ \hline Correlation & ? & & \\ \hline Annual statietica & CKX & & \\ \hline Average & 2 & & \\ \hline standard deviation & ? & & \\ \hline \multicolumn{4}{|c|}{ PORTFOUO (CKX-EXCO) } \\ \hline \multicolumn{4}{|l|}{ Portfelio ealculationa } \\ \hline Proportion of NA & 0.5 & & \\ \hline Proportion of sy & ? & DAERT FOPOULAICXT HERE. & \\ \hline Rartelie mean retum & 2 & INSERT FORMULATEXT MERE & \\ \hline Pontfoio standard ceverion & 7 & INSERT FORMULATEXT MERE & \\ \hline \end{tabular} A nankes and rogianation aambars and uplend in witin the \begin{tabular}{|c|c|c|c|c|c|} \hline & & & CK & & \\ \hline & Menthly statistics & ckx & & EKCO & \\ \hline O stocks & Average & ? & & 3 & INSERT FORMULATEXT HERE \\ \hline & standard deviation & ? & & ? & INSERT FORMUUTEXT HERE \\ \hline Pertfolio & Cavariance & ? & & & \\ \hline & Corratation & ? & & & \\ \hline & & & & & \\ \hline & Manuat statisties & ckx & & EKco & \\ \hline & Average & 7 & & & INSERT FORMULATEXT HERE \\ \hline & starisard deviation & ? & & 71 & INSERT FORMUUATEXT HERE \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & PORTFO & & \\ \hline & & & & & \\ \hline & Portfolio calcuiations & & & & \\ \hline & Proportion of M & 0.5 & & & \\ \hline & Preportion of JNy & ? & INSERT EORMUATEXT HERE & & \\ \hline & Portbolo mean return & 7 & INSERT FOAMULATEXT HERE & & \\ \hline & Portolo standard deviation & 71 & INSERT FOASIUATLXT HERE & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Dats & COX & EKCO \\ \hline & 169.40 & 173 a \\ \hline 12m21 & 162.12 & 3cos72 \\ \hline 1Mrr21 & 166.12 & \\ \hline ithor21 & 14128 & \\ \hline 5. Mar 25 & 142 & 152.22 \\ \hline 1.Feb-21 & 133.80 & 3Ts, 12. \\ \hline & 120.56 & 3956 \\ \hline 1. Des:20 & 1+94 & 194.25 \\ \hline & 122.20 & 102AC \\ \hline 2.0420 & 11340 & 107.20 \\ \hline 1.5ap-20 & 116.2B & 382.69 \\ \hline 1. Aug 20 & 1:2.44 & 181.6F \\ \hline 1.1.20 & 117.16 & 304.4 \\ \hline 1-tintaco & 126.00 & istion \\ \hline 1+ Mar 20 & 124.86 & 162.68 \\ \hline 3Ag20 & 131.46 & 141.29 \\ \hline 1. Mar:20 & 1+9.94 & \\ \hline 1. reb-20 & 144.20 & \\ \hline 1.14200 & 122,12 & 132.11 \\ \hline 1. Dests & 1.4.44 & 34.0% \\ \hline Howets & 100.24 & 357.54 \\ \hline 20410 & no.eo & 103.72 \\ \hline 1. Eap-15 & M:ce & \\ \hline t. Aagagte & 10024 & \\ \hline 1.14.19 & 107.57 & \\ \hline 13ast 10 & 100.16 & 3x2+4 \\ \hline 2Mrrss & 10048 & 384.54 \\ \hline 1.Apon & 1+048 & 195,24 \\ \hline 1 Marte & 144an & \\ \hline I Fub is & 12.48 & 174,18 \\ \hline 2.tur-10 & & tet.se \\ \hline 1. Des 16 & & 103,12 \\ \hline & & MR.41 \\ \hline & 12.7 & 19294 \\ \hline coas of & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ CKX AND EKCO } \\ \hline Monthly statisties & CKX & & \\ \hline Arerage & ? & & \\ \hline standard deviation & ? & & \\ \hline Covanance & ? & & \\ \hline Correlation & ? & & \\ \hline Annual statietica & CKX & & \\ \hline Average & 2 & & \\ \hline standard deviation & ? & & \\ \hline \multicolumn{4}{|c|}{ PORTFOUO (CKX-EXCO) } \\ \hline \multicolumn{4}{|l|}{ Portfelio ealculationa } \\ \hline Proportion of NA & 0.5 & & \\ \hline Proportion of sy & ? & DAERT FOPOULAICXT HERE. & \\ \hline Rartelie mean retum & 2 & INSERT FORMULATEXT MERE & \\ \hline Pontfoio standard ceverion & 7 & INSERT FORMULATEXT MERE & \\ \hline \end{tabular}
