ZOOM IN TO EXCEL PHOTOS FOR CLARITY.

PRESS Z AND ROLL DOWN ON MOUSE AT THE SAME TIME OR ENLARGE PAGE ZOOM

MUCH APPRECIATED

Submit your excel le including the pivot tabiesi'oharts for your answers to questions 1 and 2 {15 Marks] 1- 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 leaking for some answers. Detailed Instructions: a} Download the spreadsheet TED Talk Aotivitvsdsx. Refer to \"D1 8: Q2\" sheet in the spreadsheet. b} Using a pivot table, answer the questions asked below. (Hint: On this sheet. insert two new columns to the right of the puhiish date with a title of "lm year\" and "publish year" and extract the data for these columns} |E'tuestions {1D Marks}: i. What was the total number of comments for all the years {2 Marks}? ii. What was the average number of views for ZEUS {2 Marks}? iii. What was the average length of videos in 21305 (2 Marks)? 1 iv. Of the top 1m] TED Talks, in what film year did the presentations have the highest average number of views {2 Marks]? v. In what film year did TED Talks see the highest number of total comments {2 Marks}? iv. [if the top 10!] TED Talks, in what film year did the presentations have the highest average num ber of views {2 Marl-ts}? v. In what film year did TED Tail-ts see the highest number of total comments {2 lvlarl-ts'j'?I 2- Insert a new column with the title. \"Month" and a new column with the title, \"Count." In the \"CH 8. (12" Sheet. The Month column should contain the numbers 1-12. In the Count column, using a formula, count the number at times a month is displayed in the top 1nd video film dates Questions {10 Marks} i. Use the updated data in sheet "ill 8: 12\" to insert a bar chart at the bottom of the sheet to visualize the frequencyr of the months when filming takes place {4Marl-ts}. ii. In which month have the most presentations been lmed (2 Marks)? iii. In which month have the fewest presentations been filmed {2 Marks}? iv. Of the videos presented. how manv were lmed in July {2 Marks}?