Averages with non-counting times repeated also non-counting

personId,realAverage,adjustedAverage
2012PARK03,6.32,5.79
2012PARK03,5.84,6.13
2012PONC02,7.05,6.33
2012PONC02,7.45,6.5
2015FUSH01,7.37,6.59
2012PONC02,7.02,6.74
2012PARK03,7.43,6.79
2012PONC02,7.47,6.82
2009ZEMD01,7.01,6.89
2012PARK03,7.36,6.97
2017GARR05,6.9,7.03
2012PARK03,6.55,7.07
2007VALK01,7.31,7.07
2012PATE01,7.77,7.11
2012BEAH01,8.05,7.14
2012LEWI01,7.9,7.18
2014KIMD06,8.08,7.19
2010WEYE02,6.68,7.2
2007VALK01,7.59,7.21
2010WEYE02,6.81,7.29
2010WEYE01,6.71,7.31
2012PONC02,7.93,7.33
2013MALI03,8.05,7.34
2015LEEJ12,8.03,7.35
2013EGDA02,7.14,7.35
2011LAUA01,7.74,7.42
2012ELLI01,7.95,7.43
2015WANG09,8.37,7.47
2012ELLI01,7.97,7.5
2015LEON02,7.17,7.57
2015ROBI04,8.34,7.59
2012LEWI01,7.44,7.68
2015DUYU01,8.13,7.7
2014TYTA02,8.22,7.72
2017AGGA01,7.26,7.73
2018SANC03,8.54,7.74
2011WANN01,8.22,7.74
2015CHNG01,8.26,7.75
2016THOR08,9.03,7.76
2012PONC02,6.89,7.76
2010WEYE02,6.97,7.77
2008SEAR01,8.54,7.79
2010WUIF01,8.17,7.81
2014ZUPA01,8.21,7.82
2010BRAD01,8.24,7.83
2011SANC02,8.61,7.83
2014RZEW01,6.94,7.84
2010WEYE02,8.24,7.85
2009SMIT03,8.5,7.86
2007VALK01,7.2,7.9
2011WANN01,7.18,7.94
2009DIEC01,8.51,7.95
2007HESS01,8.52,7.96
2014TYTA02,8.62,7.97
2012WENI01,9.36,7.98
2009FUSH01,8.55,7.99
2010BURN01,8.43,8
2012CALL01,8.54,8
2018DRAN01,8.65,8.02
2016BECE01,8.51,8.03
2017SIAU02,8.67,8.03
2015LEON02,8.93,8.03
2014BAND04,7.21,8.05
2014XUZI01,7.42,8.07
2015ZHUA02,8.7,8.08
2012CARL03,7.47,8.08
2014TANG03,9.18,8.09
2017LIXU06,8.99,8.13
2010BURN01,8.5,8.13
2014RZEW01,7.51,8.13
2010WEYE01,7.29,8.13
2012RUPE01,9.44,8.15
2016KOLA02,8.63,8.16
2010WANG53,8.57,8.17
2015MOHA10,8.73,8.18
2010SCHM01,9.26,8.18
2017ENGB01,8.89,8.18
2010SCHM01,8.81,8.19
2016DEXT01,9.35,8.2
2014NURU01,9.28,8.2
2007LIME01,8.62,8.2
2009FUSH01,7.71,8.23
2009FUSH01,7.53,8.24
2014KIPR01,7.77,8.25
2007VALK01,7.35,8.26
2014TANG03,8.84,8.28
2011BARB03,9.07,8.29
2015VIRA02,8.81,8.29
2009ZEMD01,7.87,8.29
2016SATO01,8.01,8.31
2017VILL41,7.54,8.32
2018ANGE01,8.88,8.33
2013DENN01,8.03,8.36
2013LEJE03,7.94,8.38
2012BEAH01,7.57,8.39
2013KYOU01,9.33,8.39
2009FUSH01,8.79,8.4
2013LINK01,9.29,8.42
2007LIME01,10.36,8.43
2016OCHS01,9.31,8.43
2015GUNN01,9.1,8.44
2017KIMM01,7.72,8.44
2012HUAN12,8.99,8.46
2016PFEI01,8.9,8.46
2017GARR05,8.07,8.46
2011SBAH01,8.53,8.47
2016LINB01,9.07,8.49
2010UTOM01,8.63,8.55
2009RYAB01,9.11,8.56
2010MALL01,9.1,8.57
2009FUSH01,8.22,8.57
2013DENN01,8.31,8.58
2012ONGR01,9.49,8.58
2017SIAU02,9.03,8.58
2009OLSO01,9.46,8.58
2009FUSH01,8.8,8.58
2014RZEW01,7.81,8.59
2012BEAH01,8.01,8.59
2017GARR05,9.29,8.59
2015MILL01,7.16,8.61
2014GERB01,7.62,8.62
2013LINK01,8.15,8.65
2013BUCZ01,9.39,8.65
2017KIMB02,9.16,8.66
2012ELLI01,8.32,8.67
2015PARK08,8.88,8.7
2014ZAKR01,9.22,8.7
2016KOLA02,7.55,8.71
2007VALL01,8.17,8.71
2012CARL03,8.17,8.72
2010WUIF01,8.25,8.72
2014RAJE03,9.12,8.72
2015DIZO02,9.56,8.72
2014SCHW02,9.66,8.73
2015SHAH09,9.24,8.73
2014DALA03,9.34,8.74
2009DIEC01,8.34,8.75
2015CHHA03,8.21,8.75
2010YIDA01,9.21,8.78
2017YANG59,8.21,8.79
2014BELK01,9.43,8.79
2010RICC02,7.92,8.8
2014LEES01,8.54,8.8
2015CECC01,9.85,8.81
2009XIAT02,9.16,8.81
2018LIUL01,10.72,8.82
2014MEND02,8.2,8.82
2014BELK01,9.52,8.82
2013LEON05,9.04,8.82
2014OMIA01,9.32,8.83
2014KORO02,9.37,8.83
2013COLI02,10.19,8.83
2008WEST02,9.22,8.84
2015PARK08,7.91,8.84
2011AKIV01,9.71,8.84
2016RACH01,8.35,8.85
2010HULL01,9.21,8.85
2009CONT01,9.34,8.86
2016SORI04,8.33,8.88
2012ELLI01,7.89,8.88
2010DESJ01,8.09,8.9
2009YAUR01,9.41,8.91
2016RAGH02,8.5,8.91
2011HAMS01,8.22,8.92
2014CHIC01,9.19,8.92
2016DABR03,10.46,8.93
2010ARBO01,9.61,8.93
2010SCHM01,9.33,8.95
2010YIDA01,9.62,8.96
2009FANH01,9.47,8.97
2011ZALE02,9.65,8.97
2016MANN01,9.58,8.97
2016GONG02,9.75,8.97
2015GROH02,8.5,8.98
2015VACA01,8.66,8.99
2008JONG03,9.65,9
2011ETTE01,8.29,9
2014NORR01,9.79,9.01
2011HOFF02,8.61,9.01
2017BARA05,10.54,9.02
2012CROS01,9.29,9.02
2011IRIF01,9.76,9.02
2013HUAN30,9.4,9.04
2015MOGY01,10.01,9.06
2013BRAT01,9.89,9.06
2015ROSE01,8.21,9.06
2011ANIS01,10.53,9.07
2009YAUR01,10.4,9.08
2010WEYE01,8.62,9.09
2012YOSH02,8.55,9.09
2007HESS01,9.87,9.09
2012COST01,8.59,9.1
2015LARS04,8.7,9.1
2014MILL04,8.23,9.1
2018SHIN08,9.96,9.1
2010UTOM01,8.74,9.1
2015CHHA03,7.94,9.1
2014DETL01,8.52,9.1
2013KATO01,8.29,9.11
2010WEYE01,8.84,9.12
2011WANN01,9.87,9.13
2013THOM04,8.88,9.13
2010UTOM01,9.56,9.14
2014BAAR01,10.12,9.14
2015WEIB03,9.29,9.15
2011SANC02,8.08,9.15
2016HOLZ01,10.22,9.15
2017LYSK01,9.94,9.15
2010GARC02,9.61,9.16
2012ELLI01,8.72,9.17
2016HSIE02,9.96,9.18
2016LINB01,10.36,9.18
2012HALE01,10.34,9.18
2012MCNE01,9.77,9.19
2011SHAH01,9.9,9.19
2016DHIM01,8.86,9.2
2010SCHI01,10.3,9.21
2015DIZO02,9.75,9.21
2014ISSE01,11.03,9.22
2014BAIR01,8.51,9.22
2014GERB01,8.5,9.22
2008SUNZ01,8.76,9.22
2010KADD01,8.52,9.22
2010WANG53,8.16,9.22
2015SANC11,8.24,9.23
2016KOLA02,9.99,9.23
2009AZIZ02,9.89,9.23
2014CHRI04,9.56,9.23
2007VALK01,8.6,9.23
2012WALK02,9.8,9.23
2014NURU01,9.79,9.24
2009HAYS01,8.41,9.25
2009BARB01,8.81,9.25
2015WANG09,8.51,9.25
2014BILG01,10.19,9.25
2014SANC28,9.96,9.26
2017BRAU02,10.28,9.27
2015WONG02,9.59,9.27
2012HUAN12,9.84,9.27
2011CAHY03,9.82,9.27
2015RIBI01,10.26,9.27
2017MORR05,8.95,9.28
2007CHAN07,10.33,9.28
2007NAKA03,8.91,9.3
2011HETC01,8.95,9.3
2009MOOR01,9.67,9.3
2007VALL01,9.87,9.31
2014JAYE01,8.86,9.32
2009JIAY01,10.81,9.33
2010PROT01,9,9.33
2013LEJE03,8.75,9.34
2016HARA02,8.83,9.35
2014SCHW02,8.91,9.37
2011CAOS01,8.84,9.37
2016PFEI01,10.68,9.37
2016PHAM06,8.86,9.38
2015LASS03,8.51,9.38
2009YINM01,8.68,9.38
2015SANC11,8.39,9.4
2014BAIR01,8.95,9.4
2012SARL01,9.77,9.41
2009BRZE01,10.28,9.43
2012CARL03,8.1,9.44
2014GUOY04,10.37,9.44
2009OLSO01,8.61,9.45
2016HONG14,10.35,9.45
2010RICC02,8.78,9.46
2015KUCA01,8.27,9.46
2016DHIM01,9.03,9.46
2012WALK02,9.74,9.47
2011WANG52,11.17,9.47
2008SEAR01,9.64,9.48
2012COST01,8.71,9.49
2011LUDW01,11.59,9.49
2013SEKU01,10.27,9.49
2008LIMS01,10.52,9.49
2016ISID01,8.8,9.5
2012SHAK01,10.96,9.5
2013FATE01,11.15,9.5
2017JANK02,10.01,9.52
2012SLIZ01,9.01,9.52
2010YOUY01,9.42,9.52
2017YANG59,8.29,9.53
2012DERG01,10.12,9.53
2005ZOLN01,10.23,9.53
2010VYNN01,8.93,9.53
2017SAHI01,9.36,9.53
2015DUYU01,8.82,9.53
2017CHET03,10.52,9.53
2012DANE01,10.34,9.53
2010LEEY01,10.28,9.53
2015LEON02,9.03,9.54
2008SAJI01,10.01,9.54
2010YOUY01,10.76,9.55
2015SCHO05,10.68,9.55
2010KIPA01,10.6,9.55
2014BAND04,8.96,9.55
2014GERB01,8.97,9.56
2015TANG04,8.99,9.56
2011KNOT01,10.67,9.57
2011WANN01,9.2,9.57
2015PHUE01,9.18,9.57
2010JANG01,10.45,9.58
2015KOVA07,8.87,9.58
2016HART02,9.95,9.58
2011ERYO01,10.37,9.59
2012KALH01,8.82,9.59
2016CRES01,10.28,9.61
2014BEGU01,10.02,9.61
2015MOGY01,10.48,9.62
2017SHIN16,8.66,9.62
2013BUCZ01,9.42,9.62
2013RUIX02,9.98,9.62
2009FUSH01,8.82,9.62
2009JIAY01,11.3,9.64
2014CABR07,10.12,9.64
2015XIEY03,10.32,9.65
2017MAVL02,12.35,9.65
2016GABA02,10.2,9.65
2014MILL04,9.39,9.66
2012WERB01,10.08,9.66
2008BARA01,10.07,9.66
2013LINK01,9.33,9.67
2019TUKO01,10.36,9.67
2012ROQU01,8.73,9.67
2013BARC03,10.37,9.68
2012MAYE01,10.95,9.68
2015KUCA01,9.12,9.68
2016GSEL01,10.37,9.69
2016CHAP04,10.51,9.69
2015DUYU01,9.2,9.69
2010VILL03,9.91,9.69
2012ZHAN08,10.83,9.7
2014KOLE02,10.23,9.7
2017KROK01,10.4,9.7
2015ORTE02,10.16,9.71
2017BYRN02,10.11,9.71
2015XUXI02,10.88,9.71
2011BERG02,10.83,9.72
2012MAYE01,10.13,9.72
2014STIN01,10.87,9.74
2012PANJ02,10.19,9.74
2012LIYA01,9.51,9.74
2012ROQU01,8.09,9.74
2010ALFA03,8.44,9.74
2011CUBA02,10.66,9.75
2007LIME01,10.29,9.75
2007HUBE01,10.92,9.75
2013JOKI01,10.04,9.75
2011JONA01,10.26,9.76
2016GARC14,9.35,9.76
2017ROMA11,9.58,9.77
2011DOBR01,9.28,9.77
2015PARK15,11.06,9.78
2015LEEJ12,10.4,9.78
2012SANT12,9.45,9.78
2018KANT01,9.22,9.78
2011IIDA01,9.16,9.79
2017STEW08,10.82,9.79
2017LIWI02,10.28,9.8
2015BELJ01,10.23,9.8
2014CHEN37,10.41,9.81
2016MANN01,9.29,9.81
2011DOBR01,9.14,9.82
2016SILV07,9.95,9.82
2014OLAR02,11.52,9.82
2019KOSA04,9.42,9.83
2010SCHI01,9.56,9.83
2015SILV55,8.94,9.84
2012ICKL01,10.47,9.84
2014ANTA01,10.87,9.85
2017MURM01,10.75,9.85
2017CAIY04,9.25,9.85
2012MAHV01,6.73,9.86
2016ARRE02,9.39,9.87
2015XIEA01,8.7,9.87
2016WILD02,10.98,9.88
2011BANS02,11.04,9.88
2012MCNE01,9.32,9.88
2017TANG35,10.95,9.89
2013KOSK01,9.39,9.89
2015YASI02,9.62,9.9
2010GARC02,8.86,9.91
2014BAND04,8.71,9.91
2016CHAI03,10.83,9.92
2008WUKU01,10.51,9.92
2014SHES03,10.3,9.92
2017LIZH13,11.19,9.93
2010LEED02,8.71,9.93
2015PARK08,10.85,9.94
2014YASH01,10.19,9.95
2012SARL01,9.56,9.97
2017TANG20,11.12,9.98
2017JANK02,11,9.98
2011JIAN15,10.5,9.98
2011SBAH01,10.78,9.98
2017FENG09,10.9,9.99