Spreadsheet: 466185d1466054352-median-formula-help-median-formula-help
Sheet: Sheet1

Total hours | Criteria Change Number | Median Per Criteria Number
7.322 | 1
21.094 | 1
19.758 | 2
21.481 | 2
10.6 | 3
17.292 | 3
11.143 | 4
3.903 | 5
3.957 | 5
4.745 | 5
5.180000000000001 | 5
5.396 | 5
5.896 | 5
6.709000000000001 | 5
7.302 | 5
8.136999999999999 | 5
11.971 | 5
5.636 | 6
4 | 7
4.642 | 7
5.785000000000001 | 7
5.879 | 7
6.231000000000001 | 7
6.787 | 7
6.863 | 7
7.049 | 7
7.180000000000001 | 7
7.702 | 7
8.568999999999999 | 7
9.591999999999999 | 7
11.052 | 7
5.481000000000001 | 8
5.561 | 8
6.047 | 8
7.083 | 8
8.994000000000002 | 8
9.152999999999999 | 8
9.307999999999998 | 8
9.368 | 8
13.104 | 8
13.333 | 8
13.458 | 8
5.119 | 9
5.973000000000001 | 9
6.421 | 9
9.479999999999999 | 10
10.964 | 10
10.992 | 10
17.01 | 10
12.621 | 11
9.637 | 12
3.143 | 13
3.812 | 13
2.29 | 14
3.843 | 14
6.221 | 14
7.279000000000001 | 14
7.841 | 14
8.294 | 14
8.594 | 14
13.161 | 14
3.8 | 15
4.816000000000001 | 15
5.797999999999999 | 15
7.201 | 15
7.245 | 15
8.18 | 15
9.405000000000001 | 15
10.357 | 15
10.588 | 15
14.306 | 15
8.575 | 16
9.317 | 16
11.916 | 16
4.053 | 17
5.871 | 17
6.088 | 17
6.691 | 17
7.621 | 17
8.575 | 17
8.619 | 17
11.403 | 17
24.592 | 17
4.972 | 18
6.166 | 18
6.616 | 18
7.464 | 18
8.235 | 18
9.106 | 18
9.406 | 18
10.482 | 18
9.879 | 19
3.791 | 20
4.775 | 20
5.809 | 20
5.983000000000001 | 20
6.489 | 20
6.665 | 20
7.181999999999999 | 20
7.393000000000001 | 20
8.054 | 20
8.346 | 20
8.916 | 20
9.690000000000001 | 20
13.082 | 20
13.345 | 20
14.15 | 20
16.877 | 20
8.564 | 21
15.582 | 21
15.761 | 21
3.847 | 22
5.322 | 22
5.483000000000001 | 22
6.035 | 22
6.747 | 22
6.765000000000001 | 22
6.778 | 22
7.57 | 22
7.907 | 22
8.124999999999998 | 22
8.498999999999999 | 22
8.563999999999998 | 22
8.568999999999999 | 22
9.667 | 22
11.063 | 22
11.185 | 22
12.354 | 22
7.603 | 23
7.824000000000001 | 23
9.717999999999998 | 23
10.089 | 23
10.308 | 23
11.266 | 23
4.565 | 24
5.262 | 24
9.898 | 25
2.433 | 26
4.972 | 26
5.615 | 26
10.955 | 26
4.175000000000001 | 27
4.411 | 28
3.497 | 29
4.763 | 29
4.819 | 29
4.874000000000001 | 29
4.927 | 29
5.209000000000001 | 29
5.389 | 29
5.666 | 29
6.396 | 29
6.842000000000001 | 29
7.346 | 29
7.7 | 29
8.231 | 29
10.414 | 29
2.274 | 30
3.492 | 30
6.174 | 30
7.037 | 30
8.625 | 30
10.204 | 30
6.742 | 31
2.983 | 32
3.01 | 32
8.355 | 33
3.644 | 34
8.177999999999999 | 34
8.699 | 34
12.121 | 34
2.821 | 35
4.408 | 35
4.645 | 35
6.509 | 35
8.032 | 35
10.341 | 35
10.872 | 35
30.241 | 35
3.643 | 36
4.581 | 36
5.042000000000001 | 36
5.430000000000001 | 36
5.485 | 36
6.132 | 36
8.267000000000001 | 36
8.992 | 36
2.755 | 37
3.184 | 37
3.568 | 37
3.581 | 37
3.678 | 37
3.81 | 37
4.155 | 37
4.214 | 37
4.467000000000001 | 37
4.807 | 37
5.217000000000001 | 37
5.556 | 37
5.643 | 37
6.581 | 37
6.91 | 37
7.06 | 37
7.292000000000001 | 37
7.601 | 37
7.910000000000001 | 37
8.028 | 37
8.392000000000001 | 37
8.801 | 37
8.895 | 37
10.037 | 37
10.199 | 37
3.97 | 38
4.815 | 38
5.502000000000001 | 38
6.974 | 38
7.37 | 38
8.923 | 38
9.782000000000002 | 38
2.475 | 39
2.738 | 39
3.294 | 39
3.493 | 39
3.788 | 39
4.035 | 39
4.229 | 39
4.431 | 39
4.547000000000001 | 39
4.575 | 39
4.945 | 39
5.501 | 39
5.661 | 39
5.777 | 39
5.840000000000001 | 39
6.323 | 39
6.632000000000001 | 39
6.739000000000001 | 39
6.776000000000001 | 39
8.136000000000001 | 39
8.963000000000001 | 39
9.347 | 39
10.041 | 39
10.531 | 39
11.157 | 39
11.509 | 39
13.399 | 39
17.588 | 39
2.925 | 40
2.938 | 40
3.022 | 40
3.065 | 40
3.215 | 40
3.364 | 40
4.034000000000001 | 40
5.443000000000001 | 40
6.337000000000001 | 40
6.576000000000001 | 40
6.749 | 40
6.87 | 40
7.138000000000001 | 40
7.268 | 40
7.364 | 40
7.702000000000001 | 40
8.065 | 40
8.402999999999999 | 40
8.606 | 40
9.578 | 40
10.884 | 40
10.95 | 40
2.71 | 41
4.458 | 41
5.722 | 41
5.833 | 41
5.924 | 41
6.594 | 41
6.825 | 41
7.151 | 41
7.534000000000001 | 41
8.347999999999999 | 41
8.72 | 41
8.811 | 41
10.806 | 41
10.949 | 41
11.559 | 41
12.249 | 41
13.42 | 41
5.159 | 42
2.806 | 43
2.837 | 43
3.274 | 43
3.431 | 43
3.565 | 43
3.65 | 43
3.681 | 43
3.773 | 43
3.816 | 43
3.873 | 43
3.957 | 43
3.963 | 43
4.062 | 43
4.071000000000001 | 43
4.265000000000001 | 43
4.802 | 43
4.811 | 43
5.556 | 43
6.543 | 43
6.975999999999999 | 43
7.652 | 43
8.126999999999999 | 43
8.188 | 43
8.711 | 43
9.176 | 43
9.851 | 43
12.005 | 43
4.252000000000001 | 44
5.359 | 44
6.049 | 44
7.492000000000001 | 44
14.166 | 45
2.93 | 46
6.33 | 47
8.227 | 47
8.984 | 47
10.18 | 47
10.425 | 47
10.166 | 48
11.912 | 48
13.91 | 48
6.048 | 49
4.094 | 50
8.238 | 50
10.106 | 50
13.449 | 50
15.524 | 50
8.738999999999999 | 51
6.091 | 52
7.57 | 52
8.451 | 52
8.494 | 52
8.785 | 52
9.129 | 52
9.266 | 52
9.459 | 52
9.758 | 52
10.874 | 52
11.126 | 52
11.151 | 52
11.224 | 52
12.717 | 52
7.029999999999999 | 53
7.162 | 53
5.125 | 54
12.267 | 54
13.707 | 54
14.364 | 54
6.493 | 55
7.396 | 55
4.825 | 56
6.737 | 56
9.334 | 56
13.933 | 57
9.709999999999999 | 58
12.428 | 58
19.609 | 59
7.919 | 60
5.439 | 61
12.105 | 61
8.716999999999999 | 62
5.827000000000001 | 63
8.142 | 64
11.176 | 65
10.302 | 66
12.195 | 66
6.77 | 67
9.815 | 67
10.243 | 67
11.092 | 67
11.445 | 67
11.489 | 67
11.917 | 67
12.577 | 67
26.338 | 68
8.787999999999998 | 69
12.488 | 70
14.942 | 71
8.376999999999999 | 72
4.418 | 73
7.254 | 73
7.06 | 74
7.809 | 74
11.033 | 74
13.913 | 74
14.162 | 74
3.513 | 75
6.815 | 75
7.906 | 75
8.232999999999999 | 75
10.038 | 75
10.242 | 75
12.306 | 75
14.694 | 75
11.806 | 76
4.985 | 77
5.687 | 77
7.719 | 77
9.104999999999999 | 77
9.783 | 77
11.965 | 77
13.689 | 77
14.757 | 77
21.564 | 77
3.99 | 78
5.855 | 78
8.940999999999999 | 78
6.711 | 79
5.733 | 80
2.986 | 81
5.153 | 81
5.425000000000001 | 81
5.61 | 81
7.302 | 81
8.237 | 81
5.246 | 82
10.44 | 82
11.182 | 82
13.51 | 82
4.339 | 83
5.332000000000001 | 83
5.351 | 83
5.404 | 83
6.277 | 83
6.549 | 83
7.416 | 83
7.462000000000001 | 83
8.104 | 83
8.686 | 83
9.179 | 83
11.399 | 83
11.485 | 83
11.633 | 83
9.863 | 84
10.872 | 84
13.977 | 84
3.469 | 85
3.806 | 85
3.981 | 85
4.07 | 85
4.252000000000001 | 85
4.423 | 85
4.597 | 85
4.641 | 85
4.742 | 85
4.869000000000001 | 85
5.162 | 85
5.162 | 85
5.165 | 85
5.184 | 85
5.246 | 85
5.561000000000001 | 85
5.66 | 85
5.867000000000001 | 85
5.886 | 85
6.232 | 85
6.275 | 85
6.516 | 85
6.555000000000001 | 85
6.707000000000001 | 85
6.784 | 85
6.892 | 85
7.145 | 85
7.276 | 85
7.488 | 85
7.725000000000001 | 85
9.797999999999998 | 85
10.44 | 85
10.486 | 85
9.862 | 86
4.235 | 87
5.469 | 87
5.482 | 87
6.061000000000001 | 87
6.314000000000001 | 87
6.523 | 87
6.761 | 87
6.786 | 87
7.040999999999999 | 87
7.077 | 87
7.278 | 87
7.344 | 87
7.638 | 87
8.007 | 87
8.028 | 87
8.179 | 87
8.256 | 87
8.918 | 87
8.945 | 87
9.431000000000001 | 87
9.823999999999998 | 87
10.812 | 87
13.766 | 87
28.308 | 87
7.548000000000001 | 88
3.543 | 89
4.053 | 89
4.377000000000001 | 89
4.558000000000001 | 89
5.426 | 89
6.57 | 89
6.658 | 89
6.697 | 89
6.995 | 89
7.281000000000001 | 89
7.416 | 89
8.251999999999999 | 89
8.394 | 89
8.447 | 89
9.171999999999999 | 89
11.239 | 89
12.944 | 89
14.262 | 89
15.702 | 89
8.855 | 90
6.676 | 91
6.696000000000001 | 91
8.514 | 91
9.967999999999998 | 91
5.952000000000001 | 92
6.885000000000001 | 92
7.129 | 92
6.297000000000001 | 93
6.55 | 94
6.344 | 95
7.671 | 95
8.491 | 95
5.113 | 96
5.37 | 96
12.761 | 96
9.59 | 97
11.458 | 97
14.994 | 97
5.934 | 98
9.802 | 98
10.325 | 98
11.306 | 98
12.767 | 98
6.423 | 99
3.865 | 100
4.825 | 100
5.005 | 100
5.324000000000001 | 100
7.037 | 100
7.760000000000001 | 100
8.289 | 100
8.732 | 100
13.545 | 101
9.059 | 102
13.49 | 102
7.837 | 103
8.530000000000001 | 103
13.334 | 103
8.424999999999999 | 104
6.383 | 105
13.184 | 105
7.415999999999999 | 106
9.860999999999999 | 106
14.875 | 106
10.247 | 107
13.293 | 107
13.522 | 107
16.503 | 108
4.931 | 109
21.442 | 110
11.168 | 111
8.28 | 112
8.962 | 112
9.096 | 112
9.28 | 112
10.636 | 112
11.116 | 112
14.564 | 112
17.243 | 112
28.55 | 112
13.092 | 113
4.263999999999999 | 114
7.281000000000001 | 114
7.048 | 115
10.287 | 115
4.133 | 116
6.433 | 116
6.738 | 116
6.709000000000001 | 117
16.031 | 117
3.942 | 118
6.9 | 119
7.199 | 119
8.911999999999999 | 119
3.341 | 120
3.779 | 120
4.829000000000001 | 120
5.17 | 120
5.921 | 120
6.482 | 120
7.062 | 120
7.251 | 120
8.232 | 120
8.821 | 120
10.581 | 120
10.612 | 120
14.911 | 120
5.71 | 121
13.162 | 121
2.238 | 122
4.835 | 122
13.947 | 123
3.557 | 124
4.51 | 124
6.632000000000001 | 124
6.981000000000001 | 124
7.364000000000001 | 124
9.238 | 124
12.697 | 124
46.373 | 124
2.23 | 125
4.038 | 125
4.405 | 125
5.364 | 125
5.963 | 125
5.969 | 125
6.349 | 125
7.777 | 125
8.009 | 125
4.235 | 126
5.069 | 127
5.348999999999999 | 127
9.976999999999999 | 127
5.220000000000001 | 128
6.165 | 128
8.216000000000001 | 128
9.379 | 128
4.327999999999999 | 129
6.006 | 129
7.826000000000001 | 129
8.078 | 129
9.355 | 129
5.457 | 130
10.038 | 130
10.477 | 130
25.285 | 130
13.196 | 131
6.95 | 132
7.904000000000001 | 133
12.557 | 133
40.059 | 134
44.992 | 134
20.666 | 135
42.689 | 135
58.401 | 135
9.995999999999999 | 136
11.948 | 136
31.656 | 137
28.704 | 138
39.57299999999999 | 138
57.21900000000001 | 139
8.696000000000002 | 140
20.581 | 141
28.24 | 141
17.398 | 142
22.227 | 143
15.753 | 144
19.285 | 145
21.308 | 145
22.658 | 145
23.686 | 145
34.45 | 145
42.265 | 145
48.155 | 145
30.115 | 146
15.444 | 147
43.848 | 148
14.102 | 149
21.895 | 149
7.641 | 150
7.66 | 150
8.209999999999999 | 150
8.657 | 150
10.926 | 150
15.193 | 150
20.289 | 150
12.942 | 151
9.098 | 152
13.239 | 152
14.839 | 152
7.071000000000001 | 153
14.034 | 153
17.727 | 153
21.347 | 154
17.766 | 155
15.165 | 156
6.399 | 157
40.797 | 158
9.722999999999999 | 159
9.958 | 159
10 | 159
11.397 | 159
11.92 | 159
12.159 | 159
12.583 | 159
18.85 | 159
19.53 | 159
21.485 | 159
18.199 | 160
9.267999999999999 | 161
10.318 | 161
38.422 | 162
32.42899999999999 | 163
27.261 | 164
28.116 | 164
28.314 | 164
39.50300000000001 | 164
17.129 | 165