The accompanying data file shows the salary (in $) and work experience (in years) for 100 employees
Question:
The accompanying data file shows the salary (in $) and work experience (in years) for 100 employees in a marketing firm.
Salary | Experience |
96413 | 26 |
85859 | 20 |
38851 | 4 |
30846 | 3 |
43078 | 25 |
79588 | 13 |
138118 | 30 |
122792 | 28 |
66903 | 12 |
53097 | 5 |
46146 | 5 |
33339 | 1 |
110998 | 28 |
129450 | 23 |
83950 | 21 |
146507 | 28 |
159054 | 25 |
221086 | 30 |
13305 | 22 |
30867 | 16 |
54868 | 9 |
59593 | 23 |
189092 | 23 |
47257 | 13 |
35044 | 3 |
60304 | 11 |
82525 | 17 |
161507 | 28 |
39462 | 18 |
121539 | 29 |
40294 | 7 |
67330 | 9 |
190576 | 27 |
36302 | 4 |
60434 | 27 |
39094 | 6 |
182040 | 0 |
73364 | 24 |
71574 | 8 |
138535 | 28 |
a. Construct the frequency and the relative frequency distributions for the Salary variable. Use five intervals with widths of 0 < x ≤ 50,000, 50,000 < x ≤ 100,000, etc. How many employees earn between $100,000 and $150,000? What proportion of the employees earns at most $200,000?
b. Construct the frequency and the relative frequency distributions for the Experience variable. Use five intervals with widths of 0 < x ≤ 6, 6 < x ≤ 12, etc. How many employees have between 6 and 12 years of experience? What proportion of the employees has more than 24 years of experience?
Step by Step Answer:
Business Analytics
ISBN: 9781265897109
2nd Edition
Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen