In Excel, what is the formula to find the average summation, rank, and grade maximum and minimum value?

Answer 1

Hello!

If you want to find the average of a list of numbers, you can use

=AVERAGE([RANGE]) Where [RANGE] is where the data is, so if your data was in rows A1 to A30, it would look like:

=AVERAGE(A1:A30)

For Rank, you will use:

=RANK([Cell], [Range]). So let's say you had the grades going down from A1 to A30. In B1 you would put:

=RANK(A1,$A$1:$A:$30) *NOTE* The dollar signs are important because when you copy the formula down column B, you don't want the cell references to change.

For the Maximum grade, you could use:

=LARGE([RANGE], 1) So this would look like =LARGE(A1:A30 , 1) *Note* The "1" Tells it to find the largest, 2 would be the second largest and so on.

To find the Minimum grade, you would do the same as above, but it would be =SMALL(A1:A30,1) Where 1 is the smallest value, 2 would be the second smallest value and so on.

I hope this helps! Please reach out if you have any more questions!