Household Income Case Study

profileWaqas Ahmed
household_income_data.xlsx
Home>Mathematics homework help>Household Income Case Study

Sheet1

Household Subdivision Occupation Age Income Zscore Q1 Q2 Q3 Q4 Q5 EvalM
1 1 1 36 85000 -0.187 5 3 3 1 5 3.4
2 1 2 45 84000 -0.317 4 2 4 1 5 3.2
3 1 2 28 83000 -0.447 5 4 2 4 5 4
4 1 2 43 72000 -1.876 5 3 4 2 4 3.6
5 1 3 44 90000 0.4624 5 4 3 2 5 3.8
6 1 3 52 89000 0.3325 5 4 2 1 5 3.4
7 1 2 49 94000 0.982 5 3 3 2 4 3.4
8 1 2 38 95000 1.1119 5 5 2 1 5 3.6
9 1 4 32 88000 0.2026 4 4 4 2 4 3.6
10 1 2 49 89000 0.3325 4 4 5 2 5 4
11 1 5 31 74000 -1.616 4 4 3 1 4 3.2
12 1 6 55 87000 0.0727 5 4 5 1 4 3.8
13 1 2 61 89000 0.3325 5 4 5 2 5 4.2
14 1 4 37 72000 -1.876 3 4 4 2 4 3.4
15 1 4 38 86000 -0.057 4 5 5 1 5 4
16 1 3 36 97000 1.3716 5 5 5 1 5 4.2
17 1 3 45 82000 -0.577 5 4 5 2 5 4.2
18 1 3 28 74000 -1.616 4 3 4 3 3 3.4
19 1 1 43 89000 0.3325 4 4 2 4 4 3.6
20 1 2 44 93000 0.8521 4 4 5 2 4 3.8
21 1 4 52 95000 1.1119 4 5 5 2 4 4
22 1 2 49 95000 1.1119 4 5 5 3 5 4.4
23 1 5 38 85000 -0.187 5 4 4 2 4 3.8
24 1 5 32 83000 -0.447 5 4 5 1 5 4
25 1 6 49 90000 0.4624 4 4 3 2 4 3.4
26 1 4 31 85000 -0.187 5 4 5 2 4 4
27 1 3 55 82000 -0.577 5 4 5 2 4 4
28 1 2 61 71000 -2.006 3 4 4 3 4 3.6
29 1 3 37 96000 1.2417 4 5 2 3 5 3.8
30 1 6 38 98000 1.5015 5 5 2 3 5 4
31 1 2 28 87000 0.0727 4 4 5 2 5 4
32 1 4 35 89000 0.3325 4 4 3 1 4 3.2
33 1 4 46 72000 -1.876 5 4 5 1 4 3.8
34 1 3 52 86000 -0.057 5 4 5 2 5 4.2
35 1 3 33 97000 1.3716 3 4 4 2 4 3.4
36 1 3 31 82000 -0.577 4 5 5 1 5 4
37 1 1 44 74000 -1.616 5 5 5 1 5 4.2
38 1 2 42 95000 1.1119 5 4 5 2 5 4.2
39 1 4 56 85000 -0.187 5 4 2 4 5 4
40 1 2 31 83000 -0.447 5 3 4 2 4 3.6
41 1 5 59 90000 0.4624 5 4 3 2 5 3.8
42 1 5 41 85000 -0.187 5 4 2 1 5 3.4
43 1 6 37 82000 -0.577 5 3 3 2 4 3.4
44 1 4 38 71000 -2.006 5 4 5 2 5 4.2
45 1 3 44 96000 1.2417 3 4 4 2 4 3.4
46 1 2 39 98000 1.5015 4 5 5 1 5 4
47 1 3 48 87000 0.0727 5 5 5 1 5 4.2
48 1 6 32 89000 0.3325 4 4 3 2 4 3.4
49 1 1 51 94000 0.982 5 4 5 2 4 4
50 1 4 34 88000 0.2026 4 5 2 3 5 3.8
51 2 7 36 89000 1.1378 5 4 1 2 5 3.4
52 2 9 45 75000 -1.0807 4 5 2 4 3 3.6
53 2 10 28 78000 -0.6053 4 4 3 2 4 3.4
54 2 8 43 82000 0.0285 5 5 3 1 5 3.8
55 2 11 44 86000 0.6624 5 4 4 3 4 4
56 2 9 52 80000 -0.2884 4 4 3 3 4 3.6
57 2 7 49 89000 1.1378 4 3 3 3 5 3.6
58 2 10 38 80000 -0.2884 3 4 3 2 3 3
59 2 11 32 81000 -0.1299 3 3 2 3 5 3.2
60 2 9 49 78000 -0.6053 3 4 3 3 2 3
61 2 11 31 86000 0.6624 4 4 3 2 4 3.4
62 2 10 55 83000 0.187 5 5 2 3 5 4
63 2 10 61 89000 1.1378 4 3 3 3 4 3.4
64 2 7 37 68000 -2.19 5 2 2 2 5 3.2
65 2 11 38 69000 -2.0315 3 3 2 1 5 2.8
66 2 9 36 95000 2.0885 5 4 2 3 5 3.8
67 2 10 45 85000 0.5039 4 3 3 2 5 3.4
68 2 9 28 82000 0.0285 4 4 3 2 4 3.4
69 2 7 43 86000 0.6624 5 4 3 1 4 3.4
70 2 9 44 80000 -0.2884 5 4 2 3 4 3.6
71 2 9 52 89000 1.1378 4 4 3 2 4 3.4
72 2 7 49 80000 -0.2884 4 3 3 3 5 3.6
73 2 7 38 81000 -0.1299 4 4 3 2 4 3.4
74 2 11 32 78000 -0.6053 4 3 2 3 4 3.2
75 2 10 49 80000 -0.2884 4 4 2 3 5 3.6
76 2 8 31 86000 0.6624 4 4 3 2 4 3.4
77 2 7 55 82000 0.0285 5 5 2 2 4 3.6
78 2 11 61 80000 -0.2884 4 3 2 3 5 3.4
79 2 8 37 65000 -2.6653 4 5 2 2 4 3.4
80 2 10 38 70000 -1.873 5 3 2 1 5 3.2
81 2 8 43 82000 0.0285 5 2 2 2 5 3.2
82 2 7 44 86000 0.6624 3 3 2 1 5 2.8
83 2 9 52 80000 -0.2884 5 4 2 3 5 3.8
84 2 10 49 89000 1.1378 4 3 3 2 5 3.4
85 2 8 38 80000 -0.2884 4 4 3 2 4 3.4
86 2 11 32 81000 -0.1299 5 4 3 1 4 3.4
87 2 9 49 78000 -0.6053 4 4 3 2 4 3.4
88 2 7 31 82000 0.0285 4 3 2 3 4 3.2
89 2 10 55 86000 0.6624 4 4 2 3 5 3.6
90 2 11 61 80000 -0.2884 4 4 3 2 4 3.4
91 2 9 37 89000 1.1378 5 4 1 2 5 3.4
92 2 11 38 80000 -0.2884 4 5 2 4 3 3.6
93 2 10 28 81000 -0.1299 4 4 3 2 4 3.4
94 2 10 35 78000 -0.6053 5 5 3 1 5 3.8
95 2 7 46 86000 0.6624 5 4 4 3 4 4
96 2 11 52 83000 0.187 4 4 3 3 4 3.6
97 2 9 33 89000 1.1378 4 3 3 3 5 3.6
98 2 10 31 69000 -2.0315 4 3 2 3 4 3.2
99 2 9 44 95000 2.0885 4 4 2 3 5 3.6
100 2 7 42 85000 0.5039 4 4 3 2 4 3.4

Sheet2

Sheet3