Ready $,{\displaystyle \underset{x}{\overset{?}{}}}$ Accessibility: Investigate

Using Excel functions $($not Pivot Table!$)$ create a table that shows the count, average cd$\_$gross, and average imdb$\_$score for movies with title$\_$year $>=2000,$ by content$\_$rating $($include one row for each unique content$\_$rating. Include only content ratings that have non$-$zero counts for the Year $>=2000$ time period$).$

Using either Excel functions or a pivot table, make a table and graph of the top movie$$s cd$\_$gross for each year in the dataset, arranged in chronological order. Include in your table the year and the top cd$\_$gross. For an additional challenge you can try to include the movie titles as well, but they are not required.

Create a Pivot Table that shows director$\_$name, total cd$\_$gross, average cd$\_$gross, count of movies, and average imdb$\_$score for the top $10$ directors by average cd$\_$gross, sorted by average cd$\_$gross from largest to smallest.

Using either Excel functions or a pivot table, make a table that shows the counts and percentages of profitable and unprofitable movies in each content$\_$rating category. Include only the following content$\_$ratings: G$,$ PG$,$ PG$-13,$ NC$-17,$ R$,$ X$.$ For example, in the row for the G rating I should be able to see how many movies were profitable and how many movies were unprofitable, and also see those counts expressed as percentages of G$-$rated movies.

Reproduce the table from task #$4$ with a Pivot Table, but use a slicer for content$\_$rating. Make sure to base the pivot table on the original data, not your table from #$4!$

show any formulas used please and only use excel functions no calculations.