Current Attempt in Progress

TED Talk Presenters have asked for some insight into the most popular years of presentations based on number of comments and number of views. TED Talk Managers are looking for some answers.

Detailed Instructions:

Download the spreadsheet TED Talk Activity $4.$xlsx$.$

On the ted$\_$main sheet, insert two new columns to the right of the publish date with a title of "film year" and "publish year."

Make sure the new columns are formatted as a number with no decimal places.

Select all the data that includes the following fields: Film Year, Publish Year, # Comments, # Views $($million$),$ Length $($minutes$),$ Speaker and Title. Using this highlighted data, insert a pivot table on a new sheet in the workbook.

Place "Film Year" in the Row data area, and views, comments, and length in the values area. Set the field settings to the following:

a$.$ Average number of views

b$.$ Sum of number of comments

c$.$ Average length

Provide answers to the questions asked below.

Please see MS Video: Create and Format Pivot Tables and Pivot Charts.