Playing quarters

So far, you have an understanding of the variance and standard deviation in the train data.
You'll now refine this understanding by calculating the 4 quartiles. Quartiles divide a population into four parts.

The QUARTILE() function accepts an array of values followed by an integer 1 to 4 to declare the specific quartile.

• Quartile 4: The maximum value in the data.
• Quartile 3: 75% of the data is less than the third quartile.
• Quartile 2: The median of the data.
• Quartile 1: The smallest values 25% of the data.

A useful statistic computed from the quartiles is the "interquartile range" (IQR), which lies between the Q1 and Q3 and represents the middle 50% of the data.