I'm slightly stumped on how to address this problem based on the data provided. Below is the problem, and the data set provided. I'm not sure if it's an accumulation of them all or just one, total family income.
INCOMECAT: Respondent’s income categories and TFINCOMECAT Total family income categories
1. Under $1,000
2. $1,000-$2,999
3. $3,000-$3,999
4. $4,000-$4,999
5. $5,000-$5,999
6. $6,000-$6,999
7. $7,000-$7,999
8. $8,000-$9,999
9. $10,000-$12,499
10. $12,500-$14,999
11. $15,000-$17,499
12. $17,500-$19,999
13. $20,000-$22,499
14. $22,500-$24,999
15. $25000-$29,999
16. $30,000-$34,999
17. $35,000-$39,999
18. $40,000-$49,999
19. $50,000-$59,999
20. $60,000-$74,499
21. $75,000-$89,999
22. $90,000-$109,999
23. $110,000-$129,999
24. $130,000-$149,999
25. $150,000 and over
26. Refused
Missing data: 0, 26, 98, 99.
INCOME and TFINCOME: midpoints of categories
INCOMECAT | INCOME | TFINCOMECAT | TFINCOME |
25 | 175000 | ||
25 | 175000 | ||
23 | 120000 | 23 | 120000 |
24 | 140000 | ||
19 | 55000 | ||
15 | 27500 | ||
16 | 32500 | ||
5 | 5500 | ||
1 | 500 | ||
16 | 32500 | 16 | 32500 |
1 | 500 | ||
6 | 6500 | 19 | 55000 |
8 | 9000 | ||
14 | 23750 | ||
11 | 16250 | ||
19 | 55000 | 19 | 55000 |
19 | 55000 | 19 | 55000 |
18 | 45000 | 18 | 45000 |
20 | 67500 | 20 | 67500 |
14 | 23750 |
The information above includes the problem and a part of the data from the spreadsheet.
We use Minitab to solve this question-
Get Answers For Free
Most questions answered within 1 hours.