Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 04, 05:24 PM
Jens Eichelbaum
 
Posts: n/a
Default 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

  #2   Report Post  
Old November 22nd 04, 05:35 PM
Jason Morin
 
Posts: n/a
Default

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
.

  #3   Report Post  
Old November 23rd 04, 02:10 AM
Jerry W. Lewis
 
Posts: n/a
Default

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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017