# Excel auto-averaging for a set value

Microsoft Office excel 2007 - upgrade
March 12, 2011 at 20:36:55
Specs: Windows Vista
 I want to make a spreadsheet that helps students calculate the lowest possible value they need to get in 2 remaining quarters in order to pass for the year, but I don't know how to set up a formula for it. Example: Student has Q1: 65%, Q2: 60%, Midterm: 24%, Q3 (so far): 54%, Q4: X, Final:X, and must all average out to 60%. What would my formula look like for a lowest possible value in order to get overall avg to 60? Thank you very much in advance!

See More: Excel auto-averaging for a set value

#1
March 13, 2011 at 03:52:08
 Two values will give an simultaneous equation depending upon the weighting.

Report •

#2
March 13, 2011 at 09:04:02
 Assume the weighting is 20% for each quarter and 10% each exam. What equation would I use to calculate lowest possible value in order to meet an average overall of 60% for the year? I realize it would be some kind of circular reference I just don't know how to set up the formulas.

Report •

#3
March 13, 2011 at 18:28:50
 If you assume one of the scores is 100.then you could calculate the other. Otherwise two unknowns.

Report •

Related Solutions