Loading...
HomeMy WebLinkAboutLOVR_EB ExcelCITY OF SAN LUIS OBISPO - PUBLIC WORKS DEPT./TRAFFIC DIV. SPOT SPEED STUDY Street: Location: Between: Speed 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 Total: LOVR EB 12100 Block Madonna to Calle Joaquin Frequency 2 4 4 7 9 7 10 7 9 7 8 8 8 2 5 1 1 1 1 101 Percent 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.98019801980198E-02 0 3.96039603960396E-02 3.96039603960396E-02 6.93069306930693E-02 8.91089108910891E-02 6.93069306930693E-02 0.099009900990099 6.93069306930693E-02 8.91089108910891E-02 6.93069306930693E-02 7.92079207920792E-02 7.92079207920792E-02 7.92079207920792E-02 1.98019801980198E-02 4.95049504950495E-02 9.9009900990099E-03 9.9009900990099E-03 0 0 9.9009900990099E-03 0 9.9009900990099E-03 0 0 0 0 1 Cumulative Percent 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.98019801980198E-02 1.98019801980198E-02 5.94059405940594E-02 0.099009900990099 0.168316831683168 0.257425742574257 0.326732673267327 0.425742574257426 0.495049504950495 0.584158415841584 0.653465346534654 0.732673267326733 0.811881188118812 0.891089108910891 0.910891089108911 0.96039603960396 0.97029702970297 0.98019801980198 0.98019801980198 0.98019801980198 0.99009900990099 0.99009900990099 1 1 1 1 1 Date: Weather: Hours: Recorder: Posted Speed: Remarks: DATA ANALYSIS: Mean Speed: Standard Deviation: Standard error of the mean: 50th Percentile: 85th Percentile: 97th Percentile: 10 Mile Pace: % of Samples in 10-Mile Pace: Comments: 7/19/2011 Sunny 2:15PM AM 45 Day: To 37 Tuesday 2:35PM 42 4 0.4 42 46 49 to 0.792079207920792 Ref. # 46 spd_form.xls Total: COMPUTATION & LOOKUP TABLE F*U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 0 140 144 259 342 273 400 287 378 301 352 360 368 94 240 49 50 0 0 53 0 55 0 0 0 0 4211 F*U^2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2178 0 4900 5184 9583 12996 10647 16000 11767 15876 12943 15488 16200 16928 4418 11520 2401 2500 0 0 2809 0 3025 0 0 0 0 177363 Cum% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.98019801980198E-02 1.98019801980198E-02 5.94059405940594E-02 0.099009900990099 0.168316831683168 0.257425742574257 0.326732673267327 0.425742574257426 0.495049504950495 0.584158415841584 0.653465346534654 0.732673267326733 0.811881188118812 0.891089108910891 0.910891089108911 0.96039603960396 0.97029702970297 0.98019801980198 0.98019801980198 0.98019801980198 0.99009900990099 0.99009900990099 1 1 1 1 1 Speed 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 %InPace 0 0 0 0 0 0 0 0 0 1.98019801980198E-02 1.98019801980198E-02 5.94059405940594E-02 0.099009900990099 0.168316831683168 0.257425742574257 0.326732673267327 0.425742574257426 0.495049504950495 0.584158415841584 0.633663366336634 0.712871287128713 0.752475247524752 0.792079207920792 0.742574257425743 0.702970297029703 0.643564356435644 0.554455445544555 0.485148514851485 0.396039603960396 0.336633663366337 0.257425742574257 0.188118811881188 0.108910891089109 8.91089108910891E-02 3.96039603960396E-02 2.97029702970297E-02 1.98019801980198E-02 1.98019801980198E-02 1.98019801980198E-02 9.9009900990099E-03 9.9009900990099E-03 0 0 0 0 Pace-ending Speeed 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68