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, ...)
Latihan ini adalah bagian dari kursus
Data Analysis in Google Sheets
Petunjuk latihan
- In
A14:B23, sort theTitleandRelease Dateby the release date in ascending order. - In
C15:C23, calculate the interval between each release date in months, excluding the first release.
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga