Recode the Genre and Distributor columns so that all genres and distributors with a count of less than 10 are lumped into a category called Other. Then select a column chart of counts for this recoded Genre and Distributor variable. Choose the appropriate chart for count of Recoded Genre.
Recode the Genre and Distributor columns so that all genres and distributors with a count of less than 10 are lumped into a category called Other. Then select a column chart of counts for this recoded Genre and Distributor variable. Choose the appropriate chart for count of Recoded Genre.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
100%
I am having trouble with understanding the formulas to use and where to insert the formulas.
Recode the Genre and Distributor columns so that all genres and distributors with a count of less than 10 are lumped into a category called Other. Then select a column chart of counts for this recoded Genre and Distributor variable.
Choose the appropriate chart for count of Recoded Genre.
Transcribed Image Text:Choose the appropriate chart for count of Recoded Genre.
(i)
60
Count of Recoded Genre
50
40
30
20
(ii)
10
60
Count of Recoded Genre
Action
50
40
Comedy
30
Drama
20
(iii)
Horror
10
Other
Count of Recoded Genre
Thriller/Suspense
60
50
ullu „llul
Action
40
30
Comedy
20
(iv)
10
Other
Count of Recoded Genre
Thriller/Suspense
60
Action
50
40
30
Drama
20
Graph (jii) v
Horror
10
Other
Thriller/Suspense
Action
Adventure
Comedy
Drama
Horror
Other
Thriller/Suspense
Adventure
Adventure
Comedy
Adventure
Drama
Horror
Transcribed Image Text:countif
Frequency / Count
20th Century Fox
Relative Freq
Dreamworks SKG
25
0.2136752
Focus Features
3
0.025641
Distributor
30
Freestyle Releasing
MGM
0.008547
25
Miramax/Dimension
1
0.008547
0.0598291
20
Paramount Pictures
2
0.017094
PictureHouse
15
Rocky Mountain Pictures
16
0.1367521
10
Sony Pictures
0.025641
1
Sony/TriStar
Typecast Releasing
Warner Bros.
0.008547
26 0.2222222
5
1
0.008547
1
0.008547
Weinstein Co.
22
0.1880342
Total
MGM
0.0683761
20th Century Fox
117
Frees tyle Releasing
vampunt Pictures
Genre
1
Sony/ Tri Star
Miramso
Weins ten Co
Action
Tupecast Releasing
Rocky Mount
Adventure
20 0.0947867
Black Comedy
Comedy
23
0.1090047
60
Genre
0.0047393
Documentary
50
56 0.2654028
Drama
40
4 0.0189573
Horror
54
0.2559242
30
Musical
15
20
Romantic Comedy
0.07109
Thriller/Suspense
3
0.014218
10
Total
0.042654
26
0.1232227
211
Action
Adventure
Comedy
Black Comedy
Drama
Horror
Doaumentary
Musi cal
Romanic Comedy
Thrill er/Suspense
Dreamworks SKG
Focus Features
Sony Pictures
Warner Bros.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman