The file P02_02.xlsx contains data on 256 movies that grossed at least $1 million in 2017. a. Recode Distributor so that all distributors with fewer than 10 movies are listed as Other. Similarly, recode Genre so that all genres with fewer than 10 movies are listed as Other. b. Create a crosstabs and an associated column chart for these two
Chapter 3, Problems #3
The file P02_02.xlsx contains data on 256 movies that grossed at least $1 million in 2017.
a. Recode Distributor so that all distributors with fewer than 10 movies are listed as Other. Similarly, recode Genre so that all genres with fewer than 10 movies 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.
This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!
Answer
a. The recode is as follows: i) Distributor=New Distributor if it shows up in the list of Distr…View the full answer
Related Book For 
Business Analytics Data Analysis And Decision Making
7th Edition
Authors: S. Christian Albright, Wayne L. Winston
ISBN: 9780357109953