Page $48-$ Problem $2$

In the Word document paste a screen print of your spreadsheet showing results from parts a and b of the problem.

Zip your spreadsheet with the Word document when you submit this lab.

The file P$02\_02.$xlsx contains information on $256$ movies that grossed at least $$1$ million in $2017.$

Create two column charts of counts, one of the different genres and one of the different distributors.

Recode the Genre column so that all genres with a count of $10$ or less are lumped into a category called Other. Then create a column chart of counts for this recoded variable. Repeat similarly for the Distributor variable.