Menu

Weighted Average Standard Deviation

Search this Thread

#1

Report Post

[email protected]

Posts: n/a

Default

Jerry W. Lewis wrote:
wrote:
Assume that A1:A5 has the values above, and B1:B5 has
the respective scores. Then the average score (C1) is:
=SUMPRODUCT(A1:A5,B1:B5)/(SUM(A1:A5)-1)

I think you meant
=SUMPRODUCT(A1:A5,B1:B5)/SUM(A1:A5)

Yes, you are right. Overzealous editing. Only the
variance formula changes for sample v. population
statistics.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating a weighted average using formula	bob green	Excel Worksheet Functions	1	August 1st 05 10:33 PM
calculating a weighted average uisng formula	bob green	Excel Worksheet Functions	1	August 1st 05 06:31 AM
Show weighted average value after filter.	BillC	Excel Worksheet Functions	3	May 3rd 05 04:13 PM
How to calculate 2 standard deviation?	Li	Excel Worksheet Functions	1	April 12th 05 09:44 PM
Histrogramms: Calculating average and standard deviation	Jens Eichelbaum	Excel Worksheet Functions	2	November 23rd 04 02:10 AM

All times are GMT +1. The time now is 10:37 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement