Quartiles - 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. 

Quartiles

Quartiles divide a rank-ordered data set into four equal parts. The values that divide each part are called the first, second, and third quartiles; and they are denoted by Q₁, Q₂, and Q₃, respectively.

Note the relationship between quartiles and percentiles. Q₁ corresponds to P₂₅, Q₂ corresponds to P₅₀, Q₃ corresponds to P₇₅. Q₂ is the median value in the set.

Quartiles are mostly used in sales and survey data to divide populations into groups.

=QUARTILE(array,quart)

Array     is the array or cell range of numeric values for which you want the quartile value.

Quart     indicates which value to return.

Quartile = 0 returns Minimum Value

Quartile = 1 returns First Quartile (25^th   Percentile)

Quartile = 2 returns Second Quartile (50^th Percentile) = Median

Quartile = 3 returns Third Quartile (75^th Percentile)

Quartile = 4 returns Maximum Value

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

=Quartile(A2:A101,0)

=Quartile(A2:A101,1)

=Quartile(A2:A101,2)

=Quartile(A2:A101,3)

=Quartile(A2:A101,4)

First Quartile i.e. 25% of students scored less than 69.75 Marks 

Second Quartile i.e. 25% of students scored between 69.75 to 75 Marks 

Third Quartile i.e. 25% of students scored between 75 & 80 Marks 

Fourth Quartile i.e. 25% of students scored between 80 & maximum 100 Marks.

Minimum Marks scored in test is 25

Result is below Table

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