開始使用免費開始

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, ...)

本練習屬於課程

Google Sheets 的資料分析

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習