Kom igångKom igång gratis

Intervals between observations

So far, you've calculated intervals by subtracting the same date from each row in the table. In this exercise, you'll calculate intervals between the release dates of the highest grossing films, in other words, the intervals between rows.

Recall that the SORT() function has the following syntax:

SORT(range, sort_column, is_ascending, ...)

Den här övningen är en del av kursen

Dataanalys i Google Sheets

Visa kurs

Övningsinstruktioner

  • In A14:B23, sort the Title and Release Date by the release date in ascending order.
  • In C15:C23, calculate the interval between each release date in months, excluding the first release.

Interaktiv övning med praktiskt arbete

Gör teori till handling med en av våra interaktiva övningar

Starta övningen