LinkBack URL
About LinkBacks
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
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
The formula in E2 is =SUMPRODUCT(xi, wi) / SUM(wi)
Please Login or Register to view this content.
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.
Last edited by shg; 09-03-2008 at 08:27 PM.
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.
I do blog at http://blogs.koolwal.net
Just plot the data you have as a scatterplot?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks