Problem 3) Analyze some CDOT data Definitions: Begin Ref, En miles, beginning and end point of road segment Length segment length AADT annual average daily traffic count % Trucks percent of vehicles that are trucks Vehicle Miles annual average daily total miles travelled Route Capaci max vehicles expected, as per Highway Capacity Manual V/C ratio volume/capacity ratio - hourly traffic volume divided by capacity of segment V/C ratio 20 forcasted V/C ratio 20 years in future Questions (do not find values manually, but use columns and functions in Excel): a) What percentage of segments currently have a V/C ratio greater than 1? b) What is the average forecasted increase in V/C between now and 20 years from now? c) Make a plot where the x-axis is the center point of each segment, and the y-axis is the percentage of trucks in that segment. d) Verify using formulas the following feature: Vehicle Miles Travelled = AADT * segment length. e) In a new column, calculate the average daily number of trucks on each segment. f) Plot a frequency histogram of AADT with between 5-10 bins. (hint: if needed, make an extra tab for this problem)

Solved: Problem 3) Analyze some CDOT data Definitions: Begin Ref, En miles, be

Home
questions and answers
problem 3 analyze some cdot data definitions begin ref en miles beginn

Question

Problem 3) Analyze some CDOT data Definitions: Begin Ref, En miles, beginning and end point of road segment Length segment length AADT annual average daily traffic count % Trucks percent of vehicles that are trucks Vehicle Miles annual average daily total miles travelled Route Capaci max vehicles expected, as per Highw