Hello,
Long shot but does anyone know how to align the weighted std.dev formula below into the subtotal function?
=SQRT(SUMPRODUCT(weight series *(series1-weighted avg)^2)/(SUM(weight series)*(no. non zero weights-1)/no. non zero weights))
Hello,
Long shot but does anyone know how to align the weighted std.dev formula below into the subtotal function?
=SQRT(SUMPRODUCT(weight series *(series1-weighted avg)^2)/(SUM(weight series)*(no. non zero weights-1)/no. non zero weights))
Hello unz and Welcome to Excel Forum.
We might be in a better position to help if we could see what you are trying to accomplish.
There are instructions for uploading an Excel file in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Be sure to include some manually calculated results so that we will have something with which to compare the results of our proposals.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks