The URL can be used to link to this page

Home My WebLink AboutLOVR_WB Excel fileCITY 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 WB 12100 Block Madonna and Calle Joaquin Frequency 2 4 4 5 2 6 9 4 12 11 14 10 8 2 4 3 4 1 2 1 1 109 Percent 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.018348623853211 0.036697247706422 0.036697247706422 4.58715596330275E-02 0.018348623853211 0.055045871559633 8.25688073394495E-02 0.036697247706422 0.110091743119266 0.100917431192661 0.128440366972477 9.17431192660551E-02 0.073394495412844 0.018348623853211 0.036697247706422 2.75229357798165E-02 0.036697247706422 9.17431192660551E-03 0.018348623853211 9.17431192660551E-03 9.17431192660551E-03 0 0 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 0.018348623853211 0.055045871559633 9.17431192660551E-02 0.137614678899083 0.155963302752294 0.211009174311927 0.293577981651376 0.330275229357798 0.440366972477064 0.541284403669725 0.669724770642202 0.761467889908257 0.834862385321101 0.853211009174312 0.889908256880734 0.917431192660551 0.954128440366973 0.963302752293578 0.981651376146789 0.990825688073395 1 1 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/14/2011 7/19/2011 Sunny, Clear 11:50AM 2:00PM ME & AM 45 Day: To 36 Tuesday 12:03PM 2:13PM 42 4 0.38 42 46 51 to 0.743119266055046 Ref. # 45 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 136 140 180 74 228 351 160 492 462 602 440 360 92 188 144 196 50 102 52 53 0 0 0 0 0 0 4568 F*U^2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2178 4624 4900 6480 2738 8664 13689 6400 20172 19404 25886 19360 16200 4232 8836 6912 9604 2500 5202 2704 2809 0 0 0 0 0 0 193494 Cum% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.018348623853211 0.055045871559633 9.17431192660551E-02 0.137614678899083 0.155963302752294 0.211009174311927 0.293577981651376 0.330275229357798 0.440366972477064 0.541284403669725 0.669724770642202 0.761467889908257 0.834862385321101 0.853211009174312 0.889908256880734 0.917431192660551 0.954128440366973 0.963302752293578 0.981651376146789 0.990825688073395 1 1 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 0.018348623853211 0.055045871559633 9.17431192660551E-02 0.137614678899083 0.155963302752294 0.211009174311927 0.293577981651376 0.330275229357798 0.440366972477064 0.541284403669725 0.651376146788991 0.706422018348624 0.743119266055046 0.715596330275229 0.73394495412844 0.706422018348624 0.660550458715596 0.63302752293578 0.541284403669725 0.44954128440367 0.330275229357798 0.238532110091743 0.165137614678899 0.146788990825688 0.110091743119266 8.25688073394495E-02 4.58715596330275E-02 0.036697247706422 0.018348623853211 9.17431192660551E-03 0 0 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