weighted average [message #86881] |
Mon, 09 December 2013 22:41  |
gunvicsin11
Messages: 93 Registered: November 2012
|
Member |
|
|
Hello everyone,
I have data set of 800 data points spreaded in 20 years, I have to take six monthly mean of the data set, but I need to take weighted mean. My preference is that , while taking six monthly mean more weightage has to be given to those values which are more in numbers, less weightage to those values which lesser in numbers. How can I do this, is there any idl routine that does this. Please help me out in this regard.
thanking you in advance
sid
|
|
|
|
Re: weighted average [message #86890 is a reply to message #86881] |
Tue, 10 December 2013 08:15  |
Craig Markwardt
Messages: 1869 Registered: November 1996
|
Senior Member |
|
|
On Tuesday, December 10, 2013 1:41:37 AM UTC-5, sid wrote:
> Hello everyone,
>
> I have data set of 800 data points spreaded in 20 years, I have to take six monthly mean of the data set, but I need to take weighted mean. My preference is that , while taking six monthly mean more weightage has to be given to those values which are more in numbers, less weightage to those values which lesser in numbers. How can I do this, is there any idl routine that does this. Please help me out in this regard.
Mats has the right idea. But usually the analyst has a rationale for assigning weights. For example, if each data point has an error bar (gaussian), then weights is typically assigned (1/error^2).
If you want to assign weight based on the value ("more in numbers"), you can do that, but why? There is a danger in assigning weights arbitrarily. By emphasizing the larger values, you will bias your mean value toward larger values. That bias may or may not be reasonable. In the extreme limit, why not just take the maximum of all of your data points?
|
|
|