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
icon
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.

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: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
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman