Menu

Question: Current Attempt in ProgressTED Talk Managers are working with new speakers on the potential length of their topic. The general idea is that shorter presentations are better received. However, they do not know this for sure. The managers have come to you with a spreadsheet of the top 100 TED Talks from 2001 to 2017 and aśked you to analyze the data to see

Current Attempt in Progress
TED Talk Managers are working with new speakers on the potential length of their topic. The general idea is that shorter presentations are better received. However, they do not know this for sure. The managers have come to you with a spreadsheet of the top 100 TED Talks from 2001 to 2017 and aśked you to analyze the data to see if it appears that shorter videos have more views and comments.
Detailed Instructions:
Download the spreadsheet, TED Talk Activity 2.𝑥|𝑠𝑥||.
Turn on the filtering feature.
Sort by million views from largest to smallest.
Filter to show the top 10 TED Talks by million views. What information (in range of minutes) would you recommend that the managers present to the new potential speakers? 5-10? 11-15? 16-20? 21-25?
Clear the filters.
Sort by # Comments from largest to smallest.
Filter to show the top 10 TED Talks by Comments. What information (in range of minutes) would you recommend that the managers present to the new potential speakers? 5-10? 11-15? 16-20? 21-25?

There are 3 steps to solve this one.

Expert-verified

OR