Standard deviation of aggregated data

  • Thread starter KThy
  • Start date
  • #1
2
0
This might be embarrasingly easy or impossible; I've been a computer programmer for too long since my statistics classes to tell for sure :blushing:

I have a set of records with the following data for each record: interval, mean speed, standard deviation of speed, number of observations. Exempli gratia:

Code:
1, 77.2, 1.75, 10
2, 75.9, 2.05, 12
Now, if I want to aggregate the data to get mean speed and standard deviation over two or more intervals (1 and 2 above), calculating the weighted mean is no problem but how - if possible - do I calculate the standard deviation for the aggregated intervals?
 

Answers and Replies

  • #2
mathman
Science Advisor
7,858
446
Given the std. dev. and mean, you can easily get the second moment. Combine the second moments by the same procedure you used for the means. Finally calculate the std. dev. from the weighted mean and weighted second moment.
 
  • #3
2
0
Combine the second moments by the same procedure you used for the means. Finally calculate the std. dev. from the weighted mean and weighted second moment.
Right, of course. As I said, embarrasingly simple - thanks!
 
  • #4
1
0
I recently encountered a similar problem at work.

However, for me the problem is that some of the intervals used for measuring average speed are different lengths of time. I believe the problem is the same?

Since we consider the data to be a sample, we want the unbiased estimator for the standard deviation which takes on the following form given on wikipedia website (i derived it alone to make sure).


http://en.wikipedia.org/wiki/Mean_square_weighted_deviation

Cheers.
 

Related Threads on Standard deviation of aggregated data

  • Last Post
Replies
0
Views
3K
Replies
2
Views
614
Replies
9
Views
2K
Replies
5
Views
46K
Replies
3
Views
2K
Replies
9
Views
4K
  • Last Post
Replies
18
Views
986
  • Last Post
Replies
4
Views
4K
  • Last Post
Replies
5
Views
1K
  • Last Post
Replies
2
Views
3K
Top