Reserved for the medians of daily merits over days of week, for weeks since the 19th February 2018 (2018w8). Something similar to LoyceV work, but it is a little bit different, because I will use medians. 1) Converted data for use. list id day month2 year date dofw week month
+-----------------------------------------------------------------------+ | id day month2 year date dofw week month | |-----------------------------------------------------------------------| 1. | 1 24 1 2018 24jan2018 Wednesday 2018w4 2018m1 | 2. | 2 25 1 2018 25jan2018 Thursday 2018w4 2018m1 | 3. | 3 26 1 2018 26jan2018 Friday 2018w4 2018m1 | 4. | 4 27 1 2018 27jan2018 Saturday 2018w4 2018m1 | 5. | 5 28 1 2018 28jan2018 Sunday 2018w4 2018m1 | |-----------------------------------------------------------------------| 6. | 6 29 1 2018 29jan2018 Monday 2018w5 2018m1 | 7. | 7 30 1 2018 30jan2018 Tuesday 2018w5 2018m1 | 8. | 8 31 1 2018 31jan2018 Wednesday 2018w5 2018m1 | 9. | 9 1 2 2018 01feb2018 Thursday 2018w5 2018m2 | 10. | 10 2 2 2018 02feb2018 Friday 2018w5 2018m2 | |-----------------------------------------------------------------------| 11. | 11 3 2 2018 03feb2018 Saturday 2018w5 2018m2 | 12. | 12 4 2 2018 04feb2018 Sunday 2018w5 2018m2 | 13. | 13 5 2 2018 05feb2018 Monday 2018w6 2018m2 | 14. | 14 6 2 2018 06feb2018 Tuesday 2018w6 2018m2 | 15. | 15 7 2 2018 07feb2018 Wednesday 2018w6 2018m2 | |-----------------------------------------------------------------------| 16. | 16 8 2 2018 08feb2018 Thursday 2018w6 2018m2 | 17. | 17 9 2 2018 09feb2018 Friday 2018w6 2018m2 | 18. | 18 10 2 2018 10feb2018 Saturday 2018w6 2018m2 | 19. | 19 11 2 2018 11feb2018 Sunday 2018w6 2018m2 | 20. | 20 12 2 2018 12feb2018 Monday 2018w7 2018m2 | |-----------------------------------------------------------------------| 21. | 21 13 2 2018 13feb2018 Tuesday 2018w7 2018m2 | 22. | 22 14 2 2018 14feb2018 Wednesday 2018w7 2018m2 | 23. | 23 15 2 2018 15feb2018 Thursday 2018w7 2018m2 | 24. | 24 16 2 2018 16feb2018 Friday 2018w7 2018m2 | 25. | 25 17 2 2018 17feb2018 Saturday 2018w7 2018m2 | |-----------------------------------------------------------------------| 26. | 26 18 2 2018 18feb2018 Sunday 2018w7 2018m2 | 27. | 27 19 2 2018 19feb2018 Monday 2018w8 2018m2 | 28. | 28 20 2 2018 20feb2018 Tuesday 2018w8 2018m2 | 29. | 29 21 2 2018 21feb2018 Wednesday 2018w8 2018m2 | 30. | 30 22 2 2018 22feb2018 Thursday 2018w8 2018m2 | |-----------------------------------------------------------------------| 31. | 31 23 2 2018 23feb2018 Friday 2018w8 2018m2 | 32. | 32 24 2 2018 24feb2018 Saturday 2018w8 2018m2 | 33. | 33 25 2 2018 25feb2018 Sunday 2018w8 2018m2 | 34. | 34 26 2 2018 26feb2018 Monday 2018w9 2018m2 | 35. | 35 27 2 2018 27feb2018 Tuesday 2018w9 2018m2 | |-----------------------------------------------------------------------| 36. | 36 28 2 2018 28feb2018 Wednesday 2018w9 2018m2 | 37. | 37 1 3 2018 01mar2018 Thursday 2018w9 2018m3 | 38. | 38 2 3 2018 02mar2018 Friday 2018w9 2018m3 | 39. | 39 3 3 2018 03mar2018 Saturday 2018w9 2018m3 | 40. | 40 4 3 2018 04mar2018 Sunday 2018w9 2018m3 | |-----------------------------------------------------------------------| 41. | 41 5 3 2018 05mar2018 Monday 2018w10 2018m3 | 42. | 42 6 3 2018 06mar2018 Tuesday 2018w10 2018m3 | 43. | 43 7 3 2018 07mar2018 Wednesday 2018w10 2018m3 | 44. | 44 8 3 2018 08mar2018 Thursday 2018w10 2018m3 | 45. | 45 9 3 2018 09mar2018 Friday 2018w10 2018m3 | |-----------------------------------------------------------------------| 46. | 46 10 3 2018 10mar2018 Saturday 2018w10 2018m3 | 47. | 47 11 3 2018 11mar2018 Sunday 2018w10 2018m3 | 48. | 48 12 3 2018 12mar2018 Monday 2018w11 2018m3 | 49. | 49 13 3 2018 13mar2018 Tuesday 2018w11 2018m3 | 50. | 50 14 3 2018 14mar2018 Wednesday 2018w11 2018m3 | |-----------------------------------------------------------------------| 51. | 51 15 3 2018 15mar2018 Thursday 2018w11 2018m3 | 52. | 52 16 3 2018 16mar2018 Friday 2018w11 2018m3 | 53. | 53 17 3 2018 17mar2018 Saturday 2018w11 2018m3 | 54. | 54 18 3 2018 18mar2018 Sunday 2018w11 2018m3 | 55. | 55 19 3 2018 19mar2018 Monday 2018w12 2018m3 | |-----------------------------------------------------------------------| 56. | 56 20 3 2018 20mar2018 Tuesday 2018w12 2018m3 | 57. | 57 21 3 2018 21mar2018 Wednesday 2018w12 2018m3 | 58. | 58 22 3 2018 22mar2018 Thursday 2018w12 2018m3 | 59. | 59 23 3 2018 23mar2018 Friday 2018w12 2018m3 | 60. | 60 24 3 2018 24mar2018 Saturday 2018w12 2018m3 | |-----------------------------------------------------------------------| 61. | 61 25 3 2018 25mar2018 Sunday 2018w12 2018m3 | 62. | 62 26 3 2018 26mar2018 Monday 2018w13 2018m3 | 63. | 63 27 3 2018 27mar2018 Tuesday 2018w13 2018m3 | 64. | 64 28 3 2018 28mar2018 Wednesday 2018w13 2018m3 | 65. | 65 29 3 2018 29mar2018 Thursday 2018w13 2018m3 | |-----------------------------------------------------------------------| 66. | 66 30 3 2018 30mar2018 Friday 2018w13 2018m3 | 67. | 67 31 3 2018 31mar2018 Saturday 2018w13 2018m3 | 68. | 68 1 4 2018 01apr2018 Sunday 2018w13 2018m4 | 69. | 69 2 4 2018 02apr2018 Monday 2018w14 2018m4 | 70. | 70 3 4 2018 03apr2018 Tuesday 2018w14 2018m4 | |-----------------------------------------------------------------------| 71. | 71 4 4 2018 04apr2018 Wednesday 2018w14 2018m4 | 72. | 72 5 4 2018 05apr2018 Thursday 2018w14 2018m4 | 73. | 73 6 4 2018 06apr2018 Friday 2018w14 2018m4 | 74. | 74 7 4 2018 07apr2018 Saturday 2018w14 2018m4 | 75. | 75 8 4 2018 08apr2018 Sunday 2018w14 2018m4 | |-----------------------------------------------------------------------| 76. | 76 9 4 2018 09apr2018 Monday 2018w15 2018m4 | 77. | 77 10 4 2018 10apr2018 Tuesday 2018w15 2018m4 | 78. | 78 11 4 2018 11apr2018 Wednesday 2018w15 2018m4 | 79. | 79 12 4 2018 12apr2018 Thursday 2018w15 2018m4 | 80. | 80 13 4 2018 13apr2018 Friday 2018w15 2018m4 | |-----------------------------------------------------------------------| 81. | 81 14 4 2018 14apr2018 Saturday 2018w15 2018m4 | 82. | 82 15 4 2018 15apr2018 Sunday 2018w15 2018m4 | 83. | 83 16 4 2018 16apr2018 Monday 2018w16 2018m4 | 84. | 84 17 4 2018 17apr2018 Tuesday 2018w16 2018m4 | 85. | 85 18 4 2018 18apr2018 Wednesday 2018w16 2018m4 | |-----------------------------------------------------------------------| 86. | 86 19 4 2018 19apr2018 Thursday 2018w16 2018m4 | 87. | 87 20 4 2018 20apr2018 Friday 2018w16 2018m4 | 88. | 88 21 4 2018 21apr2018 Saturday 2018w16 2018m4 | 89. | 89 22 4 2018 22apr2018 Sunday 2018w16 2018m4 | 90. | 90 23 4 2018 23apr2018 Monday 2018w17 2018m4 | |-----------------------------------------------------------------------| 91. | 91 24 4 2018 24apr2018 Tuesday 2018w17 2018m4 | 92. | 92 25 4 2018 25apr2018 Wednesday 2018w17 2018m4 | 93. | 93 26 4 2018 26apr2018 Thursday 2018w17 2018m4 | 94. | 94 27 4 2018 27apr2018 Friday 2018w17 2018m4 | 95. | 95 28 4 2018 28apr2018 Saturday 2018w17 2018m4 | |-----------------------------------------------------------------------| 96. | 96 29 4 2018 29apr2018 Sunday 2018w17 2018m4 | 97. | 97 30 4 2018 30apr2018 Monday 2018w18 2018m4 | 98. | 98 1 5 2018 01may2018 Tuesday 2018w18 2018m5 | 99. | 99 2 5 2018 02may2018 Wednesday 2018w18 2018m5 | 100. | 100 3 5 2018 03may2018 Thursday 2018w18 2018m5 | |-----------------------------------------------------------------------| 101. | 101 4 5 2018 04may2018 Friday 2018w18 2018m5 | 102. | 102 5 5 2018 05may2018 Saturday 2018w18 2018m5 | 103. | 103 6 5 2018 06may2018 Sunday 2018w18 2018m5 | 104. | 104 7 5 2018 07may2018 Monday 2018w19 2018m5 | 105. | 105 8 5 2018 08may2018 Tuesday 2018w19 2018m5 | |-----------------------------------------------------------------------| 106. | 106 9 5 2018 09may2018 Wednesday 2018w19 2018m5 | 107. | 107 10 5 2018 10may2018 Thursday 2018w19 2018m5 | 108. | 108 11 5 2018 11may2018 Friday 2018w19 2018m5 | 109. | 109 12 5 2018 12may2018 Saturday 2018w19 2018m5 | 110. | 110 13 5 2018 13may2018 Sunday 2018w19 2018m5 | |-----------------------------------------------------------------------| 111. | 111 14 5 2018 14may2018 Monday 2018w20 2018m5 | 112. | 112 15 5 2018 15may2018 Tuesday 2018w20 2018m5 | 113. | 113 16 5 2018 16may2018 Wednesday 2018w20 2018m5 | 114. | 114 17 5 2018 17may2018 Thursday 2018w20 2018m5 | 115. | 115 18 5 2018 18may2018 Friday 2018w20 2018m5 | |-----------------------------------------------------------------------| 116. | 116 19 5 2018 19may2018 Saturday 2018w20 2018m5 | 117. | 117 20 5 2018 20may2018 Sunday 2018w20 2018m5 | 118. | 118 21 5 2018 21may2018 Monday 2018w21 2018m5 | 119. | 119 22 5 2018 22may2018 Tuesday 2018w21 2018m5 | 120. | 120 23 5 2018 23may2018 Wednesday 2018w21 2018m5 | |-----------------------------------------------------------------------| 121. | 121 24 5 2018 24may2018 Thursday 2018w21 2018m5 | 122. | 122 25 5 2018 25may2018 Friday 2018w21 2018m5 | 123. | 123 26 5 2018 26may2018 Saturday 2018w21 2018m5 | 124. | 124 27 5 2018 27may2018 Sunday 2018w21 2018m5 | 125. | 125 28 5 2018 28may2018 Monday 2018w22 2018m5 | |-----------------------------------------------------------------------| 126. | 126 29 5 2018 29may2018 Tuesday 2018w22 2018m5 | 127. | 127 30 5 2018 30may2018 Wednesday 2018w22 2018m5 | 128. | 128 31 5 2018 31may2018 Thursday 2018w22 2018m5 | 129. | 129 1 6 2018 01jun2018 Friday 2018w22 2018m6 | 130. | 130 2 6 2018 02jun2018 Saturday 2018w22 2018m6 | |-----------------------------------------------------------------------| 131. | 131 3 6 2018 03jun2018 Sunday 2018w22 2018m6 | 132. | 132 4 6 2018 04jun2018 Monday 2018w23 2018m6 | 133. | 133 5 6 2018 05jun2018 Tuesday 2018w23 2018m6 | 134. | 134 6 6 2018 06jun2018 Wednesday 2018w23 2018m6 | 135. | 135 7 6 2018 07jun2018 Thursday 2018w23 2018m6 | |-----------------------------------------------------------------------| 136. | 136 8 6 2018 08jun2018 Friday 2018w23 2018m6 | 137. | 137 9 6 2018 09jun2018 Saturday 2018w23 2018m6 | 138. | 138 10 6 2018 10jun2018 Sunday 2018w23 2018m6 | 139. | 139 11 6 2018 11jun2018 Monday 2018w24 2018m6 | 140. | 140 12 6 2018 12jun2018 Tuesday 2018w24 2018m6 | |-----------------------------------------------------------------------| 141. | 141 13 6 2018 13jun2018 Wednesday 2018w24 2018m6 | 142. | 142 14 6 2018 14jun2018 Thursday 2018w24 2018m6 | 143. | 143 15 6 2018 15jun2018 Friday 2018w24 2018m6 | 144. | 144 16 6 2018 16jun2018 Saturday 2018w24 2018m6 | 145. | 145 17 6 2018 17jun2018 Sunday 2018w24 2018m6 | |-----------------------------------------------------------------------| 146. | 146 18 6 2018 18jun2018 Monday 2018w25 2018m6 | 147. | 147 19 6 2018 19jun2018 Tuesday 2018w25 2018m6 | 148. | 148 20 6 2018 20jun2018 Wednesday 2018w25 2018m6 | 149. | 149 21 6 2018 21jun2018 Thursday 2018w25 2018m6 | 150. | 150 22 6 2018 22jun2018 Friday 2018w25 2018m6 | |-----------------------------------------------------------------------| 151. | 151 23 6 2018 23jun2018 Saturday 2018w25 2018m6 | 152. | 152 24 6 2018 24jun2018 Sunday 2018w25 2018m6 | 153. | 153 25 6 2018 25jun2018 Monday 2018w26 2018m6 | 154. | 154 26 6 2018 26jun2018 Tuesday 2018w26 2018m6 | 155. | 155 27 6 2018 27jun2018 Wednesday 2018w26 2018m6 | |-----------------------------------------------------------------------| 156. | 156 28 6 2018 28jun2018 Thursday 2018w26 2018m6 | 157. | 157 29 6 2018 29jun2018 Friday 2018w26 2018m6 | 158. | 158 30 6 2018 30jun2018 Saturday 2018w26 2018m6 | 159. | 159 1 7 2018 01jul2018 Sunday 2018w26 2018m7 | 160. | 160 2 7 2018 02jul2018 Monday 2018w27 2018m7 | |-----------------------------------------------------------------------| 161. | 161 3 7 2018 03jul2018 Tuesday 2018w27 2018m7 | 162. | 162 4 7 2018 04jul2018 Wednesday 2018w27 2018m7 | 163. | 163 5 7 2018 05jul2018 Thursday 2018w27 2018m7 | 164. | 164 6 7 2018 06jul2018 Friday 2018w27 2018m7 | 165. | 165 7 7 2018 07jul2018 Saturday 2018w27 2018m7 | |-----------------------------------------------------------------------| 166. | 166 8 7 2018 08jul2018 Sunday 2018w27 2018m7 | 167. | 167 9 7 2018 09jul2018 Monday 2018w28 2018m7 | 168. | 168 10 7 2018 10jul2018 Tuesday 2018w28 2018m7 | 169. | 169 11 7 2018 11jul2018 Wednesday 2018w28 2018m7 | 170. | 170 12 7 2018 12jul2018 Thursday 2018w28 2018m7 | |-----------------------------------------------------------------------| 171. | 171 13 7 2018 13jul2018 Friday 2018w28 2018m7 | 172. | 172 14 7 2018 14jul2018 Saturday 2018w28 2018m7 | 173. | 173 15 7 2018 15jul2018 Sunday 2018w28 2018m7 | 174. | 174 16 7 2018 16jul2018 Monday 2018w29 2018m7 | 175. | 175 17 7 2018 17jul2018 Tuesday 2018w29 2018m7 | |-----------------------------------------------------------------------| 176. | 176 18 7 2018 18jul2018 Wednesday 2018w29 2018m7 | 177. | 177 19 7 2018 19jul2018 Thursday 2018w29 2018m7 | 178. | 178 20 7 2018 20jul2018 Friday 2018w29 2018m7 | 179. | 179 21 7 2018 21jul2018 Saturday 2018w29 2018m7 | 180. | 180 22 7 2018 22jul2018 Sunday 2018w29 2018m7 | |-----------------------------------------------------------------------| 181. | 181 23 7 2018 23jul2018 Monday 2018w30 2018m7 | 182. | 182 24 7 2018 24jul2018 Tuesday 2018w30 2018m7 | 183. | 183 25 7 2018 25jul2018 Wednesday 2018w30 2018m7 | 184. | 184 26 7 2018 26jul2018 Thursday 2018w30 2018m7 | 185. | 185 27 7 2018 27jul2018 Friday 2018w30 2018m7 | |-----------------------------------------------------------------------| 186. | 186 28 7 2018 28jul2018 Saturday 2018w30 2018m7 | 187. | 187 29 7 2018 29jul2018 Sunday 2018w30 2018m7 | 188. | 188 30 7 2018 30jul2018 Monday 2018w31 2018m7 | 189. | 189 31 7 2018 31jul2018 Tuesday 2018w31 2018m7 | 190. | 190 1 8 2018 01aug2018 Wednesday 2018w31 2018m8 | |-----------------------------------------------------------------------| 191. | 191 2 8 2018 02aug2018 Thursday 2018w31 2018m8 | 192. | 192 3 8 2018 03aug2018 Friday 2018w31 2018m8 | 193. | 193 4 8 2018 04aug2018 Saturday 2018w31 2018m8 | 194. | 194 5 8 2018 05aug2018 Sunday 2018w31 2018m8 | 195. | 195 6 8 2018 06aug2018 Monday 2018w32 2018m8 | |-----------------------------------------------------------------------| 196. | 196 7 8 2018 07aug2018 Tuesday 2018w32 2018m8 | 197. | 197 8 8 2018 08aug2018 Wednesday 2018w32 2018m8 | 198. | 198 9 8 2018 09aug2018 Thursday 2018w32 2018m8 | 199. | 199 10 8 2018 10aug2018 Friday 2018w32 2018m8 | 200. | 200 11 8 2018 11aug2018 Saturday 2018w32 2018m8 | |-----------------------------------------------------------------------| 201. | 201 12 8 2018 12aug2018 Sunday 2018w32 2018m8 | 202. | 202 13 8 2018 13aug2018 Monday 2018w33 2018m8 | 203. | 203 14 8 2018 14aug2018 Tuesday 2018w33 2018m8 | 204. | 204 15 8 2018 15aug2018 Wednesday 2018w33 2018m8 | 205. | 205 16 8 2018 16aug2018 Thursday 2018w33 2018m8 | |-----------------------------------------------------------------------| 206. | 206 17 8 2018 17aug2018 Friday 2018w33 2018m8 | 207. | 207 18 8 2018 18aug2018 Saturday 2018w33 2018m8 | 208. | 208 19 8 2018 19aug2018 Sunday 2018w33 2018m8 | 209. | 209 20 8 2018 20aug2018 Monday 2018w34 2018m8 | 210. | 210 21 8 2018 21aug2018 Tuesday 2018w34 2018m8 | |-----------------------------------------------------------------------| 211. | 211 22 8 2018 22aug2018 Wednesday 2018w34 2018m8 | 212. | 212 23 8 2018 23aug2018 Thursday 2018w34 2018m8 | 213. | 213 24 8 2018 24aug2018 Friday 2018w34 2018m8 | 214. | 214 25 8 2018 25aug2018 Saturday 2018w34 2018m8 | 215. | 215 26 8 2018 26aug2018 Sunday 2018w34 2018m8 | |-----------------------------------------------------------------------| 216. | 216 27 8 2018 27aug2018 Monday 2018w35 2018m8 | 217. | 217 28 8 2018 28aug2018 Tuesday 2018w35 2018m8 | 218. | 218 29 8 2018 29aug2018 Wednesday 2018w35 2018m8 | 219. | 219 30 8 2018 30aug2018 Thursday 2018w35 2018m8 | 220. | 220 31 8 2018 31aug2018 Friday 2018w35 2018m8 | |-----------------------------------------------------------------------| 221. | 221 1 9 2018 01sep2018 Saturday 2018w35 2018m9 | 222. | 222 2 9 2018 02sep2018 Sunday 2018w35 2018m9 | 223. | 223 3 9 2018 03sep2018 Monday 2018w36 2018m9 | 224. | 224 4 9 2018 04sep2018 Tuesday 2018w36 2018m9 | 225. | 225 5 9 2018 05sep2018 Wednesday 2018w36 2018m9 | |-----------------------------------------------------------------------| 226. | 226 6 9 2018 06sep2018 Thursday 2018w36 2018m9 | 227. | 227 7 9 2018 07sep2018 Friday 2018w36 2018m9 | 228. | 228 8 9 2018 08sep2018 Saturday 2018w36 2018m9 | 229. | 229 9 9 2018 09sep2018 Sunday 2018w36 2018m9 | 230. | 230 10 9 2018 10sep2018 Monday 2018w37 2018m9 | |-----------------------------------------------------------------------| 231. | 231 11 9 2018 11sep2018 Tuesday 2018w37 2018m9 | 232. | 232 12 9 2018 12sep2018 Wednesday 2018w37 2018m9 | 233. | 233 13 9 2018 13sep2018 Thursday 2018w37 2018m9 | 234. | 234 14 9 2018 14sep2018 Friday 2018w37 2018m9 | 235. | 235 15 9 2018 15sep2018 Saturday 2018w37 2018m9 | |-----------------------------------------------------------------------| 236. | 236 16 9 2018 16sep2018 Sunday 2018w37 2018m9 | 237. | 237 17 9 2018 17sep2018 Monday 2018w38 2018m9 | 238. | 238 18 9 2018 18sep2018 Tuesday 2018w38 2018m9 | 239. | 239 19 9 2018 19sep2018 Wednesday 2018w38 2018m9 | 240. | 240 20 9 2018 20sep2018 Thursday 2018w38 2018m9 | |-----------------------------------------------------------------------| 241. | 241 21 9 2018 21sep2018 Friday 2018w38 2018m9 | 242. | 242 22 9 2018 22sep2018 Saturday 2018w38 2018m9 | 243. | 243 23 9 2018 23sep2018 Sunday 2018w38 2018m9 | 244. | 244 24 9 2018 24sep2018 Monday 2018w39 2018m9 | 245. | 245 25 9 2018 25sep2018 Tuesday 2018w39 2018m9 | |-----------------------------------------------------------------------| 246. | 246 26 9 2018 26sep2018 Wednesday 2018w39 2018m9 | 247. | 247 27 9 2018 27sep2018 Thursday 2018w39 2018m9 | 248. | 248 28 9 2018 28sep2018 Friday 2018w39 2018m9 | 249. | 249 29 9 2018 29sep2018 Saturday 2018w39 2018m9 | 250. | 250 30 9 2018 30sep2018 Sunday 2018w39 2018m9 | |-----------------------------------------------------------------------| 251. | 251 1 10 2018 01oct2018 Monday 2018w40 2018m10 | 252. | 252 2 10 2018 02oct2018 Tuesday 2018w40 2018m10 | 253. | 253 3 10 2018 03oct2018 Wednesday 2018w40 2018m10 | 254. | 254 4 10 2018 04oct2018 Thursday 2018w40 2018m10 | 255. | 255 5 10 2018 05oct2018 Friday 2018w40 2018m10 | |-----------------------------------------------------------------------| 256. | 256 6 10 2018 06oct2018 Saturday 2018w40 2018m10 | 257. | 257 7 10 2018 07oct2018 Sunday 2018w40 2018m10 | 258. | 258 8 10 2018 08oct2018 Monday 2018w41 2018m10 | 259. | 259 9 10 2018 09oct2018 Tuesday 2018w41 2018m10 | 260. | 260 10 10 2018 10oct2018 Wednesday 2018w41 2018m10 | |-----------------------------------------------------------------------| 261. | 261 11 10 2018 11oct2018 Thursday 2018w41 2018m10 | 262. | 262 12 10 2018 12oct2018 Friday 2018w41 2018m10 | 263. | 263 13 10 2018 13oct2018 Saturday 2018w41 2018m10 | 264. | 264 14 10 2018 14oct2018 Sunday 2018w41 2018m10 | 265. | 265 15 10 2018 15oct2018 Monday 2018w42 2018m10 | |-----------------------------------------------------------------------| 266. | 266 16 10 2018 16oct2018 Tuesday 2018w42 2018m10 | 267. | 267 17 10 2018 17oct2018 Wednesday 2018w42 2018m10 | 268. | 268 18 10 2018 18oct2018 Thursday 2018w42 2018m10 | 269. | 269 19 10 2018 19oct2018 Friday 2018w42 2018m10 | 270. | 270 20 10 2018 20oct2018 Saturday 2018w42 2018m10 | |-----------------------------------------------------------------------| 271. | 271 21 10 2018 21oct2018 Sunday 2018w42 2018m10 | 272. | 272 22 10 2018 22oct2018 Monday 2018w43 2018m10 | 273. | 273 23 10 2018 23oct2018 Tuesday 2018w43 2018m10 | 274. | 274 24 10 2018 24oct2018 Wednesday 2018w43 2018m10 | 275. | 275 25 10 2018 25oct2018 Thursday 2018w43 2018m10 | |-----------------------------------------------------------------------| 276. | 276 26 10 2018 26oct2018 Friday 2018w43 2018m10 | 277. | 277 27 10 2018 27oct2018 Saturday 2018w43 2018m10 | 278. | 278 28 10 2018 28oct2018 Sunday 2018w43 2018m10 | 279. | 279 29 10 2018 29oct2018 Monday 2018w44 2018m10 | 280. | 280 30 10 2018 30oct2018 Tuesday 2018w44 2018m10 | |-----------------------------------------------------------------------| 281. | 281 31 10 2018 31oct2018 Wednesday 2018w44 2018m10 | 282. | 282 1 11 2018 01nov2018 Thursday 2018w44 2018m11 | 283. | 283 2 11 2018 02nov2018 Friday 2018w44 2018m11 | 284. | 284 3 11 2018 03nov2018 Saturday 2018w44 2018m11 | 285. | 285 4 11 2018 04nov2018 Sunday 2018w44 2018m11 | |-----------------------------------------------------------------------| 286. | 286 5 11 2018 05nov2018 Monday 2018w45 2018m11 | 287. | 287 6 11 2018 06nov2018 Tuesday 2018w45 2018m11 | 288. | 288 7 11 2018 07nov2018 Wednesday 2018w45 2018m11 | 289. | 289 8 11 2018 08nov2018 Thursday 2018w45 2018m11 | 290. | 290 9 11 2018 09nov2018 Friday 2018w45 2018m11 | |-----------------------------------------------------------------------| 291. | 291 10 11 2018 10nov2018 Saturday 2018w45 2018m11 | 292. | 292 11 11 2018 11nov2018 Sunday 2018w45 2018m11 | 293. | 293 12 11 2018 12nov2018 Monday 2018w46 2018m11 | 294. | 294 13 11 2018 13nov2018 Tuesday 2018w46 2018m11 | 295. | 295 14 11 2018 14nov2018 Wednesday 2018w46 2018m11 | |-----------------------------------------------------------------------| 296. | 296 15 11 2018 15nov2018 Thursday 2018w46 2018m11 | 297. | 297 16 11 2018 16nov2018 Friday 2018w46 2018m11 | 298. | 298 17 11 2018 17nov2018 Saturday 2018w46 2018m11 | 299. | 299 18 11 2018 18nov2018 Sunday 2018w46 2018m11 | 300. | 300 19 11 2018 19nov2018 Monday 2018w47 2018m11 | |-----------------------------------------------------------------------| 301. | 301 20 11 2018 20nov2018 Tuesday 2018w47 2018m11 | 302. | 302 21 11 2018 21nov2018 Wednesday 2018w47 2018m11 | +-----------------------------------------------------------------------+
2) Results2.1) Full data (only for reference) Raw resutls: dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 43.0 849.9 563.8 641.0 511.0 989.0 412.0 3188.0 Monday | 43.0 890.7 586.8 684.0 589.0 992.0 455.0 3799.0 Tuesday | 43.0 857.8 633.9 639.0 580.0 902.0 383.0 4192.0 Wednesday | 44.0 1127.2 1902.4 684.0 582.0 977.0 435.0 13018.0 Thursday | 43.0 934.9 1017.2 673.0 528.0 848.0 376.0 6761.0 Friday | 43.0 792.9 707.3 567.0 475.0 789.0 370.0 4493.0 Saturday | 43.0 783.3 553.7 627.0 463.0 797.0 347.0 3489.0 ----------+-------------------------------------------------------------------------------- Total | 302.0 891.7 966.6 648.5 531.0 880.0 347.0 13018.0 -------------------------------------------------------------------------------------------
Median: p50 Q1: p25 Q3: p75 Min: Minimum Max: Maximum Mean: Average- Lowest day: Friday (567) - Highest day: Monday and Wednesday (all both at 684) - Percentage of difference between highest and lowest: 20.6% . di (684-567)*100/567 20.634921
2.2) First four weeks and first three days of 2018w47 dropped (I strongly suggest to use these below results) Raw results: dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 39.0 729.7 364.2 617.0 486.0 853.0 412.0 2463.0 Monday | 39.0 774.2 319.2 674.0 562.0 884.0 455.0 1862.0 Tuesday | 39.0 718.9 250.1 632.0 580.0 768.0 383.0 1326.0 Wednesday | 39.0 730.7 230.6 654.0 562.0 786.0 435.0 1268.0 Thursday | 39.0 686.3 226.1 644.0 521.0 838.0 376.0 1333.0 Friday | 39.0 619.9 240.1 542.0 463.0 733.0 370.0 1696.0 Saturday | 39.0 640.3 228.0 614.0 461.0 688.0 347.0 1409.0 ----------+-------------------------------------------------------------------------------- Total | 273.0 700.0 272.0 626.0 521.0 786.0 347.0 2463.0 -------------------------------------------------------------------------------------------
- Lowest day: Saturday (542) - Highest day: Wednesday (654) - Percentage of difference between highest and lowest: 20.7% . di (654-542)*100/542 20.664207
Boxplots of merits over days of weeksPotential outliers displayed with red circles. Potential outliers' displays disabled.
Not sure which factors make difference between my findings and LoyceV's ones, because my analysis for full data shows that the highest median of days of week is Thursday; and I guess LoyceV findings come from full daily data. There are three possible reasons: 1) My start 'assumed' calendar day should move backwards or forwards one day from the current one. 2) LoyceV used total merit per days of week, which significantly affected by outliers. 3) I used truncated dataset, LoyceV used full dataset. Here is LoyceV's findings: Merit per day of the week Monday 36842 (13.63%) Tuesday 38426 (14.22%) Wednesday 37368 (13.83%) Thursday 49743 (18.41%) Friday 39854 (14.75%) Saturday 34291 (12.69%) Sunday 33611 (12.44%) If I actually did something wrong, I believe that it highly comes from reason #1, because Wednesday is the day with highest median daily merit for both full and truncated datasets (one day earlier than LoyceV's findings - Thursday). Waiting for LoyceV's answer at this point.
|
|
|
Continue of the above thread: Then, I created the same box plot, but for only days since 19th February till 18th November 2018 (since week 2018w8 to 2018w46).The first four weeks since the start of merit system truncated due to extreme oultliers.Now, let's see the difference and magical meanings of medians. The above box plot represents medians of daily merit during the week 2018w8 (start point of the period) to specific weeks (from week 2018w26 to 2018w46). It means the box plot represent the changes of medians over the last 20 weeks (week #26 to #46). Details statistics of medians of daily merits over weeks will be given later with a table (I will add a table later). Now, let's see raw results, and medians is p50. . list week merit median q3 q1
+--------------------------------------+ | week merit median q3 q1 | |--------------------------------------| 1. | 2018w26 4457 733 991 609 | 2. | 2018w27 4253 715 979 598 | 3. | 2018w28 4239 707 963 592 | 4. | 2018w29 4159 693 922 589 | 5. | 2018w30 3652 684 902 577 | |--------------------------------------| 6. | 2018w31 3798 682 891 575 | 7. | 2018w32 3994 675 880 567 | 8. | 2018w33 3618 667 867 559 | 9. | 2018w34 3789 652 848 555 | 10. | 2018w35 3065 642 844 537 | |--------------------------------------| 11. | 2018w36 3574 639 838 528 | 12. | 2018w37 5630 634 829 528 | 13. | 2018w38 7825 641 846 530 | 14. | 2018w39 4388 640 839 531 | 15. | 2018w40 4271 639 829 528 | |--------------------------------------| 16. | 2018w41 3800 637 808 528 | 17. | 2018w42 4821 639 807 530 | 18. | 2018w43 3945 639 801 528 | 19. | 2018w44 3339 628 796 521 | 20. | 2018w45 4513 630 789 522 | |--------------------------------------| 21. | 2018w46 3722 626 786 521 | +--------------------------------------+
Next, list of weeks with ascending medians. . list week merit median q3 q1
+--------------------------------------+ | week merit median q3 q1 | |--------------------------------------| 1. | 2018w46 3722 626 786 521 | 2. | 2018w44 3339 628 796 521 | 3. | 2018w45 4513 630 789 522 | 4. | 2018w37 5630 634 829 528 | 5. | 2018w41 3800 637 808 528 | |--------------------------------------| 6. | 2018w42 4821 639 807 530 | 7. | 2018w43 3945 639 801 528 | 8. | 2018w40 4271 639 829 528 | 9. | 2018w36 3574 639 838 528 | 10. | 2018w39 4388 640 839 531 | |--------------------------------------| 11. | 2018w38 7825 641 846 530 | 12. | 2018w35 3065 642 844 537 | 13. | 2018w34 3789 652 848 555 | 14. | 2018w33 3618 667 867 559 | 15. | 2018w32 3994 675 880 567 | |--------------------------------------| 16. | 2018w31 3798 682 891 575 | 17. | 2018w30 3652 684 902 577 | 18. | 2018w29 4159 693 922 589 | 19. | 2018w28 4239 707 963 592 | 20. | 2018w27 4253 715 979 598 | |--------------------------------------| 21. | 2018w26 4457 733 991 609 | +--------------------------------------+
One more thing, a time-series plot of median, and interquartile range (from Q1 to Q3) of daily merits, from weeks #2018w8 to #2018w46), display only for weeks #26 to #46, 20 recent weeks). From the ascending list of medians of daily merits, the lowest and highest are 626 (at week 2018w46) and 733 (at week 2018w26). What does it mean? It means over the recent 20 weeks, there is 14.6% decrease of medians of daily merits (from 733 to 626), based on merit data we have till now, already truncated extreme outliers in the first four weeks. Notes:The interquartile range represents 50% of observed data. It means the 50% of observed days have total distribute merit per day inside the range, from Q1 to Q3. For instance, 50% of observed days from 2018w8 to 2018w46 have total merits per day in the range from 521 to 786. . list week merit median q3 q1
+--------------------------------------+ | week merit median q3 q1 | |--------------------------------------| 1. | 2018w46 3722 626 786 521 |
|
|
|
Thanks LoyceV for the newest data dump this week. I converted data for my analysis, here is full converted data: . list, abb(30)
+-------------------------------------------------------------------+ | id day month2 year merit date week month | |-------------------------------------------------------------------| 1. | 1 24 1 2018 13018 24jan2018 2018w4 2018m1 | 2. | 2 25 1 2018 6761 25jan2018 2018w4 2018m1 | 3. | 3 26 1 2018 4493 26jan2018 2018w4 2018m1 | 4. | 4 27 1 2018 3489 27jan2018 2018w4 2018m1 | 5. | 5 28 1 2018 3188 28jan2018 2018w4 2018m1 | |-------------------------------------------------------------------| 6. | 6 29 1 2018 3799 29jan2018 2018w5 2018m1 | 7. | 7 30 1 2018 4192 30jan2018 2018w5 2018m1 | 8. | 8 31 1 2018 2820 31jan2018 2018w5 2018m1 | 9. | 9 1 2 2018 2545 01feb2018 2018w5 2018m2 | 10. | 10 2 2 2018 2568 02feb2018 2018w5 2018m2 | |-------------------------------------------------------------------| 11. | 11 3 2 2018 1867 03feb2018 2018w5 2018m2 | 12. | 12 4 2 2018 2167 04feb2018 2018w5 2018m2 | 13. | 13 5 2 2018 2077 05feb2018 2018w6 2018m2 | 14. | 14 6 2 2018 2308 06feb2018 2018w6 2018m2 | 15. | 15 7 2 2018 2141 07feb2018 2018w6 2018m2 | |-------------------------------------------------------------------| 16. | 16 8 2 2018 2141 08feb2018 2018w6 2018m2 | 17. | 17 9 2 2018 1448 09feb2018 2018w6 2018m2 | 18. | 18 10 2 2018 1747 10feb2018 2018w6 2018m2 | 19. | 19 11 2 2018 1442 11feb2018 2018w6 2018m2 | 20. | 20 12 2 2018 1331 12feb2018 2018w7 2018m2 | |-------------------------------------------------------------------| 21. | 21 13 2 2018 1579 13feb2018 2018w7 2018m2 | 22. | 22 14 2 2018 2513 14feb2018 2018w7 2018m2 | 23. | 23 15 2 2018 1991 15feb2018 2018w7 2018m2 | 24. | 24 16 2 2018 1411 16feb2018 2018w7 2018m2 | 25. | 25 17 2 2018 1608 17feb2018 2018w7 2018m2 | |-------------------------------------------------------------------| 26. | 26 18 2 2018 1289 18feb2018 2018w7 2018m2 | 27. | 27 19 2 2018 1403 19feb2018 2018w8 2018m2 | 28. | 28 20 2 2018 1169 20feb2018 2018w8 2018m2 | 29. | 29 21 2 2018 1266 21feb2018 2018w8 2018m2 | 30. | 30 22 2 2018 1279 22feb2018 2018w8 2018m2 | |-------------------------------------------------------------------| 31. | 31 23 2 2018 1046 23feb2018 2018w8 2018m2 | 32. | 32 24 2 2018 1409 24feb2018 2018w8 2018m2 | 33. | 33 25 2 2018 1186 25feb2018 2018w8 2018m2 | 34. | 34 26 2 2018 1382 26feb2018 2018w9 2018m2 | 35. | 35 27 2 2018 1326 27feb2018 2018w9 2018m2 | |-------------------------------------------------------------------| 36. | 36 28 2 2018 991 28feb2018 2018w9 2018m2 | 37. | 37 1 3 2018 1333 01mar2018 2018w9 2018m3 | 38. | 38 2 3 2018 1696 02mar2018 2018w9 2018m3 | 39. | 39 3 3 2018 1089 03mar2018 2018w9 2018m3 | 40. | 40 4 3 2018 989 04mar2018 2018w9 2018m3 | |-------------------------------------------------------------------| 41. | 41 5 3 2018 1245 05mar2018 2018w10 2018m3 | 42. | 42 6 3 2018 1074 06mar2018 2018w10 2018m3 | 43. | 43 7 3 2018 1109 07mar2018 2018w10 2018m3 | 44. | 44 8 3 2018 922 08mar2018 2018w10 2018m3 | 45. | 45 9 3 2018 789 09mar2018 2018w10 2018m3 | |-------------------------------------------------------------------| 46. | 46 10 3 2018 1023 10mar2018 2018w10 2018m3 | 47. | 47 11 3 2018 1091 11mar2018 2018w10 2018m3 | 48. | 48 12 3 2018 1354 12mar2018 2018w11 2018m3 | 49. | 49 13 3 2018 994 13mar2018 2018w11 2018m3 | 50. | 50 14 3 2018 1159 14mar2018 2018w11 2018m3 | |-------------------------------------------------------------------| 51. | 51 15 3 2018 1130 15mar2018 2018w11 2018m3 | 52. | 52 16 3 2018 840 16mar2018 2018w11 2018m3 | 53. | 53 17 3 2018 797 17mar2018 2018w11 2018m3 | 54. | 54 18 3 2018 1035 18mar2018 2018w11 2018m3 | 55. | 55 19 3 2018 992 19mar2018 2018w12 2018m3 | |-------------------------------------------------------------------| 56. | 56 20 3 2018 1322 20mar2018 2018w12 2018m3 | 57. | 57 21 3 2018 1227 21mar2018 2018w12 2018m3 | 58. | 58 22 3 2018 764 22mar2018 2018w12 2018m3 | 59. | 59 23 3 2018 733 23mar2018 2018w12 2018m3 | 60. | 60 24 3 2018 1045 24mar2018 2018w12 2018m3 | |-------------------------------------------------------------------| 61. | 61 25 3 2018 858 25mar2018 2018w12 2018m3 | 62. | 62 26 3 2018 808 26mar2018 2018w13 2018m3 | 63. | 63 27 3 2018 879 27mar2018 2018w13 2018m3 | 64. | 64 28 3 2018 848 28mar2018 2018w13 2018m3 | 65. | 65 29 3 2018 1043 29mar2018 2018w13 2018m3 | |-------------------------------------------------------------------| 66. | 66 30 3 2018 928 30mar2018 2018w13 2018m3 | 67. | 67 31 3 2018 968 31mar2018 2018w13 2018m3 | 68. | 68 1 4 2018 1233 01apr2018 2018w13 2018m4 | 69. | 69 2 4 2018 1146 02apr2018 2018w14 2018m4 | 70. | 70 3 4 2018 1080 03apr2018 2018w14 2018m4 | |-------------------------------------------------------------------| 71. | 71 4 4 2018 1061 04apr2018 2018w14 2018m4 | 72. | 72 5 4 2018 838 05apr2018 2018w14 2018m4 | 73. | 73 6 4 2018 620 06apr2018 2018w14 2018m4 | 74. | 74 7 4 2018 614 07apr2018 2018w14 2018m4 | 75. | 75 8 4 2018 1056 08apr2018 2018w14 2018m4 | |-------------------------------------------------------------------| 76. | 76 9 4 2018 884 09apr2018 2018w15 2018m4 | 77. | 77 10 4 2018 768 10apr2018 2018w15 2018m4 | 78. | 78 11 4 2018 963 11apr2018 2018w15 2018m4 | 79. | 79 12 4 2018 917 12apr2018 2018w15 2018m4 | 80. | 80 13 4 2018 682 13apr2018 2018w15 2018m4 | |-------------------------------------------------------------------| 81. | 81 14 4 2018 681 14apr2018 2018w15 2018m4 | 82. | 82 15 4 2018 592 15apr2018 2018w15 2018m4 | 83. | 83 16 4 2018 609 16apr2018 2018w16 2018m4 | 84. | 84 17 4 2018 628 17apr2018 2018w16 2018m4 | 85. | 85 18 4 2018 681 18apr2018 2018w16 2018m4 | |-------------------------------------------------------------------| 86. | 86 19 4 2018 848 19apr2018 2018w16 2018m4 | 87. | 87 20 4 2018 463 20apr2018 2018w16 2018m4 | 88. | 88 21 4 2018 522 21apr2018 2018w16 2018m4 | 89. | 89 22 4 2018 880 22apr2018 2018w16 2018m4 | 90. | 90 23 4 2018 709 23apr2018 2018w17 2018m4 | |-------------------------------------------------------------------| 91. | 91 24 4 2018 626 24apr2018 2018w17 2018m4 | 92. | 92 25 4 2018 687 25apr2018 2018w17 2018m4 | 93. | 93 26 4 2018 675 26apr2018 2018w17 2018m4 | 94. | 94 27 4 2018 583 27apr2018 2018w17 2018m4 | 95. | 95 28 4 2018 623 28apr2018 2018w17 2018m4 | |-------------------------------------------------------------------| 96. | 96 29 4 2018 682 29apr2018 2018w17 2018m4 | 97. | 97 30 4 2018 822 30apr2018 2018w18 2018m4 | 98. | 98 1 5 2018 741 01may2018 2018w18 2018m5 | 99. | 99 2 5 2018 759 02may2018 2018w18 2018m5 | 100. | 100 3 5 2018 747 03may2018 2018w18 2018m5 | |-------------------------------------------------------------------| 101. | 101 4 5 2018 597 04may2018 2018w18 2018m5 | 102. | 102 5 5 2018 688 05may2018 2018w18 2018m5 | 103. | 103 6 5 2018 599 06may2018 2018w18 2018m5 | 104. | 104 7 5 2018 898 07may2018 2018w19 2018m5 | 105. | 105 8 5 2018 618 08may2018 2018w19 2018m5 | |-------------------------------------------------------------------| 106. | 106 9 5 2018 761 09may2018 2018w19 2018m5 | 107. | 107 10 5 2018 475 10may2018 2018w19 2018m5 | 108. | 108 11 5 2018 867 11may2018 2018w19 2018m5 | 109. | 109 12 5 2018 415 12may2018 2018w19 2018m5 | 110. | 110 13 5 2018 719 13may2018 2018w19 2018m5 | |-------------------------------------------------------------------| 111. | 111 14 5 2018 674 14may2018 2018w20 2018m5 | 112. | 112 15 5 2018 700 15may2018 2018w20 2018m5 | 113. | 113 16 5 2018 652 16may2018 2018w20 2018m5 | 114. | 114 17 5 2018 574 17may2018 2018w20 2018m5 | 115. | 115 18 5 2018 542 18may2018 2018w20 2018m5 | |-------------------------------------------------------------------| 116. | 116 19 5 2018 587 19may2018 2018w20 2018m5 | 117. | 117 20 5 2018 617 20may2018 2018w20 2018m5 | 118. | 118 21 5 2018 626 21may2018 2018w21 2018m5 | 119. | 119 22 5 2018 639 22may2018 2018w21 2018m5 | 120. | 120 23 5 2018 531 23may2018 2018w21 2018m5 | |-------------------------------------------------------------------| 121. | 121 24 5 2018 554 24may2018 2018w21 2018m5 | 122. | 122 25 5 2018 370 25may2018 2018w21 2018m5 | 123. | 123 26 5 2018 575 26may2018 2018w21 2018m5 | 124. | 124 27 5 2018 559 27may2018 2018w21 2018m5 | 125. | 125 28 5 2018 589 28may2018 2018w22 2018m5 | |-------------------------------------------------------------------| 126. | 126 29 5 2018 638 29may2018 2018w22 2018m5 | 127. | 127 30 5 2018 599 30may2018 2018w22 2018m5 | 128. | 128 31 5 2018 687 31may2018 2018w22 2018m5 | 129. | 129 1 6 2018 698 01jun2018 2018w22 2018m6 | 130. | 130 2 6 2018 461 02jun2018 2018w22 2018m6 | |-------------------------------------------------------------------| 131. | 131 3 6 2018 511 03jun2018 2018w22 2018m6 | 132. | 132 4 6 2018 773 04jun2018 2018w23 2018m6 | 133. | 133 5 6 2018 731 05jun2018 2018w23 2018m6 | 134. | 134 6 6 2018 504 06jun2018 2018w23 2018m6 | 135. | 135 7 6 2018 506 07jun2018 2018w23 2018m6 | |-------------------------------------------------------------------| 136. | 136 8 6 2018 766 08jun2018 2018w23 2018m6 | 137. | 137 9 6 2018 672 09jun2018 2018w23 2018m6 | 138. | 138 10 6 2018 575 10jun2018 2018w23 2018m6 | 139. | 139 11 6 2018 519 11jun2018 2018w24 2018m6 | 140. | 140 12 6 2018 422 12jun2018 2018w24 2018m6 | |-------------------------------------------------------------------| 141. | 141 13 6 2018 786 13jun2018 2018w24 2018m6 | 142. | 142 14 6 2018 528 14jun2018 2018w24 2018m6 | 143. | 143 15 6 2018 445 15jun2018 2018w24 2018m6 | 144. | 144 16 6 2018 654 16jun2018 2018w24 2018m6 | 145. | 145 17 6 2018 464 17jun2018 2018w24 2018m6 | |-------------------------------------------------------------------| 146. | 146 18 6 2018 601 18jun2018 2018w25 2018m6 | 147. | 147 19 6 2018 662 19jun2018 2018w25 2018m6 | 148. | 148 20 6 2018 707 20jun2018 2018w25 2018m6 | 149. | 149 21 6 2018 705 21jun2018 2018w25 2018m6 | 150. | 150 22 6 2018 774 22jun2018 2018w25 2018m6 | |-------------------------------------------------------------------| 151. | 151 23 6 2018 643 23jun2018 2018w25 2018m6 | 152. | 152 24 6 2018 829 24jun2018 2018w25 2018m6 | 153. | 153 25 6 2018 1138 25jun2018 2018w26 2018m6 | 154. | 154 26 6 2018 435 26jun2018 2018w26 2018m6 | 155. | 155 27 6 2018 516 27jun2018 2018w26 2018m6 | |-------------------------------------------------------------------| 156. | 156 28 6 2018 470 28jun2018 2018w26 2018m6 | 157. | 157 29 6 2018 479 29jun2018 2018w26 2018m6 | 158. | 158 30 6 2018 778 30jun2018 2018w26 2018m6 | 159. | 159 1 7 2018 641 01jul2018 2018w26 2018m7 | 160. | 160 2 7 2018 711 02jul2018 2018w27 2018m7 | |-------------------------------------------------------------------| 161. | 161 3 7 2018 902 03jul2018 2018w27 2018m7 | 162. | 162 4 7 2018 557 04jul2018 2018w27 2018m7 | 163. | 163 5 7 2018 577 05jul2018 2018w27 2018m7 | 164. | 164 6 7 2018 475 06jul2018 2018w27 2018m7 | 165. | 165 7 7 2018 506 07jul2018 2018w27 2018m7 | |-------------------------------------------------------------------| 166. | 166 8 7 2018 525 08jul2018 2018w27 2018m7 | 167. | 167 9 7 2018 455 09jul2018 2018w28 2018m7 | 168. | 168 10 7 2018 620 10jul2018 2018w28 2018m7 | 169. | 169 11 7 2018 555 11jul2018 2018w28 2018m7 | 170. | 170 12 7 2018 644 12jul2018 2018w28 2018m7 | |-------------------------------------------------------------------| 171. | 171 13 7 2018 542 13jul2018 2018w28 2018m7 | 172. | 172 14 7 2018 627 14jul2018 2018w28 2018m7 | 173. | 173 15 7 2018 796 15jul2018 2018w28 2018m7 | 174. | 174 16 7 2018 636 16jul2018 2018w29 2018m7 | 175. | 175 17 7 2018 641 17jul2018 2018w29 2018m7 | |-------------------------------------------------------------------| 176. | 176 18 7 2018 608 18jul2018 2018w29 2018m7 | 177. | 177 19 7 2018 554 19jul2018 2018w29 2018m7 | 178. | 178 20 7 2018 606 20jul2018 2018w29 2018m7 | 179. | 179 21 7 2018 567 21jul2018 2018w29 2018m7 | 180. | 180 22 7 2018 547 22jul2018 2018w29 2018m7 | |-------------------------------------------------------------------| 181. | 181 23 7 2018 684 23jul2018 2018w30 2018m7 | 182. | 182 24 7 2018 444 24jul2018 2018w30 2018m7 | 183. | 183 25 7 2018 492 25jul2018 2018w30 2018m7 | 184. | 184 26 7 2018 673 26jul2018 2018w30 2018m7 | 185. | 185 27 7 2018 521 27jul2018 2018w30 2018m7 | |-------------------------------------------------------------------| 186. | 186 28 7 2018 418 28jul2018 2018w30 2018m7 | 187. | 187 29 7 2018 420 29jul2018 2018w30 2018m7 | 188. | 188 30 7 2018 471 30jul2018 2018w31 2018m7 | 189. | 189 31 7 2018 632 31jul2018 2018w31 2018m7 | 190. | 190 1 8 2018 435 01aug2018 2018w31 2018m8 | |-------------------------------------------------------------------| 191. | 191 2 8 2018 376 02aug2018 2018w31 2018m8 | 192. | 192 3 8 2018 421 03aug2018 2018w31 2018m8 | 193. | 193 4 8 2018 695 04aug2018 2018w31 2018m8 | 194. | 194 5 8 2018 768 05aug2018 2018w31 2018m8 | 195. | 195 6 8 2018 595 06aug2018 2018w32 2018m8 | |-------------------------------------------------------------------| 196. | 196 7 8 2018 610 07aug2018 2018w32 2018m8 | 197. | 197 8 8 2018 647 08aug2018 2018w32 2018m8 | 198. | 198 9 8 2018 471 09aug2018 2018w32 2018m8 | 199. | 199 10 8 2018 567 10aug2018 2018w32 2018m8 | 200. | 200 11 8 2018 517 11aug2018 2018w32 2018m8 | |-------------------------------------------------------------------| 201. | 201 12 8 2018 587 12aug2018 2018w32 2018m8 | 202. | 202 13 8 2018 513 13aug2018 2018w33 2018m8 | 203. | 203 14 8 2018 565 14aug2018 2018w33 2018m8 | 204. | 204 15 8 2018 626 15aug2018 2018w33 2018m8 | 205. | 205 16 8 2018 470 16aug2018 2018w33 2018m8 | |-------------------------------------------------------------------| 206. | 206 17 8 2018 451 17aug2018 2018w33 2018m8 | 207. | 207 18 8 2018 561 18aug2018 2018w33 2018m8 | 208. | 208 19 8 2018 432 19aug2018 2018w33 2018m8 | 209. | 209 20 8 2018 658 20aug2018 2018w34 2018m8 | 210. | 210 21 8 2018 600 21aug2018 2018w34 2018m8 | |-------------------------------------------------------------------| 211. | 211 22 8 2018 612 22aug2018 2018w34 2018m8 | 212. | 212 23 8 2018 530 23aug2018 2018w34 2018m8 | 213. | 213 24 8 2018 528 24aug2018 2018w34 2018m8 | 214. | 214 25 8 2018 385 25aug2018 2018w34 2018m8 | 215. | 215 26 8 2018 476 26aug2018 2018w34 2018m8 | |-------------------------------------------------------------------| 216. | 216 27 8 2018 457 27aug2018 2018w35 2018m8 | 217. | 217 28 8 2018 383 28aug2018 2018w35 2018m8 | 218. | 218 29 8 2018 488 29aug2018 2018w35 2018m8 | 219. | 219 30 8 2018 514 30aug2018 2018w35 2018m8 | 220. | 220 31 8 2018 379 31aug2018 2018w35 2018m8 | |-------------------------------------------------------------------| 221. | 221 1 9 2018 432 01sep2018 2018w35 2018m9 | 222. | 222 2 9 2018 412 02sep2018 2018w35 2018m9 | 223. | 223 3 9 2018 536 03sep2018 2018w36 2018m9 | 224. | 224 4 9 2018 567 04sep2018 2018w36 2018m9 | 225. | 225 5 9 2018 654 05sep2018 2018w36 2018m9 | |-------------------------------------------------------------------| 226. | 226 6 9 2018 509 06sep2018 2018w36 2018m9 | 227. | 227 7 9 2018 458 07sep2018 2018w36 2018m9 | 228. | 228 8 9 2018 395 08sep2018 2018w36 2018m9 | 229. | 229 9 9 2018 455 09sep2018 2018w36 2018m9 | 230. | 230 10 9 2018 472 10sep2018 2018w37 2018m9 | |-------------------------------------------------------------------| 231. | 231 11 9 2018 580 11sep2018 2018w37 2018m9 | 232. | 232 12 9 2018 595 12sep2018 2018w37 2018m9 | 233. | 233 13 9 2018 540 13sep2018 2018w37 2018m9 | 234. | 234 14 9 2018 517 14sep2018 2018w37 2018m9 | 235. | 235 15 9 2018 463 15sep2018 2018w37 2018m9 | |-------------------------------------------------------------------| 236. | 236 16 9 2018 2463 16sep2018 2018w37 2018m9 | 237. | 237 17 9 2018 1862 17sep2018 2018w38 2018m9 | 238. | 238 18 9 2018 1294 18sep2018 2018w38 2018m9 | 239. | 239 19 9 2018 1268 19sep2018 2018w38 2018m9 | 240. | 240 20 9 2018 846 20sep2018 2018w38 2018m9 | |-------------------------------------------------------------------| 241. | 241 21 9 2018 807 21sep2018 2018w38 2018m9 | 242. | 242 22 9 2018 944 22sep2018 2018w38 2018m9 | 243. | 243 23 9 2018 804 23sep2018 2018w38 2018m9 | 244. | 244 24 9 2018 749 24sep2018 2018w39 2018m9 | 245. | 245 25 9 2018 596 25sep2018 2018w39 2018m9 | |-------------------------------------------------------------------| 246. | 246 26 9 2018 562 26sep2018 2018w39 2018m9 | 247. | 247 27 9 2018 675 27sep2018 2018w39 2018m9 | 248. | 248 28 9 2018 518 28sep2018 2018w39 2018m9 | 249. | 249 29 9 2018 669 29sep2018 2018w39 2018m9 | 250. | 250 30 9 2018 619 30sep2018 2018w39 2018m9 | |-------------------------------------------------------------------| 251. | 251 1 10 2018 509 01oct2018 2018w40 2018m10 | 252. | 252 2 10 2018 760 02oct2018 2018w40 2018m10 | 253. | 253 3 10 2018 705 03oct2018 2018w40 2018m10 | 254. | 254 4 10 2018 521 04oct2018 2018w40 2018m10 | 255. | 255 5 10 2018 513 05oct2018 2018w40 2018m10 | |-------------------------------------------------------------------| 256. | 256 6 10 2018 660 06oct2018 2018w40 2018m10 | 257. | 257 7 10 2018 603 07oct2018 2018w40 2018m10 | 258. | 258 8 10 2018 678 08oct2018 2018w41 2018m10 | 259. | 259 9 10 2018 578 09oct2018 2018w41 2018m10 | 260. | 260 10 10 2018 639 10oct2018 2018w41 2018m10 | |-------------------------------------------------------------------| 261. | 261 11 10 2018 616 11oct2018 2018w41 2018m10 | 262. | 262 12 10 2018 399 12oct2018 2018w41 2018m10 | 263. | 263 13 10 2018 460 13oct2018 2018w41 2018m10 | 264. | 264 14 10 2018 430 14oct2018 2018w41 2018m10 | 265. | 265 15 10 2018 655 15oct2018 2018w42 2018m10 | |-------------------------------------------------------------------| 266. | 266 16 10 2018 626 16oct2018 2018w42 2018m10 | 267. | 267 17 10 2018 732 17oct2018 2018w42 2018m10 | 268. | 268 18 10 2018 774 18oct2018 2018w42 2018m10 | 269. | 269 19 10 2018 643 19oct2018 2018w42 2018m10 | 270. | 270 20 10 2018 538 20oct2018 2018w42 2018m10 | |-------------------------------------------------------------------| 271. | 271 21 10 2018 853 21oct2018 2018w42 2018m10 | 272. | 272 22 10 2018 694 22oct2018 2018w43 2018m10 | 273. | 273 23 10 2018 674 23oct2018 2018w43 2018m10 | 274. | 274 24 10 2018 759 24oct2018 2018w43 2018m10 | 275. | 275 25 10 2018 553 25oct2018 2018w43 2018m10 | |-------------------------------------------------------------------| 276. | 276 26 10 2018 424 26oct2018 2018w43 2018m10 | 277. | 277 27 10 2018 426 27oct2018 2018w43 2018m10 | 278. | 278 28 10 2018 415 28oct2018 2018w43 2018m10 | 279. | 279 29 10 2018 534 29oct2018 2018w44 2018m10 | 280. | 280 30 10 2018 529 30oct2018 2018w44 2018m10 | |-------------------------------------------------------------------| 281. | 281 31 10 2018 495 31oct2018 2018w44 2018m10 | 282. | 282 1 11 2018 433 01nov2018 2018w44 2018m11 | 283. | 283 2 11 2018 454 02nov2018 2018w44 2018m11 | 284. | 284 3 11 2018 430 03nov2018 2018w44 2018m11 | 285. | 285 4 11 2018 464 04nov2018 2018w44 2018m11 | |-------------------------------------------------------------------| 286. | 286 5 11 2018 562 05nov2018 2018w45 2018m11 | 287. | 287 6 11 2018 405 06nov2018 2018w45 2018m11 | 288. | 288 7 11 2018 691 07nov2018 2018w45 2018m11 | 289. | 289 8 11 2018 843 08nov2018 2018w45 2018m11 | 290. | 290 9 11 2018 536 09nov2018 2018w45 2018m11 | |-------------------------------------------------------------------| 291. | 291 10 11 2018 688 10nov2018 2018w45 2018m11 | 292. | 292 11 11 2018 788 11nov2018 2018w45 2018m11 | 293. | 293 12 11 2018 591 12nov2018 2018w46 2018m11 | 294. | 294 13 11 2018 580 13nov2018 2018w46 2018m11 | 295. | 295 14 11 2018 569 14nov2018 2018w46 2018m11 | |-------------------------------------------------------------------| 296. | 296 15 11 2018 650 15nov2018 2018w46 2018m11 | 297. | 297 16 11 2018 499 16nov2018 2018w46 2018m11 | 298. | 298 17 11 2018 347 17nov2018 2018w46 2018m11 | 299. | 299 18 11 2018 486 18nov2018 2018w46 2018m11 | 300. | 300 19 11 2018 898 19nov2018 2018w47 2018m11 | |-------------------------------------------------------------------| 301. | 301 20 11 2018 767 20nov2018 2018w47 2018m11 | 302. | 302 21 11 2018 608 21nov2018 2018w47 2018m11 | +-------------------------------------------------------------------+
1) Box plot for median of weekly merits over weeks[the #1 in my To-Do list above]. For below analysis and box plots, I only use data since 24th Jan. 2018 to 18th November 2018 (or equal to Week #46, which ends at the id #299) because the week #47, from id #300 to id #303, has been incomple one. Boxplot #1: For daily merits (full data, before - after 18th Feb 2018, and over weeks since week #38) Boxplot #2: For daily merits (after 18th Feb 2018, and over weeks since week #38) In the second box plot, it is clearly that both medians, interquartile range (Q3 - Q1) tend to slowly decrease over weeks.
Nevertheless, as I said before, the first four weeks (half of week 4, and weeks #5 to #7) contain extreme outliers. In fact, I made two above box plots due to mistakes in the code, but I will leave them above for referece. . list, abb(30)
+-------------------------------------------------------------------+ | id day month2 year merit date week month | |-------------------------------------------------------------------| 1. | 1 24 1 2018 13018 24jan2018 2018w4 2018m1 | 2. | 2 25 1 2018 6761 25jan2018 2018w4 2018m1 | 3. | 3 26 1 2018 4493 26jan2018 2018w4 2018m1 | 4. | 4 27 1 2018 3489 27jan2018 2018w4 2018m1 | 5. | 5 28 1 2018 3188 28jan2018 2018w4 2018m1 | |-------------------------------------------------------------------| 6. | 6 29 1 2018 3799 29jan2018 2018w5 2018m1 | 7. | 7 30 1 2018 4192 30jan2018 2018w5 2018m1 | 8. | 8 31 1 2018 2820 31jan2018 2018w5 2018m1 | 9. | 9 1 2 2018 2545 01feb2018 2018w5 2018m2 | 10. | 10 2 2 2018 2568 02feb2018 2018w5 2018m2 | |-------------------------------------------------------------------| 11. | 11 3 2 2018 1867 03feb2018 2018w5 2018m2 | 12. | 12 4 2 2018 2167 04feb2018 2018w5 2018m2 | 13. | 13 5 2 2018 2077 05feb2018 2018w6 2018m2 | 14. | 14 6 2 2018 2308 06feb2018 2018w6 2018m2 | 15. | 15 7 2 2018 2141 07feb2018 2018w6 2018m2 | |-------------------------------------------------------------------| 16. | 16 8 2 2018 2141 08feb2018 2018w6 2018m2 | 17. | 17 9 2 2018 1448 09feb2018 2018w6 2018m2 | 18. | 18 10 2 2018 1747 10feb2018 2018w6 2018m2 | 19. | 19 11 2 2018 1442 11feb2018 2018w6 2018m2 | 20. | 20 12 2 2018 1331 12feb2018 2018w7 2018m2 | |-------------------------------------------------------------------| 21. | 21 13 2 2018 1579 13feb2018 2018w7 2018m2 | 22. | 22 14 2 2018 2513 14feb2018 2018w7 2018m2 | 23. | 23 15 2 2018 1991 15feb2018 2018w7 2018m2 | 24. | 24 16 2 2018 1411 16feb2018 2018w7 2018m2 | 25. | 25 17 2 2018 1608 17feb2018 2018w7 2018m2 | |-------------------------------------------------------------------| 26. | 26 18 2 2018 1289 18feb2018 2018w7 2018m2 |
|
|
|
Highly appreciated your time to do it, keep it update weekly. Would you mind spending your precious time to scrap data and give me and others the sort of weekly merits sent from each rank over weeks, since the start of merit system, please. Additionally, if you have intention to do this, I suggest you to do the same for total weekly merit received from each rank over weeks, since the start of merit sytem. I asked this because I have a topic, which shows the observations of distributed merits over days, weeks, and months, since the start of merit system. By now, I use LoyceV's data source, which has not had the sort of data mentioned above. My topic is here: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)Merits sent from each rank last week Administrator 12 Copper Member 92 Donator 141 Full Member 313 Global Moderator 31 Hero Member 450 Jr. Member 82 Legendary 2012 Member 226 Newbie 40 Sr. Member 499 Staff 380
|
|
|
Reserved for To-Do List next weeks' data:1) Box plot for median of weekly merits over weeks. This one is to track changes of median with impacts of weekly merits, especially with extreme values, both extreme highs and extreme lows. 2) Box plot and descriptive table of the percentage of change between specific week's merits and the median of weekly merits of previous period. This one is to observe the percentage change, from which can early disclose weeks with abnormal changes of total weekly merits (extremes high or extreme lows, or simply in the range of potential outliers). Something similar to this one: https://bitcointalk.org/index.php?topic=2818350.msg48187605#msg48187605But, I will use data from LoyceV's source, and will do it for more past weeks.
|
|
|
Findings of the last week is normal, nothing abnormal found. Because, the total distributed merits over the last week is 4050, which is in the range of 50% previous period weekly merits, with the median found at 4423, and the interquartile range from 3854 to 5487. I meant for weeks with total merits range from 3.8k to 5.4k, there is no reason to pay attention and dicuss about them, because they obviously have normal distribution of weekly merit. Weekly update My topic in which discusses about daily, weekly, and monthly distributed merits is here: Weekly Analysis:Updated at 19th Nov. 2018: Overview plot and trendGeneral trend has been downward, despite of one spike due to adjustment on rank requirements aims at Junior Member rank. Mean +/- standard deviation; Median (Interquartile range)
Comparison between last week total merits and median of previous period. What I found is: . di (4050-4423)*100/4423 -8.4331901
Last week total merits (at 4050) is 8.4% lower than median weekly merit of previous period, at 4423.
I will update my topic later days with newest data dump from LoyceV.
|
|
|
Those guys are someone who luckily ranked up to higher-ranks in the forum with unintentionally help from old rank requirements, before the start of merit system. They ranked up this way, so it's easily to understand why they have not earned any singly merit around 10 months after the first active day of merit system. I believe that if someday demotion implemented for higher-rank users, most of them will have to fight hopelessly to get at least one more merit (their first own-made merit) to rank up again to their rank before demoted. Some legendary or hero for the same reason don't deserve their rank, also for my point of view I can't find the difference on the "good post history" from earning 500 or 1000 merits, some users are spamming the meta 24/7 only to fish merits.
I remembered that I occasionally read somewhere that there are higher proportion of higher rank users who don't earn at least only one merit point till now. I will find and quote it later.Found it. [Merit Analysis] Users ranked Sr. Member & up that have not earned any meritIt means that 47% Legendary are likely efforlessly Ledgendary, 79.8% adn 73.3% of Senior Members, and Hero are Effortlessly ones, respectively. Detailed statistics given below. Rank | number of users | number of users received at least 1 merit
| number of users with who didn’t earn any merit
| Member | 27 918 | 4 744 (17%) | 23 174 (83%) | Full Member | 18 181 | 3 173 (17,45%) | 15 008 (82,55%) | Sr. Member | 9 016 | 1 818 (20,16%) | 7 198 (79,84%) | Hero Member | 4 143 | 1 105 (26,67%) | 3 038 (73,33%) | Legendary | 2 145 | 1 133 (52,82%) | 1 012 (47,18%) |
|
|
|
Update on daily merit distributions since 24th Jan. 2018.The new box plot looks better after disable displays of outliers in box plot. For full details, please visit the original thread via the link below. ~ Medians displayed via horizontal lines inside boxes, and the plot presents same statistical facts as the table below. In the boxplot, it easily see the small difference of median between full and after merit dataset, which are 652 and 627, respectively. In contrast, the difference between before and after 19th Jan. 2018 is much more significant, with nearly 3.4 times higher for the median daily merits of the period before 19th. Jan. [2154 compared to 627]. ~ * Before: the period of first four weeks after the launch day of merit system (days before 19th Jan. 2018). * After: the period of days since 19th Jan. 2018.
|
|
|
I congratulate you, Coolcryptovator! You are another case study (beside iasenko, who commented above. I actually learned several tips from iasenko, too.), which gives me strong belief that someday I will become a self-made Full Member. I have made some initiatives, gone far distance from the start, and almost reach my dream. Just some days, and not too far from now.
|
|
|
I am not sure, but the following findings maybe partially due to effects of the latest restrictions and tightening requirements on Junior member rank. During the recent 10 weeks, after the start of new tank requirements on Junior members, the weekly merit per post has been on downwards. The figures of peak is 80% higher than the bottom during the period Of course, there is not good causal-inferance here due to lack of more potential bias variables that have not included, such as: - Merit per ranks; - Posts per ranks; - Decreases of new bounties; - And more bias factors. In addition, it is un-clear, but it seems that merit per post tend to increase each four weeks. It is too soon to go to conclusion that there is monthly periodic because only 10 weeks followed in the dataset. We need more weekly data points to have a clearer picture. I would like to disclose one more thing, merit per post during the last 10 weeks. My approach:1) Total weekly merits: Calculated from real data. 2) Total weekly posts (weekposts): Calculated from real data, except the week #2018w37, which is only the assumed median/ mean from the continuous three weeks (2018w35, 2018w36, and 2018w37). I took it from the OP. 3) Merit per post (meritperpost): = round(merit/weekposts,0.001). Real dataset is here: . list, abb(30)
+-------------------------------------------------+ | week merit weekposts id meritperpost | |-------------------------------------------------| 1. | 2018w37 5630 353813 34 .016 | 2. | 2018w38 7825 286408 35 .027 | 3. | 2018w39 4388 280503 36 .016 | 4. | 2018w40 4271 259694 37 .016 | 5. | 2018w41 3800 263685 38 .014 | |-------------------------------------------------| 6. | 2018w42 4821 240339 39 .02 | 7. | 2018w43 3945 240045 40 .016 | 8. | 2018w44 3339 219689 41 .015 | 9. | 2018w45 4513 219774 42 .021 | 10. | 2018w46 1740 215135 43 .008 | +-------------------------------------------------+
Results:Merit per post has fluctuated during the 10-week period, from 0.015 to 0.207 merit per post. The shocking figure found here is that there is 80-percentage difference between the highest and the lowest compared to the lowest. . di (0.027-0.015)*100/0.015 80
The last week (#2018w46) is incomplete one, with only half of the week collected in the dataset. Here is the plot of the ten-week-period merit per post: Notes: It is better if having dataset on different ranks in the forum (for merits, posts), but I unfortunately have not had them so far.
|
|
|
I would like to disclose one more thing, merit per post during the last 10 weeks. My approach:1) Total weekly merits: Calculated from real data. 2) Total weekly posts (weekposts): Calculated from real data, except the week #2018w37, which is only the assumed median/ mean from the continuous three weeks (2018w35, 2018w36, and 2018w37). I took it from the OP. 3) Merit per post (meritperpost): = round(merit/weekposts,0.001). Real dataset is here: . list, abb(30)
+-------------------------------------------------+ | week merit weekposts id meritperpost | |-------------------------------------------------| 1. | 2018w37 5630 353813 34 .016 | 2. | 2018w38 7825 286408 35 .027 | 3. | 2018w39 4388 280503 36 .016 | 4. | 2018w40 4271 259694 37 .016 | 5. | 2018w41 3800 263685 38 .014 | |-------------------------------------------------| 6. | 2018w42 4821 240339 39 .02 | 7. | 2018w43 3945 240045 40 .016 | 8. | 2018w44 3339 219689 41 .015 | 9. | 2018w45 4513 219774 42 .021 | 10. | 2018w46 1740 215135 43 .008 | +-------------------------------------------------+
Results:Merit per post has fluctuated during the 10-week period, from 0.015 to 0.207 merit per post. The shocking figure found here is that there is 80-percentage difference between the highest and the lowest compared to the lowest. . di (0.027-0.015)*100/0.015 80
The last week (#2018w46) is incomplete one, with only half of the week collected in the dataset. Here is the plot of the ten-week-period merit per post: Notes: It is better if having dataset on different ranks in the forum (for merits, posts), but I unfortunately have not had them so far.
|
|
|
Updated the OP with box plots. Today, I added box plots of merit for full dataset, the part of days before 19th Jan. 2018, and the rest part of days since 19th Jan. 2018. Now, let's adjust a little bit to have better box plot. I made small adjustments in order to disable outliers' display in the plot (data used for the plot is still the full one, and no truncation made here). After that, we have a clearer visual box plot on the distributions of merits. Medians displayed via horizontal lines inside boxes, and the plot presents same statistical facts as the table below. In the boxplot, it easily see the small difference of median between full and after merit dataset, which are 652 and 627, respectively. In contrast, the difference between before and after 19th Jan. 2018 is much more significant, with nearly 3.4 times higher for the median daily merits of the period before 19th. Jan. [2154 compared to 627]. Note:I can do the same kind of box plot for distributions of merit over ranks, boards, and other categories.As always, what I need is data. I have not had skills required to retrieve data or scrap data from given raw data. LoyceV proposed dataset given by Piggy. I will try learning more to use the Piggy's dataset.
|
|
|
It requires lots of skills to retrieve and/ or process from raw data. I can't too, but I have plans to learn SQL for my interests. I wanna sort raw data out and get my target variables for analysis. It's better with the approach, rather than waiting for help if someone else. And worthy to spend my time to learn, for future use.
Can you me data on forum posts since 14th December of 2017, please. I will keep find them, but it's great if you already have it. I made a graph based on data in your OP, but I think it might be better if we can have full forum post history (weekly/monthly). Box plotBasic statistics on central tendency of Weekly Newposts presented below: 1) Mean +/- Standard deviation: 247253 +/- 26716 2) Median (Interquartile range): 240339 (219774 - 263685). 3) Min - max: 215135 - 286408. Compared to the median of the previous three weeks, based from @LoyceV resutls (simply asssumed it is the median to make comparision), at 353813; we can easily see the big difference. ---> The Percentage Difference Between Medians of the two period is calculated as: (240339 - 353813)*100/353813 ~ -32.1% (nearly 32% decrease). Time series of Weekly Newposts, since Sep 17 06:27 (Dutch time)In a nutshell, the median of weekly newposts over the recent 9 week since Sep 17 06:27 (Dutch time) has decreased about 32% compared to the 'assumed' median of previous period. 32% decrease in median over the 9-week period is significant impact, in my opinion.
Importanly to note about the 'assumed median' of weekly posts for the period before 17th Sep. It is assumed median because I don't have enough datapoints to get real median.
|
|
|
Reserved for further analytical contents (not sure for now).Finally, I have ideas for the one, which used specifically to make a tracking time-series of Weekly New posts since Sep 17 06:27 (Dutch time), at which the forum admin, Theymos announced the "Enhanced newbie restrictions & requirements" in post 45810047. Original data used for the analysis has been available here, published by LoyceV. Here is dataset, after converted by myself for the analysis, with the assumption that those days fit to calendar days, started from 17th Sep. . list, abb(30)
+----------------------------------+ | week merit weekposts id | |----------------------------------| 1. | 2018w37 5630 353813 34 | 2. | 2018w38 7825 286408 35 | 3. | 2018w39 4388 280503 36 | 4. | 2018w40 4271 259694 37 | 5. | 2018w41 3800 263685 38 | |----------------------------------| 6. | 2018w42 4821 240339 39 | 7. | 2018w43 3945 240045 40 | 8. | 2018w44 3339 219689 41 | 9. | 2018w45 4513 219774 42 | 10. | 2018w46 1740 215135 43 | +----------------------------------+
Results presented here, in the topic made by LoyceV. I made a graph based on data in your OP, but I think it might be better if we can have full forum post history (weekly/monthly). Box plotBasic statistics on central tendency of Weekly Newposts presented below: 1) Mean +/- Standard deviation: 247253 +/- 26716 2) Median (Interquartile range): 240339 (219774 - 263685). 3) Min - max: 215135 - 286408. Compared to the median of the previous three weeks, based from @LoyceV resutls (simply asssumed it is the median to make comparision), at 353813; we can easily see the big difference. ---> The Percentage Difference Between Medians of the two period is calculated as: (240339 - 353813)*100/353813 ~ -32.1% (nearly 32% decrease). Time series of Weekly Newposts, since Sep 17 06:27 (Dutch time)In a nutshell, the median of weekly newposts over the recent 9 week since Sep 17 06:27 (Dutch time) has decreased about 32% compared to the 'assumed' median of previous period. Importanly to note about the 'assumed median' of weekly posts for the period before 17th Sep. It is assumed median because I don't have enough datapoint to get real median. Notes:I will keep the thread updated regularly with help from LoyceV's data dumps.
|
|
|
Dataset, after converted is here: . list id month newtopics newposts newmems, abb(30)
+-----------------------------------------------+ | id month newtopics newposts newmems | |-----------------------------------------------| 1. | 1 2009m11 9 37 4 | 2. | 2 2009m12 6 44 15 | 3. | 3 2010m1 17 102 9 | 4. | 4 2010m2 33 394 25 | 5. | 5 2010m3 26 258 40 | |-----------------------------------------------| 6. | 6 2010m4 30 200 73 | 7. | 7 2010m5 36 280 65 | 8. | 8 2010m6 67 584 55 | 9. | 9 2010m7 429 4968 370 | 10. | 10 2010m8 303 4938 515 | |-----------------------------------------------| 11. | 11 2010m9 364 2978 587 | 12. | 12 2010m10 303 4648 315 | 13. | 13 2010m11 394 6411 374 | 14. | 14 2010m12 532 8840 680 | 15. | 15 2011m1 516 8281 837 | |-----------------------------------------------| 16. | 16 2011m2 902 14094 1379 | 17. | 17 2011m3 1260 19730 2538 | 18. | 18 2011m4 1660 24397 2924 | 19. | 19 2011m5 4034 55331 5959 | 20. | 20 2011m6 12279 152375 14483 | |-----------------------------------------------| 21. | 21 2011m7 6697 107909 5466 | 22. | 22 2011m8 5302 78007 3866 | 23. | 23 2011m9 3225 57585 2452 | 24. | 24 2011m10 2648 49434 2078 | 25. | 25 2011m11 2002 34436 1993 | |-----------------------------------------------| 26. | 26 2011m12 1962 32853 1725 | 27. | 27 2012m1 2921 55861 2051 | 28. | 28 2012m2 2677 51083 1991 | 29. | 29 2012m3 2765 53534 2118 | 30. | 30 2012m4 2504 46647 2072 | |-----------------------------------------------| 31. | 31 2012m5 3692 57525 2018 | 32. | 32 2012m6 4184 67045 2080 | 33. | 33 2012m7 3508 68316 2109 | 34. | 34 2012m8 4505 81790 2395 | 35. | 35 2012m9 4265 83672 2345 | |-----------------------------------------------| 36. | 36 2012m10 3854 75289 3200 | 37. | 37 2012m11 3334 60438 2708 | 38. | 38 2012m12 3302 57992 2766 | 39. | 39 2013m1 4022 66163 3184 | 40. | 40 2013m2 4512 72812 3532 | |-----------------------------------------------| 41. | 41 2013m3 9614 142393 7358 | 42. | 42 2013m4 19141 277862 18712 | 43. | 43 2013m5 19742 344735 15512 | 44. | 44 2013m6 14191 287307 9373 | 45. | 45 2013m7 10814 220391 7413 | |-----------------------------------------------| 46. | 46 2013m8 9919 208365 6052 | 47. | 47 2013m9 9727 217959 5156 | 48. | 48 2013m10 8454 180006 2927 | 49. | 49 2013m11 19251 333103 19683 | 50. | 50 2013m12 25109 453630 31775 | |-----------------------------------------------| 51. | 51 2014m1 27070 620113 26625 | 52. | 52 2014m2 22881 570024 25448 | 53. | 53 2014m3 20928 573478 45800 | 54. | 54 2014m4 15450 473110 17948 | 55. | 55 2014m5 15091 579361 14264 | |-----------------------------------------------| 56. | 56 2014m6 14200 547288 11952 | 57. | 57 2014m7 14470 517814 11119 | 58. | 58 2014m8 15298 489137 11443 | 59. | 59 2014m9 14160 418902 10158 | 60. | 60 2014m10 12092 363300 8332 | |-----------------------------------------------| 61. | 61 2014m11 11053 303707 7996 | 62. | 62 2014m12 11425 294517 8391 | 63. | 63 2015m1 12385 317332 20794 | 64. | 64 2015m2 11808 292022 34357 | 65. | 65 2015m3 13216 330749 38298 | |-----------------------------------------------| 66. | 66 2015m4 12021 302162 8914 | 67. | 67 2015m5 10998 248327 7625 | 68. | 68 2015m6 11769 257628 9310 | 69. | 69 2015m7 12039 262282 12616 | 70. | 70 2015m8 12163 273247 10942 | |-----------------------------------------------| 71. | 71 2015m9 10468 272867 7727 | 72. | 72 2015m10 12526 277609 68832 | 73. | 73 2015m11 14731 269984 44058 | 74. | 74 2015m12 22477 297934 39950 | 75. | 75 2016m1 21854 324306 39178 | |-----------------------------------------------| 76. | 76 2016m2 16622 316374 40436 | 77. | 77 2016m3 19387 327322 24945 | 78. | 78 2016m4 15706 334879 18493 | 79. | 79 2016m5 16037 321836 16918 | 80. | 80 2016m6 16815 388361 20630 | |-----------------------------------------------| 81. | 81 2016m7 12678 345322 11257 | 82. | 82 2016m8 12352 333431 11193 | 83. | 83 2016m9 12277 311745 9923 | 84. | 84 2016m10 12232 320979 9935 | 85. | 85 2016m11 11595 305415 11187 | |-----------------------------------------------| 86. | 86 2016m12 12179 315340 11199 | 87. | 87 2017m1 13452 330242 13354 | 88. | 88 2017m2 13001 327436 12677 | 89. | 89 2017m3 17381 391524 14760 | 90. | 90 2017m4 18200 405690 15807 | |-----------------------------------------------| 91. | 91 2017m5 22759 483854 23978 | 92. | 92 2017m6 23179 567436 32733 | 93. | 93 2017m7 25013 654076 41011 | 94. | 94 2017m8 25998 869899 42253 | 95. | 95 2017m9 27470 1.0e+06 46186 | |-----------------------------------------------| 96. | 96 2017m10 35572 1.4e+06 89443 | 97. | 97 2017m11 41651 1.7e+06 97286 | 98. | 98 2017m12 21168 752589 63756 | +-----------------------------------------------+
.
Will update later if I find additional monthly data points.
|
|
|
TIME SERIES ON MONTHLY STATISTICS OF FORUM (NEW USERS, NEW TOPICS, NEW POSTS) Hello all, Today, I would like to show you the time series plots of several basic statistics of the bitcointalk forum. These observed variables are: 1) New members; 2) New topics; 3) New posts. DataOriginal dataAll of them have been tracked on monthly basis, since November of 2009 to December of 2017. Note that the data on months in December of 2017 is incomple, with only the first two months given by forum's stats [Stopped since 14th December of 2017]. Since that point, the forum has stopped giving away these statisitics, so I have not get later months for now. I will try searching to find available data of those months, and update the OP later. There is one similar topic ( 100 Days of Merit), published by zentdex, but it has been abandoned for months. Converted dataset is there Plots1) New members and new topicsA quick overview. It seems that monthly statistics on new members and new topics tend to hit peaks each two-year period. 2) New posts Further analysisWill be released soon. Notes:The topic has still been under construction.
|
|
|
Data sources1) Original data set (by LoyceV) Please get it here. Day 1: 13018 Merit Day 2: 6761 Merit Day 3: 4493 Merit Day 4: 3489 Merit Day 5: 3188 Merit Day 6: 3799 Merit Day 7: 4192 Merit Day 8: 2820 Merit Day 9: 2545 Merit Day 10: 2568 Merit Day 11: 1867 Merit Day 12: 2167 Merit Day 13: 2077 Merit Day 14: 2308 Merit Day 15: 2141 Merit Day 16: 2141 Merit Day 17: 1448 Merit Day 18: 1747 Merit Day 19: 1442 Merit Day 20: 1331 Merit Day 21: 1579 Merit Day 22: 2513 Merit Day 23: 1991 Merit Day 24: 1411 Merit Day 25: 1608 Merit Day 26: 1289 Merit Day 27: 1403 Merit Day 28: 1169 Merit Day 29: 1266 Merit Day 30: 1279 Merit Day 31: 1046 Merit Day 32: 1409 Merit Day 33: 1186 Merit Day 34: 1382 Merit Day 35: 1326 Merit Day 36: 991 Merit Day 37: 1333 Merit Day 38: 1696 Merit Day 39: 1089 Merit Day 40: 989 Merit Day 41: 1245 Merit Day 42: 1074 Merit Day 43: 1109 Merit Day 44: 922 Merit Day 45: 789 Merit Day 46: 1023 Merit Day 47: 1091 Merit Day 48: 1354 Merit Day 49: 994 Merit Day 50: 1159 Merit Day 51: 1130 Merit Day 52: 840 Merit Day 53: 797 Merit Day 54: 1035 Merit Day 55: 992 Merit Day 56: 1322 Merit Day 57: 1227 Merit Day 58: 764 Merit Day 59: 733 Merit Day 60: 1045 Merit Day 61: 858 Merit Day 62: 808 Merit Day 63: 879 Merit Day 64: 848 Merit Day 65: 1043 Merit Day 66: 928 Merit Day 67: 968 Merit Day 68: 1233 Merit Day 69: 1146 Merit Day 70: 1080 Merit Day 71: 1061 Merit Day 72: 838 Merit Day 73: 620 Merit Day 74: 614 Merit Day 75: 1056 Merit Day 76: 884 Merit Day 77: 768 Merit Day 78: 963 Merit Day 79: 917 Merit Day 80: 682 Merit Day 81: 681 Merit Day 82: 592 Merit Day 83: 609 Merit Day 84: 628 Merit Day 85: 681 Merit Day 86: 848 Merit Day 87: 563 Merit Day 88: 522 Merit Day 89: 880 Merit Day 90: 709 Merit Day 91: 626 Merit Day 92: 687 Merit Day 93: 675 Merit Day 94: 583 Merit Day 95: 623 Merit Day 96: 682 Merit Day 97: 822 Merit Day 98: 741 Merit Day 99: 759 Merit Day 100: 747 Merit Day 101: 597 Merit Day 102: 688 Merit Day 103: 599 Merit Day 104: 898 Merit Day 105: 618 Merit Day 106: 761 Merit Day 107: 475 Merit Day 108: 867 Merit Day 109: 415 Merit Day 110: 719 Merit Day 111: 674 Merit Day 112: 700 Merit Day 113: 652 Merit Day 114: 574 Merit Day 115: 542 Merit Day 116: 587 Merit Day 117: 617 Merit Day 118: 626 Merit Day 119: 639 Merit Day 120: 531 Merit Day 121: 554 Merit Day 122: 370 Merit Day 123: 575 Merit Day 124: 559 Merit Day 125: 589 Merit Day 126: 638 Merit Day 127: 599 Merit Day 128: 687 Merit Day 129: 698 Merit Day 130: 461 Merit Day 131: 511 Merit Day 132: 773 Merit Day 133: 731 Merit Day 134: 504 Merit Day 135: 506 Merit Day 136: 766 Merit Day 137: 672 Merit Day 138: 575 Merit Day 139: 519 Merit Day 140: 422 Merit Day 141: 786 Merit Day 142: 528 Merit Day 143: 445 Merit Day 144: 654 Merit Day 145: 464 Merit Day 146: 601 Merit Day 147: 662 Merit Day 148: 707 Merit Day 149: 705 Merit Day 150: 774 Merit Day 151: 643 Merit Day 152: 829 Merit Day 153: 1138 Merit Day 154: 435 Merit Day 155: 516 Merit Day 156: 470 Merit Day 157: 479 Merit Day 158: 778 Merit Day 159: 641 Merit Day 160: 711 Merit Day 161: 902 Merit Day 162: 557 Merit Day 163: 577 Merit Day 164: 475 Merit Day 165: 506 Merit Day 166: 525 Merit Day 167: 455 Merit Day 168: 620 Merit Day 169: 555 Merit Day 170: 644 Merit Day 171: 542 Merit Day 172: 627 Merit Day 173: 796 Merit Day 174: 636 Merit Day 175: 641 Merit Day 176: 608 Merit Day 177: 554 Merit Day 178: 606 Merit Day 179: 567 Merit Day 180: 547 Merit Day 181: 684 Merit Day 182: 444 Merit Day 183: 492 Merit Day 184: 673 Merit Day 185: 521 Merit Day 186: 418 Merit Day 187: 420 Merit Day 188: 471 Merit Day 189: 632 Merit Day 190: 435 Merit Day 191: 376 Merit Day 192: 421 Merit Day 193: 695 Merit Day 194: 768 Merit Day 195: 595 Merit Day 196: 610 Merit Day 197: 647 Merit Day 198: 471 Merit Day 199: 567 Merit Day 200: 517 Merit Day 201: 587 Merit Day 202: 513 Merit Day 203: 565 Merit Day 204: 626 Merit Day 205: 470 Merit Day 206: 451 Merit Day 207: 561 Merit Day 208: 432 Merit Day 209: 658 Merit Day 210: 600 Merit Day 211: 612 Merit Day 212: 530 Merit Day 213: 528 Merit Day 214: 385 Merit Day 215: 476 Merit Day 216: 457 Merit Day 217: 383 Merit Day 218: 488 Merit Day 219: 514 Merit Day 220: 379 Merit Day 221: 432 Merit Day 222: 412 Merit Day 223: 536 Merit Day 224: 567 Merit Day 225: 654 Merit Day 226: 509 Merit Day 227: 458 Merit Day 228: 395 Merit Day 229: 455 Merit Day 230: 472 Merit Day 231: 580 Merit Day 232: 595 Merit Day 233: 540 Merit Day 234: 517 Merit Day 235: 463 Merit Day 236: 2463 Merit Day 237: 1862 Merit Day 238: 1294 Merit Day 239: 1268 Merit Day 240: 846 Merit Day 241: 807 Merit Day 242: 944 Merit Day 243: 804 Merit Day 244: 749 Merit Day 245: 596 Merit Day 246: 562 Merit Day 247: 675 Merit Day 248: 518 Merit Day 249: 669 Merit Day 250: 619 Merit Day 251: 509 Merit Day 252: 760 Merit Day 253: 705 Merit Day 254: 521 Merit Day 255: 513 Merit Day 256: 660 Merit Day 257: 603 Merit Day 258: 678 Merit Day 259: 578 Merit Day 260: 639 Merit Day 261: 616 Merit Day 262: 399 Merit Day 263: 460 Merit Day 264: 430 Merit Day 265: 655 Merit Day 266: 626 Merit Day 267: 732 Merit Day 268: 774 Merit Day 269: 643 Merit Day 270: 538 Merit Day 271: 853 Merit Day 272: 694 Merit Day 273: 674 Merit Day 274: 759 Merit Day 275: 553 Merit Day 276: 424 Merit Day 277: 426 Merit Day 278: 415 Merit Day 279: 534 Merit Day 280: 529 Merit Day 281: 495 Merit Day 282: 433 Merit Day 283: 454 Merit Day 284: 430 Merit Day 285: 464 Merit Day 286: 562 Merit Day 287: 405 Merit Day 288: 691 Merit Day 289: 843 Merit Day 290: 536 Merit Day 291: 688 Merit Day 292: 788 Merit Day 293: 591 Merit Day 294: 580 Merit Day 295: 569 Merit Day 296: 106 Merit (incomplete day)
Datasets used in my analysis was taken from LoyceV source. 2) Fully converted dataset (made by myself):Details about date time format in my converted dataset explains clearly at the bottom of the OP. +-------------------------------------------------------------------+ | id day month2 year merit date week month | |-------------------------------------------------------------------| 1. | 1 24 1 2018 13018 24jan2018 2018w4 2018m1 | 2. | 2 25 1 2018 6761 25jan2018 2018w4 2018m1 | 3. | 3 26 1 2018 4493 26jan2018 2018w4 2018m1 | 4. | 4 27 1 2018 3489 27jan2018 2018w4 2018m1 | 5. | 5 28 1 2018 3188 28jan2018 2018w4 2018m1 | |-------------------------------------------------------------------| 6. | 6 29 1 2018 3799 29jan2018 2018w5 2018m1 | 7. | 7 30 1 2018 4192 30jan2018 2018w5 2018m1 | 8. | 8 31 1 2018 2820 31jan2018 2018w5 2018m1 | 9. | 9 1 2 2018 2545 01feb2018 2018w5 2018m2 | 10. | 10 2 2 2018 2568 02feb2018 2018w5 2018m2 | |-------------------------------------------------------------------| 11. | 11 3 2 2018 1867 03feb2018 2018w5 2018m2 | 12. | 12 4 2 2018 2167 04feb2018 2018w5 2018m2 | 13. | 13 5 2 2018 2077 05feb2018 2018w6 2018m2 | 14. | 14 6 2 2018 2308 06feb2018 2018w6 2018m2 | 15. | 15 7 2 2018 2141 07feb2018 2018w6 2018m2 | |-------------------------------------------------------------------| 16. | 16 8 2 2018 2141 08feb2018 2018w6 2018m2 | 17. | 17 9 2 2018 1448 09feb2018 2018w6 2018m2 | 18. | 18 10 2 2018 1747 10feb2018 2018w6 2018m2 | 19. | 19 11 2 2018 1442 11feb2018 2018w6 2018m2 | 20. | 20 12 2 2018 1331 12feb2018 2018w7 2018m2 | |-------------------------------------------------------------------| 21. | 21 13 2 2018 1579 13feb2018 2018w7 2018m2 | 22. | 22 14 2 2018 2513 14feb2018 2018w7 2018m2 | 23. | 23 15 2 2018 1991 15feb2018 2018w7 2018m2 | 24. | 24 16 2 2018 1411 16feb2018 2018w7 2018m2 | 25. | 25 17 2 2018 1608 17feb2018 2018w7 2018m2 | |-------------------------------------------------------------------| 26. | 26 18 2 2018 1289 18feb2018 2018w7 2018m2 | 27. | 27 19 2 2018 1403 19feb2018 2018w8 2018m2 | 28. | 28 20 2 2018 1169 20feb2018 2018w8 2018m2 | 29. | 29 21 2 2018 1266 21feb2018 2018w8 2018m2 | 30. | 30 22 2 2018 1279 22feb2018 2018w8 2018m2 | |-------------------------------------------------------------------| 31. | 31 23 2 2018 1046 23feb2018 2018w8 2018m2 | 32. | 32 24 2 2018 1409 24feb2018 2018w8 2018m2 | 33. | 33 25 2 2018 1186 25feb2018 2018w8 2018m2 | 34. | 34 26 2 2018 1382 26feb2018 2018w9 2018m2 | 35. | 35 27 2 2018 1326 27feb2018 2018w9 2018m2 | |-------------------------------------------------------------------| 36. | 36 28 2 2018 991 28feb2018 2018w9 2018m2 | 37. | 37 1 3 2018 1333 01mar2018 2018w9 2018m3 | 38. | 38 2 3 2018 1696 02mar2018 2018w9 2018m3 | 39. | 39 3 3 2018 1089 03mar2018 2018w9 2018m3 | 40. | 40 4 3 2018 989 04mar2018 2018w9 2018m3 | |-------------------------------------------------------------------| 41. | 41 5 3 2018 1245 05mar2018 2018w10 2018m3 | 42. | 42 6 3 2018 1074 06mar2018 2018w10 2018m3 | 43. | 43 7 3 2018 1109 07mar2018 2018w10 2018m3 | 44. | 44 8 3 2018 922 08mar2018 2018w10 2018m3 | 45. | 45 9 3 2018 789 09mar2018 2018w10 2018m3 | |-------------------------------------------------------------------| 46. | 46 10 3 2018 1023 10mar2018 2018w10 2018m3 | 47. | 47 11 3 2018 1091 11mar2018 2018w10 2018m3 | 48. | 48 12 3 2018 1354 12mar2018 2018w11 2018m3 | 49. | 49 13 3 2018 994 13mar2018 2018w11 2018m3 | 50. | 50 14 3 2018 1159 14mar2018 2018w11 2018m3 | |-------------------------------------------------------------------| 51. | 51 15 3 2018 1130 15mar2018 2018w11 2018m3 | 52. | 52 16 3 2018 840 16mar2018 2018w11 2018m3 | 53. | 53 17 3 2018 797 17mar2018 2018w11 2018m3 | 54. | 54 18 3 2018 1035 18mar2018 2018w11 2018m3 | 55. | 55 19 3 2018 992 19mar2018 2018w12 2018m3 | |-------------------------------------------------------------------| 56. | 56 20 3 2018 1322 20mar2018 2018w12 2018m3 | 57. | 57 21 3 2018 1227 21mar2018 2018w12 2018m3 | 58. | 58 22 3 2018 764 22mar2018 2018w12 2018m3 | 59. | 59 23 3 2018 733 23mar2018 2018w12 2018m3 | 60. | 60 24 3 2018 1045 24mar2018 2018w12 2018m3 | |-------------------------------------------------------------------| 61. | 61 25 3 2018 858 25mar2018 2018w12 2018m3 | 62. | 62 26 3 2018 808 26mar2018 2018w13 2018m3 | 63. | 63 27 3 2018 879 27mar2018 2018w13 2018m3 | 64. | 64 28 3 2018 848 28mar2018 2018w13 2018m3 | 65. | 65 29 3 2018 1043 29mar2018 2018w13 2018m3 | |-------------------------------------------------------------------| 66. | 66 30 3 2018 928 30mar2018 2018w13 2018m3 | 67. | 67 31 3 2018 968 31mar2018 2018w13 2018m3 | 68. | 68 1 4 2018 1233 01apr2018 2018w13 2018m4 | 69. | 69 2 4 2018 1146 02apr2018 2018w14 2018m4 | 70. | 70 3 4 2018 1080 03apr2018 2018w14 2018m4 | |-------------------------------------------------------------------| 71. | 71 4 4 2018 1061 04apr2018 2018w14 2018m4 | 72. | 72 5 4 2018 838 05apr2018 2018w14 2018m4 | 73. | 73 6 4 2018 620 06apr2018 2018w14 2018m4 | 74. | 74 7 4 2018 614 07apr2018 2018w14 2018m4 | 75. | 75 8 4 2018 1056 08apr2018 2018w14 2018m4 | |-------------------------------------------------------------------| 76. | 76 9 4 2018 884 09apr2018 2018w15 2018m4 | 77. | 77 10 4 2018 768 10apr2018 2018w15 2018m4 | 78. | 78 11 4 2018 963 11apr2018 2018w15 2018m4 | 79. | 79 12 4 2018 917 12apr2018 2018w15 2018m4 | 80. | 80 13 4 2018 682 13apr2018 2018w15 2018m4 | |-------------------------------------------------------------------| 81. | 81 14 4 2018 681 14apr2018 2018w15 2018m4 | 82. | 82 15 4 2018 592 15apr2018 2018w15 2018m4 | 83. | 83 16 4 2018 609 16apr2018 2018w16 2018m4 | 84. | 84 17 4 2018 628 17apr2018 2018w16 2018m4 | 85. | 85 18 4 2018 681 18apr2018 2018w16 2018m4 | |-------------------------------------------------------------------| 86. | 86 19 4 2018 848 19apr2018 2018w16 2018m4 | 87. | 87 20 4 2018 463 20apr2018 2018w16 2018m4 | 88. | 88 21 4 2018 522 21apr2018 2018w16 2018m4 | 89. | 89 22 4 2018 880 22apr2018 2018w16 2018m4 | 90. | 90 23 4 2018 709 23apr2018 2018w17 2018m4 | |-------------------------------------------------------------------| 91. | 91 24 4 2018 626 24apr2018 2018w17 2018m4 | 92. | 92 25 4 2018 687 25apr2018 2018w17 2018m4 | 93. | 93 26 4 2018 675 26apr2018 2018w17 2018m4 | 94. | 94 27 4 2018 583 27apr2018 2018w17 2018m4 | 95. | 95 28 4 2018 623 28apr2018 2018w17 2018m4 | |-------------------------------------------------------------------| 96. | 96 29 4 2018 682 29apr2018 2018w17 2018m4 | 97. | 97 30 4 2018 822 30apr2018 2018w18 2018m4 | 98. | 98 1 5 2018 741 01may2018 2018w18 2018m5 | 99. | 99 2 5 2018 759 02may2018 2018w18 2018m5 | 100. | 100 3 5 2018 747 03may2018 2018w18 2018m5 | |-------------------------------------------------------------------| 101. | 101 4 5 2018 597 04may2018 2018w18 2018m5 | 102. | 102 5 5 2018 688 05may2018 2018w18 2018m5 | 103. | 103 6 5 2018 599 06may2018 2018w18 2018m5 | 104. | 104 7 5 2018 898 07may2018 2018w19 2018m5 | 105. | 105 8 5 2018 618 08may2018 2018w19 2018m5 | |-------------------------------------------------------------------| 106. | 106 9 5 2018 761 09may2018 2018w19 2018m5 | 107. | 107 10 5 2018 475 10may2018 2018w19 2018m5 | 108. | 108 11 5 2018 867 11may2018 2018w19 2018m5 | 109. | 109 12 5 2018 415 12may2018 2018w19 2018m5 | 110. | 110 13 5 2018 719 13may2018 2018w19 2018m5 | |-------------------------------------------------------------------| 111. | 111 14 5 2018 674 14may2018 2018w20 2018m5 | 112. | 112 15 5 2018 700 15may2018 2018w20 2018m5 | 113. | 113 16 5 2018 652 16may2018 2018w20 2018m5 | 114. | 114 17 5 2018 574 17may2018 2018w20 2018m5 | 115. | 115 18 5 2018 542 18may2018 2018w20 2018m5 | |-------------------------------------------------------------------| 116. | 116 19 5 2018 587 19may2018 2018w20 2018m5 | 117. | 117 20 5 2018 617 20may2018 2018w20 2018m5 | 118. | 118 21 5 2018 626 21may2018 2018w21 2018m5 | 119. | 119 22 5 2018 639 22may2018 2018w21 2018m5 | 120. | 120 23 5 2018 531 23may2018 2018w21 2018m5 | |-------------------------------------------------------------------| 121. | 121 24 5 2018 554 24may2018 2018w21 2018m5 | 122. | 122 25 5 2018 370 25may2018 2018w21 2018m5 | 123. | 123 26 5 2018 575 26may2018 2018w21 2018m5 | 124. | 124 27 5 2018 559 27may2018 2018w21 2018m5 | 125. | 125 28 5 2018 589 28may2018 2018w22 2018m5 | |-------------------------------------------------------------------| 126. | 126 29 5 2018 638 29may2018 2018w22 2018m5 | 127. | 127 30 5 2018 599 30may2018 2018w22 2018m5 | 128. | 128 31 5 2018 687 31may2018 2018w22 2018m5 | 129. | 129 1 6 2018 698 01jun2018 2018w22 2018m6 | 130. | 130 2 6 2018 461 02jun2018 2018w22 2018m6 | |-------------------------------------------------------------------| 131. | 131 3 6 2018 511 03jun2018 2018w22 2018m6 | 132. | 132 4 6 2018 773 04jun2018 2018w23 2018m6 | 133. | 133 5 6 2018 731 05jun2018 2018w23 2018m6 | 134. | 134 6 6 2018 504 06jun2018 2018w23 2018m6 | 135. | 135 7 6 2018 506 07jun2018 2018w23 2018m6 | |-------------------------------------------------------------------| 136. | 136 8 6 2018 766 08jun2018 2018w23 2018m6 | 137. | 137 9 6 2018 672 09jun2018 2018w23 2018m6 | 138. | 138 10 6 2018 575 10jun2018 2018w23 2018m6 | 139. | 139 11 6 2018 519 11jun2018 2018w24 2018m6 | 140. | 140 12 6 2018 422 12jun2018 2018w24 2018m6 | |-------------------------------------------------------------------| 141. | 141 13 6 2018 786 13jun2018 2018w24 2018m6 | 142. | 142 14 6 2018 528 14jun2018 2018w24 2018m6 | 143. | 143 15 6 2018 445 15jun2018 2018w24 2018m6 | 144. | 144 16 6 2018 654 16jun2018 2018w24 2018m6 | 145. | 145 17 6 2018 464 17jun2018 2018w24 2018m6 | |-------------------------------------------------------------------| 146. | 146 18 6 2018 601 18jun2018 2018w25 2018m6 | 147. | 147 19 6 2018 662 19jun2018 2018w25 2018m6 | 148. | 148 20 6 2018 707 20jun2018 2018w25 2018m6 | 149. | 149 21 6 2018 705 21jun2018 2018w25 2018m6 | 150. | 150 22 6 2018 774 22jun2018 2018w25 2018m6 | |-------------------------------------------------------------------| 151. | 151 23 6 2018 643 23jun2018 2018w25 2018m6 | 152. | 152 24 6 2018 829 24jun2018 2018w25 2018m6 | 153. | 153 25 6 2018 1138 25jun2018 2018w26 2018m6 | 154. | 154 26 6 2018 435 26jun2018 2018w26 2018m6 | 155. | 155 27 6 2018 516 27jun2018 2018w26 2018m6 | |-------------------------------------------------------------------| 156. | 156 28 6 2018 470 28jun2018 2018w26 2018m6 | 157. | 157 29 6 2018 479 29jun2018 2018w26 2018m6 | 158. | 158 30 6 2018 778 30jun2018 2018w26 2018m6 | 159. | 159 1 7 2018 641 01jul2018 2018w26 2018m7 | 160. | 160 2 7 2018 711 02jul2018 2018w27 2018m7 | |-------------------------------------------------------------------| 161. | 161 3 7 2018 902 03jul2018 2018w27 2018m7 | 162. | 162 4 7 2018 557 04jul2018 2018w27 2018m7 | 163. | 163 5 7 2018 577 05jul2018 2018w27 2018m7 | 164. | 164 6 7 2018 475 06jul2018 2018w27 2018m7 | 165. | 165 7 7 2018 506 07jul2018 2018w27 2018m7 | |-------------------------------------------------------------------| 166. | 166 8 7 2018 525 08jul2018 2018w27 2018m7 | 167. | 167 9 7 2018 455 09jul2018 2018w28 2018m7 | 168. | 168 10 7 2018 620 10jul2018 2018w28 2018m7 | 169. | 169 11 7 2018 555 11jul2018 2018w28 2018m7 | 170. | 170 12 7 2018 644 12jul2018 2018w28 2018m7 | |-------------------------------------------------------------------| 171. | 171 13 7 2018 542 13jul2018 2018w28 2018m7 | 172. | 172 14 7 2018 627 14jul2018 2018w28 2018m7 | 173. | 173 15 7 2018 796 15jul2018 2018w28 2018m7 | 174. | 174 16 7 2018 636 16jul2018 2018w29 2018m7 | 175. | 175 17 7 2018 641 17jul2018 2018w29 2018m7 | |-------------------------------------------------------------------| 176. | 176 18 7 2018 608 18jul2018 2018w29 2018m7 | 177. | 177 19 7 2018 554 19jul2018 2018w29 2018m7 | 178. | 178 20 7 2018 606 20jul2018 2018w29 2018m7 | 179. | 179 21 7 2018 567 21jul2018 2018w29 2018m7 | 180. | 180 22 7 2018 547 22jul2018 2018w29 2018m7 | |-------------------------------------------------------------------| 181. | 181 23 7 2018 684 23jul2018 2018w30 2018m7 | 182. | 182 24 7 2018 444 24jul2018 2018w30 2018m7 | 183. | 183 25 7 2018 492 25jul2018 2018w30 2018m7 | 184. | 184 26 7 2018 673 26jul2018 2018w30 2018m7 | 185. | 185 27 7 2018 521 27jul2018 2018w30 2018m7 | |-------------------------------------------------------------------| 186. | 186 28 7 2018 418 28jul2018 2018w30 2018m7 | 187. | 187 29 7 2018 420 29jul2018 2018w30 2018m7 | 188. | 188 30 7 2018 471 30jul2018 2018w31 2018m7 | 189. | 189 31 7 2018 632 31jul2018 2018w31 2018m7 | 190. | 190 1 8 2018 435 01aug2018 2018w31 2018m8 | |-------------------------------------------------------------------| 191. | 191 2 8 2018 376 02aug2018 2018w31 2018m8 | 192. | 192 3 8 2018 421 03aug2018 2018w31 2018m8 | 193. | 193 4 8 2018 695 04aug2018 2018w31 2018m8 | 194. | 194 5 8 2018 768 05aug2018 2018w31 2018m8 | 195. | 195 6 8 2018 595 06aug2018 2018w32 2018m8 | |-------------------------------------------------------------------| 196. | 196 7 8 2018 610 07aug2018 2018w32 2018m8 | 197. | 197 8 8 2018 647 08aug2018 2018w32 2018m8 | 198. | 198 9 8 2018 471 09aug2018 2018w32 2018m8 | 199. | 199 10 8 2018 567 10aug2018 2018w32 2018m8 | 200. | 200 11 8 2018 517 11aug2018 2018w32 2018m8 | |-------------------------------------------------------------------| 201. | 201 12 8 2018 587 12aug2018 2018w32 2018m8 | 202. | 202 13 8 2018 513 13aug2018 2018w33 2018m8 | 203. | 203 14 8 2018 565 14aug2018 2018w33 2018m8 | 204. | 204 15 8 2018 626 15aug2018 2018w33 2018m8 | 205. | 205 16 8 2018 470 16aug2018 2018w33 2018m8 | |-------------------------------------------------------------------| 206. | 206 17 8 2018 451 17aug2018 2018w33 2018m8 | 207. | 207 18 8 2018 561 18aug2018 2018w33 2018m8 | 208. | 208 19 8 2018 432 19aug2018 2018w33 2018m8 | 209. | 209 20 8 2018 658 20aug2018 2018w34 2018m8 | 210. | 210 21 8 2018 600 21aug2018 2018w34 2018m8 | |-------------------------------------------------------------------| 211. | 211 22 8 2018 612 22aug2018 2018w34 2018m8 | 212. | 212 23 8 2018 530 23aug2018 2018w34 2018m8 | 213. | 213 24 8 2018 528 24aug2018 2018w34 2018m8 | 214. | 214 25 8 2018 385 25aug2018 2018w34 2018m8 | 215. | 215 26 8 2018 476 26aug2018 2018w34 2018m8 | |-------------------------------------------------------------------| 216. | 216 27 8 2018 457 27aug2018 2018w35 2018m8 | 217. | 217 28 8 2018 383 28aug2018 2018w35 2018m8 | 218. | 218 29 8 2018 488 29aug2018 2018w35 2018m8 | 219. | 219 30 8 2018 514 30aug2018 2018w35 2018m8 | 220. | 220 31 8 2018 379 31aug2018 2018w35 2018m8 | |-------------------------------------------------------------------| 221. | 221 1 9 2018 432 01sep2018 2018w35 2018m9 | 222. | 222 2 9 2018 412 02sep2018 2018w35 2018m9 | 223. | 223 3 9 2018 536 03sep2018 2018w36 2018m9 | 224. | 224 4 9 2018 567 04sep2018 2018w36 2018m9 | 225. | 225 5 9 2018 654 05sep2018 2018w36 2018m9 | |-------------------------------------------------------------------| 226. | 226 6 9 2018 509 06sep2018 2018w36 2018m9 | 227. | 227 7 9 2018 458 07sep2018 2018w36 2018m9 | 228. | 228 8 9 2018 395 08sep2018 2018w36 2018m9 | 229. | 229 9 9 2018 455 09sep2018 2018w36 2018m9 | 230. | 230 10 9 2018 472 10sep2018 2018w37 2018m9 | |-------------------------------------------------------------------| 231. | 231 11 9 2018 580 11sep2018 2018w37 2018m9 | 232. | 232 12 9 2018 595 12sep2018 2018w37 2018m9 | 233. | 233 13 9 2018 540 13sep2018 2018w37 2018m9 | 234. | 234 14 9 2018 517 14sep2018 2018w37 2018m9 | 235. | 235 15 9 2018 463 15sep2018 2018w37 2018m9 | |-------------------------------------------------------------------| 236. | 236 16 9 2018 2463 16sep2018 2018w37 2018m9 | 237. | 237 17 9 2018 1862 17sep2018 2018w38 2018m9 | 238. | 238 18 9 2018 1294 18sep2018 2018w38 2018m9 | 239. | 239 19 9 2018 1268 19sep2018 2018w38 2018m9 | 240. | 240 20 9 2018 846 20sep2018 2018w38 2018m9 | |-------------------------------------------------------------------| 241. | 241 21 9 2018 807 21sep2018 2018w38 2018m9 | 242. | 242 22 9 2018 944 22sep2018 2018w38 2018m9 | 243. | 243 23 9 2018 804 23sep2018 2018w38 2018m9 | 244. | 244 24 9 2018 749 24sep2018 2018w39 2018m9 | 245. | 245 25 9 2018 596 25sep2018 2018w39 2018m9 | |-------------------------------------------------------------------| 246. | 246 26 9 2018 562 26sep2018 2018w39 2018m9 | 247. | 247 27 9 2018 675 27sep2018 2018w39 2018m9 | 248. | 248 28 9 2018 518 28sep2018 2018w39 2018m9 | 249. | 249 29 9 2018 669 29sep2018 2018w39 2018m9 | 250. | 250 30 9 2018 619 30sep2018 2018w39 2018m9 | |-------------------------------------------------------------------| 251. | 251 1 10 2018 509 01oct2018 2018w40 2018m10 | 252. | 252 2 10 2018 760 02oct2018 2018w40 2018m10 | 253. | 253 3 10 2018 705 03oct2018 2018w40 2018m10 | 254. | 254 4 10 2018 521 04oct2018 2018w40 2018m10 | 255. | 255 5 10 2018 513 05oct2018 2018w40 2018m10 | |-------------------------------------------------------------------| 256. | 256 6 10 2018 660 06oct2018 2018w40 2018m10 | 257. | 257 7 10 2018 603 07oct2018 2018w40 2018m10 | 258. | 258 8 10 2018 678 08oct2018 2018w41 2018m10 | 259. | 259 9 10 2018 578 09oct2018 2018w41 2018m10 | 260. | 260 10 10 2018 639 10oct2018 2018w41 2018m10 | |-------------------------------------------------------------------| 261. | 261 11 10 2018 616 11oct2018 2018w41 2018m10 | 262. | 262 12 10 2018 399 12oct2018 2018w41 2018m10 | 263. | 263 13 10 2018 460 13oct2018 2018w41 2018m10 | 264. | 264 14 10 2018 430 14oct2018 2018w41 2018m10 | 265. | 265 15 10 2018 655 15oct2018 2018w42 2018m10 | |-------------------------------------------------------------------| 266. | 266 16 10 2018 626 16oct2018 2018w42 2018m10 | 267. | 267 17 10 2018 732 17oct2018 2018w42 2018m10 | 268. | 268 18 10 2018 774 18oct2018 2018w42 2018m10 | 269. | 269 19 10 2018 643 19oct2018 2018w42 2018m10 | 270. | 270 20 10 2018 538 20oct2018 2018w42 2018m10 | |-------------------------------------------------------------------| 271. | 271 21 10 2018 853 21oct2018 2018w42 2018m10 | 272. | 272 22 10 2018 694 22oct2018 2018w43 2018m10 | 273. | 273 23 10 2018 674 23oct2018 2018w43 2018m10 | 274. | 274 24 10 2018 759 24oct2018 2018w43 2018m10 | 275. | 275 25 10 2018 553 25oct2018 2018w43 2018m10 | |-------------------------------------------------------------------| 276. | 276 26 10 2018 424 26oct2018 2018w43 2018m10 | 277. | 277 27 10 2018 426 27oct2018 2018w43 2018m10 | 278. | 278 28 10 2018 415 28oct2018 2018w43 2018m10 | 279. | 279 29 10 2018 534 29oct2018 2018w44 2018m10 | 280. | 280 30 10 2018 529 30oct2018 2018w44 2018m10 | |-------------------------------------------------------------------| 281. | 281 31 10 2018 495 31oct2018 2018w44 2018m10 | 282. | 282 1 11 2018 433 01nov2018 2018w44 2018m11 | 283. | 283 2 11 2018 454 02nov2018 2018w44 2018m11 | 284. | 284 3 11 2018 430 03nov2018 2018w44 2018m11 | 285. | 285 4 11 2018 464 04nov2018 2018w44 2018m11 | |-------------------------------------------------------------------| 286. | 286 5 11 2018 562 05nov2018 2018w45 2018m11 | 287. | 287 6 11 2018 405 06nov2018 2018w45 2018m11 | 288. | 288 7 11 2018 691 07nov2018 2018w45 2018m11 | 289. | 289 8 11 2018 843 08nov2018 2018w45 2018m11 | 290. | 290 9 11 2018 536 09nov2018 2018w45 2018m11 | |-------------------------------------------------------------------| 291. | 291 10 11 2018 688 10nov2018 2018w45 2018m11 | 292. | 292 11 11 2018 788 11nov2018 2018w45 2018m11 | 293. | 293 12 11 2018 591 12nov2018 2018w46 2018m11 | 294. | 294 13 11 2018 580 13nov2018 2018w46 2018m11 | 295. | 295 14 11 2018 569 14nov2018 2018w46 2018m11 | +-------------------------------------------------------------------+
.
|
|
|
It's true. In modern society, people will be lack of self-learn abilities if they don't have good English skills, especially reading and writing. Reading to find and read, then comprehend information they read; writing is especially essential to express ideas for asking for help, for joining discussions, for help others, etc. English is a very widely recognised and accepted language it's use in most officially activities regardless of the number of different countries involved and bitcointalk forum I feel is not an exception to that.
Someone who have not had good English skills, it's time to start improving and sharpening their English skills, right? Sorry, I am non-native English speaker. Also the very enlightened member mostly communicate in English although some of them are from other countries but they command good English and can only help there own local board and the English section (normal forum language) this can deprive others of there immense contributions.
By the way, I give you and others who have interests in improving their English skills a helpful topic. ENGLISH COLLECTIONS(by tbct_mt2)
|
|
|
Updated the OP, weekly, and monthly analyses, with more interesting findings, including the following table. Daily meritsThe median of daily merits of the period before 19th Feb. 2018 is 3.4 times higher than as of the period since 19th Feb. 2018, at 2154 and 627, respectively. For full merit dataset, the all-time-high is 13018, and all-time-low is 370. Weekly meritsMonthly merits
For more details, please visit and re-read the OP, everyone.
|
|
|
Thanks for the hint. I will try it later, might be months later, because I have to learn SQL queries in order to retrieve necessary data variables for my analysis from raw data given by @Theymos. Great initiatives! I thank you so much for your intention to help. I tried to quickly get you a list of new accounts per day, but it proves to be harder than expected to extract the registration date from each line (in Raw.zip), so I gave up (for now).
For others, It is just a hint from my analysis: Updated the OP, weekly, and monthly analyses, with more interesting findings, including the following table. Daily meritsThe median of daily merits of the period before 19th Feb. 2018 is 3.4 times higher than as of the period since 19th Feb. 2018, at 2154 and 627, respectively. For full merit dataset, the all-time-high is 13018, and all-time-low is 370. Weekly meritsMonthly merits
For more details, please visit and re-read the OP, everyone. My topic is here
|
|
|
|