Weighted Averages

[MattCufre]

Hi,

I've got a class where the overall mark for the year comes from two scores and I need to find the average. The problem I'm having is that the test score is worth 25% of the overall grade and the coursework score is worth 75%.

For example:

Name TA average Test Average
A 5.5 6
B 6.5 6
C 7.0 7
D 6.5 6

How would I go about get a weighted average so I could give each pupil an overall grade?

Thanks for your help!

[dilipandey]

Hi MattCufre,


It would be helpful if you could share your results, entered manually and will try to achieve the same using formulas... please upload a sample. Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[Andrew-R]

A weighted average is the sum of each result multiplied by the weighting applied to it, divided by the sum of the weighting.

So, in your example, assuming your data was in cells A2:D5, the average for your first row would be:

=(C2*0.25)+(B2*0.75)

Which would give 5.625.

[MattCufre]

I was going to upload my spreadsheet (I've only just got in from work), but that seems to have done it.

Thanks! I was clearly over thinking things!

Matt

[dilipandey]

Hi Matt..

Please share your solution here as this can be helpful for users who could be routed here through internet search
thanks.



Regards,
DILIPandey
<click on below * if this helps>

[MattCufre]

The solution I used was exactly what Andrew-R suggested. His formula returned an average score that was weighted to show that 75% of the overall score came from the TA mark, whilst only 25% came from the test score. Which is what I was after!