1. The following rows of data were sampled from a single lane of roadway (7).
Density
(vplm) SMS
(mph)
10 61.0
15 54.3
20 46.5
25 59.6
30 52.2
35 56.5
40 45.8
45 43.9
50 45.3
55 32.9
60 44.4
65 34.6
70 36.4
75 29.4
80 26.5
85 27.9
90 17.3
95 19.4
100 12.3
105 24.2
• Use Excel to plot the speed-density graph and use linear regression to fit a line to the data (include the chart in your submission).
• Estimate the free flow speed and clearly label on your Excel graph.
• Estimate the jam density and clearly label on your Excel graph.
• Estimate the maximum capacity for two lanes.
2. A study of freeway flow at a particular site has resulted in a calibrated speed-density relationship as follows: S = 57.5(1-0.008D). Determine the following:
a. Free Flow Speed
b. Jam Density
c. Speed-Flow Relationship
d. Flow Density Relationship
e. Capacity
Be sure to show your calculations! Also plot the Flow-Density relationship with Density on the x-axis and Flow on the y-axis. (10)