Data
# mf <- read_excel("Data/MF Data from Bareksa.xlsx")
mf <- read.csv("Data/MF.csv")
head(mf)
## X6.Nov.23 X1D X1Wk X1M X3M X6M X1T
## 1 Recapital Equity 0.51 1.60 0.21 -2.76 8.67 14.47
## 2 HPAM Syariah Ekuitas 0.23 2.91 -1.73 11.69 7.21 9.65
## 3 Majoris Saham Syariah Indonesia 1.24 2.28 -1.70 -1.72 5.98 4.02
## 4 Majoris Saham Alokasi Dinamik Indonesia 1.38 2.52 -1.86 -3.15 3.94 3.86
## 5 Prospera Bijak 1.03 2.11 -1.37 -2.03 4.13 2.56
## 6 TRIM Kapital Plus 1.15 1.23 -2.88 -3.38 4.13 2.61
## X3T X5T YTD Inception
## 1 35.49 -19.47 17.54 -50.96
## 2 29.59 -14.79 13.47 -28.92
## 3 6.97 -10.41 9.44 -26.46
## 4 7.63 -15.33 8.89 -3.53
## 5 29.22 -0.06 8.89 -11.24
## 6 46.97 25.16 8.78 323.70
mf$X3M <- as.numeric(mf$X3M)
## Warning: NAs introduced by coercion
mf$X6M <- as.numeric(mf$X6M)
## Warning: NAs introduced by coercion
mf$X1T <- as.numeric(mf$X1T)
## Warning: NAs introduced by coercion
mf$X3T <- as.numeric(mf$X3T)
## Warning: NAs introduced by coercion
mf$X5T <- as.numeric(mf$X5T)
## Warning: NAs introduced by coercion
mf$YTD <- as.numeric(mf$YTD)
## Warning: NAs introduced by coercion
mf$Inception <- as.numeric(mf$Inception)
## Warning: NAs introduced by coercion
mf <- as.data.frame(mf)
colnames(mf)[1] <- "MF_name"
head(mf)
## MF_name X1D X1Wk X1M X3M X6M X1T
## 1 Recapital Equity 0.51 1.60 0.21 -2.76 8.67 14.47
## 2 HPAM Syariah Ekuitas 0.23 2.91 -1.73 11.69 7.21 9.65
## 3 Majoris Saham Syariah Indonesia 1.24 2.28 -1.70 -1.72 5.98 4.02
## 4 Majoris Saham Alokasi Dinamik Indonesia 1.38 2.52 -1.86 -3.15 3.94 3.86
## 5 Prospera Bijak 1.03 2.11 -1.37 -2.03 4.13 2.56
## 6 TRIM Kapital Plus 1.15 1.23 -2.88 -3.38 4.13 2.61
## X3T X5T YTD Inception
## 1 35.49 -19.47 17.54 -50.96
## 2 29.59 -14.79 13.47 -28.92
## 3 6.97 -10.41 9.44 -26.46
## 4 7.63 -15.33 8.89 -3.53
## 5 29.22 -0.06 8.89 -11.24
## 6 46.97 25.16 8.78 323.70
Clustering
mf_clean <- mf %>%
arrange(MF_name) %>%
na.omit()
mf_clean
## MF_name X1D X1Wk X1M
## 3 Architas Saham Dinamis 1.17 1.71 -3.34
## 4 Ashmore Dana Ekuitas Nusantara 1.28 1.67 -3.66
## 5 Ashmore Dana Progresif Nusantara 0.99 1.25 -4.02
## 6 Ashmore Dana USD Equity Nusantara 1.90 2.55 -5.40
## 8 Ashmore Saham Dinamis Nusantara 1.32 1.76 -4.38
## 10 Ashmore Saham Sejahtera Nusantara 1.08 1.46 -3.75
## 11 Ashmore Saham Sejahtera Nusantara II 1.14 1.84 -3.24
## 12 Ashmore Saham Unggulan Nusantara 1.15 1.61 -3.23
## 14 Asia Raya Saham Unggulan Syariah 0.00 0.00 0.00
## 15 Asia Raya Syariah Saham Barokah 0.00 0.00 0.00
## 16 Aurora Dana Ekuitas 0.45 1.19 2.22
## 17 Aurora Equity 0.23 0.35 1.28
## 18 Aurora SMC Equity 0.58 0.44 -2.43
## 19 Aurora Sharia Equity 0.17 0.13 -4.21
## 20 Aurora Syariah Saham Amanah 0.04 0.31 1.17
## 21 Avrist Ada Saham Blue Safir 1.13 1.78 -4.64
## 22 Avrist Equity - Amar Syariah 1.54 2.11 -3.86
## 23 Avrist Equity - Cross Sectoral 0.81 0.45 -6.12
## 26 BNI-AM Dana Saham Syariah Musahamah 1.47 2.46 -3.83
## 27 BNI-AM Inspiring Equity Fund 1.50 3.44 -2.40
## 32 BNP Paribas Infrastruktur Plus 1.09 2.40 -2.22
## 33 BNP Paribas Maxi Saham 1.10 2.21 -2.30
## 35 BNP Paribas Pesona Syariah 0.82 0.19 -4.96
## 36 BNP Paribas Solaris 1.63 1.58 -4.53
## 37 Bahana Dana Ekuitas Andalan Kelas G 1.39 2.64 -1.91
## 39 Bahana Explorer Equity Fund 1.58 2.70 -2.98
## 42 Bahana Primavera 99 Kelas S 1.55 2.43 -3.16
## 43 Bahana Stellar Equity Fund 1.27 2.10 -1.99
## 44 Bahana Trailblazer Fund 1.42 2.30 -3.23
## 46 Batavia Dana Saham Optimal 1.43 2.64 -2.06
## 47 Batavia Dana Saham Syariah 1.48 1.25 -4.34
## 50 Batavia Saham Cemerlang 1.50 2.90 -1.79
## 52 Batavia Saham Sejahtera 1.51 2.91 -1.80
## 53 Capital Equity Fund -2.03 -10.94 -11.99
## 54 Cipta Equity Plus 1.03 2.31 -2.97
## 55 Cipta GTWS Equity 1.27 2.64 -3.24
## 56 Cipta Ovo Ekuitas 1.01 1.06 -5.23
## 57 Cipta Prima 1.00 1.56 -4.15
## 60 Cipta Sakura Equity 0.98 2.54 -3.42
## 61 Cipta Syariah Equity 0.67 -1.02 -6.81
## 62 Corfina Equity Syariah 0.69 0.01 -3.18
## 63 Corfina Grow-2-Prosper Rotasi Strategis 0.42 0.11 0.16
## 64 Corfina Investa Saham Syariah 0.74 0.09 -2.38
## 65 Dana Ekuitas Prima 1.62 2.84 -3.87
## 66 Danakita Saham Prioritas 1.11 1.45 -2.45
## 67 Danareksa Mawar 1.20 1.70 -3.68
## 68 Danareksa Mawar Ekuitas Plus 1.26 1.83 -3.41
## 69 Danareksa Mawar Ekuitas Utama 1.20 1.82 -3.28
## 70 Danareksa Mawar Fokus 10 1.61 -0.03 -5.37
## 71 Danareksa Mawar Komoditas 10 1.21 1.72 -3.49
## 72 Danareksa Syariah Saham 1.06 1.39 -5.61
## 73 Eastspring Investments Alpha Navigator Kelas A 1.11 1.53 -3.38
## 75 Eastspring Investments Value Discovery Kelas A 1.18 1.60 -3.23
## 77 Emco Growth Fund 0.10 -0.19 -1.53
## 78 Emco Mantap -0.02 -0.33 -0.87
## 79 Emco Saham Barokah Syariah 0.05 -0.14 -0.29
## 80 Foster Equity Fund -1.91 -10.32 -10.96
## 81 GAP Equity Aggressive Fund 1.42 1.81 -4.10
## 82 GAP Equity Focus Fund 0.88 1.02 -1.42
## 85 HPAM Investa Ekuitas Strategis 0.84 0.94 -4.07
## 86 HPAM Saham Dinamis 1.69 3.01 -0.14
## 87 HPAM Smart Beta Ekuitas 0.86 2.32 -0.33
## 88 HPAM Syariah Ekuitas 0.23 2.91 -1.73
## 90 HPAM Ultima Ekuitas 1 1.05 2.64 -1.09
## 91 I AM Equity Fund 1.18 0.78 -3.46
## 92 Insight Wealth 1.49 2.11 -3.24
## 93 Jasa Capital Saham Progresif 0.38 1.26 -0.89
## 95 Lautandhana Equity Progresif 1.50 1.55 -3.64
## 96 Lautandhana Growth Fund 1.32 1.42 -2.98
## 97 Lautandhana Saham Lestari 1.47 1.31 -2.48
## 98 Lautandhana Saham Mahadi 1.43 1.83 -2.25
## 99 Lautandhana Saham Prima 1.48 1.77 -2.88
## 100 Lautandhana Saham Syariah 1.13 0.37 -3.84
## 101 MNC Dana Ekuitas -0.27 -2.29 -2.67
## 102 MNC Dana Syariah Ekuitas II 0.57 1.18 1.29
## 103 MNC Smart Equity Fund 0.83 0.25 -0.73
## 104 Majoris Saham Alokasi Dinamik Indonesia 1.38 2.52 -1.86
## 105 Majoris Saham Alpha Recovery Perdana 1.44 2.97 -1.34
## 106 Majoris Saham Gemilang Indonesia 1.30 2.58 -2.81
## 107 Majoris Saham Syariah Indonesia 1.24 2.28 -1.70
## 108 Mandiri Investa Atraktif Kelas A 1.14 1.10 -4.34
## 110 Mandiri Investa Atraktif Syariah 1.00 0.49 -5.21
## 111 Mandiri Investa Cerdas Bangsa Kelas A 1.23 1.28 -3.50
## 113 Mandiri Investa Ekuitas Dinamis 1.16 0.58 -4.65
## 114 Mandiri Investa Ekuitas Syariah 0.97 0.45 -4.99
## 115 Mandiri Investa Equity ASEAN 5 Plus 1.13 1.02 -4.58
## 116 Mandiri Investa Equity Dynamo Factor 1.32 1.75 -3.65
## 117 Mandiri Investa Equity Movement 1.15 1.10 -4.32
## 118 Mandiri Saham Atraktif Kelas A 1.17 1.16 -3.81
## 121 Manulife Dana Ekuitas Utama Kelas I 1.54 2.51 -3.32
## 123 Manulife Dana Saham Kelas A 1.50 2.41 -3.88
## 125 Manulife Dana Saham Utama Kelas I 1.35 2.38 -3.78
## 126 Manulife Greater Indonesia Fund 1.77 2.77 -6.27
## 128 Manulife Saham Andalan 1.23 1.72 -5.32
## 129 Manulife Saham SMC Plus 1.90 1.36 -4.48
## 130 Manulife Syariah Sektoral Amanah Kelas A 1.29 0.98 -4.81
## 131 Maybank Dana Ekuitas 0.89 1.70 -3.25
## 132 Maybank Dana Ekuitas Syariah 0.33 2.40 1.38
## 133 Mega Asset Greater Infrastructure 1.09 1.72 -2.86
## 134 Mega Asset Maxima 1.53 3.97 -2.16
## 135 Millenium Dynamic Equity Fund 0.73 -0.08 -3.11
## 136 Millenium Equity Prima Plus 0.12 0.23 1.20
## 137 Millenium MCM Equity Sektoral 0.83 2.97 0.14
## 138 Minna Padi Indraprastha Saham Syariah 0.11 0.07 -0.44
## 141 Nikko Indonesia Equity Fund 0.98 1.14 -3.34
## 142 Nikko Saham Pembangunan Indonesia 1.39 2.48 -1.70
## 143 OSO Andalas Equity Fund 0.27 -0.90 -1.95
## 144 OSO Flores Equity Fund 0.43 0.79 -0.73
## 145 OSO Moluccas Equity Fund 1.20 1.35 -2.86
## 146 PNM Ekuitas Syariah 1.20 0.54 -5.24
## 147 PNM Saham Agresif 0.76 -0.15 -4.65
## 148 PNM Saham Unggulan 1.43 1.66 -3.18
## 149 Pacific Equity Flexi Fund -0.69 -8.06 -8.64
## 150 Pacific Equity Fund -1.32 -10.64 -11.71
## 151 Pacific Equity Growth Fund -1.15 -10.38 -11.61
## 152 Pacific Equity Growth Fund III -1.18 -9.98 -10.48
## 153 Pacific Equity Growth Fund IV -1.41 -11.39 -11.95
## 154 Pacific Equity Growth Fund V -0.61 -7.44 -8.17
## 155 Pacific Equity Growth Fund VI -1.39 -11.33 -11.99
## 156 Pacific Equity Optimum Fund -2.14 -11.96 -12.58
## 157 Pacific Equity Progresif Fund -1.11 -10.51 -11.67
## 158 Pacific Equity Progresif Fund II -1.45 -9.75 -10.74
## 159 Pacific Equity Progresif Fund III -1.06 -10.18 -11.30
## 160 Pacific Saham Syariah 0.83 2.18 0.88
## 161 Pacific Saham Syariah II 0.74 1.89 0.41
## 162 Pacific Saham Syariah III 0.97 2.32 0.17
## 163 Pan Arcadia Dana Saham Bertumbuh 0.71 1.75 -1.45
## 164 Pan Arcadia Dana Saham Syariah 0.82 0.32 -1.09
## 168 Panin Beta One 1.29 2.25 -3.42
## 169 Panin Dana Berdedikasi 1.32 2.10 -2.51
## 170 Panin Dana Berkembang 1.29 1.91 -2.78
## 171 Panin Dana Infrastruktur Bertumbuh 1.27 1.47 -3.30
## 173 Panin Dana Prima 1.32 2.39 -2.14
## 174 Panin Dana Syariah Saham 1.39 1.60 -3.66
## 175 Panin Dana Teladan 1.38 2.57 -2.41
## 176 Panin Dana Ultima 1.14 1.59 -3.46
## 178 Pinnacle Dana Ekuitas Nusantara -1.49 -10.88 -11.29
## 179 Pinnacle Dana Prima 0.28 -0.30 0.48
## 180 Pinnacle Strategic Equity Fund 0.90 -0.32 -4.73
## 182 Pool Advista Kapital Optimal 0.68 1.11 0.05
## 183 Pool Advista Kapital Syariah 0.93 1.43 -0.99
## 184 Pratama Dana Alpha Saham 0.58 -2.20 -8.19
## 185 Pratama Dana Atraktif Saham 0.58 -1.73 -7.77
## 186 Pratama Dana Cemerlang Saham 0.63 0.81 -5.70
## 187 Pratama Dana Dinamis Saham 0.50 -1.94 -7.70
## 188 Pratama Dana Gemilang Saham 0.60 -2.01 -8.30
## 189 Pratama Dana Mantap Saham 0.57 -1.48 -6.62
## 190 Pratama Dana Saham Unggulan 0.54 -1.53 -7.86
## 191 Pratama Investa Mandiri Saham 0.57 -1.56 -7.22
## 192 Pratama Saham 0.61 -1.59 -6.84
## 193 Pratama Syariah 0.33 -2.31 -8.66
## 194 Premier Ekuitas Makro Plus 1.56 2.41 -3.35
## 195 Principal Indo Domestic Equity Fund 1.07 1.66 -3.25
## 196 Principal Islamic Equity Growth Syariah 0.97 1.09 -4.42
## 198 Prospera BUMN Growth Fund 1.34 2.30 -2.11
## 199 Prospera Bijak 1.03 2.11 -1.37
## 200 Prospera Dana Berkembang 0.67 0.94 -1.32
## 201 Prospera Saham SMC 1.12 1.98 -1.82
## 202 Prospera Syariah Saham 0.68 1.17 -1.55
## 204 Recapital Equity 0.51 1.60 0.21
## 205 Reksa Dana Allianz Alpha Sector Rotation 1.26 1.79 -2.95
## 206 Reksa Dana Allianz Indo Asia Equity Fund 1.23 1.78 -2.49
## 207 Reksa Dana Asia Raya Saham Berkembang 0.00 0.00 0.00
## 208 Reksa Dana BNI AM Dana Saham Bandagara 1.29 2.98 -3.34
## 210 Reksa Dana Capital Optimal Equity 1.45 2.18 -2.95
## 211 Reksa Dana Danareksa Mawar Konsumer 10 Kelas A 1.18 1.59 -3.80
## 212 Reksa Dana Manulife Institutional Equity Fund Kelas I 1.34 1.96 -4.83
## 213 Reksa Dana Principal Total Return Equity Fund Kelas O 1.11 1.46 -3.81
## 214 Reksa Dana Syailendra Equity Opportunity Fund Kelas A 1.27 1.82 -2.88
## 215 Reksa Dana Syariah Bahana Icon Syariah Kelas G 1.28 0.74 -2.92
## 216 Reksa Dana Syariah Capital Sharia Equity 1.55 2.70 -1.28
## 217 Reliance Dana Saham 0.87 5.50 5.63
## 219 SAM Beta Plus Equity Fund 1.14 1.02 -4.76
## 220 SAM Dana Cerdas 1.01 1.87 -3.09
## 223 SAM Sharia Equity Fund 0.62 1.10 -6.44
## 224 STAR Sustainable Equity 1.46 1.73 -3.11
## 226 Sam Indonesian Equity Fund 1.39 2.14 -4.77
## 227 Schroder 90 Plus Equity Fund 1.52 2.07 -3.24
## 228 Schroder Dana Istimewa 1.33 1.57 -3.22
## 231 Schroder Dana Prestasi Prima 1.42 1.90 -2.99
## 232 Semesta Dana Saham 1.19 2.18 -2.42
## 233 Sentra Ekuitas Berkembang -0.02 -0.03 -0.13
## 235 Sequis Equity Indonesia 1.29 1.70 -2.81
## 236 Sequis Equity Maxima 1.28 1.37 -2.88
## 237 Shinhan Equity Growth 0.86 0.65 -3.62
## 238 Shinhan Mitra Maxima Ekuitas -1.31 -11.01 -11.65
## 239 Simas Dana Ekuitas 1.27 2.07 -2.75
## 240 Simas Danamas Saham 0.84 1.13 -4.15
## 242 Simas Saham Bertumbuh 1.23 2.10 -1.84
## 243 Simas Saham Gemilang 1.25 1.96 -2.82
## 244 Simas Saham Maksima 1.25 2.31 -3.22
## 245 Simas Saham Ultima 0.16 0.83 -0.28
## 246 Simas Saham Unggulan 1.23 2.23 -2.60
## 247 Simas Syariah Unggulan 0.91 0.56 -4.32
## 248 Sucorinvest Equity Fund 0.35 0.01 -5.37
## 249 Sucorinvest Equity Prima Fund -0.36 -3.23 -4.72
## 250 Sucorinvest Maxi Fund 0.36 1.52 -4.90
## 251 Sucorinvest Saham Dinamis 1.09 0.99 -4.66
## 252 Sucorinvest Sharia Equity Fund -0.25 0.74 -2.00
## 256 Syailendra Dana Ekuitas Sejahtera 1.27 1.59 -3.28
## 257 Syailendra Equity BUMN Plus 1.27 1.84 -2.85
## 258 Syailendra Equity Garuda Fund 1.23 1.69 -2.82
## 259 Syailendra Equity Momentum Fund 1.03 1.72 -2.96
## 260 Syailendra Equity Platinum Fund 1.06 1.77 -3.18
## 261 TRAM Consumption Plus Kelas A 1.41 2.19 -3.94
## 262 TRAM Infrastructure Plus 1.21 2.23 -2.53
## 263 TRIM Bhakti Bangsa 1.56 2.54 -3.29
## 265 TRIM Kapital Plus 1.15 1.23 -2.88
## 266 TRIM Syariah Saham 1.32 0.33 -5.73
## 267 Treasure Fund Super Maxxi 0.52 2.15 -1.75
## 268 Treasure Saham Berkah Syariah 0.64 1.55 2.23
## 269 Treasure Saham Mantap 0.50 1.69 2.97
## 270 Trimegah Saham Nusantara 1.31 2.21 -3.14
## 273 VMI Dana Saham 0.00 0.00 0.00
## 275 Victoria Equity Maxima -0.11 -0.07 -0.30
## 276 Victoria Prime Equity Fund -1.30 -10.93 -12.25
## X3M X6M X1T X3T X5T YTD Inception
## 3 -3.73 -0.18 -11.11 29.81 16.20 -6.59 482.84
## 4 -3.96 -2.54 -5.99 11.14 -8.56 -2.60 36.12
## 5 -5.38 -1.07 -5.81 24.41 8.85 -0.31 62.46
## 6 -6.56 -6.61 -6.09 16.99 14.10 1.08 24.99
## 8 -1.62 3.48 -3.26 27.97 11.36 4.83 9.63
## 10 -3.78 -1.11 -3.83 24.75 3.92 1.24 4.50
## 11 -4.10 -2.74 -3.69 25.04 14.25 -0.22 12.95
## 12 -4.76 -2.60 -3.47 29.92 26.92 0.11 27.48
## 14 0.00 0.00 0.00 0.00 -60.58 0.00 -63.50
## 15 0.00 0.00 0.00 0.00 -62.85 0.00 -62.98
## 16 5.93 4.44 -2.21 -6.33 -70.78 0.71 -73.58
## 17 0.87 -0.44 -5.94 -11.74 -70.55 -3.44 -73.73
## 18 -3.79 -5.37 -8.49 -0.10 -56.91 -8.63 -58.70
## 19 -4.57 -4.40 -7.58 -12.39 -79.02 -7.34 -79.12
## 20 1.08 0.95 -3.47 -14.41 -63.59 -1.13 -63.66
## 21 -6.35 -1.55 -5.16 22.19 7.89 0.67 7.44
## 22 -10.02 -5.83 -13.15 -3.01 -13.86 -9.59 -26.63
## 23 -6.97 -1.54 -0.84 32.72 25.65 2.58 -4.09
## 26 -3.66 -0.77 -7.64 1.60 0.26 -5.73 9.17
## 27 -4.40 -1.89 -8.19 5.88 -5.39 -1.91 -1.55
## 32 -5.11 -1.16 -1.58 11.13 -4.91 3.23 189.08
## 33 -4.17 -0.92 -2.07 16.02 -1.99 1.81 87.31
## 35 -6.21 -2.66 -4.50 11.28 1.94 -1.87 138.84
## 36 -8.06 -0.92 -10.17 -0.54 -14.94 -4.94 80.87
## 37 -3.11 -0.11 -7.20 14.79 -0.87 -2.06 371.25
## 39 -4.69 -1.04 -11.00 7.41 -12.31 -1.94 -21.66
## 42 -3.49 -0.49 -2.47 20.88 3.72 1.66 24.89
## 43 -3.02 0.54 -5.79 19.97 -0.39 1.65 -4.66
## 44 -6.00 -0.01 -8.22 1.62 -19.82 -0.78 -21.08
## 46 -2.34 0.94 -0.53 28.98 12.86 2.95 216.22
## 47 -6.33 -6.84 -10.64 4.88 -8.69 -6.89 68.38
## 50 -1.83 2.54 2.16 32.96 14.68 5.42 25.41
## 52 -1.85 2.50 2.07 32.22 17.72 5.33 27.01
## 53 -13.96 -20.96 -25.26 -18.66 -26.16 -24.23 -6.32
## 54 -6.06 -3.80 -8.36 14.88 -8.95 -5.01 -4.70
## 55 -5.90 -3.18 -6.98 20.53 2.91 -4.44 9.60
## 56 -8.10 3.97 9.20 68.25 90.33 8.67 179.36
## 57 -7.50 -1.52 -2.94 28.60 12.89 0.82 35.70
## 60 -6.41 -3.14 -7.39 20.92 4.27 -5.17 16.11
## 61 -7.68 -2.12 -8.46 15.76 -6.15 -3.91 75.79
## 62 -3.42 -1.16 -8.03 14.76 -63.43 -4.38 -73.32
## 63 -0.92 -3.18 -7.08 0.39 -58.31 -5.22 -64.84
## 64 -2.79 -1.14 -7.63 -7.94 -72.00 -4.37 -74.83
## 65 -6.48 -4.26 -15.22 -3.94 -21.58 -6.98 262.53
## 66 -2.44 -0.51 1.79 25.19 14.63 4.46 14.90
## 67 -4.24 -1.48 -4.28 18.61 -3.41 0.76 753.50
## 68 -3.87 -1.46 -5.91 13.08 -6.97 1.07 -5.90
## 69 -3.80 -0.84 -4.08 17.86 -6.39 2.48 -12.86
## 70 -5.83 3.03 -10.55 -0.96 -20.85 -4.23 32.52
## 71 -3.90 -0.67 -2.46 28.37 11.48 2.44 -8.95
## 72 -8.62 -7.67 -16.89 -2.86 -13.60 -12.19 -24.74
## 73 -2.79 1.43 -0.01 27.21 12.83 2.99 52.96
## 75 -4.47 -0.79 -4.80 23.17 5.11 -1.03 30.08
## 77 -2.56 -14.05 -17.78 -22.35 -89.14 -19.41 -91.00
## 78 0.30 -18.12 -19.80 -38.78 -93.60 -24.07 -60.80
## 79 -0.51 -7.03 -8.08 -12.11 -75.67 -9.51 -75.64
## 80 -12.37 -20.87 -25.28 -15.23 -29.61 -23.56 -29.41
## 81 -5.06 -2.32 -8.97 -5.43 -21.71 -2.93 -15.71
## 82 -2.14 -0.15 -1.51 19.63 -36.19 0.78 -46.56
## 85 -6.59 -9.22 -14.38 -17.92 -34.72 -14.52 -20.43
## 86 0.60 2.29 -2.72 -0.25 5.30 2.74 4.60
## 87 5.24 4.88 -1.03 31.13 46.98 2.15 34.74
## 88 11.69 7.21 9.65 29.59 -14.79 13.47 -28.92
## 90 8.64 10.74 1.96 32.24 11.63 7.34 167.10
## 91 -6.23 -3.45 -12.48 -4.10 -18.37 -7.60 -23.81
## 92 -6.03 -2.42 -6.98 4.33 -9.34 -2.74 0.06
## 93 1.38 1.59 -3.78 -0.94 -65.29 -1.47 -68.04
## 95 -6.90 -4.83 -8.49 1.74 -2.87 -2.54 -5.86
## 96 -6.83 -8.20 -14.51 -7.44 -10.10 -7.08 -9.09
## 97 -5.92 -4.73 -11.30 8.16 -14.46 -4.43 -6.49
## 98 -4.57 -5.60 -8.80 1.25 -21.37 -2.77 -6.30
## 99 -5.86 -6.64 -11.43 1.81 -19.97 -4.65 -17.84
## 100 -5.54 -7.48 -12.47 -7.28 -14.47 -5.21 -20.18
## 101 -4.89 -11.91 -22.98 -13.33 -43.70 -17.88 119.35
## 102 -0.23 1.56 -8.03 -20.42 -75.28 -2.55 -77.30
## 103 -4.77 -4.00 -12.20 -9.55 -34.95 -5.50 -34.69
## 104 -3.15 3.94 3.86 7.63 -15.33 8.89 -3.53
## 105 -1.40 2.63 -1.61 22.39 -6.05 3.72 -56.04
## 106 -1.50 2.04 -2.76 17.15 4.94 2.78 -2.32
## 107 -1.72 5.98 4.02 6.97 -10.41 9.44 -26.46
## 108 -6.47 -3.42 -3.56 12.00 -10.03 -0.06 303.52
## 110 -2.72 -2.33 -2.76 0.72 -19.68 -5.66 -5.20
## 111 -5.15 -1.66 -2.94 18.68 -3.90 1.00 138.20
## 113 -6.45 2.66 -6.54 21.67 -4.49 -1.45 -13.20
## 114 -2.96 -3.01 -3.61 21.57 -6.39 -6.31 2.25
## 115 -7.41 -4.45 -6.73 -0.84 -10.54 -2.54 27.91
## 116 -6.08 0.36 -7.96 11.49 -21.34 -3.35 12.66
## 117 -6.42 -3.29 -4.54 8.80 33.90 0.14 45.54
## 118 -5.74 -2.52 -4.24 13.29 -2.01 -0.37 40.34
## 121 -6.16 -2.92 -8.47 20.61 4.61 -1.40 -8.76
## 123 -7.21 -6.05 -13.45 2.34 -15.48 -5.65 884.28
## 125 -6.81 -6.40 -16.87 17.64 1.15 -7.22 35.07
## 126 -13.11 -17.91 -23.52 5.85 -5.72 -13.26 -5.87
## 128 -9.90 -11.66 -23.10 17.57 0.44 -12.74 88.64
## 129 -7.52 0.71 -14.56 11.91 -1.70 -7.83 -33.54
## 130 -6.53 -2.47 -9.54 11.57 -1.93 -5.07 237.71
## 131 -4.12 0.27 -5.40 8.89 -5.56 2.89 246.45
## 132 6.98 9.55 3.04 29.50 -46.75 7.16 -58.19
## 133 -3.63 3.08 0.49 20.30 0.77 4.51 19.80
## 134 -6.57 -2.04 -11.44 -0.98 -12.07 -5.16 -16.12
## 135 -4.23 -2.85 -6.77 13.63 -16.15 -5.10 -32.30
## 136 1.47 1.19 -1.03 -3.23 -82.50 -0.02 -85.86
## 137 -6.06 -16.07 -30.50 -17.49 -88.19 -21.63 -81.42
## 138 -0.89 -0.35 -5.07 -1.43 -33.49 -6.35 -9.15
## 141 -4.13 -1.03 -6.07 28.00 15.48 -1.90 63.91
## 142 -1.95 1.84 -9.46 -0.07 -10.18 -2.82 -21.06
## 143 -10.06 -9.99 -32.88 -22.43 -36.24 -25.59 -46.08
## 144 -0.95 -0.27 -3.44 0.75 -52.04 -1.56 -50.27
## 145 -4.08 -1.58 -2.67 75.28 -35.59 -1.14 -60.85
## 146 -9.95 -10.01 -17.90 -6.61 -20.16 -14.58 3.64
## 147 -8.11 -5.29 -8.85 18.78 4.10 -6.98 -18.37
## 148 -3.80 -4.62 -11.44 14.48 -24.73 -4.33 -38.04
## 149 -12.80 -25.45 -34.32 -35.50 -10.19 -32.69 -32.97
## 150 -14.09 -22.24 -26.17 -20.52 -30.61 -24.46 -19.29
## 151 -14.30 -21.42 -25.66 -15.37 -29.77 -23.85 -36.91
## 152 -11.83 -23.69 -28.04 -16.29 -39.89 -26.34 -38.71
## 153 -13.46 -28.19 -32.10 -29.67 -40.10 -30.72 -26.75
## 154 -9.88 -19.47 -23.67 -13.11 -21.02 -22.02 -2.49
## 155 -13.68 -24.79 -29.16 -19.95 -41.66 -27.43 -26.13
## 156 -14.05 -22.39 -26.82 -14.76 -9.50 -25.06 -6.06
## 157 -14.47 -25.70 -30.17 -21.44 -33.77 -28.37 -34.54
## 158 -17.14 -28.60 -37.93 -39.87 -50.70 -34.12 -40.04
## 159 -13.84 -25.48 -30.05 -19.58 -37.44 -28.20 -24.48
## 160 -1.68 -19.82 -23.54 -17.59 -38.53 -22.63 -36.01
## 161 -1.25 -14.52 -25.78 -21.00 -38.79 -20.55 184.95
## 162 -4.33 -25.97 -36.44 -25.14 -47.64 -32.47 -46.04
## 163 -7.70 -15.37 -23.54 -2.56 -65.83 -19.98 -70.59
## 164 -4.07 -2.39 -6.55 1.70 -68.79 -2.36 -73.20
## 168 -4.19 -1.05 -3.60 19.31 0.83 0.06 2.03
## 169 -4.69 -0.10 -1.67 25.10 3.07 2.43 -2.13
## 170 -4.68 -1.50 -2.98 24.72 7.24 2.31 1.33
## 171 -5.89 0.06 -2.63 43.84 20.27 0.73 27.89
## 173 -4.92 -1.40 -3.35 37.85 13.26 -0.11 252.93
## 174 -6.22 -2.78 -5.61 27.75 9.72 -3.57 8.69
## 175 -4.53 -1.69 -4.31 63.37 34.13 -0.52 95.66
## 176 -8.10 -1.14 -7.67 55.64 27.11 -1.84 22.58
## 178 -11.77 -26.53 -32.38 -22.00 -26.68 -28.88 -20.73
## 179 -1.50 -4.02 -8.04 -4.22 -66.87 -8.72 -70.58
## 180 -5.79 -0.32 -7.28 26.54 4.89 -0.43 51.35
## 182 -0.99 -2.38 -9.00 -13.70 -78.07 -6.22 -62.49
## 183 -0.52 -0.41 -6.38 5.70 -70.08 -2.97 -69.82
## 184 -9.49 -0.97 -5.33 21.05 -12.15 -0.14 -31.24
## 185 -9.56 -1.69 -5.38 19.09 -15.15 -0.37 -10.90
## 186 -7.87 -0.02 -2.04 32.29 -4.73 2.04 0.76
## 187 -10.77 -2.69 -8.75 15.78 -17.80 -3.76 -18.03
## 188 -10.12 -2.36 -6.16 20.15 -14.22 -1.08 -5.58
## 189 -9.68 -2.12 -7.26 17.29 -16.60 -2.15 -36.72
## 190 -8.84 -0.90 -5.16 19.29 -15.52 0.20 -43.73
## 191 -8.69 -0.78 -5.13 19.92 -13.37 0.13 -30.83
## 192 -8.65 -0.97 -5.04 15.13 -16.80 0.32 392.07
## 193 -11.45 -1.69 -15.74 5.66 -23.38 -8.99 -32.78
## 194 -4.63 -1.51 -3.30 -5.78 -20.52 1.51 -12.76
## 195 -5.67 -1.27 -7.41 3.61 -14.32 -1.43 -21.53
## 196 -5.28 -1.81 -3.99 0.38 -13.61 -3.42 17.53
## 198 -4.18 1.05 -2.20 26.35 -0.69 3.59 18.96
## 199 -2.03 4.13 2.56 29.22 -0.06 8.89 -11.24
## 200 -1.53 -0.13 -0.86 18.65 -47.99 0.75 -53.85
## 201 -2.27 4.61 0.21 38.79 0.93 6.58 57.11
## 202 -1.46 -1.29 -8.12 -19.86 -65.99 -3.65 -77.38
## 204 -2.76 8.67 14.47 35.49 -19.47 17.54 -50.96
## 205 -4.54 -0.90 -2.90 12.66 -11.79 1.72 52.66
## 206 -3.80 1.11 0.08 21.01 2.81 4.02 19.72
## 207 0.00 0.00 0.00 0.00 -56.43 0.00 -62.96
## 208 -3.87 -0.67 -6.92 6.87 -10.01 -0.88 -16.34
## 210 -4.67 -2.02 -5.49 4.58 -7.88 -0.43 -3.52
## 211 -4.88 -2.50 -5.26 11.93 -11.90 -0.14 56.84
## 212 -8.49 -9.28 -20.67 74.03 50.85 -9.91 93.78
## 213 -5.88 -2.64 -8.33 6.28 -7.59 -2.73 225.93
## 214 -2.92 2.53 -0.30 23.67 2.43 4.18 299.24
## 215 0.51 3.24 -1.22 5.02 -5.49 2.03 -14.22
## 216 -2.73 -10.92 -20.89 -13.58 -31.71 -16.10 -19.57
## 217 0.47 0.36 -19.53 -48.81 -61.53 -10.74 -57.53
## 219 -4.97 -3.39 -2.63 25.20 4.16 -0.49 4.20
## 220 -1.74 2.27 -3.19 32.63 1.09 3.04 25.54
## 223 -12.03 -11.72 -20.88 -4.43 -13.87 -16.58 -17.42
## 224 -6.55 -4.81 -8.57 38.01 1.98 -4.10 0.88
## 226 -1.34 5.98 -2.31 28.72 -5.65 5.06 115.19
## 227 -4.70 -1.86 -1.51 16.58 -2.12 -0.49 102.89
## 228 -6.61 -3.04 -5.65 13.84 -0.64 -5.04 560.76
## 231 -4.29 -0.56 0.52 24.05 7.50 2.85 33.03
## 232 -5.16 -1.97 -15.64 18.07 -1.81 -7.87 -0.60
## 233 -0.06 -1.99 -2.40 -2.35 -65.68 -2.67 -69.67
## 235 -4.39 -0.64 -2.10 17.81 2.15 2.48 -0.43
## 236 -5.03 -1.53 -5.75 12.43 -3.48 -1.36 -5.80
## 237 -3.96 1.33 -6.35 50.77 13.62 -2.55 135.85
## 238 -13.09 -29.55 -34.06 -38.16 -37.68 -32.09 -29.63
## 239 -3.75 -0.98 -3.15 15.58 -3.23 1.68 -13.66
## 240 0.58 10.70 1.84 11.71 -5.92 7.06 67.12
## 242 -0.95 1.26 -2.86 24.27 3.69 3.26 20.02
## 243 -3.99 -0.80 -6.26 14.59 -4.94 1.59 -4.83
## 244 -4.80 -1.52 -5.36 16.06 -3.26 0.99 -2.32
## 245 -1.15 -0.18 -2.75 3.61 -59.89 -2.38 -56.50
## 246 -3.11 -0.81 -3.63 6.30 -29.63 1.40 29.08
## 247 -2.15 0.31 -3.44 -2.76 -43.83 1.53 -38.28
## 248 -5.89 -0.39 -10.23 30.83 31.84 -5.05 158.16
## 249 -7.52 -8.76 -18.31 -38.42 -51.54 -15.20 -47.79
## 250 -11.44 -2.16 -11.40 25.82 23.46 -4.87 75.03
## 251 -3.74 7.95 -2.37 48.47 33.14 4.39 17.47
## 252 -6.44 -1.81 -14.98 29.41 19.60 -10.49 78.86
## 256 -5.86 -0.57 -2.83 24.78 -5.59 3.56 9.52
## 257 -2.44 3.26 -2.49 19.42 4.00 5.49 15.27
## 258 -4.55 -0.15 -3.04 32.79 8.48 3.43 -0.64
## 259 -3.01 2.58 -1.52 32.33 13.45 2.31 22.71
## 260 -2.54 2.31 -1.65 41.99 35.05 2.47 42.89
## 261 -4.82 0.41 -1.30 18.03 2.67 3.22 79.78
## 262 -4.95 1.06 3.90 36.82 4.58 3.80 38.28
## 263 -3.57 3.99 -2.01 29.41 6.26 5.26 48.92
## 265 -3.38 4.13 2.61 46.97 25.16 8.78 323.70
## 266 -6.01 0.62 -5.29 13.10 11.03 -0.73 81.19
## 267 -6.93 -13.97 -24.48 -15.66 -70.23 -18.85 -72.79
## 268 6.16 6.71 -3.42 -11.77 -84.54 2.08 -85.39
## 269 2.80 0.81 1.04 89.42 -25.03 3.88 -43.53
## 270 -3.72 -0.25 -3.09 18.63 3.88 2.35 6.77
## 273 0.00 -0.01 -0.02 -0.50 -76.18 -0.02 -76.26
## 275 0.57 -2.34 -3.72 21.97 5.28 -3.65 10.23
## 276 -13.70 -26.12 -30.94 -43.56 -44.79 -28.91 -33.99
rownames(mf_clean) <- mf_clean$MF_name
mf_clean_norow <- mf_clean[,-1]
mf_clean_norow.km <- kmeans(mf_clean_norow, 4)
mf_clean$cluster <- mf_clean_norow.km$cluster
mf_clean$cluster <- as.factor(mf_clean$cluster)
Cluster Plot
Graphs YTD &
6M
Graphs 1M &
3M
Graphs Wrap YTD &
6M
Graphs Wrap 1M &
3M
Graphs YTD & 6M,
Cluster 2
Graphs 1M & 3M,
Cluster 2
Graphs YTD & 6M,
Cluster 3
Graphs 1M & 3M,
Cluster 3
