View Single Post
  #11  
Old October 23rd, 2008, 10:28 PM posted to microsoft.public.excel.worksheet.functions
Suzy
external usenet poster
 
Posts: 39
Default How to omit blank cells when calculating weighted averages

Hi Tom,

Row 2 has the percentage the assignment was worth out of 100%, so row 2 (for
this specific assignment) has 30%, 25%, and 45%.

Then row 5 has the score the student received for the assignment, in this
case, blank, 85, and 68.

Thank you so much!!
Suzy

"TomPl" wrote:

Suzy,

If a child gets a grade of .80 on a 5 credit assignment that counts for 4.00
points (.80 X 5).

If a child gets a grade of .90 on a 3 credit assignment that counts for 2.70
points (.90 X 3).

Therefore the weighted average grade for that child is total points (4.00 +
2.70) divided by total credits (5 + 3) or 6.7 รท 8 = .8375 (you might round
that to .84).

Actually, I may have misunderstood your question. I assumed that row 2 has
the number of credits for the assignment and that row 5 has an individual
student's grade for that assignment. If that is not true, please do describe
what is in rows 2 and 5 of your example.

It is always about communication!

Tom