Business Analytics Assignment

AhmadAbdul18
A11.xlsx
Home>Business & Finance homework help>Business Analytics Assignment

DataDescription

BLITZ Department Store
Random Sample of 300 (100 each from 3 different stores) actual BLITZ Customers were interviewed.
Customers were asked a range of questions about BLITZ Products, average spend, shopping frequency and their shopping habits in general.
Variable Name and Description:
Customer: Numbered: 1-100 : Melbourne, 101-200 : Sydney, 201-300 : Perth
City: 1 = Melbourne
2 = Sydney
3 = Perth
Age: Age of respondent (years).
Age Band: Age group of respondent. (Less than 30 years, 30-40 years ,40-50 years, 50 or more)
Sex: Gender of respondent, Male / Female
Time Spent Per Visit: Average time in minutes spent by customer during a visit
Visits Per Month: Average number of days shopping at BLITZ stores during a month
Spend Per Visit: Average amount spent during a visit to BLITZ stores
BLITZ Online: Whether the respondent shopping at BLITZ Online store. 1-Shop at BLITZ online store, 0 - Don't shop at BLITZ online store.
Internet @ Home: Whether the respondent has access to internet at home, 0 - Customer does not have access to the internet from home, 1 - Customer has access to the internet from home
Household size: The number of people in the respondent's household
Household Income: The annual net income from all sources of the household for the last financial year
Loyalty Program Awareness Whether the customer aware of the BLITZ loyalty program. YES - Customer aware of the loyalty Program NO - Customer unaware of the loyalty program
Already A Member?: Whether the customer is a member of BLITZ loyalty program. YES -Customer is a member, NO - Not a member
Loyalty Club: Loyalty program tier if a member (BLUE, SILVER, PLATINUM, NONE - Not a member)
Shopping Behaviour
MEN SHOP: 1 - Shop in the Men's section 0 - Don't shop in the Men's section
WOMEN SHOP: 1 - Shop in the Women's section 0 - Don't shop in the Women's section
BEAUTY: 1 - Shop in the Beauty section 0 - Don't shop in the Beauty section
KIDS & TOYS 1 - Shop in the Kids & Toys section 0 - Don't shop in the Kids & Toys section
HOME 1 - Shop in the Home section 0 - Don't shop in the Home section
ELECTRICAL 1 - Shop in the Electrical section 0 - Don't shop in the Electrical section
GIFTS 1 - Shop in the Gifts section 0 - Don't shop in the Gifts section

SurveyData

Customer No City Age Gender Time Spent Per Visit Visits Per Month Spend Per Visit BLITZ Online Internet @ Home Household size Household Income Loyalty Program Awareness Already A Member? Loyalty Club MEN SHOP WOMEN SHOP BEAUTY KIDS & TOYS HOME ELECTRICAL GIFTS
1 Melbourne 24 FEMALE 52 3 115 NO NO 2 59000 NO NO NONE 0 1 0 0 0 1 1
2 Melbourne 29 FEMALE 26 3 113 NO YES 3 68000 NO NO NONE 0 1 1 1 1 1 0
3 Melbourne 31 FEMALE 44 4 127 NO NO 3 45000 NO NO NONE 0 1 1 1 1 1 0
4 Melbourne 32 FEMALE 50 5 63 NO YES 2 53000 NO NO NONE 0 1 1 1 0 1 0
5 Melbourne 29 FEMALE 48 3 130 YES YES 5 67000 NO NO NONE 0 1 1 1 1 1 0
6 Melbourne 28 MALE 37 1 35 NO YES 4 110000 YES YES BLUE 0 0 0 1 1 1 0
7 Melbourne 35 MALE 37 4 107 YES YES 4 75000 NO NO NONE 0 0 1 1 1 1 0
8 Melbourne 24 MALE 38 3 119 NO NO 5 86000 NO NO NONE 1 1 0 1 0 1 0
9 Melbourne 27 FEMALE 40 4 119 YES YES 4 53000 YES YES SILVER 0 1 1 1 0 0 1
10 Melbourne 30 FEMALE 36 5 90 NO YES 4 74000 YES NO NONE 0 1 1 1 1 0 1
11 Melbourne 34 FEMALE 35 2 68 NO YES 4 71000 NO NO NONE 0 1 1 1 1 1 1
12 Melbourne 35 FEMALE 35 4 90 NO YES 4 40000 YES YES BLUE 0 1 1 1 1 1 0
13 Melbourne 31 FEMALE 58 6 110 NO YES 4 54000 YES YES BLUE 0 1 1 1 1 1 1
14 Melbourne 26 MALE 52 3 79 YES YES 4 51000 YES YES PLATINUM 1 1 0 1 0 0 0
15 Melbourne 35 FEMALE 49 4 119 YES YES 4 45000 YES NO NONE 0 1 1 1 0 1 0
16 Melbourne 29 MALE 21 4 130 YES YES 5 87000 YES YES BLUE 1 0 0 1 1 1 0
17 Melbourne 28 MALE 44 1 76 NO NO 4 70000 NO NO NONE 1 1 1 1 1 1 0
18 Melbourne 36 FEMALE 51 3 101 NO YES 3 33000 NO NO NONE 0 1 1 0 1 1 0
19 Melbourne 25 MALE 58 4 89 NO YES 5 107000 YES YES SILVER 1 0 0 0 1 1 0
20 Melbourne 35 FEMALE 39 2 135 NO NO 4 72000 NO NO NONE 0 1 1 1 1 0 1
21 Melbourne 26 FEMALE 38 3 95 NO NO 4 85000 NO NO NONE 0 1 1 0 1 0 1
22 Melbourne 32 FEMALE 44 4 98 NO YES 5 59000 YES NO NONE 0 1 0 1 1 1 0
23 Melbourne 23 FEMALE 54 5 132 NO YES 2 61000 NO NO NONE 0 1 1 0 0 1 1
24 Melbourne 28 FEMALE 53 4 91 NO YES 4 109000 NO NO NONE 0 1 1 1 1 1 0
25 Melbourne 26 MALE 60 1 114 NO YES 4 103000 YES YES SILVER 1 0 0 1 0 0 0
26 Melbourne 33 FEMALE 43 3 111 NO YES 4 39000 NO NO NONE 0 1 1 1 0 0 1
27 Melbourne 28 MALE 38 4 88 NO NO 2 89000 YES NO NONE 1 1 0 0 1 0 1
28 Melbourne 31 FEMALE 43 4 112 NO NO 3 62000 YES NO NONE 0 0 1 1 1 1 0
29 Melbourne 25 MALE 34 2 89 YES YES 5 102000 NO NO NONE 1 1 0 1 1 1 0
30 Melbourne 36 FEMALE 54 3 100 NO NO 3 84000 NO NO NONE 0 1 0 1 1 0 0
31 Melbourne 27 MALE 41 2 91 YES YES 1 57000 YES YES SILVER 0 0 0 0 0 1 0
32 Melbourne 32 FEMALE 37 2 108 NO YES 3 87000 YES YES SILVER 0 1 1 0 0 1 0
33 Melbourne 36 MALE 29 2 110 YES YES 4 39000 NO NO NONE 1 0 0 1 0 0 0
34 Melbourne 31 MALE 42 4 86 YES YES 2 73000 YES NO NONE 1 1 0 0 1 1 1
35 Melbourne 32 MALE 57 4 83 YES YES 3 61000 NO NO NONE 1 1 1 1 1 1 0
36 Melbourne 25 MALE 41 4 61 NO YES 4 72000 YES YES BLUE 1 0 0 1 1 0 0
37 Melbourne 32 FEMALE 41 3 113 NO YES 3 109000 YES NO NONE 0 1 1 1 1 1 0
38 Melbourne 35 MALE 49 2 120 NO NO 4 28000 YES NO NONE 0 1 0 1 0 1 0
39 Melbourne 22 FEMALE 56 3 141 NO NO 4 55000 NO NO NONE 0 1 1 1 1 1 1
40 Melbourne 28 FEMALE 42 3 78 NO NO 4 69000 NO NO NONE 0 1 1 1 1 0 0
41 Melbourne 29 MALE 46 5 85 NO YES 3 48000 YES NO NONE 1 1 0 0 1 1 1
42 Melbourne 33 FEMALE 54 3 117 NO YES 3 78000 YES NO NONE 0 1 0 1 1 0 0
43 Melbourne 26 FEMALE 34 3 92 NO YES 3 66000 NO NO NONE 0 1 1 1 1 1 1
44 Melbourne 37 MALE 31 5 102 NO NO 5 44000 NO NO NONE 1 1 0 1 0 1 0
45 Melbourne 26 MALE 40 3 86 NO NO 4 67000 YES YES BLUE 1 1 0 0 1 0 0
46 Melbourne 33 FEMALE 56 3 109 YES YES 3 72000 NO NO NONE 0 1 0 1 1 0 1
47 Melbourne 21 FEMALE 51 1 109 NO NO 3 44000 YES YES PLATINUM 0 1 1 1 0 1 1
48 Melbourne 24 FEMALE 53 3 125 NO NO 4 52000 NO NO NONE 0 1 0 1 1 0 0
49 Melbourne 28 FEMALE 49 4 112 YES YES 5 105000 NO NO NONE 0 1 1 1 1 0 0
50 Melbourne 42 FEMALE 45 4 112 NO NO 3 49000 YES YES SILVER 0 1 1 1 0 1 0
51 Melbourne 39 FEMALE 43 3 77 NO YES 4 62000 NO NO NONE 0 1 0 1 0 1 1
52 Melbourne 41 FEMALE 61 4 91 NO YES 4 47000 NO NO NONE 0 1 1 1 1 0 1
53 Melbourne 30 MALE 54 3 93 NO YES 3 60000 NO NO NONE 1 1 0 1 1 0 0
54 Melbourne 41 FEMALE 58 3 112 NO YES 3 70000 NO NO NONE 0 1 1 1 1 1 0
55 Melbourne 37 MALE 21 4 71 NO NO 4 53000 NO NO NONE 1 1 0 1 1 1 0
56 Melbourne 34 FEMALE 66 3 128 NO NO 3 55000 YES YES SILVER 0 1 1 0 0 0 1
57 Melbourne 30 MALE 33 2 98 NO YES 4 56000 YES YES BLUE 1 0 0 1 1 0 0
58 Melbourne 38 FEMALE 48 3 86 YES YES 4 78000 YES NO NONE 0 1 1 1 1 0 1
59 Melbourne 36 FEMALE 41 4 71 YES YES 2 85000 NO NO NONE 0 1 0 0 0 1 1
60 Melbourne 38 MALE 57 4 114 NO YES 3 78000 NO NO NONE 1 0 0 1 1 0 0
61 Melbourne 45 FEMALE 53 3 92 NO YES 4 48000 YES YES BLUE 0 1 0 1 1 0 0
62 Melbourne 34 MALE 32 4 102 NO YES 3 86000 YES YES SILVER 1 1 0 0 1 1 0
63 Melbourne 39 FEMALE 64 2 99 NO NO 2 58000 YES YES BLUE 0 1 1 1 1 1 0
64 Melbourne 35 FEMALE 57 5 68 YES YES 4 85000 YES YES PLATINUM 0 1 1 1 1 1 1
65 Melbourne 38 MALE 64 2 109 NO YES 3 86000 NO NO NONE 1 1 0 1 0 0 1
66 Melbourne 44 MALE 54 1 88 NO YES 2 65000 YES NO NONE 1 0 0 0 0 1 0
67 Melbourne 38 FEMALE 21 5 70 NO YES 5 98000 NO NO NONE 0 1 1 0 1 0 1
68 Melbourne 42 FEMALE 71 5 137 NO YES 3 62000 NO NO NONE 0 1 0 1 1 1 1
69 Melbourne 35 MALE 62 4 72 NO YES 4 57000 NO NO NONE 1 0 0 1 0 0 0
70 Melbourne 39 MALE 48 4 83 NO YES 2 64000 YES YES PLATINUM 1 0 1 1 1 1 0
71 Melbourne 32 MALE 61 4 79 NO NO 5 76000 YES YES PLATINUM 1 0 0 1 0 1 0
72 Melbourne 41 MALE 48 3 107 NO YES 4 49000 YES YES SILVER 0 0 0 0 0 0 0
73 Melbourne 39 MALE 52 4 118 NO YES 5 62000 NO NO NONE 1 1 0 1 0 1 0
74 Melbourne 37 MALE 32 4 103 NO YES 3 76000 YES YES SILVER 1 0 0 1 1 1 1
75 Melbourne 34 MALE 47 3 106 NO YES 4 85000 NO NO NONE 1 1 0 1 1 0 0
76 Melbourne 38 MALE 64 4 90 NO NO 3 5000 NO NO NONE 1 0 0 1 1 1 0
77 Melbourne 45 FEMALE 38 3 143 YES YES 2 46000 NO NO NONE 0 1 1 0 0 1 1
78 Melbourne 37 FEMALE 40 6 116 NO NO 3 99000 NO NO NONE 0 1 1 1 1 1 0
79 Melbourne 39 FEMALE 49 4 82 NO NO 1 49000 YES YES BLUE 0 1 0 0 0 0 1
80 Melbourne 42 FEMALE 61 4 94 NO YES 3 47000 NO NO NONE 1 1 1 1 1 0 1
81 Melbourne 49 MALE 69 4 93 NO YES 4 61000 NO NO NONE 1 1 0 0 1 1 0
82 Melbourne 33 MALE 53 5 81 YES YES 3 60000 YES YES SILVER 1 1 0 1 1 0 0
83 Melbourne 35 FEMALE 42 4 104 NO NO 3 80000 NO NO NONE 0 1 0 1 1 1 0
84 Melbourne 43 FEMALE 51 3 97 NO NO 2 81000 YES YES BLUE 0 1 1 1 1 0 0
85 Melbourne 36 FEMALE 37 3 87 NO YES 4 58000 NO NO NONE 0 1 0 0 0 0 0
86 Melbourne 39 FEMALE 71 4 85 NO YES 4 71000 NO NO NONE 0 1 0 1 1 1 1
87 Melbourne 40 FEMALE 48 6 117 YES YES 3 55000 NO NO NONE 0 0 1 0 1 0 1
88 Melbourne 42 MALE 50 3 119 NO YES 2 80000 NO NO NONE 1 0 0 0 0 1 0
89 Melbourne 34 MALE 20 4 130 NO YES 4 29000 NO NO NONE 1 0 0 1 0 0 0
90 Melbourne 33 FEMALE 56 3 45 NO NO 3 87000 NO NO NONE 0 1 1 0 1 1 1
91 Melbourne 40 MALE 34 1 111 NO YES 2 73000 NO NO NONE 1 1 0 0 0 1 1
92 Melbourne 38 FEMALE 47 3 110 NO YES 5 77000 NO NO NONE 1 1 1 1 1 0 0
93 Melbourne 40 FEMALE 56 4 90 NO YES 5 47000 YES YES PLATINUM 0 1 1 1 1 1 0
94 Melbourne 44 FEMALE 55 3 111 NO YES 5 89000 YES NO NONE 0 1 1 1 1 0 1
95 Melbourne 50 FEMALE 41 2 79 NO NO 4 55000 NO NO NONE 0 1 0 1 0 0 0
96 Melbourne 35 MALE 53 3 118 NO NO 3 65000 NO NO NONE 1 1 0 1 0 0 0
97 Melbourne 27 MALE 39 2 75 NO YES 3 22000 YES YES BLUE 1 1 0 0 1 1 1
98 Melbourne 39 MALE 41 2 88 YES YES 2 58000 YES NO NONE 1 1 0 1 0 0 0
99 Melbourne 35 MALE 46 3 118 NO NO 2 67000 NO NO NONE 1 1 0 0 0 0 0
100 Melbourne 40 FEMALE 33 3 112 NO YES 4 57000 NO NO NONE 0 1 1 1 1 0 1
101 Sydney 35 MALE 37 6 91 NO NO 2 80000 NO NO NONE 1 1 0 1 0 0 0
102 Sydney 38 FEMALE 30 3 125 NO YES 3 80000 NO NO NONE 0 1 1 0 1 0 1
103 Sydney 35 FEMALE 52 5 112 NO NO 2 81000 NO NO NONE 0 1 1 1 0 1 1
104 Sydney 44 FEMALE 34 5 99 YES YES 4 55000 NO NO NONE 0 1 1 1 1 1 1
105 Sydney 47 MALE 48 7 82 NO YES 5 62000 YES YES SILVER 1 1 0 1 1 0 0
106 Sydney 32 FEMALE 46 4 100 YES YES 2 83000 YES NO NONE 0 1 1 0 1 1 1
107 Sydney 31 FEMALE 36 4 147 NO NO 4 79000 YES NO NONE 0 0 1 0 1 0 1
108 Sydney 37 FEMALE 40 4 144 NO NO 3 76000 NO NO NONE 0 1 1 0 1 0 1
109 Sydney 39 MALE 50 2 194 YES YES 5 101000 NO NO NONE 1 0 0 1 1 1 0
110 Sydney 40 FEMALE 59 4 123 NO YES 4 74000 YES NO NONE 0 1 1 1 1 1 1
111 Sydney 39 MALE 51 6 115 NO YES 4 80000 NO NO NONE 1 0 0 1 1 1 0
112 Sydney 32 FEMALE 44 6 112 NO YES 3 77000 YES NO NONE 0 0 1 1 0 0 1
113 Sydney 46 MALE 30 4 128 NO YES 5 82000 YES YES SILVER 1 1 0 1 0 0 1
114 Sydney 40 MALE 32 4 109 YES YES 4 64000 NO NO NONE 1 1 1 1 1 1 1
115 Sydney 41 FEMALE 56 4 131 NO YES 5 61000 NO NO NONE 0 1 1 1 1 1 0
116 Sydney 45 FEMALE 45 5 131 NO NO 1 68000 YES NO NONE 0 1 1 0 1 1 0
117 Sydney 41 FEMALE 50 6 52 NO YES 2 69000 YES YES BLUE 0 1 1 0 1 0 1
118 Sydney 34 FEMALE 45 5 122 YES YES 3 91000 NO NO NONE 0 1 1 1 0 0 0
119 Sydney 43 MALE 28 6 105 NO NO 3 76000 YES NO NONE 1 0 1 1 1 1 0
120 Sydney 37 MALE 55 3 132 NO YES 3 43000 YES NO NONE 1 0 0 1 1 1 0
121 Sydney 47 FEMALE 55 5 122 NO NO 1 89000 NO NO NONE 0 1 0 1 1 1 1
122 Sydney 40 FEMALE 31 4 156 NO YES 4 73000 YES NO NONE 0 1 0 1 1 0 1
123 Sydney 34 FEMALE 61 4 119 NO YES 4 81000 YES YES BLUE 0 1 1 1 1 0 1
124 Sydney 48 FEMALE 52 2 92 NO NO 3 83000 YES NO NONE 0 1 1 1 1 1 0
125 Sydney 40 FEMALE 39 3 126 YES YES 5 63000 YES YES BLUE 0 1 0 1 1 0 1
126 Sydney 35 MALE 50 6 121 NO YES 3 52000 YES NO NONE 1 1 1 1 0 1 0
127 Sydney 37 FEMALE 44 5 162 NO YES 4 77000 NO NO NONE 0 1 0 1 1 1 1
128 Sydney 44 FEMALE 37 3 145 YES YES 2 36000 NO NO NONE 0 1 1 1 0 1 0
129 Sydney 42 MALE 54 5 135 NO YES 3 77000 NO NO NONE 0 0 0 1 0 0 0
130 Sydney 38 MALE 45 4 78 NO YES 2 82000 NO NO NONE 1 1 0 0 1 1 0
131 Sydney 41 MALE 47 4 108 NO NO 4 41000 NO NO NONE 1 0 0 1 1 1 0
132 Sydney 45 FEMALE 32 6 126 NO NO 3 114000 NO NO NONE 0 1 0 1 1 1 1
133 Sydney 35 FEMALE 46 4 140 NO YES 3 69000 YES YES SILVER 0 1 0 0 1 0 1
134 Sydney 30 MALE 49 5 170 YES YES 4 71000 NO NO NONE 1 0 0 1 1 1 0
135 Sydney 47 FEMALE 44 4 141 NO NO 2 38000 NO NO NONE 0 1 1 0 0 0 1
136 Sydney 46 MALE 56 3 108 NO YES 2 41000 YES YES BLUE 1 1 0 1 0 0 0
137 Sydney 38 FEMALE 56 5 94 NO YES 3 61000 YES YES SILVER 0 1 1 1 1 1 0
138 Sydney 37 FEMALE 42 3 157 NO NO 5 81000 YES YES SILVER 0 1 1 1 1 0 0
139 Sydney 45 MALE 44 5 115 NO YES 2 30000 YES YES SILVER 1 1 0 1 0 0 0
140 Sydney 38 FEMALE 27 4 67 NO NO 4 55000 NO NO NONE 0 1 1 1 1 1 1
141 Sydney 42 FEMALE 34 5 116 NO NO 4 86000 NO NO NONE 0 0 1 1 1 1 1
142 Sydney 40 FEMALE 52 5 116 YES YES 2 92000 YES YES BLUE 0 1 1 0 1 0 1
143 Sydney 38 FEMALE 51 5 184 NO NO 4 105000 YES YES SILVER 0 1 1 1 1 0 1
144 Sydney 35 FEMALE 43 3 117 YES YES 4 59000 NO NO NONE 0 1 0 1 1 1 1
145 Sydney 48 FEMALE 33 4 123 NO NO 3 57000 NO NO NONE 1 1 1 1 1 0 0
146 Sydney 42 FEMALE 57 3 112 NO YES 4 29000 NO NO NONE 0 1 0 0 0 0 1
147 Sydney 39 FEMALE 30 5 79 NO YES 2 87000 NO NO NONE 1 1 1 1 1 1 1
148 Sydney 31 FEMALE 44 5 155 NO YES 4 59000 NO NO NONE 0 1 1 1 1 1 1
149 Sydney 36 FEMALE 48 3 95 NO NO 4 73000 NO NO NONE 0 1 1 1 1 1 0
150 Sydney 41 MALE 46 6 89 YES YES 2 86000 YES NO NONE 1 0 0 0 0 1 0
151 Sydney 17 MALE 50 4 114 YES YES 3 71000 NO NO NONE 1 0 0 1 1 1 0
152 Sydney 27 MALE 56 3 74 NO YES 5 64000 NO NO NONE 1 1 0 1 0 1 0
153 Sydney 25 MALE 47 5 113 NO NO 2 82000 YES NO NONE 1 1 0 0 0 1 0
154 Sydney 26 FEMALE 45 6 93 NO NO 4 51000 NO NO NONE 0 1 0 0 0 1 1
155 Sydney 27 FEMALE 32 5 115 YES YES 3 32000 NO NO NONE 0 1 1 1 1 1 1
156 Sydney 25 MALE 41 4 113 NO YES 3 99000 NO NO NONE 1 1 0 1 0 0 0
157 Sydney 38 MALE 39 5 167 NO NO 3 71000 NO NO NONE 1 0 0 1 0 1 0
158 Sydney 26 FEMALE 46 2 101 YES YES 4 89000 NO NO NONE 0 1 1 0 1 0 1
159 Sydney 30 FEMALE 31 4 152 YES YES 4 70000 NO NO NONE 0 1 1 1 1 0 0
160 Sydney 31 MALE 47 5 106 YES YES 5 87000 YES YES BLUE 1 1 0 1 1 1 0
161 Sydney 26 MALE 46 3 113 NO YES 4 15000 NO NO NONE 1 1 1 0 1 1 0
162 Sydney 37 MALE 58 4 139 NO NO 3 86000 NO NO NONE 1 1 0 1 0 1 1
163 Sydney 25 FEMALE 40 5 152 NO YES 2 56000 YES NO NONE 0 1 1 0 0 0 1
164 Sydney 25 MALE 42 3 142 NO NO 3 62000 NO NO NONE 1 1 0 1 0 0 0
165 Sydney 32 FEMALE 50 4 92 NO NO 3 52000 YES YES PLATINUM 0 1 1 1 1 0 1
166 Sydney 29 FEMALE 39 5 129 YES YES 4 89000 NO NO NONE 1 1 1 1 1 0 1
167 Sydney 26 MALE 57 5 130 NO NO 4 92000 NO NO NONE 1 0 0 1 1 0 0
168 Sydney 28 FEMALE 46 3 115 NO YES 2 57000 NO NO NONE 0 1 1 1 1 1 1
169 Sydney 27 MALE 61 3 116 NO YES 2 56000 YES NO NONE 1 0 0 1 1 1 0
170 Sydney 35 MALE 36 3 126 NO YES 3 72000 YES YES PLATINUM 1 1 1 0 1 0 0
171 Sydney 29 MALE 57 5 114 NO NO 4 62000 NO NO NONE 1 1 0 1 0 1 0
172 Sydney 29 FEMALE 44 4 90 NO NO 5 104000 YES NO NONE 0 1 0 1 1 1 1
173 Sydney 36 FEMALE 48 5 141 NO YES 5 66000 YES NO NONE 0 0 1 1 1 0 1
174 Sydney 29 FEMALE 52 5 135 NO NO 3 83000 YES YES BLUE 0 1 1 1 1 1 0
175 Sydney 30 FEMALE 37 7 90 NO NO 4 106000 YES YES BLUE 0 1 1 0 1 1 1
176 Sydney 21 FEMALE 44 4 94 NO NO 4 91000 NO NO NONE 1 1 1 0 1 1 0
177 Sydney 28 MALE 41 4 150 YES YES 2 76000 YES NO NONE 1 0 0 0 1 1 0
178 Sydney 30 FEMALE 47 4 148 NO NO 4 76000 YES NO NONE 0 1 0 0 1 1 0
179 Sydney 26 FEMALE 49 4 135 YES YES 3 51000 YES YES BLUE 0 1 1 1 0 1 0
180 Sydney 22 FEMALE 50 5 154 YES YES 2 71000 NO NO NONE 0 1 0 1 1 1 1
181 Sydney 30 FEMALE 35 3 96 YES YES 3 82000 NO NO NONE 0 1 0 1 1 0 1
182 Sydney 25 MALE 39 6 123 NO YES 2 112000 YES NO NONE 1 1 0 0 1 1 0
183 Sydney 28 FEMALE 34 5 135 NO YES 3 58000 NO NO NONE 0 1 1 1 1 0 1
184 Sydney 35 FEMALE 45 5 125 YES YES 4 39000 NO NO NONE 0 1 1 1 1 0 1
185 Sydney 31 MALE 29 4 143 NO NO 4 38000 NO NO NONE 1 0 0 1 0 1 1
186 Sydney 34 MALE 48 3 89 NO YES 2 104000 NO NO NONE 1 1 1 0 0 1 0
187 Sydney 21 MALE 34 5 137 NO YES 3 59000 NO NO NONE 1 1 0 1 0 1 0
188 Sydney 31 MALE 66 5 123 YES YES 4 38000 NO NO NONE 1 1 0 1 1 0 0
189 Sydney 28 FEMALE 47 4 117 NO YES 4 86000 NO NO NONE 0 1 1 1 0 1 0
190 Sydney 27 FEMALE 19 1 121 NO YES 5 84000 YES NO NONE 0 1 1 1 1 0 0
191 Sydney 30 FEMALE 46 6 74 NO YES 4 65000 NO NO NONE 0 1 1 1 0 1 1
192 Sydney 16 FEMALE 67 4 112 NO YES 3 36000 YES YES PLATINUM 0 1 1 0 1 0 1
193 Sydney 29 MALE 66 7 85 NO NO 3 73000 YES YES BLUE 0 0 0 1 0 1 0
194 Sydney 31 FEMALE 49 4 125 NO YES 4 39000 YES NO NONE 0 1 1 1 1 1 1
195 Sydney 27 FEMALE 44 5 108 NO YES 4 72000 YES YES BLUE 0 1 1 1 1 0 0
196 Sydney 35 FEMALE 47 5 98 NO YES 5 41000 NO NO NONE 0 1 1 1 1 0 0
197 Sydney 34 FEMALE 46 4 91 YES YES 4 111000 NO NO NONE 0 1 1 1 1 1 0
198 Sydney 25 MALE 49 5 103 NO YES 6 48000 NO NO NONE 1 0 0 0 1 1 0
199 Sydney 26 FEMALE 40 3 98 NO YES 3 63000 YES NO NONE 0 1 1 1 1 1 1
200 Sydney 32 MALE 37 4 122 NO NO 4 82000 YES YES SILVER 0 1 1 1 1 1 0
201 Perth 31 FEMALE 27 2 109 NO YES 2 64000 NO NO NONE 0 1 1 1 0 1 0
202 Perth 42 FEMALE 31 3 90 NO YES 4 71000 NO NO NONE 0 1 1 0 1 0 1
203 Perth 28 FEMALE 27 2 85 NO NO 5 46000 YES NO NONE 1 1 1 1 1 1 1
204 Perth 37 FEMALE 37 1 107 NO YES 3 73000 NO NO NONE 1 1 0 1 0 1 0
205 Perth 29 MALE 33 2 95 NO YES 4 60000 NO NO NONE 0 1 0 1 0 0 0
206 Perth 36 MALE 32 3 94 YES YES 5 52000 YES NO NONE 1 0 0 1 0 0 0
207 Perth 26 FEMALE 21 2 83 NO YES 3 75000 NO NO NONE 0 0 1 1 1 0 1
208 Perth 29 FEMALE 28 3 97 NO YES 3 82000 NO NO NONE 0 1 1 1 1 1 0
209 Perth 44 MALE 27 3 107 YES YES 4 61000 NO NO NONE 0 0 0 1 0 1 0
210 Perth 34 FEMALE 31 3 121 NO NO 3 61000 NO NO NONE 0 1 1 1 1 0 0
211 Perth 26 FEMALE 30 2 96 NO NO 4 44000 YES NO NONE 0 1 0 1 1 1 1
212 Perth 38 FEMALE 25 2 96 NO YES 3 67000 NO NO NONE 0 1 1 1 0 0 1
213 Perth 37 MALE 28 2 88 NO NO 3 91000 NO NO NONE 1 0 0 1 0 1 1
214 Perth 42 MALE 38 2 57 NO YES 5 79000 YES YES SILVER 1 0 1 0 0 1 0
215 Perth 39 FEMALE 25 3 68 NO YES 3 52000 NO NO NONE 0 1 0 0 1 1 1
216 Perth 43 MALE 25 2 79 YES YES 4 81000 NO NO NONE 0 0 0 1 0 1 1
217 Perth 31 FEMALE 27 2 90 YES YES 6 79000 NO NO NONE 0 1 1 0 1 1 1
218 Perth 39 MALE 30 3 69 NO YES 4 78000 YES YES BLUE 0 0 0 1 0 1 0
219 Perth 41 MALE 33 4 98 NO NO 2 89000 YES NO NONE 1 1 0 1 1 1 0
220 Perth 31 FEMALE 33 3 98 NO NO 4 66000 NO NO NONE 0 1 1 1 1 1 0
221 Perth 35 FEMALE 33 2 77 NO NO 4 75000 NO NO NONE 0 1 1 1 1 1 0
222 Perth 30 FEMALE 36 2 102 YES YES 5 23000 NO NO NONE 0 1 1 1 1 0 0
223 Perth 22 MALE 28 2 57 NO YES 4 38000 YES NO NONE 1 1 0 1 0 0 0
224 Perth 41 FEMALE 31 2 106 YES YES 4 91000 YES YES BLUE 0 1 1 1 1 1 1
225 Perth 35 FEMALE 31 4 105 NO YES 3 67000 NO NO NONE 1 1 0 1 1 1 1
226 Perth 39 MALE 34 1 110 YES YES 2 45000 YES YES SILVER 1 0 1 1 0 1 0
227 Perth 35 FEMALE 30 1 57 NO YES 4 39000 NO NO NONE 0 1 1 1 0 0 1
228 Perth 35 FEMALE 28 3 55 YES YES 4 79000 NO NO NONE 0 1 1 1 1 1 1
229 Perth 33 MALE 30 3 106 NO YES 3 48000 NO NO NONE 1 0 0 1 0 0 0
230 Perth 42 FEMALE 24 3 110 NO YES 5 62000 NO NO NONE 0 0 1 1 0 0 0
231 Perth 40 FEMALE 35 3 82 YES YES 4 75000 NO NO NONE 0 1 1 1 1 0 0
232 Perth 34 FEMALE 31 3 64 NO YES 3 34000 YES NO NONE 0 1 0 1 1 0 1
233 Perth 24 MALE 24 2 114 NO YES 4 32000 NO NO NONE 1 0 0 1 0 1 0
234 Perth 28 MALE 37 1 65 NO NO 2 68000 NO NO NONE 1 1 0 1 1 1 0
235 Perth 33 MALE 33 3 80 NO YES 1 89000 NO NO NONE 1 1 0 0 0 0 0
236 Perth 34 FEMALE 28 2 107 NO NO 3 65000 NO NO NONE 0 1 0 1 1 1 1
237 Perth 28 MALE 41 2 91 NO NO 4 73000 NO NO NONE 1 0 1 1 1 0 0
238 Perth 44 MALE 39 3 79 NO NO 3 70000 NO NO NONE 1 1 0 1 0 0 1
239 Perth 31 FEMALE 30 3 69 NO NO 4 48000 NO NO NONE 0 1 1 1 1 1 1
240 Perth 32 MALE 33 2 76 NO NO 6 85000 YES NO NONE 1 0 0 1 0 0 0
241 Perth 34 MALE 36 1 82 NO NO 3 52000 NO NO NONE 1 1 0 0 1 1 0
242 Perth 31 MALE 30 2 123 NO YES 3 74000 YES YES PLATINUM 1 1 1 1 0 1 0
243 Perth 24 MALE 33 1 85 NO NO 4 72000 NO NO NONE 1 1 0 1 0 0 0
244 Perth 27 FEMALE 31 3 67 NO YES 3 42000 YES NO NONE 0 1 1 0 0 1 0
245 Perth 33 FEMALE 29 3 101 NO YES 2 77000 NO NO NONE 0 1 1 1 0 1 0
246 Perth 33 FEMALE 27 2 109 NO NO 3 93000 NO NO NONE 0 1 1 0 1 1 0
247 Perth 25 FEMALE 25 3 104 NO YES 4 89000 YES NO NONE 1 1 1 1 0 0 1
248 Perth 36 MALE 29 2 71 YES YES 5 63000 NO NO NONE 1 1 0 1 0 0 0
249 Perth 44 MALE 36 3 114 NO NO 4 45000 NO NO NONE 1 1 0 1 0 0 1
250 Perth 38 FEMALE 29 3 111 NO YES 4 65000 NO NO NONE 0 1 1 1 1 0 0
251 Perth 44 FEMALE 32 2 69 NO YES 3 109000 NO NO NONE 0 1 1 1 1 1 0
252 Perth 42 FEMALE 30 3 101 NO NO 4 56000 NO NO NONE 1 1 1 1 0 1 1
253 Perth 36 FEMALE 39 4 101 YES YES 4 49000 NO NO NONE 0 1 1 1 1 0 0
254 Perth 32 MALE 33 3 99 YES YES 3 73000 NO NO NONE 0 0 0 1 1 1 0
255 Perth 36 MALE 29 3 91 NO YES 3 88000 NO NO NONE 1 1 0 1 1 1 0
256 Perth 36 MALE 33 3 92 NO YES 3 116000 YES YES BLUE 1 0 0 1 0 0 0
257 Perth 34 FEMALE 30 3 123 NO NO 3 112000 NO NO NONE 0 1 0 1 1 1 0
258 Perth 34 FEMALE 32 2 60 NO YES 5 70000 NO NO NONE 0 1 1 1 1 0 1
259 Perth 41 FEMALE 22 1 128 NO YES 4 58000 YES YES BLUE 0 1 1 1 1 0 1
260 Perth 47 FEMALE 35 2 73 NO YES 4 76000 YES YES SILVER 0 1 1 1 1 1 0
261 Perth 36 MALE 28 3 78 NO YES 5 79000 YES NO NONE 0 0 0 1 0 0 1
262 Perth 32 FEMALE 32 2 82 YES YES 3 66000 NO NO NONE 0 0 1 1 1 0 1
263 Perth 35 MALE 28 4 90 NO YES 3 73000 NO NO NONE 1 0 0 1 0 0 0
264 Perth 37 FEMALE 27 3 129 NO NO 2 52000 YES NO NONE 0 1 1 1 0 1 1
265 Perth 44 FEMALE 30 2 85 NO YES 2 75000 YES YES PLATINUM 0 1 1 0 1 1 1
266 Perth 51 FEMALE 23 3 75 NO NO 5 115000 YES NO NONE 0 1 0 1 1 1 1
267 Perth 45 FEMALE 26 1 70 NO NO 5 57000 NO NO NONE 0 1 1 1 1 1 0
268 Perth 40 MALE 36 4 68 YES YES 3 109000 NO NO NONE 1 0 0 1 0 0 1
269 Perth 45 MALE 38 3 95 NO NO 4 36000 YES YES BLUE 1 1 0 1 0 1 1
270 Perth 40 MALE 29 2 51 NO YES 3 91000 NO NO NONE 1 1 0 1 1 1 0
271 Perth 37 MALE 32 4 109 YES YES 3 87000 YES YES SILVER 1 1 0 1 0 1 0
272 Perth 34 FEMALE 19 4 80 NO YES 4 104000 NO NO NONE 0 1 1 1 1 1 0
273 Perth 39 FEMALE 35 2 72 YES YES 2 65000 NO NO NONE 0 1 1 1 1 1 0
274 Perth 51 FEMALE 32 3 79 NO YES 4 81000 NO NO NONE 0 1 1 1 1 1 1
275 Perth 39 FEMALE 23 3 94 NO YES 4 63000 NO NO NONE 0 1 1 1 1 1 1
276 Perth 47 FEMALE 26 2 91 NO YES 3 83000 YES YES SILVER 1 1 1 1 1 1 1
277 Perth 47 MALE 27 3 104 NO YES 4 77000 NO NO NONE 1 1 0 1 0 1 0
278 Perth 41 FEMALE 30 1 102 NO NO 3 82000 NO NO NONE 0 1 1 1 1 1 1
279 Perth 47 MALE 31 2 101 NO YES 4 47000 NO NO NONE 0 1 1 1 1 1 0
280 Perth 44 MALE 36 2 79 NO YES 3 83000 NO NO NONE 1 0 0 0 1 1 0
281 Perth 45 MALE 29 3 85 NO NO 3 69000 YES NO NONE 1 0 0 0 1 1 0
282 Perth 40 FEMALE 27 3 130 NO YES 4 56000 NO NO NONE 0 1 1 1 0 1 0
283 Perth 37 FEMALE 34 2 107 NO NO 5 71000 NO NO NONE 0 1 1 0 1 0 1
284 Perth 34 MALE 27 3 109 NO NO 3 59000 NO NO NONE 1 0 0 1 1 0 0
285 Perth 29 FEMALE 25 2 72 NO NO 3 80000 NO NO NONE 0 1 0 0 1 1 0
286 Perth 32 MALE 30 3 87 NO NO 4 50000 NO NO NONE 1 1 0 1 0 1 0
287 Perth 36 FEMALE 28 2 88 NO YES 4 75000 NO NO NONE 0 1 1 0 1 1 0
288 Perth 37 MALE 35 3 145 YES YES 3 58000 NO NO NONE 1 1 1 1 0 1 0
289 Perth 51 MALE 18 3 70 NO NO 3 72000 NO NO NONE 1 0 1 1 0 0 1
290 Perth 37 FEMALE 37 2 74 YES YES 3 112000 NO NO NONE 0 1 1 1 1 0 0
291 Perth 37 FEMALE 28 4 59 NO YES 4 55000 YES NO NONE 0 1 1 1 1 1 1
292 Perth 46 FEMALE 25 5 106 YES YES 2 60000 NO NO NONE 0 0 1 0 1 0 0
293 Perth 37 FEMALE 29 2 110 YES YES 5 12000 NO NO NONE 0 1 1 1 1 1 1
294 Perth 60 FEMALE 27 4 112 NO YES 2 110000 NO NO NONE 0 1 0 0 1 1 0
295 Perth 46 MALE 28 2 62 YES YES 5 66000 NO NO NONE 1 1 0 1 1 0 0
296 Perth 39 MALE 36 3 58 YES YES 3 62000 NO NO NONE 1 0 0 1 0 0 0
297 Perth 41 FEMALE 33 2 87 NO YES 2 82000 NO NO NONE 0 1 0 1 1 1 1
298 Perth 44 FEMALE 27 2 90 NO NO 3 102000 NO NO NONE 0 0 1 1 0 0 1
299 Perth 37 FEMALE 23 2 82 NO YES 6 83000 NO NO NONE 0 1 1 0 1 1 0
300 Perth 33 FEMALE 26 1 124 NO NO 2 85000 YES NO NONE 0 1 1 0 1 1 1

Working

Results