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!

Two values will give an simultaneous equation depending upon the weighting.

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.

If you assume one of the scores is 100.then you could calculate the other. Otherwise two unknowns.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History