18 16 20 24 15 19 19 12 10 16 26 27 13 23 17 15 24 20

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

Can you please make excel steps. Thanks 

Question 1
The manager of an automobile showroom studied the time spent by each salesperson interacting
with the customer in a month apart from the other jobs assigned to them. The data in hours are
given below.
17
13
18
16
20
24
15
19
19
12
10
16
26
27
13
23
17
15
24
20
14
21
26
24
Using classes 10-13, 14-17, and so on, show:
a. The frequency distribution.
b. The cumulative frequency distribution.
c. The proportion of salesperson who spent 13 hours of time or less with the customers.
d. Prepare a histogram.
e. Comment on the shape of the distribution in the histogram you prepared in part d.
Transcribed Image Text:Question 1 The manager of an automobile showroom studied the time spent by each salesperson interacting with the customer in a month apart from the other jobs assigned to them. The data in hours are given below. 17 13 18 16 20 24 15 19 19 12 10 16 26 27 13 23 17 15 24 20 14 21 26 24 Using classes 10-13, 14-17, and so on, show: a. The frequency distribution. b. The cumulative frequency distribution. c. The proportion of salesperson who spent 13 hours of time or less with the customers. d. Prepare a histogram. e. Comment on the shape of the distribution in the histogram you prepared in part d.
Expert Solution
steps

Step by step

Solved in 2 steps

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