Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hourly average from large data set
I have a large set of traffic data (55000+ rows and 15 columns). Each row
contains the data of one vehicle passing through a survey location. The columns include the time at which the vehicle passed the survey location, it's velocity, a property called headway etc... I would like to work out the average velocity and headway of the vehicles passing through the survey location for each hour (remembering that the number of vehicles and hence rows is different for every hour). Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hourly average from large data set
P.S. Forgot to mention I am using Excel 2003...
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hourly average from large data set
NRH -
You can use the database functions to calculate the counts and averages, using the time fields for your criteria. Look at the help in Access for DCOUNT, DAVERAGE, and Database in general. -- Daryl S "~~NRH~~" wrote: I have a large set of traffic data (55000+ rows and 15 columns). Each row contains the data of one vehicle passing through a survey location. The columns include the time at which the vehicle passed the survey location, it's velocity, a property called headway etc... I would like to work out the average velocity and headway of the vehicles passing through the survey location for each hour (remembering that the number of vehicles and hence rows is different for every hour). Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hourly average help | New Users to Excel | |||
How do I average hourly data into daily data? | Excel Discussion (Misc queries) | |||
Calculating Hourly Rate | Excel Discussion (Misc queries) | |||
Using a time value in an Excel formula to figure an hourly average | Excel Discussion (Misc queries) | |||
How to convert half hourly data into hourly | Excel Discussion (Misc queries) |