LoslegenKostenlos loslegen

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.

Diese Übung ist Teil des Kurses

Introduction to Statistics in Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • Use the QUARTILE() function to calculate the first, second, third, and fourth quartiles in the respective cells.

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten