Minimum, Maximum & Range - Descriptive Statistics using Microsoft Excel Statistical Functions

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

MINIMUM

=MIN(number1,number2,...)


The MIN function is used to find the smallest or minimum value in a range of data. Text Data Cells are ignored.
In the Data Sheet Data, we have Data from A2:A101, 

=MIN(A2:A101)
Result is 25

One Student has scored the lowest Marks i.e. 25.

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.

MAXIMUM
The MAX function returnsthe largest value in a set of values. Text Data Cells are ignored.
In the Data Sheet Data, we have Data from A2:A101, 

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA function.
=MAX(number1,number2,...)

=MAX(A2:A101)

Result is 100
Two Students have scored the highest marks i.e. 100.

RANGE
Range is a measure of spread.

The range is a good way to get a very basic understanding of how spread out our data are. 

RANGE = Maximum - Minimum

In the Data Sheet Data, we have Data from A2:A101, 

RANGE =MAX(A2:A101) - MIN(A2:A101)

Result is 75

If Max function result is in Cell B3 & Min function result is in cell B2, then

=B3-B2

It can also be calculated as 100 - 25 = 75

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet