Standard deviation of aggregate data

2 views (last 30 days)
Abraham
Abraham on 8 Jul 2013
Hi
I have two matrix with 1) day 2) travel time (sec). Where there are several observations of travel times per day. And date for more than two years.
day .......Traveltime
1 .............220
1 .............230
1 .............240
2 .............210
2 .............210
...etc
How can I aggregate the data_, so that I will have only one observation (average travel time) per day, and the standard deviation for each day.
So that the output, will be something like this:
day.......average_time.......Std_dev
1............230.............10
2............210.............0
I would appreciate if you can help me.

Answers (1)

Shashank Prasanna
Shashank Prasanna on 8 Jul 2013
Group stats can be used to compute statistics based on some grouping. In this case day is the grouping variable and mean and standard deviation are your statistics.
Take a look at few examples that demonstrate how to do this:

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!