Formula for Weight Avg., Histogram, Std Deviation

[modest_16081982]

Hello,

I am wondering if there is a formula/script which will do the following:

1. Plot the histogram
2. Calculate Weighted Average
3. Calculate Standard Deviation

of a given sample data.

I am attached a sample file with data in it.

Thanks

[shg]

Please Login or Register  to view this content.

The formula in E2 is =SUMPRODUCT(xi, wi) / SUM(wi)

The array formula in E3 is =SQRT( SUMPRODUCT(wi * (xi - wxAvg)^2) / ( ( COUNTIF(wi, ">0") - 1) * SUM(wi) / COUNTIF(wi, ">0") ) ) (from http://www.itl.nist.gov/div898/softw...2/weightsd.pdf)

Array formulas MUST be confirmed with Ctrl+Shift+Enter, not Enter. You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.

[modest_16081982]

Thanks for the info. How do I plot the histogram? I tried going through Tools->Data Analysis->Histogram but it gives me weird kind of results.

[shg]

Just plot the data you have as a scatterplot?