#1 Fifty randomly selected adults who follow professional sports were asked to name their favorite professional sports league. The results are as follows where MLB = Major League Baseball, MLS = Major League Soccer, NBA = National Basketball Association, NFL = National Football League, and NHL = National Hockey League. a. Find the frequency distribution, relative frequency distribution, and percent frequency distribution for these data. b. Construct a frequency bar chart for these data. c. Which professional sports league is most popular with these 50 adults? Which is least popular?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
icon
Related questions
Question

Please do this in excel and show me how to do it. Need help

 

1
2
3
4
5
6
7
Sheet3 (2)
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
9:34 AM
31
32
33
34
35
36
37
38
39
40
41
Edit
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
A
Data Set for Favorite
Professional Sports League
סם
Tools
NFL
MLB
NBA
NHL
MLS
NBA
NFL
NFL
MLB
NFL
NFL
MLB
NHL
NHL
MLB
MLB
NBA
NFL
NFL
NBA
MLB
NBA
MLS
NFL
NFL
NHL
NFL
NFL
NFL
NFL
NFL
NFL
MLB
MLB
MLB
NFL
NFL
NFL
NFL
NBA
MLS
NHL
MLB
NBA
NFL
MLB
NBA
NFL
NFL
NFL
B
Mobile View
K
Share
L
a
M
{}
N
Edit on PC
=
50
0
21%
x
P
0
Assistant
Transcribed Image Text:1 2 3 4 5 6 7 Sheet3 (2) 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 9:34 AM 31 32 33 34 35 36 37 38 39 40 41 Edit 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 A Data Set for Favorite Professional Sports League סם Tools NFL MLB NBA NHL MLS NBA NFL NFL MLB NFL NFL MLB NHL NHL MLB MLB NBA NFL NFL NBA MLB NBA MLS NFL NFL NHL NFL NFL NFL NFL NFL NFL MLB MLB MLB NFL NFL NFL NFL NBA MLS NHL MLB NBA NFL MLB NBA NFL NFL NFL B Mobile View K Share L a M {} N Edit on PC = 50 0 21% x P 0 Assistant
#1 Fifty randomly selected adults who follow professional sports were asked to name their
favorite professional sports league. The results are as follows where MLB = Major League
Baseball, MLS = Major League Soccer, NBA = National Basketball Association, NFL = National
Football League, and NHL = National Hockey League.
<Refer to spreadsheet "Data Set for Favorite Professional Sports League">
a. Find the frequency distribution, relative frequency distribution, and percent frequency
distribution for these data.
b.
Construct a frequency bar chart for these data.
c. Which professional sports league is most popular with these 50 adults? Which is least
popular?
Transcribed Image Text:#1 Fifty randomly selected adults who follow professional sports were asked to name their favorite professional sports league. The results are as follows where MLB = Major League Baseball, MLS = Major League Soccer, NBA = National Basketball Association, NFL = National Football League, and NHL = National Hockey League. <Refer to spreadsheet "Data Set for Favorite Professional Sports League"> a. Find the frequency distribution, relative frequency distribution, and percent frequency distribution for these data. b. Construct a frequency bar chart for these data. c. Which professional sports league is most popular with these 50 adults? Which is least popular?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill