Formula for determing average based on weighting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Sullivan - 16 Dec 2005 03:41 GMT

What is the formula for determining the following: If you have an 84 average
that counts as 60% of a grade (school); and you have 91 average that counts
as 30% of a grade' and you have 85 average that counts as 10% of your grade,
what is the formula to determine what your average of all 3 is, to arrive at
a final grade point average?

Reply to this Message

Biff - 16 Dec 2005 03:56 GMT

Hi!

Try this:

A1 = 84
A2 = 91
A3 = 85

B1 = 0.6
B2 = 0.3
B3 = 0.1

=SUMPRODUCT(A1:A3,B1:B3)

Biff

> What is the formula for determining the following: If you have an 84
> average
[quoted text clipped - 5 lines]
> at
> a final grade point average?

Reply to this Message

joeu2004@hotmail.com - 16 Dec 2005 08:21 GMT

> If you have an 84 average that counts as 60% of a grade
> (school); and you have 91 average that counts as 30% of
> a grade' and you have 85 average that counts as 10% of
> your grade, what is the formula to determine what your
> average of all 3 is, to arrive at a final grade point average?

If I interpret your facts correctly, the simplest formula might
be:

=84*60% + 91*30% + 85*10%

Reply to this Message