开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习