MKT403 MODULE 4 CASE

profilekenyati
copy_of_householddata_mkt403_case_4.xls
Home>Business & Finance homework help>Marketing homework help>MKT403 MODULE 4 CASE

Sheet1

Column Variable
1 7.50 3 2800 20 1 2 1 1 1 A Household Identification Number 1-60 A Household Identification Number 1-60
2 19.00 3 3200 24 2 2 1 2 1 B Weekly food expenditure, actual, e.g., 34.50 B Weekly food expenditure, actual, e.g., 34.50
3 22.50 4 5000 30 2 2 2 2 2 C Number of persons in household, coded in nine categories C Number of persons in household, coded in nine categories
4 28.50 5 7000 33 2 2 2 3 2 1. One D Annual income of household, actual, e.g., $10,000
5 34.50 5 10000 38 3 2 2 4 3 2. Two E Age of head of household, actual, e.g., 38
6 52.50 6 2500 37 4 2 2 1 3 3. Three F Education of head of household, coded in seven categories
7 58.00 8 10000 42 4 2 2 4 3 4. Four G Any children under 6 years in household, coded into two categories
8 7.00 1 2500 19 1 1 1 1 1 5. Five H Any children 6-18 years in household, coded into two categories
9 26.00 1 500 68 2 1 1 1 6 6. Six I Annual income of household, coded in six categories
10 15.00 1 2500 20 2 1 1 1 1 7. Seven J Age of head of household, coded into seven categories, 1-7
11 30.00 1 6000 34 3 1 1 3 2 8. Eight
12 25.50 1 6000 66 2 1 1 3 6 9. Nine or over
13 7.50 1 1500 67 1 1 1 1 6 D Annual income of household, actual, e.g., $10,000
14 12.00 1 1500 72 1 1 1 1 6 E Age of head of household, actual, e.g., 38
15 13.50 2 4000 28 1 1 1 2 2 F Education of head of household, coded in seven categories
16 18.00 2 2500 20 2 1 1 1 1 1. Less than grade 8
17 30.00 2 2500 21 3 1 1 1 1 2. Grades 9-11
18 12.00 2 500 26 1 1 1 1 2 3. High school graduate
19 15.00 2 1500 19 2 1 1 1 1 4. Some college
20 7.50 2 500 19 1 1 1 1 1 5. College graduate
21 10.50 2 1500 33 1 1 1 1 2 6. Graduate work
22 12.00 2 1500 36 1 1 1 1 3 7. Graduate degree
23 15.00 2 500 30 2 1 1 1 2 G Any children under 6 years in household, coded into two categories
24 20.00 2 2500 45 2 1 1 1 4 1. No
25 16.00 2 500 54 2 1 1 1 4 2. Yes
26 15.00 2 500 56 2 1 1 1 5 H Any children 6-18 years in household, coded into two categories
27 26.00 2 6200 26 2 1 1 3 2 1. No
28 15.00 2 1500 39 2 1 1 1 3 2. Yes
29 30.00 2 2500 21 3 1 1 1 1 I Annual income of household, coded in six categories
30 22.00 2 2500 40 2 1 1 1 3 1. Less than $3,000
31 22.50 2 2500 48 2 1 1 1 4 2. $3000-5999
32 24.00 2 2500 60 2 1 1 1 5 3. $6000-9999
33 20.00 2 3500 23 2 1 1 2 1 4. $10,000-14,999
34 11.00 2 500 26 1 1 1 1 2 5. $15,000-24,999
35 16.50 2 2500 64 2 1 1 1 5 6. $25,000 or over
36 15.00 2 500 70 2 1 1 1 6 J Age of head of household, coded into seven categories, 1-7
37 15.00 2 2500 31 2 1 1 1 2 1. Less than 25
38 30.00 2 6300 32 3 1 1 3 2 2. 25-34
39 28.00 2 4500 44 2 1 1 2 3 3. 35-44
40 30.00 2 6000 49 3 1 1 3 4 4. 45-54
41 37.50 2 3500 35 3 1 1 2 3 5. 55-64
42 60.00 2 3500 22 5 1 1 2 1 6. 65-74
43 24.00 2 2500 28 2 1 1 1 2 7. 75 or older
44 7.50 2 2500 51 1 1 1 1 4
45 87.00 3 11000 69 6 1 1 4 6
46 30.00 3 6300 43 3 1 1 3 3
47 21.00 3 2500 33 2 1 1 1 2
48 120.00 3 8000 39 7 1 1 3 3
49 20.00 3 8500 58 2 1 1 3 5
50 22.50 3 2500 19 2 1 1 1 1
51 30.00 3 10000 33 3 1 1 4 2
52 40.00 3 6000 41 3 1 1 3 3
53 37.50 3 6000 47 3 1 1 3 4
54 30.00 4 4500 48 3 1 2 2 4
55 38.00 4 2500 55 3 1 2 1 5
56 60.00 4 6400 36 5 1 2 3 3
57 37.50 5 6000 57 3 1 2 3 5
58 75.00 6 4500 49 6 1 2 2 4
59 37.50 6 3500 32 3 1 2 2 2
60 22.50 2 1900 40 2 2 1 1 3

Sheet2

1 7.50 3 2800 20 1 2 1 1 1 A Household Identification Number 1-60
4 28.50 5 7000 33 2 2 2 3 2 B Weekly food expenditure, actual, e.g., $34.50
7 58.00 8 10000 42 4 2 2 4 3 C Number of persons in household, coded in nine categories
10 15.00 1 2500 20 2 1 1 1 1 1. One
13 7.50 1 1500 67 1 1 1 1 6 2. Two
16 18.00 2 2500 20 2 1 1 1 1 3. Three
19 15.00 2 1500 19 2 1 1 1 1 4. Four
22 12.00 2 1500 36 1 1 1 1 3 5. Five
25 16.00 2 500 54 2 1 1 1 4 6. Six
28 15.00 2 1500 39 2 1 1 1 3 7. Seven
31 22.50 2 2500 48 2 1 1 1 4 8. Eight
34 11.00 2 500 26 1 1 1 1 2 9. Nine or over
37 15.00 2 2500 31 2 1 1 1 2 D Annual income of household, actual, e.g., $10,000
40 30.00 2 6000 49 3 1 1 3 4 E Age of head of household, actual, e.g., 38
43 24.00 2 2500 28 2 1 1 1 2 F Education of head of household, coded in seven categories
46 30.00 3 6300 43 3 1 1 3 3 1. Less than grade 8
49 20.00 3 8500 58 2 1 1 3 5 2. Grades 9-11
52 40.00 3 6000 41 3 1 1 3 3 3. High school graduate
55 38.00 4 2500 55 3 1 2 1 5 4. Some college
58 75.00 6 4500 49 6 1 2 2 4 5. College graduate
6. Graduate work
7. Graduate degree
G Any children under 6 years in household, coded into two categories
1. No
2. Yes
H Any children 6-18 years in household, coded into two categories
1. No
2. Yes
I Annual income of household, coded in six categories
1. Less than $3,000
2. $3000-5999
3. $6000-9999
4. $10,000-14,999
5. $15,000-24,999
6. $25,000 or over
J Age of head of household, coded into seven categories, 1-7
1. Less than 25
2. 25-34
3. 35-44
4. 45-54
5. 55-64
6. 65-74
7. 75 or older

Sheet3