Histrogramms: Calculating average and standard deviation
 

Hello group,

from an external tool I get as output a histogram with my measurment
values and their occurences (number of samples) during the whole
measurement.

I am now interested in the average and std. deviation of the
measurement values.

Do you know a function?


Thanks and best regards,
Jens

Have a look in the Excel Help menu under "Statistical
Functions".

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello group,

from an external tool I get as output a histogram with
my measurment
values and their occurences (number of samples) during
the whole
measurement.

I am now interested in the average and std. deviation of
the
measurement values.

Do you know a function?


Thanks and best regards,
Jens
.

For Average use
=SUMPRODUCT(values,occurences)/SUM(occurrences)
For standard deviation use
=SQRT(SUMPRODUCT((values-average)^2,occurrences)/(SUM(occurrences)-1))

Jerry

Jens Eichelbaum wrote:

Hello group,

from an external tool I get as output a histogram with my measurment
values and their occurences (number of samples) during the whole
measurement.

I am now interested in the average and std. deviation of the
measurement values.

Do you know a function?