Excel formula to calculate Target Grade

[Guest]

Problem:
Current Grade 94.1 - Target Grade 96.5

I need a formula that will calculate what grade is needed to maintain to
achieve target grade from current grade. Their is only 7 months left and
only 1 test per month.

So what grade do I need to maintain to achieve my goal grade at the end of
the year? (Excel Formula)

 

[Tom Ogilvy]

How is the end of the year grade calculated. Assume each test is of equal
weight, then how many test have contributed to your current grade.

Assume you take 9 tests, so 2 have been taken and average to 94.1. Then the
final grade would be

Sum of 9 grades / 9 = final grade

sum of all tests = 9 * 96.5


average needed per remaining test = ((96.4 * 9) - (94.1 * 2))/7 = 97.1

 

[Guest]

Thanks for your help..

How is the end of the year grade calculated. Assume each test is of equal
weight, then how many test have contributed to your current grade.

Assume you take 9 tests, so 2 have been taken and average to 94.1. Then the
final grade would be

Sum of 9 grades / 9 = final grade

sum of all tests = 9 * 96.5


average needed per remaining test = ((96.4 * 9) - (94.1 * 2))/7 = 97.1