始める無料で始める

How long has it been?

Many analyses involve working with intervals or durations between two dates and times. Intervals are commonly taken between two fixed time points, such as when a project started and finished, but many also involve calculating intervals relative to the present time.

In this exercise, you'll be preparing the film data for analysis by calculating the date interval between each film's release and the present date. These date intervals will need to update in real-time as the present day changes.

この演習はコースの一部です

Google Sheetsで学ぶデータ分析

コースを見る

演習の手順

  • In column E, calculate the interval in days between the present date and the Release Date.
  • In column F, calculate the interval in months between the present date and the Release Date.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する