b. Create a frequency table showing the frequency of customers within this sample who have incomes in the $30,000-$39,999 range, in the $40,000-$49,999 range, in the $50,000-$59,999 range, and in the $60,000+ range. (Please show in excel)
TABLE C5-2: CUSTOMER ANNUAL HOUSEHOLD INCOME |
53000 |
63000 |
74000 |
42500 |
61000 |
37500 |
59000 |
38500 |
45000 |
44000 |
77000 |
40500 |
38000 |
36500 |
44500 |
47000 |
52000 |
45500 |
39000 |
39500 |
39500 |
43000 |
51500 |
45500 |
46000 |
47500 |
52500 |
43500 |
44000 |
47500 |
The frequency table for the given data set as per given class range is shown in excel as
Frequency Table | |
Class | Count |
30000-39999 | 7 |
40000-49999 | 14 |
50000-59999 | 5 |
60000+ | 4 |
b. Create a frequency table showing the frequency of customers within this sample who have incomes in the $30,000-$39,99...