Spreadsheet: 51001d1250603859-another-average-or-averageif-issue-scarames_revhour
Sheet: Weekday

[NAME]
Riders per Revenue Hour Year to Date
FY 09 Weekdays
 |  |  |  |  |  |  |  |  |  |  |  |  | Weekday
Route | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Weekdays | Average
1 | 35.94592015036049 | 35.96691196075295 | 33.57261828006509 | 33.60009488428941 | 34.24223235393448 | 33.14758527524485 | 33.42294525805164 | 32.16226981400045 | 32.37518151341855 | 32.77665840714035
2 | 28.13642159511685 | 27.58864036967456 | 24.58213432927202 | 25.93230765642447 | 26.85360925733178 | 25.14457623439439 | 24.86961700517079 | 23.95640727361783 | 21.83309863466601 | 22.44269403900878
3 | 34.52875438453381 | 35.5208847635035 | 31.58724202626642 | 32.13901545608863 | 34.01913696060038 | 33.01142759679345 | 33.37949855023026 | 32.17786116322701 | 30.05901415657513 | 28.8101802757158
4 | 24.50712902657983 | 24.44598337950138 | 22.81008465218991 | 22.67206477732793 | 23.11234817813765 | 22.85609127714391 | 21.97736474052263 | 21.69028340080972 | 18.18181818181818 | 19.02393944728041
5 |  |  |  |  |  |  |  |  |  | 0
10 | 11.78180733893662 | 12.36943623525165 | 11.59061684136695 | 11.30569673218623 | 11.83669095585084 | 11.37240384990064 | 11.8380547870475 | 11.50450064294899 | 11.19120913377236 | 11.47990085540171
20 | 15.79392347682179 | 15.91359449513316 | 14.37356602851017 | 13.75967846799456 | 13.5188249896566 | 13.15116410275699 | 13.26212058524843 | 12.32312784443525 | 11.51502614059503 | 11.74290802468025
21 | 16.16595672815297 | 17.10015219317175 | 15.62953662651548 | 16.83827609593686 | 16.21709106603366 | 15.3803900027465 | 15.22737081649468 | 15.21148036253777 | 14.39557421430533 | 14.82051378281511
30 | 31.08770874078532 | 32.2964851575305 | 28.31393519974835 | 28.06393145493492 | 27.87543252595156 | 27.88927335640139 | 27.01163888015099 | 26.50865051903114 | 24.41648317080843 | 25.44004814201896
31 | 36.2545532461967 | 35.78541382382461 | 33.40767867230263 | 32.89254849143428 | 32.77265909577887 | 30.08746128523287 | 31.97791066871847 | 29.66466680951361 | 30.21602353078676 | 31.42135810175049
33 | 23.81197296812391 | 23.62412220372113 | 22.03201200450169 | 21.53009759612236 | 22.18156808803301 | 20.7765412029511 | 20.01625609603601 | 20.03393051031487 | 18.35234940498099 | 18.52138707973948
40 | 15.92313760329629 | 15.2860573134439 | 13.80530690025141 | 13.88057072397393 | 13.79337678351242 | 13.36173074767403 | 13.31048729322465 | 12.38065879866126 | 11.40807404679168 | 12.33122209372678
41 | 20.25714005299833 | 21.18331947249614 | 21.20870100554074 | 20.0150489089541 | 20.72234762979684 | 20.52123948286476 | 19.64908680484301 | 18.73589164785553 | 16.83767699569054 | 16.27245068210816
42 |  |  |  |  |  |  |  |  |  | 0
43 | 30.73389595128726 | 31.75250294363868 | 28.58293264991829 | 29.2130818446608 | 30.01357817147291 | 28.62701762223293 | 28.81511350410872 | 33.74259323806204 | 35.8386237968462 | 35.17883695874774
44 | 17.6325785363786 | 18.22272215973003 | 18.00456761086682 | 18.74765654293213 | 20.59992500937382 | 19.99522786924362 | 19.3100862392201 | 18.1758530183727 | 17.67563145515901 | 17.6472506154122
45 | 18.44313300413505 | 18.16591339845458 | 17.77050281205406 | 18.22538803148221 | 18.59187442289936 | 16.2721396793419 | 16.51976832032234 | 16.14958448753463 | 15.70972886762361 | 17.04604761331246
46 | 29.10631936707611 | 30.1671304436895 | 25.71285347801728 | 27.15351466567814 | 29.33992864093416 | 28.34311326040162 | 27.64131748886858 | 27.89166396367175 | 22.58720844513903 | 21.61079693691915
47 | 24.67424657940379 | 24.34726434223985 | 23.43706412918823 | 21.88885100579612 | 21.86157517899762 | 20.81951461426402 | 19.97024455258346 | 20.45005114217525 | 19.2279081300561 | 20.57694303206392
48 | 16.85711925544511 | 17.71940935302157 | 17.13253497610686 | 15.21909587140746 | 16.41545281823939 | 16.16673383614486 | 14.91882088778859 | 14.58043065231159 | 12.81305774655996 | 14.20684527907041
49 |  |  |  |  |  |  |  | 18.33015873015873 | 23.03838383838384 | 23.68309178743961
50 | 15.15988037727168 | 14.72199016058665 | 11.74442841109508 | 14.17653481145545 | 13.65079365079365 | 12.64229597562931 | 12.6984126984127 | 11.05232216343328 |  | 0
52 | 17.97828183304683 | 18.13429426990814 | 16.87560270009643 | 17.78941084630574 | 18.1099324975892 | 16.25317787323573 | 16.23564477952135 | 16.67791706846673 | 16.71780485666696 | 16.7749779883443
53 |  |  |  |  |  |  |  |  |  | 0
60 | 18.67826086956522 | 17.52046783625731 | 14.3030303030303 | 10.07917825807832 | 11.0431654676259 | 10.77092871157619 | 11.26962066710268 | 12.02338129496403 | 11.4494767822106 | 11.59680950891461
61 | 23.63327032136106 | 25.49656750572082 | 23.54150197628459 | 23.92132505175983 | 25.4 | 24.16600790513834 | 24.53359683794466 | 23.07391304347826 | 21.92490118577075 | 22.37618147448015
62 | 44.75803773871301 | 44.57089702217578 | 41.30482216888501 | 44.87599098116227 | 45.92079423958106 | 44.47860670858707 | 44.93285462083193 | 43.34933449705433 | 43.51357784698391 | 42.32655655589181
63 | 40.42715484363082 | 39.86975749623366 | 39.56182321833292 | 39.44070703073473 | 40.09233610341644 | 39.32678586418199 | 38.52094350709309 | 38.5180055401662 | 34.35322756652397 | 34.68625797904372
64 | 27.34353045084106 | 28.42980026242892 | 25.50155292537564 | 25.96403288924065 | 28.3056325023084 | 27.15940569126165 | 27.44061109712079 | 25.13388734995383 | 25.33786619659196 | 22.49387771488217
70 | 18.8135713218115 | 18.6976850485178 | 16.38156487984605 | 16.47496704489648 | 17.92382847837887 | 16.90708423112983 | 16.93998059114759 | 16.44291659127918 | 14.20547066467095 | 14.41303954500043
71 | 26.08695652173913 | 25.03280361568742 | 22.59296566775791 | 20.59534801917073 | 21.88365650969529 | 20.18383278771091 | 21.43876437505246 | 23.43951985226223 | 16.07067909006967 | 15.95808743827532
73 | 20.34639094556248 | 21.07632171200695 | 17.70783604992157 | 19.10120387239667 | 19.77119279819955 | 18.77514833253768 | 18.73763895519334 | 17.67066766691673 | 16.99515788037919 | 17.23800515346228
80 | 19.88997037663987 | 18.77853754148384 | 17.92598007155773 | 17.82036555629446 | 18.30300465509945 | 17.65475320278536 | 17.93559804562767 | 18.14853999153618 | 17.22579155926596 | 16.96259360797807
81 | 22.7536231884058 | 21.51378446115288 | 20.78138528138528 | 20.48526077097506 | 20.92380952380952 | 20.11255411255411 | 19.69480519480519 | 20.42619047619048 | 18.63419913419913 | 18.37474120082816
91 | 15.94609125775117 | 15.99514036534039 | 14.97339428914037 | 15.62752718564755 | 16.12036273701566 | 15.45529491118939 | 15.10305028854081 | 13.26628194558945 | 12.32256613954883 | 11.95383347073372
92 | 14.90209093926319 | 15.3586893442257 | 14.73899298326779 | 15.6791469768569 | 15.60432569974555 | 15.26717557251908 | 15.01850566736063 | 14.02247667514843 | 14.13177577299715 | 13.39381199985249
94 | 32.17351009388726 | 27.18891761377494 | 13.51209031931923 | 22.90480603733616 | 23.74420759962929 | 19.56146263375179 | 20.40188726935715 | 14.50880444856348 | 15.36987109276266 | 14.62707015352379
 | THESE ARE NOT WEIGHTED AVERAGES |  |  |  | THESE ARE NOT WEIGHTED AVERAGES
Average
75% of Avg
50% of Avg