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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!