Histrogramms: Calculating average and standard deviation

  • Thread starter Thread starter Jens Eichelbaum
  • Start date Start date
J

Jens Eichelbaum

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
 
For Average use
=SUMPRODUCT(values,occurences)/SUM(occurrences)
For standard deviation use
=SQRT(SUMPRODUCT((values-average)^2,occurrences)/(SUM(occurrences)-1))

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gain / Loss Standard Deviation 1
Standard deviation calculation 1
Calculating Sortino Ration (Downside Deviation) 9
Calculating Conditional Standard Deviation? 5
Calculate 2 Standard Deviations 2
Calculating STDEV and other Calcs based on another cells value 3
Standard Deviation from one sheet to another 1
Negative Standard Deviations? 3

Back
Top