I have completed A and B below Question C is the one I need help with Thanks Date Adj Close MSFT Returns Adj Close GE Returns Adj Close S P Returns 12 31 2004 19 92 0 001 23 06 0 003 1211 92 0 001 12 30 2004 19 95 0 005 23 12 0 001 1213 55 0 000 12 29 2004 20 05 0 002 23 09 0 004 1213 45 0 000 12 28 2004 20 09 0 004 23 18 0 003 1213 54 0 007 12 27 2004 20 02 0 006 23 10 0 005 1204 92 0 004 12 23 2004 20 14 0 001 23 23 0 002 1210 13 0 000 12 22 2004 20 11 0 004 23 27 0 003 1209 57 0 003 12 21 2004 20 18 0 004 23 34 0 002 1205 45 0 009 12 20 2004 20 09 0 000 23 30 0 010 1194 65 0 000 12 17 2004 20 10 0 007 23 08 0 010 1194 20 0 007 12 16 2004 20 25 0 002 23 30 0 007 1203 21 0 002 12 15 2004 20 21 0 004 23 48 0 000 1205 72 0 002 12 14 2004 20 30 0 001 23 47 0 003 1203 38 0 004 12 13 2004 20 31 0 006 23 53 0 022 1198 68 0 009 12 10 2004 20 19 0 006 23 04 0 019 1188 00 0 001 12 9 2004 20 30 0 005 22 62 0 009 1189 24 0 005 12 8 2004 20 40 0 011 22 42 0 011 1182 81 0 005 12 7 2004 20 18 0 010 22 17 0 010 1177 07 0 011 12 6 2004 20 37 0 004 22 40 0 004 1190 25 0 001 12 3 2004 20 30 0 005 22 50 0 003 1191 17 0 001 12 2 2004 20 20 0 006 22 57 0 002 1190 33 0 001 12 1 2004 20 31 0 016 22 62 0 019 1191 37 0 015 11 30 2004 19 99 0 001 22 20 0 002 1173 82 0 004 11 29 2004 19 96 0 006 22 17 0 004 1178 57 0 003 11 26 2004 19 83 0 002 22 25 0 006 1182 65 0 001 11 24 2004 19 86 0 004 22 38 0 005 1181 76 0 004 11 23 2004 19 78 0 005 22 49 0 008 1176 94 0 000 11 22 2004 19 87 0 008 22 66 0 005 1177 24 0 006 11 19 2004 20 02 0 008 22 77 0 015 1170 34 0 011 11 18 2004 20 18 0 004 23 13 0 013 1183 55 0 001 11 17 2004 20 26 0 002 22 82 0 007 1181 94 0 006 11 16 2004 20 22 0 010 22 67 0 000 1175 43 0 007 11 15 2004 20 42 0 084 22 67 0 004 1183 81 0 000 11 12 2004 22 28 0 000 22 76 0 013 1184 17 0 009 11 11 2004 22 29 0 008 22 48 0 014 1173 48 0 009 11 10 2004 22 10 0 001 22 18 0 003 1162 91 0 001 11 9 2004 22 13 0 017 22 24 0 009 1164 08 0 001 11 8 2004 21 77 0 001 22 05 0 002 1164 89 0 001 11 5 2004 21 79 0 011 22 10 0 003 1166 17 0 004 11 4 2004 21 56 0 019 22 03 0 022 1161 67 0 016 11 3 2004 21 17 0 008 21 56 0 008 1143 20 0 011 11 2 2004 21 00 0 006 21 38 0 000 1130 56 0 000 11 1 2004 20 88 0 004 21 38 0 002 1130 51 0 000 10 29 2004 20 80 0 001 21 42 0 003 1130 20 0 002 10 28 2004 20 83 0 005 21 37 0 002 1127 44 0 002 10 27 2004 20 93 0 009 21 32 0 010 1125 40 0 013 10 26 2004 20 74 0 010 21 12 0 022 1111 09 0 015 10 25 2004 20 54 0 004 20 66 0 002 1094 80 0 001 10 22 2004 20 62 0 029 20 69 0 013 1095 74 0 010 10 21 2004 21 23 0 005 20 95 0 005 1106 49 0 003 10 20 2004 21 34 0 018 20 86 0 006 1103 66 0 000 10 19 2004 20 95 0 008 20 99 0 014 1103 23 0 010 10 18 2004 21 12 0 015 21 28 0 010 1114 02 0 005 10 15 2004 20 81 0 007 21 07 0 003 1108 20 0 004 10 14 2004 20 67 0 008 21 01 0 007 1103 29 0 009 10 13 2004 20 84 0 000 21 17 0 009 1113 65 0 007 10 12 2004 20 84 0 001 21 36 0 001 1121 84 0 002 10 11 2004 20 86 0 003 21 35 0 008 1124 39 0 002 10 8 2004 20 81 0 006 21 19 0 006 1122 14 0 008 10 7 2004 20 94 0 013 21 32 0 013 1130 65 0 010 10 6 2004 21 21 0 005 21 59 0 010 1142 05 0 007 10 5 2004 21 10 0 009 21 38 0 002 1134 48 0 001 10 4 2004 20 91 0 005 21 42 0 004 1135 17 0 003 10 1 2004 21 00 0 022 21 33 0 012 1131 50 0 015 9 30 2004 20 56 0 003 21 09 0 004 1114 58 0 000 9 29 2004 20 51 0 011 21 00 0 004 1114 80 0 004 9 28 2004 20 28 0 003 20 92 0 006 1110 06 0 006 9 27 2004 20 22 0 004 20 80 0 009 1103 52 0 006 9 24 2004 20 29 0 002 20 98 0 000 1110 11 0 002 9 23 2004 20 33 0 008 20 98 0 009 1108 36 0 005 9 22 2004 20 16 0 005 21 18 0 015 1113 56 0 014 9 21 2004 20 27 0 009 21 51 0 007 1129 30 0 006 9 20 2004 20 45 0 000 21 35 0 000 1122 20 0 006 9 17 2004 20 45 0 009 21 36 0 021 1128 55 0 004 9 16 2004 20 27 0 003 20 93 0 000 1123 50 0 003 9 15 2004 20 22 0 009 20 93 0 009 1120 37 0 007 9 14 2004 20 40 0 007 21 11 0 002 1128 33 0 002 9 13 2004 20 26 0 009 21 07 0 004 1125 82 0 002 9 10 2004 20 44 0 008 21 15 0 001 1123 92 0 005 9 9 2004 20 28 0 001 21 14 0 006 1118 38 0 002 9 8 2004 20 27 0 004 21 01 0 010 1116 27 0 004 9 7 2004 20 34 0 009 20 81 0 015 1121 30 0 007 9 3 2004 20 16 0 018 20 50 0 009 1113 63 0 004 9 2 2004 20 54 0 008 20 68 0 008 1118 31 0 011 9 1 2004 20 36 0 003 20 52 0 003 1105 91 0 002 8 31 2004 20 30 0 000 20 47 0 007 1104 24 0 005 8 30 2004 20 30 0 006 20 33 0 006 1099 15 0 008 8 27 2004 20 42 0 001 20 46 0 001 1107 77 0 002 8 26 2004 20 40 0 004 20 47 0 000 1105 09 0 000 8 25 2004 20 48 0 011 20 47 0 005 1104 96 0 008 8 24 2004 20 25 0 000 20 37 0 004 1096 19 0 000 8 23 2004 20 25 0 004 20 29 0 004 1095 68 0 002 8 20 2004 20 16 0 003 20 38 0 002 1098 35 0 007 8 19 2004 20 10 0 012 20 42 0 002 1091 23 0 004 8 18 2004 20 36 0 015 20 46 0 020 1095 17 0 012 8 17 2004 20 05 0 001 20 06 0 005 1081 71 0 002 8 16 2004 20 08 0 003 20 16 0 013 1079 34 0 014 8 13 2004 20 03 0 005 19 91 0 009 1064 80 0 001 8 12 2004 19 93 0 019 19 73 0 018 1063 23 0 012 8 11 2004 20 32 0 011 20 10 0 003 1075 79 0 003 8 10 2004 20 55 0 020 20 03 0 008 1079 04 0 013 8 9 2004 20 15 0 001 19 88 0 010 1065 22 0 001 8 6 2004 20 12 0 014 19 68 0 022 1063 97 0 015 8 5 2004 20 41 0 019 20 11 0 020 1080 70 0 016 8 4 2004 20 80 0 000 20 52 0 000 1098 63 0 001 8 3 2004 20 81 0 016 20 52 0 012 1099 69 0 006 8 2 2004 21 14 0 001 20 76 0 000 1106 62 0 004 7 30 2004 21 12 0 000 20 75 0 001 1101 72 0 001 7 29 2004 21 11 0 003 20 73 0 002 1100 43 0 005 7 28 2004 21 19 0 005 20 78 0 015 1095 42 0 001 7 27 2004 21 08 0 008 20 47 0 015 1094 83 0 010 7 26 2004 21 25 0 022 20 17 0 006 1084 07 0 002 7 23 2004 20 78 0 033 20 30 0 011 1086 20 0 010 7 22 2004 21 50 0 005 20 52 0 009 1096 84 0 003 7 21 2004 21 39 0 019 20 35 0 018 1093 88 0 013 7 20 2004 20 99 0 013 20 73 0 001 1108 67 0 007 7 19 2004 20 72 0 017 20 74 0 004 1100 90 0 000 7 16 2004 20 37 0 014 20 66 0 008 1101 39 0 005 7 15 2004 20 66 0 009 20 83 0 007 1106 69 0 004 7 14 2004 20 85 0 019 20 68 0 009 1111 47 0 003 7 13 2004 20 46 0 010 20 50 0 007 1115 14 0 001 7 12 2004 20 68 0 001 20 35 0 013 1114 35 0 001 7 9 2004 20 65 0 008 20 08 0 015 1112 81 0 003 7 8 2004 20 49 0 016 19 79 0 010 1109 11 0 008 7 7 2004 20 83 0 003 19 99 0 006 1118 33 0 002 7 6 2004 20 77 0 019 19 87 0 005 1116 21 0 008 7 2 2004 21 18 0 002 19 77 0 011 1125 38 0 003 7 1 2004 21 22 0 002 19 98 0 012 1128 94 0 010 6 30 2004 21 17 0 002 20 22 0 002 1140 84 0 004 6 29 2004 21 13 0 008 20 18 0 001 1136 20 0 003 6 28 2004 20 96 0 010 20 17 0 004 1133 35 0 001 6 25 2004 21 18 0 006 20 09 0 033 1134 43 0 005 6 24 2004 21 05 0 003 20 77 0 002 1140 65 0 003 6 23 2004 20 98 0 000 20 74 0 017 1144 06 0 009 6 22 2004 20 97 0 002 20 38 0 008 1134 41 0 004 6 21 2004 21 02 0 000 20 23 0 001 1130 30 0 004 6 18 2004 21 02 0 021 20 22 0 007 1135 02 0 003 6 17 2004 20 59 0 016 20 08 0 008 1132 05 0 001 6 16 2004 20 25 0 003 19 92 0 009 1133 56 0 001 6 15 2004 20 32 0 019 19 74 0 008 1132 01 0 006 6 14 2004 19 94 0 005 19 59 0 003 1125 29 0 010 6 10 2004 19 85 0 011 19 54 0 010 1136 47 0 005 6 9 2004 19 62 0 005 19 35 0 009 1131 33 0 009 6 8 2004 19 72 0 006 19 53 0 007 1142 18 0 002 6 7 2004 19 59 0 018 19 66 0 014 1140 42 0 016 6 4 2004 19 24 0 002 19 38 0 007 1122 50 0 005 6 3 2004 19 19 0 009 19 23 0 003 1116 64 0 007 6 2 2004 19 37 0 001 19 30 0 002 1124 99 0 003 6 1 2004 19 36 0 005 19 26 0 003 1121 20 0 000 5 28 2004 19 44 0 002 19 31 0 004 1120 68 0 001 5 27 2004 19 42 0 002 19 40 0 001 1121 28 0 006 5 26 2004 19 38 0 002 19 41 0 003 1114 94 0 002 5 25 2004 19 35 0 013 19 36 0 014 1113 05 0 016 5 24 2004 19 10 0 005 19 10 0 004 1095 41 0 002 5 21 2004 19 19 0 006 19 02 0 014 1093 56 0 004 5 20 2004 19 07 0 004 18 76 0 001 1089 19 0 000 5 19 2004 18 99 0 008 18 77 0 006 1088 68 0 003 5 18 2004 19 15 0 011 18 88 0 015 1091 49 0 007 5 17 2004 18 93 0 012 18 60 0 006 1084 10 0 011 5 14 2004 19 17 0 009 18 71 0 006 1095 70 0 001 5 13 2004 19 35 0 006 18 83 0 002 1096 44 0 001 5 12 2004 19 23 0 000 18 86 0 005 1097 28 0 002 5 11 2004 19 23 0 000 18 77 0 007 1095 45 0 008 5 10 2004 19 22 0 006 18 63 0 001 1087 12 0 011 5 7 2004 19 11 0 013 18 61 0 015 1098 70 0 014 5 6 2004 19 36 0 007 18 91 0 001 1113 99 0 007 5 5 2004 19 50 0 001 18 92 0 002 1121 53 0 002 5 4 2004 19 52 0 001 18 89 0 005 1119 55 0 002 5 3 2004 19 53 0 008 18 80 0 012 1117 49 0 009 4 30 2004 19 37 0 013 18 58 0 003 1107 30 0 006 4 29 2004 19 63 0 003 18 65 0 001 1113 89 0 008 4 28 2004 19 69 0 024 18 63 0 017 1122 41 0 014 4 27 2004 20 18 0 001 18 96 0 007 1138 11 0 002 4 26 2004 20 19 0 011 19 08 0 002 1135 53 0 004 4 23 2004 20 42 0 061 19 04 0 005 1140 60 0 001 4 22 2004 19 24 0 020 19 14 0 005 1139 93 0 014 4 21 2004 18 87 0 005 19 05 0 008 1124 09 0 005 4 20 2004 18 78 0 008 18 91 0 020 1118 15 0 016 4 19 2004 18 93 0 015 19 30 0 004 1135 82 0 001 4 16 2004 18 65 0 002 19 38 0 015 1134 61 0 005 4 15 2004 18 70 0 011 19 09 0 009 1128 84 0 001 4 14 2004 18 91 0 002 18 91 0 017 1128 17 0 001 4 13 2004 18 87 0 006 19 23 0 020 1129 44 0 014 4 12 2004 18 99 0 005 19 62 0 007 1145 20 0 005 4 8 2004 18 89 0 004 19 49 0 000 1139 32 0 001 4 7 2004 18 97 0 008 19 48 0 004 1140 53 0 007 4 6 2004 19 13 0 006 19 56 0 002 1148 16 0 002 4 5 2004 19 24 0 004 19 59 0 017 1150 57 0 008 4 2 2004 19 16 0 031 19 27 0 014 1141 81 0 009 4 1 2004 18 59 0 006 19 00 0 003 1132 17 0 005 3 31 2004 18 48 0 011 18 94 0 006 1126 21 0 001 3 30 2004 18 68 0 004 19 04 0 007 1127 00 0 004 3 29 2004 18 76 0 011 18 91 0 013 1122 47 0 013 3 26 2004 18 56 0 006 18 68 0 013 1108 06 0 001 3 25 2004 18 67 0 032 18 43 0 018 1109 19 0 016 3 24 2004 18 10 0 011 18 11 0 001 1091 33 0 002 3 23 2004 17 90 0 014 18 12 0 007 1093 95 0 001 3 22 2004 18 16 0 005 18 25 0 024 1095 40 0 013 3 19 2004 18 26 0 010 18 70 0 019 1109 78 0 011 3 18 2004 18 45 0 010 19 06 0 001 1122 32 0 001 3 17 2004 18 63 0 002 19 09 0 009 1123 75 0 012 3 16 2004 18 67 0 001 18 92 0 007 1110 70 0 006 3 15 2004 18 65 0 009 18 80 0 010 1104 49 0 014 3 12 2004 18 81 0 012 18 99 0 006 1120 57 0 012 3 11 2004 18 60 0 011 18 87 0 022 1106 78 0 015 3 10 2004 18 81 0 014 19 30 0 015 1123 89 0 015 3 9 2004 19 07 0 004 19 58 0 008 1140 58 0 006 3 8 2004 19 15 0 020 19 75 0 029 1147 20 0 008 3 5 2004 19 53 0 001 20 33 0 004 1156 86 0 002 3 4 2004 19 55 0 000 20 41 0 002 1154 87 0 003 3 3 2004 19 55 0 001 20 38 0 011 1151 03 0 002 3 2 2004 19 56 0 012 20 16 0 009 1149 10 0 006 3 1 2004 19 79 0 006 20 35 0 008 1155 97 0 010 2 27 2004 19 67 0 001 20 18 0 005 1144 94 0 000 2 26 2004 19 64 0 007 20 27 0 003 1144 91 0 001 2 25 2004 19 79 0 007 20 33 0 009 1143 67 0 004 2 24 2004 19 93 0 010 20 52 0 004 1139 09 0 002 2 23 2004 19 73 0 002 20 61 0 022 1140 99 0 003 2 20 2004 19 70 0 004 20 17 0 003 1144 11 0 003 2 19 2004 19 62 0 012 20 10 0 005 1147 06 0 004 2 18 2004 19 85 0 008 20 20 0 009 1151 82 0 004 2 17 2004 20 01 0 015 20 38 0 010 1156 99 0 010 2 13 2004 19 71 0 013 20 18 0 004 1145 81 0 005 2 12 2004 19 98 0 007 20 27 0 007 1152 11 0 005 2 11 2004 20 13 0 005 20 40 0 018 1157 76 0 011 2 10 2004 20 03 0 004 20 04 0 012 1145 54 0 005 2 9 2004 19 94 0 007 20 28 0 009 1139 81 0 003 2 6 2004 20 07 0 004 20 46 0 010 1142 76 0 013 2 5 2004 19 99 0 002 20 67 0 010 1128 59 0 002 2 4 2004 20 02 0 010 20 46 0 001 1126 52 0 008 2 3 2004 20 23 0 004 20 48 0 012 1136 03 0 001 2 2 2004 20 31 0 009 20 74 0 000 1135 26 0 004 1 30 2004 20 50 0 009 20 74 0 012 1131 13 0 003 1 29 2004 20 69 0 007 20 99 0 008 1134 11 0 005 1 28 2004 20 54 0 019 20 82 0 013 1128 48 0 014 1 27 2004 20 94 0 019 21 09 0 001 1144 05 0 010 1 26 2004 21 35 0 011 21 05 0 028 1155 37 0 012 1 23 2004 21 11 0 017 20 48 0 009 1141 55 0 002 1 22 2004 20 76 0 010 20 67 0 010 1143 94 0 003 1 21 2004 20 98 0 007 20 88 0 015 1147 62 0 008 1 20 2004 20 83 0 010 20 57 0 000 1138 77 0 001 1 16 2004 20 62 0 010 20 57 0 042 1139 83 0 007 1 15 2004 20 42 0 006 19 73 0 000 1132 05 0 001 1 14 2004 20 53 0 010 19 73 0 012 1130 52 0 008 1 13 2004 20 33 0 005 19 49 0 015 1121 22 0 005 1 12 2004 20 44 0 003 19 79 0 009 1127 23 0 005 1 9 2004 20 50 0 018 19 61 0 014 1121 86 0 009 1 8 2004 20 88 0 002 19 89 0 018 1131 92 0 005 1 7 2004 20 91 0 001 19 54 0 010 1126 33 0 002 1 6 2004 20 93 0 004 19 35 0 007 1123 67 0 001 1 5 2004 20 86 0 025 19 48 0 015 1122 22 0 012 1 2 2004 20 35 DIV 0 19 19 DIV 0 1108 48 DIV 0 MSFT GE S P Avg Return 0 00001 0 001 0 0004 Annualized Avg Return 0 33 19 79 9 57 Standard Deviation 0 01196 0 010428421 0 0069848 Annualized Std Dev 3 015 2 628 1 760 MSFT v GE MSFT v S P GE v S P Correlation 0 424 0 534 0 7294332 Go to Yahoo Finance and search for Microsoft (Symbol MSFT) Click on Historical Prices , and set the date range from January 1st, 2004 to December 31st, 2004 (daily) Then click on Apply , and then click on Download Data You now have price data for Microsoft (make sure to sort the data so it is increasing in date) Do the same for General Electric (Symbol GE) and the S P500 (Symbol AGSPC) a) Calculate the daily realized returns for each of these stocks based on the adjusted close price, using the equation below Note that the price has already been adjusted for dividends (P P i) 1 1 You do not need to report these returns Report the average realized return and realized standard deviation of returns over the past year for each of the three symbols Annualize these statistics by multiplying the average realized return by 252 (the number of business days in a year), and by multiplying the realized standard deviation by the square root of 252 b) What is the realized correlation in returns between Microsoft and General Electric Microsoft and the S P500 General Electric and the S P500 (Excel function CORREL)

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

Question: I have completed A and B below. Question C is the one I need help with. Thanks. Date Adj Close MSFT Returns Adj Close GE

I have completed A and B below. Question C is the one I need help with. Thanks.

I have completed A and B below. Question C is the one I need help with. Thanks. Date Adj Close MSFT Returns Adj Close

Date	Adj Close	MSFT Returns	Adj Close	GE Returns	Adj Close	S&P Returns
12/31/2004	19.92	-0.001	23.06	-0.003	1211.92	-0.001
12/30/2004	19.95	-0.005	23.12	0.001	1213.55	0.000
12/29/2004	20.05	-0.002	23.09	-0.004	1213.45	0.000
12/28/2004	20.09	0.004	23.18	0.003	1213.54	0.007
12/27/2004	20.02	-0.006	23.10	-0.005	1204.92	-0.004
12/23/2004	20.14	0.001	23.23	-0.002	1210.13	0.000
12/22/2004	20.11	-0.004	23.27	-0.003	1209.57	0.003
12/21/2004	20.18	0.004	23.34	0.002	1205.45	0.009
12/20/2004	20.09	0.000	23.30	0.010	1194.65	0.000
12/17/2004	20.10	-0.007	23.08	-0.010	1194.20	-0.007
12/16/2004	20.25	0.002	23.30	-0.007	1203.21	-0.002
12/15/2004	20.21	-0.004	23.48	0.000	1205.72	0.002
12/14/2004	20.30	-0.001	23.47	-0.003	1203.38	0.004
12/13/2004	20.31	0.006	23.53	0.022	1198.68	0.009
12/10/2004	20.19	-0.006	23.04	0.019	1188.00	-0.001
12/9/2004	20.30	-0.005	22.62	0.009	1189.24	0.005
12/8/2004	20.40	0.011	22.42	0.011	1182.81	0.005
12/7/2004	20.18	-0.010	22.17	-0.010	1177.07	-0.011
12/6/2004	20.37	0.004	22.40	-0.004	1190.25	-0.001
12/3/2004	20.30	0.005	22.50	-0.003	1191.17	0.001
12/2/2004	20.20	-0.006	22.57	-0.002	1190.33	-0.001
12/1/2004	20.31	0.016	22.62	0.019	1191.37	0.015
11/30/2004	19.99	0.001	22.20	0.002	1173.82	-0.004
11/29/2004	19.96	0.006	22.17	-0.004	1178.57	-0.003
11/26/2004	19.83	-0.002	22.25	-0.006	1182.65	0.001
11/24/2004	19.86	0.004	22.38	-0.005	1181.76	0.004
11/23/2004	19.78	-0.005	22.49	-0.008	1176.94	0.000
11/22/2004	19.87	-0.008	22.66	-0.005	1177.24	0.006
11/19/2004	20.02	-0.008	22.77	-0.015	1170.34	-0.011
11/18/2004	20.18	-0.004	23.13	0.013	1183.55	0.001
11/17/2004	20.26	0.002	22.82	0.007	1181.94	0.006
11/16/2004	20.22	-0.010	22.67	0.000	1175.43	-0.007
11/15/2004	20.42	-0.084	22.67	-0.004	1183.81	0.000
11/12/2004	22.28	0.000	22.76	0.013	1184.17	0.009
11/11/2004	22.29	0.008	22.48	0.014	1173.48	0.009
11/10/2004	22.10	-0.001	22.18	-0.003	1162.91	-0.001
11/9/2004	22.13	0.017	22.24	0.009	1164.08	-0.001
11/8/2004	21.77	-0.001	22.05	-0.002	1164.89	-0.001
11/5/2004	21.79	0.011	22.10	0.003	1166.17	0.004
11/4/2004	21.56	0.019	22.03	0.022	1161.67	0.016
11/3/2004	21.17	0.008	21.56	0.008	1143.20	0.011
11/2/2004	21.00	0.006	21.38	0.000	1130.56	0.000
11/1/2004	20.88	0.004	21.38	-0.002	1130.51	0.000
10/29/2004	20.80	-0.001	21.42	0.003	1130.20	0.002
10/28/2004	20.83	-0.005	21.37	0.002	1127.44	0.002
10/27/2004	20.93	0.009	21.32	0.010	1125.40	0.013
10/26/2004	20.74	0.010	21.12	0.022	1111.09	0.015
10/25/2004	20.54	-0.004	20.66	-0.002	1094.80	-0.001
10/22/2004	20.62	-0.029	20.69	-0.013	1095.74	-0.010
10/21/2004	21.23	-0.005	20.95	0.005	1106.49	0.003
10/20/2004	21.34	0.018	20.86	-0.006	1103.66	0.000
10/19/2004	20.95	-0.008	20.99	-0.014	1103.23	-0.010
10/18/2004	21.12	0.015	21.28	0.010	1114.02	0.005
10/15/2004	20.81	0.007	21.07	0.003	1108.20	0.004
10/14/2004	20.67	-0.008	21.01	-0.007	1103.29	-0.009
10/13/2004	20.84	0.000	21.17	-0.009	1113.65	-0.007
10/12/2004	20.84	-0.001	21.36	0.001	1121.84	-0.002
10/11/2004	20.86	0.003	21.35	0.008	1124.39	0.002
10/8/2004	20.81	-0.006	21.19	-0.006	1122.14	-0.008
10/7/2004	20.94	-0.013	21.32	-0.013	1130.65	-0.010
10/6/2004	21.21	0.005	21.59	0.010	1142.05	0.007
10/5/2004	21.10	0.009	21.38	-0.002	1134.48	-0.001
10/4/2004	20.91	-0.005	21.42	0.004	1135.17	0.003
10/1/2004	21.00	0.022	21.33	0.012	1131.50	0.015
9/30/2004	20.56	0.003	21.09	0.004	1114.58	0.000
9/29/2004	20.51	0.011	21.00	0.004	1114.80	0.004
9/28/2004	20.28	0.003	20.92	0.006	1110.06	0.006
9/27/2004	20.22	-0.004	20.80	-0.009	1103.52	-0.006
9/24/2004	20.29	-0.002	20.98	0.000	1110.11	0.002
9/23/2004	20.33	0.008	20.98	-0.009	1108.36	-0.005
9/22/2004	20.16	-0.005	21.18	-0.015	1113.56	-0.014
9/21/2004	20.27	-0.009	21.51	0.007	1129.30	0.006
9/20/2004	20.45	0.000	21.35	0.000	1122.20	-0.006
9/17/2004	20.45	0.009	21.36	0.021	1128.55	0.004
9/16/2004	20.27	0.003	20.93	0.000	1123.50	0.003
9/15/2004	20.22	-0.009	20.93	-0.009	1120.37	-0.007
9/14/2004	20.40	0.007	21.11	0.002	1128.33	0.002
9/13/2004	20.26	-0.009	21.07	-0.004	1125.82	0.002
9/10/2004	20.44	0.008	21.15	0.001	1123.92	0.005
9/9/2004	20.28	0.001	21.14	0.006	1118.38	0.002
9/8/2004	20.27	-0.004	21.01	0.010	1116.27	-0.004
9/7/2004	20.34	0.009	20.81	0.015	1121.30	0.007
9/3/2004	20.16	-0.018	20.50	-0.009	1113.63	-0.004
9/2/2004	20.54	0.008	20.68	0.008	1118.31	0.011
9/1/2004	20.36	0.003	20.52	0.003	1105.91	0.002
8/31/2004	20.30	0.000	20.47	0.007	1104.24	0.005
8/30/2004	20.30	-0.006	20.33	-0.006	1099.15	-0.008
8/27/2004	20.42	0.001	20.46	-0.001	1107.77	0.002
8/26/2004	20.40	-0.004	20.47	0.000	1105.09	0.000
8/25/2004	20.48	0.011	20.47	0.005	1104.96	0.008
8/24/2004	20.25	0.000	20.37	0.004	1096.19	0.000
8/23/2004	20.25	0.004	20.29	-0.004	1095.68	-0.002
8/20/2004	20.16	0.003	20.38	-0.002	1098.35	0.007
8/19/2004	20.10	-0.012	20.42	-0.002	1091.23	-0.004
8/18/2004	20.36	0.015	20.46	0.020	1095.17	0.012
8/17/2004	20.05	-0.001	20.06	-0.005	1081.71	0.002
8/16/2004	20.08	0.003	20.16	0.013	1079.34	0.014
8/13/2004	20.03	0.005	19.91	0.009	1064.80	0.001
8/12/2004	19.93	-0.019	19.73	-0.018	1063.23	-0.012
8/11/2004	20.32	-0.011	20.10	0.003	1075.79	-0.003
8/10/2004	20.55	0.020	20.03	0.008	1079.04	0.013
8/9/2004	20.15	0.001	19.88	0.010	1065.22	0.001
8/6/2004	20.12	-0.014	19.68	-0.022	1063.97	-0.015
8/5/2004	20.41	-0.019	20.11	-0.020	1080.70	-0.016
8/4/2004	20.80	0.000	20.52	0.000	1098.63	-0.001
8/3/2004	20.81	-0.016	20.52	-0.012	1099.69	-0.006
8/2/2004	21.14	0.001	20.76	0.000	1106.62	0.004
7/30/2004	21.12	0.000	20.75	0.001	1101.72	0.001
7/29/2004	21.11	-0.003	20.73	-0.002	1100.43	0.005
7/28/2004	21.19	0.005	20.78	0.015	1095.42	0.001
7/27/2004	21.08	-0.008	20.47	0.015	1094.83	0.010
7/26/2004	21.25	0.022	20.17	-0.006	1084.07	-0.002
7/23/2004	20.78	-0.033	20.30	-0.011	1086.20	-0.010
7/22/2004	21.50	0.005	20.52	0.009	1096.84	0.003
7/21/2004	21.39	0.019	20.35	-0.018	1093.88	-0.013
7/20/2004	20.99	0.013	20.73	-0.001	1108.67	0.007
7/19/2004	20.72	0.017	20.74	0.004	1100.90	0.000
7/16/2004	20.37	-0.014	20.66	-0.008	1101.39	-0.005
7/15/2004	20.66	-0.009	20.83	0.007	1106.69	-0.004
7/14/2004	20.85	0.019	20.68	0.009	1111.47	-0.003
7/13/2004	20.46	-0.010	20.50	0.007	1115.14	0.001
7/12/2004	20.68	0.001	20.35	0.013	1114.35	0.001
7/9/2004	20.65	0.008	20.08	0.015	1112.81	0.003
7/8/2004	20.49	-0.016	19.79	-0.010	1109.11	-0.008
7/7/2004	20.83	0.003	19.99	0.006	1118.33	0.002
7/6/2004	20.77	-0.019	19.87	0.005	1116.21	-0.008
7/2/2004	21.18	-0.002	19.77	-0.011	1125.38	-0.003
7/1/2004	21.22	0.002	19.98	-0.012	1128.94	-0.010
6/30/2004	21.17	0.002	20.22	0.002	1140.84	0.004
6/29/2004	21.13	0.008	20.18	0.001	1136.20	0.003
6/28/2004	20.96	-0.010	20.17	0.004	1133.35	-0.001
6/25/2004	21.18	0.006	20.09	-0.033	1134.43	-0.005
6/24/2004	21.05	0.003	20.77	0.002	1140.65	-0.003
6/23/2004	20.98	0.000	20.74	0.017	1144.06	0.009
6/22/2004	20.97	-0.002	20.38	0.008	1134.41	0.004
6/21/2004	21.02	0.000	20.23	0.001	1130.30	-0.004
6/18/2004	21.02	0.021	20.22	0.007	1135.02	0.003
6/17/2004	20.59	0.016	20.08	0.008	1132.05	-0.001
6/16/2004	20.25	-0.003	19.92	0.009	1133.56	0.001
6/15/2004	20.32	0.019	19.74	0.008	1132.01	0.006
6/14/2004	19.94	0.005	19.59	0.003	1125.29	-0.010
6/10/2004	19.85	0.011	19.54	0.010	1136.47	0.005
6/9/2004	19.62	-0.005	19.35	-0.009	1131.33	-0.009
6/8/2004	19.72	0.006	19.53	-0.007	1142.18	0.002
6/7/2004	19.59	0.018	19.66	0.014	1140.42	0.016
6/4/2004	19.24	0.002	19.38	0.007	1122.50	0.005
6/3/2004	19.19	-0.009	19.23	-0.003	1116.64	-0.007
6/2/2004	19.37	0.001	19.30	0.002	1124.99	0.003
6/1/2004	19.36	-0.005	19.26	-0.003	1121.20	0.000
5/28/2004	19.44	0.002	19.31	-0.004	1120.68	-0.001
5/27/2004	19.42	0.002	19.40	-0.001	1121.28	0.006
5/26/2004	19.38	0.002	19.41	0.003	1114.94	0.002
5/25/2004	19.35	0.013	19.36	0.014	1113.05	0.016
5/24/2004	19.10	-0.005	19.10	0.004	1095.41	0.002
5/21/2004	19.19	0.006	19.02	0.014	1093.56	0.004
5/20/2004	19.07	0.004	18.76	-0.001	1089.19	0.000
5/19/2004	18.99	-0.008	18.77	-0.006	1088.68	-0.003
5/18/2004	19.15	0.011	18.88	0.015	1091.49	0.007
5/17/2004	18.93	-0.012	18.60	-0.006	1084.10	-0.011
5/14/2004	19.17	-0.009	18.71	-0.006	1095.70	-0.001
5/13/2004	19.35	0.006	18.83	-0.002	1096.44	-0.001
5/12/2004	19.23	0.000	18.86	0.005	1097.28	0.002
5/11/2004	19.23	0.000	18.77	0.007	1095.45	0.008
5/10/2004	19.22	0.006	18.63	0.001	1087.12	-0.011
5/7/2004	19.11	-0.013	18.61	-0.015	1098.70	-0.014
5/6/2004	19.36	-0.007	18.91	-0.001	1113.99	-0.007
5/5/2004	19.50	-0.001	18.92	0.002	1121.53	0.002
5/4/2004	19.52	-0.001	18.89	0.005	1119.55	0.002
5/3/2004	19.53	0.008	18.80	0.012	1117.49	0.009
4/30/2004	19.37	-0.013	18.58	-0.003	1107.30	-0.006
4/29/2004	19.63	-0.003	18.65	0.001	1113.89	-0.008
4/28/2004	19.69	-0.024	18.63	-0.017	1122.41	-0.014
4/27/2004	20.18	-0.001	18.96	-0.007	1138.11	0.002
4/26/2004	20.19	-0.011	19.08	0.002	1135.53	-0.004
4/23/2004	20.42	0.061	19.04	-0.005	1140.60	0.001
4/22/2004	19.24	0.020	19.14	0.005	1139.93	0.014
4/21/2004	18.87	0.005	19.05	0.008	1124.09	0.005
4/20/2004	18.78	-0.008	18.91	-0.020	1118.15	-0.016
4/19/2004	18.93	0.015	19.30	-0.004	1135.82	0.001
4/16/2004	18.65	-0.002	19.38	0.015	1134.61	0.005
4/15/2004	18.70	-0.011	19.09	0.009	1128.84	0.001
4/14/2004	18.91	0.002	18.91	-0.017	1128.17	-0.001
4/13/2004	18.87	-0.006	19.23	-0.020	1129.44	-0.014
4/12/2004	18.99	0.005	19.62	0.007	1145.20	0.005
4/8/2004	18.89	-0.004	19.49	0.000	1139.32	-0.001
4/7/2004	18.97	-0.008	19.48	-0.004	1140.53	-0.007
4/6/2004	19.13	-0.006	19.56	-0.002	1148.16	-0.002
4/5/2004	19.24	0.004	19.59	0.017	1150.57	0.008
4/2/2004	19.16	0.031	19.27	0.014	1141.81	0.009
4/1/2004	18.59	0.006	19.00	0.003	1132.17	0.005
3/31/2004	18.48	-0.011	18.94	-0.006	1126.21	-0.001
3/30/2004	18.68	-0.004	19.04	0.007	1127.00	0.004
3/29/2004	18.76	0.011	18.91	0.013	1122.47	0.013
3/26/2004	18.56	-0.006	18.68	0.013	1108.06	-0.001
3/25/2004	18.67	0.032	18.43	0.018	1109.19	0.016
3/24/2004	18.10	0.011	18.11	-0.001	1091.33	-0.002
3/23/2004	17.90	-0.014	18.12	-0.007	1093.95	-0.001
3/22/2004	18.16	-0.005	18.25	-0.024	1095.40	-0.013
3/19/2004	18.26	-0.010	18.70	-0.019	1109.78	-0.011
3/18/2004	18.45	-0.010	19.06	-0.001	1122.32	-0.001
3/17/2004	18.63	-0.002	19.09	0.009	1123.75	0.012
3/16/2004	18.67	0.001	18.92	0.007	1110.70	0.006
3/15/2004	18.65	-0.009	18.80	-0.010	1104.49	-0.014
3/12/2004	18.81	0.012	18.99	0.006	1120.57	0.012
3/11/2004	18.60	-0.011	18.87	-0.022	1106.78	-0.015
3/10/2004	18.81	-0.014	19.30	-0.015	1123.89	-0.015
3/9/2004	19.07	-0.004	19.58	-0.008	1140.58	-0.006
3/8/2004	19.15	-0.020	19.75	-0.029	1147.20	-0.008
3/5/2004	19.53	-0.001	20.33	-0.004	1156.86	0.002
3/4/2004	19.55	0.000	20.41	0.002	1154.87	0.003
3/3/2004	19.55	-0.001	20.38	0.011	1151.03	0.002
3/2/2004	19.56	-0.012	20.16	-0.009	1149.10	-0.006
3/1/2004	19.79	0.006	20.35	0.008	1155.97	0.010
2/27/2004	19.67	0.001	20.18	-0.005	1144.94	0.000
2/26/2004	19.64	-0.007	20.27	-0.003	1144.91	0.001
2/25/2004	19.79	-0.007	20.33	-0.009	1143.67	0.004
2/24/2004	19.93	0.010	20.52	-0.004	1139.09	-0.002
2/23/2004	19.73	0.002	20.61	0.022	1140.99	-0.003
2/20/2004	19.70	0.004	20.17	0.003	1144.11	-0.003
2/19/2004	19.62	-0.012	20.10	-0.005	1147.06	-0.004
2/18/2004	19.85	-0.008	20.20	-0.009	1151.82	-0.004
2/17/2004	20.01	0.015	20.38	0.010	1156.99	0.010
2/13/2004	19.71	-0.013	20.18	-0.004	1145.81	-0.005
2/12/2004	19.98	-0.007	20.27	-0.007	1152.11	-0.005
2/11/2004	20.13	0.005	20.40	0.018	1157.76	0.011
2/10/2004	20.03	0.004	20.04	-0.012	1145.54	0.005
2/9/2004	19.94	-0.007	20.28	-0.009	1139.81	-0.003
2/6/2004	20.07	0.004	20.46	-0.010	1142.76	0.013
2/5/2004	19.99	-0.002	20.67	0.010	1128.59	0.002
2/4/2004	20.02	-0.010	20.46	-0.001	1126.52	-0.008
2/3/2004	20.23	-0.004	20.48	-0.012	1136.03	0.001
2/2/2004	20.31	-0.009	20.74	0.000	1135.26	0.004
1/30/2004	20.50	-0.009	20.74	-0.012	1131.13	-0.003
1/29/2004	20.69	0.007	20.99	0.008	1134.11	0.005
1/28/2004	20.54	-0.019	20.82	-0.013	1128.48	-0.014
1/27/2004	20.94	-0.019	21.09	0.001	1144.05	-0.010
1/26/2004	21.35	0.011	21.05	0.028	1155.37	0.012
1/23/2004	21.11	0.017	20.48	-0.009	1141.55	-0.002
1/22/2004	20.76	-0.010	20.67	-0.010	1143.94	-0.003
1/21/2004	20.98	0.007	20.88	0.015	1147.62	0.008
1/20/2004	20.83	0.010	20.57	0.000	1138.77	-0.001
1/16/2004	20.62	0.010	20.57	0.042	1139.83	0.007
1/15/2004	20.42	-0.006	19.73	0.000	1132.05	0.001
1/14/2004	20.53	0.010	19.73	0.012	1130.52	0.008
1/13/2004	20.33	-0.005	19.49	-0.015	1121.22	-0.005
1/12/2004	20.44	-0.003	19.79	0.009	1127.23	0.005
1/9/2004	20.50	-0.018	19.61	-0.014	1121.86	-0.009
1/8/2004	20.88	-0.002	19.89	0.018	1131.92	0.005
1/7/2004	20.91	-0.001	19.54	0.010	1126.33	0.002
1/6/2004	20.93	0.004	19.35	-0.007	1123.67	0.001
1/5/2004	20.86	0.025	19.48	0.015	1122.22	0.012
1/2/2004	20.35	#DIV/0!	19.19	#DIV/0!	1108.48	#DIV/0!

	MSFT	GE	S&P
Avg. Return	-0.00001	0.001	0.0004
Annualized Avg Return	-0.33%	19.79%	9.57%
Standard Deviation	0.01196	0.010428421	0.0069848
Annualized Std Dev	3.015	2.628	1.760

	MSFT v GE	MSFT v S&P	GE v S&P
Correlation	0.424	0.534	0.7294332

Go to Yahoo! Finance and search for Microsoft (Symbol: MSFT). Click on "Historical Prices", and set the date range from January 1st, 2004 to December 31st, 2004 (daily). Then click on "Apply", and then click on "Download Data". You now have price data for Microsoft (make sure to sort the data so it is increasing in date). Do the same for General Electric (Symbol: GE) and the S&P500 (Symbol: AGSPC) a) Calculate the daily realized returns for each of these stocks based on the adjusted close price, using the equation below. Note that the price has already been adjusted for dividends. (P -P-i) 1-1 You do not need to report these returns. Report the average realized return and realized standard deviation of returns over the past year for each of the three symbols. Annualize these statistics by multiplying the average realized return by 252 (the number of business days in a year), and by multiplying the realized standard deviation by the square root of 252. b) What is the realized correlation in returns between Microsoft and General Electric? Microsoft and the S&P500? General Electric and the S&P500? (Excel function: CORREL)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Below is the question: Task 5 (14 points) What are the expected monthly returns of Amazon and Tesla stocks? What are their sample standard deviations? and i got the correct answers but I have no idea...

1. You will be assigned twenty (20) stocks from the current S&P 500 index. You must use these 20 stocks (or, more precisely, the ticker symbols) to download data from yahoo.com. Go to yahoo.com, then...

I need help with some of the required calculations. I downloaded the necessary data from Yahoo Finance and started putting things together in an excel file. I have attached my working file, the excel...

The purpose of this analysis is to find an intrinsic value for Microsoft (MSFT) using the both the Constant Dividend Discount Model (DDM) and the Non-constant DDM. You will need to (1) estimate Beta...

Use MSFT.PDF file provided to you with historical returns from 5/1/2016 to 3/19/2021. As of November 11, 2022, price of MSFT is $247.11. Assume current price of MSFT is $247.11/share. Use the...

what would have been some differences in return and risks charactersistics of your portfolio, if you had weighted the amount invested in the stocks differently ( in terms of optimum risk and return)...

You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 or S&P 500 index. Choose companies that are in different industries. Collect the end-of-month prices...

Go to assignment2 sheet in the Chapter 3 Excel file. Compute the 60 monthly log returns of Coca-Cola and S&P 500 using their 61 monthly adjusted prices/indices from August 2015 to August 2020, and...

Use the portfolio you estimated in Question 8 and the CAPM to estimate the expected return of a portfolio that consists of one share of KO, two shares of T. and one share of XOM. Assume that the...

1. Go to finance.yahoo.com and download five years of monthly closing prices for Eli Lilly (ticker = LLY), Alcoa (AA), and the S&P 500 Index (GSPC). Download the data into an Excel file and use the...

Calculate the betas for Chevron, Yum! Brands and Johnson & Johnson.

Head-First Company plans to sell 5,000 bicycle helmets at $75 each in the coming year. Unit variable cost is $45 (includes direct materials, direct labor, variable factory overhead, and variable...

7. Which of the following does not increase when a gas is heated in a sealed container? (a) Average kinetic energy of particles (b) Pressure inside the container (c) Size of the gas particles (d)...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...