Average Per Sample?

[Gmrrrr]

I'm attempting to kinda "normalize" my data per sample. We have many data points from each individual sample. Taking the general "average" of it doesn't seem to be representative of the actual data. (different samples have different amounts of points and there is a discrepancy between conditions on the count of data points)


So in short I'm looking for a way to make the average of the data per sample. Previous attempts just give me back the calculated average.

 

[Hui]

Gmrrrr


Welcome to the Chandoo.org forums


Are your samples the same weight?

If not you could do a weighted average

=Sumproduct( mass range * value range)/Sum( mass range)