Start Time $||$ Count

$0$:$0049$

$0$:$1522$

$0$:$3022$

$0$:$4518$

$1$:$0010$

$1$:$1512$

$1$:$3019$

$1$:$4510$

$2$:$008$

$2$:$158$

$2$:$303$

$2$:$4510$

$3$:$004$

$3$:$156$

$3$:$308$

$3$:$453$

$4$:$006$

$4$:$1511$

$4$:$3011$

$4$:$4515$

$5$:$0028$

$5$:$1535$

$5$:$3051$

$5$:$4562$

$6$:$0070$

$6$:$1563$

$6$:$30114$

$6$:$45121$

$7$:$00185$

$7$:$15259$

$7$:$30246$

$7$:$45280$

$8$:$00226$

$8$:$15204$

$8$:$30205$

$8$:$45190$

$9$:$00138$

$9$:$15124$

$9$:$30149$

$9$:$45141$

$10$:$00123$

$10$:$15121$

$10$:$30139$

$10$:$45119$

$11$:$00122$

$11$:$15126$

$11$:$3091$

$11$:$45102$

$12$:$00153$

$12$:$15123$

$12$:$30122$

$12$:$45115$

$13$:$00134$

$13$:$15127$

$13$:$30124$

$13$:$45146$

$14$:$00168$

$14$:$15172$

$14$:$30246$

$14$:$45242$

$15$:$00216$

$15$:$15219$

$15$:$30232$

$15$:$45177$

$16$:$00192$

$16$:$15227$

$16$:$30193$

$16$:$45224$

$17$:$00214$

$17$:$15220$

$17$:$30208$

$17$:$45170$

$18$:$00186$

$18$:$15151$

$18$:$30163$

$18$:$45152$

$19$:$00143$

$19$:$15141$

$19$:$30137$

$19$:$45152$

$20$:$00136$

$20$:$15111$

$20$:$3099$

$20$:$45101$

$21$:$0075$

$21$:$1575$

$21$:$3068$

$21$:$4574$

$22$:$0056$

$22$:$1577$

$22$:$3074$

$22$:$4553$

$23$:$0040$

$23$:$1548$

$23$:$3037$

$23$:$4533$

Speed distribution plot

Using the data in the speed data tab,

$1.$ Create a cumulative distribution plot of speeds: You should use the speed bins $($classes$)$ as provided in the data,

$2.$ Determine the mean, mode, and median speeds $($round to nearest whole speed$),$

$3.$ Determine the standard deviation of speeds $($use one decimal place$),$

$4.$ Determine the pace $($use a $10$ mph increment$),$ and

$5.$ Determine the $85$th percentile speed.

Volume Plot

Using the data in the volume data tab

$6.$ Create a plot to show the total volume for each hour and discuss any noted trends.

$7.$ Determine the peak hour and peak hour factor on $9/13,$

$8.$ Determine the hourly expansion factor on $9/13$ for the time period provided to you.