G
Guest
How can I drop the lowest score of a group of scores (from tests), then get the average for the rest?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
One way
=SUMPRODUCT((SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50))))))/(COUN
T($A$1:$A$50)-1)
--
Regards,
Peo Sjoblom
=SUMPRODUCT((SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50))))))/(COUN
T($A$1:$A$50)-1)
--
Regards,
Peo Sjoblom
get the average for the rest?John said:How can I drop the lowest score of a group of scores (from tests), then
P
Peo Sjoblom
=SUMPRODUCT((SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50))))))/(COUN
T($A$1:$A$50)-1)
or maybe
=(SUM($A$1:$A$50)-MIN($A$1:$A$50))/(COUNT($A$1:$A$50)-1)
or
=AVERAGE(SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50)))))
the last entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
T($A$1:$A$50)-1)
or maybe
=(SUM($A$1:$A$50)-MIN($A$1:$A$50))/(COUNT($A$1:$A$50)-1)
or
=AVERAGE(SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50)))))
the last entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
get the average for the rest?John said:How can I drop the lowest score of a group of scores (from tests), then
D
dvt
How can I drop the lowest score of a group of scores (from tests), then
get the average for the rest?
Assuming test scores in column A,
=(SUM(A:A) - MIN(A:A))/(COUNT(A:A) - 1)
(total of the scores minus the lowest score divided by the number of
scores less one)