Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
im sry im a new user i need to know how to take for instance
quizzes homework participation finalwith quizzes at 72% hw at 100% participation at 58% and final at 73% at make a formula where i can use quizzes as 40 % of the final mark at the rest 20% each to come up with one grade |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
Look for "weighted average"
-- Don Guillett SalesAid Software "canuckking" wrote in message ... im sry im a new user i need to know how to take for instance quizzes homework participation finalwith quizzes at 72% hw at 100% participation at 58% and final at 73% at make a formula where i can use quizzes as 40 % of the final mark at the rest 20% each to come up with one grade |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
canuckking wrote:
im sry im a new user i need to know how to take for instance quizzes homework participation finalwith quizzes at 72% hw at 100% participation at 58% and final at 73% at make a formula where i can use quizzes as 40 % of the final mark at the rest 20% each to come up with one grade I think you are saying: you got 72%, 100%, 58% and 73% on quizzes, homework, participation and final respectively, and you want to know your total score given that quizzes count for 40% of the total and the other categories count for 20% each. The following is one way to compute the answer: =sumproduct({0.72, 1, 0.58, 0.73}, {0.4, 0.2, 0.2, 0.2}) Of course, you can replace the constant arrays with ranges, if the values are stored in cells. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
Thank you so much. Your a saviour.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|