TED Talk Marketing Managers are working with potential speakers, and a question came up about how long it takes for a recorded video to be posted online. They have provided you with a spreadsheet that includes $100$ of the videos recorded between $2001$ and $2017.$ Using this data, calculate the average, minimum and maximum number of days between the recording and publishing dates.

Detailed Instructions:

Download the spreadsheet. TED Talk Activity $1.x$ sx$.$

Highlight both the film date and publish date columns. Make sure both are formatted as dates.

Write a formula that will calculate the difference in the publish date and the film date.

Be sure to format this new column as a number rather than a date.

Beneath the newly created data, write a formula that will calculate the average number of days between the publish date and the film date. Be sure to set the number of decimal points to $0.$

Beneath the average formula, write another formula that will display the minimum number of days between the publish date and the film date.

Beneath the minimum formula, write a final formula that will display the maximum number of days between the publish date and the film date.

Be sure to label your average, min, and max using the cell directly to the left of each formula so any viewer will know what they are viewing.