Averaging averaged fields

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

I need to take a field that is an average of "grades" and
average it with one other number. I am having trouble. It
would be the equivant of taking an averaged field with a
number (like a grade at the end of a semester) from a
query and adding a single field number (like the final
exam score) and weighting it to 25%.

For example, if I have 13 "grades" and they equal 2.0
then I need to add a final "grade" of 4 that is weighted
25% and get a "total grade overall".

I tried to take the "grade" field and add it to
the "final" and divide it by 2 (which would weight it
50%) and that didn't even work. Any suggestions?
 
Dear Deidra:

A weighted average would be calculated using the weights like this:

Source Grade Weight Extend
The 13 grades 2.0 75% 1.50
Final Grade 4.0 25% 1.00

Result 2.50

Extend means multiply, as in 2.0 * .75 = 1.50 and 4.0 * 25% = 1.00.

All this assumes that 2.50 is the correct answer you wanted.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top