Question: I am being asked the one question below. How would I make a formula that computes the average in excel, while dropping the lowest score.
I am being asked the one question below. How would I make a formula that computes the average in excel, while dropping the lowest score. we are not allowed to make extra cells or add any data.
| Basketball | ||||||||
| Baskets Made Attempt 1 | Baskets Made Attempt 2 | Baskets Made Attempt 3 | Baskets Made Attempt 4 | Baskets Made Attempt 5 | Determine Average # of Baskets Made (dropping lowest attempt) | |||
| John | 10 | 12 | 8 | 6 | 7 | |||
| Joe | 8 | 12 | 7 | 7 | 4 | |||
| Sarah | 11 | 13 | 15 | 8 | 10 | |||
| Kim | 10 | 10 | 10 | 8 | 12 | |||
| Create one formula in cell G4, to calculate average baskets made, dropping lowest. | ||||||||
| HINT: You will not use the AVERAGE function. | ||||||||
| Do not add any columns or new data | ||||||||
| Formula can be done with what data is there. | ||||||||
| Formula should be most efficient. | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
