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