211 movies released in 2006 and 2007. Recode Genre so that all genres except for Action, Adventure, Thriller/Suspense, Drama, and Comedy are listed...

211 movies released in 2006 and 2007.

a. Recode Genre so that all genres except for Action, Adventure, Thriller/Suspense, Drama, and Comedy are listed as Other. (Those in Other are genres with fewer than 16 movies.)

b. Find the mean, median, and standard deviation of Total US Gross, broken down by the recoded Genre variable. Also, create side-by-side box plots of Total US Gross, again broken down by the recoded Genre variable. Comment on what the results say about the popularity of different genres.

How do I attach the spreadsheet