Statistical Software FAQ:
Stata Application:
Excel Application:
Example question: I have my students taken 5 tests, and I want to sum up the best 3 of the five tests and take the
average as their final grade. How to do that if I store all my stuents grade on Excel?
e.g. you have 5 columns: A1 to E1 for these 5 tests score,you want to sum up the best 3 and put it in Column F1.
Possible answer: you may simply enter this formula to Column 6: " = AVERAGE(LARGE (A1:E1,1),LARGE(A1:E1,2),LARGE(A1:E1,3)) "
That is easy!
back to previous page
|