Page 1 of 1

travel time decreased but the speed also decreased

PostPosted: Tue Nov 27, 2018 3:28 pm
by trafficdata2000
On Joseph Lowery Blvd AM Southbound, the travel time decreased but the speed also decreased in my before and after spread sheets. That does not seem to be possible.
any ideas or adjustments to be done?

Re: travel time decreased but the speed also decreased

PostPosted: Tue Nov 27, 2018 7:49 pm
by bullock
Would you upload the *.Dgm file so I can look at some of the details? You're welcome to either post it here or email it to me separately.

Regards.
Greg

Re: travel time decreased but the speed also decreased

PostPosted: Wed Nov 28, 2018 12:10 am
by trafficdata2000
I have attached the file.

Re: travel time decreased but the speed also decreased

PostPosted: Wed Nov 28, 2018 7:03 pm
by bullock
Thank you.

At the bottom of the Southbound Details page of the TT&D report, there's a section labelled Cumulative Reports. In there, you can see that the CAS column of the Before-type runs includes a couple of outliers, including one run with CAS 19.2 mph, and another at 17.4 mph. These raise the average CAS to exceed that of the After-type runs.

The attached file assembles the detailed numbers and illustrates how they are averaged together.

For averaging the speed from link to link of a single run, Tru-Traffic uses CAS=CTL/CTT. But for averaging the speeds of separate runs along the same artery, Tru-Traffic calculates something like SUM(CAS)/COUNT(CAS), that is, it sums all the speeds together then divides by the number of runs. I believe this is the appropriate way to summarize multiple, separate runs.

If Tru-Traffic instead calculated the average CAS of separate runs by summing the CTL of all the runs and dividing by the sum of the CTT of all the runs (similar to the way it calculates the CAS or the average speed over multiple links along a single run), then it would indeed be surprising if the average CAS speed went down while the average CTT also decreased.

Regards.
Greg

Re: travel time decreased but the speed also decreased

PostPosted: Wed Nov 28, 2018 8:43 pm
by trafficdata2000
Greg,
We can say that what happened in the travel time decreasing and the speed also decreasing is a possibility?

Re: travel time decreased but the speed also decreased

PostPosted: Wed Nov 28, 2018 11:48 pm
by bullock
Yes. You can confirm this using the file that I attached.

I'm re-attaching it, this time as a spreadsheet, so you can see for yourself that
  • CAS is calculated as CTL/CTT (and converted to mph),
  • The average CTT and CAS (as calculated in the spreadsheet) agree with Tru-Traffic's reported value, and
  • The average CTT and CAS both decrease going from Before to After.

Regards.
Greg

Re: travel time decreased but the speed also decreased

PostPosted: Thu Nov 29, 2018 12:47 am
by trafficdata2000
Wow!
Thanks Greg! This explains it well.