Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can't figure out how to average
I am a teacher at a high school. I can not figure out how to do averages a
certin way. I wanted to know how you can average a grade, in a percet way. Example: I have 4 tests and 2 quizes so far, and particapation grade. I want the test grade to be 50% of the grade, and the other two to each be 25%. I was wondering if there was any formula to find the average of the number, and what 50% of that number is, and same for the other two, except 25% of them. I would really appreciate the help. Thanks. |
#2
|
|||
|
|||
If I understand what you're asking for, you want to find each individual
average, then add them together after adjusting for their relative weight. =AVERAGE(Test Scores)*.5 + AVERAGE(Quiz Scores)*.25 + Participation*.25 You can either list each set of scores, separated by commas (e.g., (A1,A2,...An), or enter the cell range (e.g., A1:An) in the AVERAGE function "mikevetteguy" wrote: I am a teacher at a high school. I can not figure out how to do averages a certin way. I wanted to know how you can average a grade, in a percet way. Example: I have 4 tests and 2 quizes so far, and particapation grade. I want the test grade to be 50% of the grade, and the other two to each be 25%. I was wondering if there was any formula to find the average of the number, and what 50% of that number is, and same for the other two, except 25% of them. I would really appreciate the help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I figure average MPH? | Excel Discussion (Misc queries) | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |