The file S02_02.xlsx contains data about 211 movies released in 2006 and 2007.
a. Recode Distributor so that all distributors except for Paramount Pictures, Buena Vista, Fox Searchlight, Universal, Warner Bros., 20th Century Fox, and Sony Pictures are listed as Other. Similarly, recode Genre so that all genres except for Action, Adventure, Thriller/Suspense, Drama, and Comedy are listed as Other.
b. Create a crosstabs and an associated column chart for these two recoded variables. Express the counts as percentages so that for any distributor, the percentages add to 100%. Discuss your findings.