faculty of business, design and information technology

profilerupali
Ass_4_Assignment_120202.xlsx

Excel Assignment

Excel Assignment
Faculty of Business, Design and Information Technology
Higher Education
BAC105 & BEX 103
Business Maths and Statistics
Semester 2 2020
Due Date Sunday May 10th 11pm
Task 1 24 marks
Task 2 18 marks
Task 3 18 marks
Task 4 20 marks
Task 5 20 marks
Total 100 marks (15%)

All work is to be included in the each of the Data Sheets Learning Outcomes for Assessement_4_Assignment 1. Examine the role of statistics in business and utilise a range of analytical tools to provide mathematical and statistical solutions to business problems 2. Perform percentage adjustments to common commercial situations including depreciation calculations and those requiring algebraic manipulation of formulae 3. Plot and interpret straight line graphs, apply them to business decision-making and discuss the significant features of non-linear graphs 4. Demonstrate correct usage of measures of central tendency and measures of dispersion to describe data and perform analysis of data based on the results of these measures 5. Use measures of association to evaluate statistical relationships between different factors and determine the validity of these results 6. Apply probability calculations and normal distribution techniques to calculate probabilities for business scenarios

Task 1

July 1 2018 to June 2019 Marks
Total Sales/Income (including GST) $ 15,936,300.00
GST to ATO 0.5
Income excluding GST 0.5
Cost Price (with Mark Up 47.45%) 0.5
Income excluding Cost Price 0.5
Depreciation of Assets for the year (See Text Box 1) 0.5
Income excluding Depreciation 0.5
Salaries (See Text Box 2) 0.5
Income excluding Salaries 0.5
Donations to Charities $ 650,000.00
Income excluding Donations 0.5
Insurance, Rates, Telephones etc $ 35,000.00
Income excluding Insurance, Rates, Telephones etc 0.5
Car Leasing $ 400,000.00
Income excluding Car Leasing 0.5
Profit Before Company Tax 0.5
Company Tax 0.5
Profit After Company Tax 0.5
PAYE Tax for 6 staff Members each earning $75500 0.5
PAYE Tax for 3staff Members earning $82000 0.5
Total Tax to be paid to the ATO by this company 2.0
10 marks
Part 2 Break Even Graph
4 marks Graph
Part 3 Using Fx function (6marks)
2marks
2marks
2marks
Part 4 Using an appropriate formula (4 marks)
2marks
2marks

Text Box 1 Open book value of assets July 1 2019 valued at $256,000 to be depreciated at 3.15% using Dimishing Value Method.

You are to complete Column B to determine the final Profit(or Loss) for this company before and after company tax. It is important the you use Excel for ALL of the calculation You are also to determine the total amount of Tax which this company has to pay to the ATO for the financial year 17/18

Text Box 2 6 Staff members earn $75500 each and 3 staff members earn $82000 each. Also determine the amount of PAYE tax that will need to be paid to the ATO

What is the Future Value of payments of $32000 compounded monthly for 3.5 years at 5.3% per annum?

How much can you borrow today if you can make fortnightly repayments of $160 for the next 4 years at 5.55% compounded forthnightly ?

How much will you need to save quarterly to have $39,000 in the next 4.5 years at 3.9% compounded quarterly?

Determine the value of assets after 17 years originally worth $205,000 with diminishing value depreciated at 3.3% per annum

Determine the original value of assets 9 years ago which are worth $80,000 today with diminishing value depreciated at 11.3% per annum

HolmesGrove University hires a juice making machine for Orientation Week. The machine costs $80 a day to hire and the machine operator and server are paid $150 each a day. The fruit, and other ingredients for one serve cost $1.10 and the paper cup is .10c each. A juice is sold for $3.50. Determine the Daily Break Even Point for the number of Daily Juice serves (show formula below) and produce an appropriate and professional Break Even Point Graph for Daily Juice serves (show graph in box to the right). Please include your working for the Simple Equation Below:

Task 2

Gender Student Status Employment Status Exercise Frequency
1 Female 1 Full Time 1 Full Time 1 More than Twice a Week
2 Male 2 Part Time 2 Part Time 2 Once a Week
3 Non Binary 3 Casual 3 Less Often than Once a Week
4 Student
5 Volunteer
6 Carer
7 Home Duties
8 Unemployed
9 N/A
ID Gender Age Student Status Years of Ed Employment Status Total Income Exercise Frequency Weekly Take Away Coffee Expense
1 2 20 1 10 1 $50,000.00 3 $26.00
2 3 50 1 8 1 $5,000.00 3 $15.00
4 1 38 1 12 1 $10,000.00 3 $19.00
6 1 27 1 11 1 $24,020.00 3 $8.00
7 1 46 1 9 4 $50,000.00 3 $10.00
10 1 41 1 7 1 $5,000.00 3 $21.00
11 1 51 1 7 9 $5,000.00 3 $10.00
12 1 90 1 12 5 $5,000.00 2 $10.00
13 1 21 1 9 1 $50,000.00 2 $15.00
14 1 33 1 10 1 $50,000.00 2 $15.00
16 2 19 1 10 1 $8,117.00 2 $23.00
17 1 57 1 12 1 $55,000.00 2 $27.00
19 2 22 1 16 6 $3,988.00 2 $10.00
20 1 37 1 11 1 $12,000.00 2 $15.00
23 1 41 1 9 1 $50,000.00 2 $15.00
28 1 33 1 12 1 $20,000.00 2 $18.00
30 2 24 1 10 1 $13,500.00 2 $30.00
31 1 60 1 16 1 $28,750.00 2 $17.00
32 1 42 1 8 1 $5,000.00 2 $22.00
33 1 33 1 10 1 $20,600.00 2 $19.00
38 1 18 1 11 1 $8,000.00 2 $26.00
39 1 55 1 9 1 $50,000.00 2 $15.00
40 1 32 1 16 1 $28,000.00 3 $11.00
41 1 32 1 12 2 $17,320.00 3 $24.00
42 1 40 1 12 1 $25,500.00 3 $26.00
45 1 20 1 13 6 $2,860.00 3 $10.00
48 1 35 1 8 1 $5,000.00 3 $19.00
49 2 20 1 12 1 $7,500.00 3 $13.00
51 1 33 1 10 1 $22,000.00 3 $21.00
54 1 26 1 13 1 $30,000.00 3 $26.00
55 2 22 1 15 1 $22,000.00 3 $20.00
56 1 30 1 10 1 $26,934.00 3 $18.00
57 1 36 1 9 1 $50,000.00 1 $20.00
59 1 25 1 13 1 $28,000.00 1 $20.00
61 2 42 1 16 1 $24,780.00 1 $16.00
65 1 28 1 11 1 $15,000.00 1 $12.00
66 1 37 1 10 3 $48,000.00 1 $23.00
67 1 33 1 16 1 $24,000.00 1 $20.00
71 1 53 1 15 5 $20,000.00 1 $10.00
72 1 29 1 16 1 $28,500.00 1 $25.00
73 1 24 1 16 1 $13,872.00 1 $26.00
74 1 40 1 8 1 $5,000.00 1 $13.00
75 1 25 1 11 1 $35,000.00 1 $21.00
76 1 38 1 10 1 $23,000.00 1 $23.00
77 1 23 1 12 1 $20,000.00 1 $22.00
78 1 52 1 8 1 $5,000.00 1 $12.00
79 1 23 1 10 1 $14,500.00 1 $22.00
80 1 25 1 16 1 $26,020.00 1 $22.00
81 2 27 1 17 1 $24,700.00 1 $24.00
82 1 38 1 11 1 $16,500.00 1 $23.00
84 3 31 1 18 1 $10,000.00 1 $20.00
85 1 28 1 16 1 $24,000.00 1 $25.00
90 2 21 1 15 1 $15,120.00 1 $17.00
92 1 34 1 10 1 $26,000.00 1 $14.00
94 1 53 1 12 1 $25,030.00 1 $26.00
95 1 33 1 10 1 $15,470.00 1 $31.00
96 2 25 1 16 1 $25,500.00 1 $17.00
97 1 22 1 14 1 $20,000.00 1 $17.00
98 1 36 1 11 1 $26,000.00 1 $23.00
99 1 31 1 10 1 $42,000.00 1 $24.00
100 1 26 1 15 1 $17,600.00 1 $17.00
101 1 28 1 11 1 $5,000.00 1 $19.00
102 1 24 1 12 1 $9,010.00 1 $19.00
107 1 66 1 8 5 $5,000.00 1 $10.00
108 2 22 1 13 1 $14,000.00 1 $18.00
109 1 30 1 11 1 $19,020.00 1 $13.00
114 1 74 1 12 5 $20,000.00 1 $10.00
115 2 76 1 6 7 $5,000.00 1 $10.00
118 1 42 1 11 1 $24,000.00 1 $16.00
121 1 33 1 11 4 $9,600.00 1 $10.00
122 1 19 1 12 1 $19,604.00 1 $21.00
123 2 31 1 12 1 $20,600.00 1 $19.00
124 1 30 1 13 3 $27,068.00 1 $20.00
125 1 35 1 17 1 $28,020.00 1 $8.00
126 3 33 1 15 1 $24,175.00 1 $27.00
128 3 32 1 10 1 $38,000.00 1 $18.00
129 1 69 1 9 5 $5,000.00 1 $10.00
136 3 57 1 15 1 $39,000.00 1 $16.00
138 1 66 1 7 5 $5,000.00 1 $10.00
139 1 39 1 14 1 $24,100.00 1 $20.00
141 1 31 1 18 1 $10,000.00 1 $9.00
142 1 39 1 6 1 $5,000.00 1 $16.00
144 2 56 1 9 7 $5,000.00 1 $10.00
146 2 54 1 18 2 $10,000.00 1 $25.00
149 1 42 1 18 1 $10,000.00 1 $20.00
150 1 49 1 11 5 $12,000.00 1 $10.00
151 1 31 1 15 1 $25,000.00 1 $9.00
153 2 55 1 11 1 $23,000.00 1 $20.00
154 2 19 1 13 6 $8,247.00 1 $10.00
155 2 29 1 17 1 $20,000.00 1 $9.00
157 3 43 1 9 1 $5,000.00 1 $17.00
159 1 27 1 9 2 $5,000.00 1 $25.00
160 2 29 1 10 3 $13,500.00 1 $17.00
164 1 27 1 12 1 $24,500.00 1 $18.00
165 2 25 1 11 1 $16,500.00 1 $16.00
166 1 70 1 17 5 $19,900.00 1 $10.00
167 2 27 1 13 1 $15,600.00 1 $30.00
168 2 21 1 11 1 $29,000.00 1 $11.00
169 1 48 1 13 1 $30,000.00 2 $19.00
170 1 30 1 9 1 $5,000.00 2 $17.00
171 1 46 1 11 1 $19,500.00 2 $29.00
172 1 78 1 5 5 $5,000.00 2 $10.00
173 1 51 1 9 3 $5,000.00 2 $18.00
174 2 53 1 7 2 $5,000.00 2 $17.00
178 1 60 1 8 5 $5,000.00 2 $10.00
179 1 37 1 16 1 $24,000.00 2 $18.00
180 1 22 1 15 1 $18,800.00 2 $25.00
181 1 37 1 14 1 $18,018.00 2 $28.00
182 3 61 1 8 1 $5,000.00 2 $31.00
184 1 46 1 10 1 $18,000.00 2 $25.00
186 1 21 1 9 4 $5,000.00 1 $10.00
188 3 33 1 10 1 $19,000.00 1 $15.00
190 1 60 1 13 1 $16,500.00 1 $14.00
192 2 41 1 10 3 $16,500.00 1 $20.00
193 1 66 1 9 5 $5,000.00 1 $10.00
194 1 26 1 14 8 $6,000.00 1 $10.00
195 1 21 1 13 2 $13,500.00 1 $27.00
196 1 42 1 18 1 $10,000.00 1 $18.00
199 1 47 1 6 1 $5,000.00 1 $23.00
200 1 35 1 11 1 $21,060.00 1 $17.00
201 1 43 1 11 1 $17,000.00 1 $24.00
202 2 71 1 16 7 $2,941.00 1 $10.00
203 2 29 1 13 1 $23,000.00 2 $19.00
204 2 31 1 16 1 $0.00 1 $24.00
208 2 41 1 14 2 $13,500.00 3 $27.00
209 2 35 1 9 1 $5,000.00 1 $17.00
210 1 22 1 10 1 $17,500.00 1 $13.00
214 1 64 1 11 5 $20,000.00 1 $10.00
216 1 68 1 6 5 $5,000.00 1 $10.00
217 2 22 1 8 7 $5,000.00 3 $10.00
219 1 57 1 14 1 $53,200.00 1 $14.00
223 1 38 1 18 1 $10,000.00 1 $25.00
224 1 22 1 16 6 $4,844.00 1 $10.00
225 2 45 1 9 1 $5,000.00 1 $14.00
226 2 49 1 7 1 $5,000.00 1 $11.00
227 2 51 1 18 1 $10,000.00 3 $24.00
228 2 59 1 10 5 $12,000.00 1 $10.00
230 2 20 1 13 1 $10,880.00 3 $24.00
231 2 19 1 11 1 $5,000.00 3 $25.00
232 2 25 1 11 2 $7,000.00 1 $18.00
233 2 62 1 14 5 $6,124.00 1 $10.00
234 2 67 1 13 7 $4,788.00 1 $10.00
235 1 31 1 10 1 $21,000.00 1 $20.00
237 1 38 1 16 1 $35,000.00 1 $13.00
238 2 20 1 12 1 $10,700.00 3 $21.00
239 1 68 1 11 1 $45,000.00 1 $22.00
240 1 29 1 14 1 $25,400.00 1 $22.00
241 2 43 1 9 1 $5,000.00 3 $19.00
243 1 36 1 10 1 $16,276.00 1 $12.00
245 2 37 1 9 1 $5,000.00 1 $20.00
247 2 83 1 8 5 $5,000.00 1 $10.00
250 2 80 1 6 7 $5,000.00 1 $10.00
251 2 48 1 7 2 $5,000.00 1 $16.00
252 2 32 1 13 6 $10,608.00 3 $10.00
254 2 39 1 13 2 $7,020.00 1 $27.00
255 2 35 1 14 7 $1,020.00 1 $10.00
261 2 61 1 13 7 $120.00 1 $10.00
262 1 30 1 17 1 $37,000.00 1 $24.00
263 2 49 1 12 2 $12,500.00 1 $19.00
264 1 60 1 12 1 $19,312.00 1 $20.00
265 1 35 1 19 1 $10,000.00 1 $24.00
266 2 35 1 16 1 $21,000.00 2 $21.00
267 2 37 1 17 2 $2,500.00 1 $11.00
270 1 32 1 14 1 $28,000.00 1 $21.00
272 2 23 1 14 6 $6,500.00 3 $10.00
273 2 24 1 12 8 $8,512.00 3 $10.00
276 1 68 1 9 5 $5,000.00 2 $10.00
278 2 66 1 9 7 $5,000.00 1 $10.00
279 1 73 1 10 5 $2,995.00 1 $10.00
280 2 30 1 15 7 $200.00 1 $10.00
281 2 26 1 11 1 $20,900.00 3 $23.00
282 2 34 1 10 7 $5,300.00 1 $10.00
283 1 37 1 11 1 $16,000.00 1 $17.00
284 2 40 1 8 2 $5,000.00 1 $15.00
285 2 26 1 10 1 $14,700.00 1 $25.00
286 2 40 1 10 2 $25,000.00 1 $16.00
287 2 20 1 12 3 $10,525.00 1 $23.00
288 2 69 1 8 7 $5,000.00 1 $10.00
290 2 75 1 7 7 $5,000.00 1 $10.00
291 2 26 1 12 4 $3,060.00 1 $10.00
292 2 77 1 9 7 $5,000.00 1 $10.00
293 2 23 1 11 1 $13,000.00 3 $21.00
295 1 56 1 6 5 $5,000.00 1 $10.00
296 2 35 1 16 1 $10,000.00 3 $20.00
298 2 54 1 10 1 $25,000.00 3 $21.00
299 1 59 1 9 4 $5,000.00 1 $10.00
300 2 56 1 9 7 $5,000.00 1 $10.00
301 2 38 1 9 7 $5,000.00 3 $10.00
302 2 39 1 12 7 $2,060.00 1 $10.00
305 2 56 1 6 7 $5,000.00 1 $10.00
308 1 80 1 17 5 $4,358.00 2 $10.00
309 2 21 1 12 1 $28,000.00 3 $21.00
310 2 64 1 12 5 $14,050.00 3 $10.00
311 2 61 1 9 5 $5,000.00 3 $10.00
314 2 56 1 7 7 $5,000.00 1 $10.00
315 2 54 1 11 7 $4,680.00 1 $10.00
316 2 38 1 17 2 $0.00 1 $26.00
317 2 21 1 14 4 $1,360.00 1 $10.00
318 2 60 1 6 5 $5,000.00 1 $10.00
319 2 42 1 9 7 $5,000.00 1 $10.00
320 1 32 1 12 1 $26,000.00 1 $23.00
322 2 55 1 8 7 $50,000.00 2 $10.00
324 2 58 1 10 7 $12,000.00 1 $10.00
327 2 35 1 12 7 $1,456.00 1 $10.00
328 2 50 1 8 3 $50,000.00 1 $22.00
329 2 21 1 12 1 $3,262.00 1 $16.00
330 2 47 1 9 1 $5,000.00 3 $22.00
331 1 62 1 8 5 $50,000.00 2 $10.00
333 2 59 1 8 3 $50,000.00 1 $19.00
334 2 57 1 9 7 $5,000.00 1 $10.00
336 3 34 1 8 7 $50,000.00 1 $10.00
338 2 99 1 6 1 $5,000.00 1 $17.00
341 1 34 1 7 2 $5,000.00 1 $16.00
342 2 71 1 17 7 $2,995.00 1 $10.00
343 3 47 1 10 8 $19,300.00 1 $10.00
344 2 25 1 10 7 $6,000.00 1 $10.00
345 2 62 1 6 7 $5,000.00 1 $10.00
347 2 43 1 9 7 $5,000.00 1 $10.00
349 2 32 1 9 8 $5,045.00 1 $10.00
350 3 29 1 10 7 $4,346.00 1 $10.00
351 2 56 1 8 7 $50,000.00 1 $10.00
352 2 41 1 10 7 $15,000.00 1 $10.00
354 2 30 1 10 2 $1,400.00 1 $19.00
357 2 56 1 17 7 $5,148.00 1 $10.00
359 1 75 1 10 5 $4,900.00 1 $10.00
360 2 35 1 9 6 $1,456.00 1 $10.00
361 2 26 1 10 7 $5,561.00 1 $10.00
362 2 67 1 17 2 $5,788.00 1 $32.00
363 2 28 1 10 7 $4,346.00 1 $10.00
364 2 35 1 9 7 $1,456.00 1 $10.00
365 2 54 1 9 2 $4,200.00 3 $22.00
368 2 31 1 12 7 $8,000.00 3 $10.00
369 2 29 1 12 7 $7,100.00 1 $10.00
371 1 52 1 7 8 $5,000.00 1 $10.00
372 2 53 1 18 7 $10,000.00 1 $10.00
373 2 35 1 16 7 $4,019.00 1 $10.00
374 2 45 1 12 2 $30,000.00 1 $23.00
375 2 53 1 9 7 $8,500.00 1 $10.00
376 2 48 1 8 7 $50,000.00 1 $10.00
378 2 24 1 17 1 $16,640.00 2 $20.00
379 2 73 1 12 6 $20,000.00 2 $10.00
381 2 33 1 11 2 $6,923.00 3 $17.00
383 2 41 1 13 2 $6,480.00 1 $31.00
385 2 31 1 10 7 $648.00 1 $10.00
387 2 46 1 10 9 $7,500.00 3 $10.00
388 1 69 1 6 5 $5,000.00 1 $10.00
391 2 78 1 10 5 $17,100.00 3 $10.00
392 2 58 1 11 8 $12,000.00 1 $10.00
394 2 47 1 6 6 $5,000.00 1 $10.00
395 2 27 1 9 7 $10,000.00 1 $10.00
396 2 58 1 8 7 $50,000.00 2 $10.00
398 2 42 1 9 2 $2,444.00 1 $21.00
399 1 35 1 13 1 $41,000.00 1 $22.00
400 2 41 1 9 7 $2,160.00 1 $10.00
401 2 26 1 13 7 $624.00 1 $10.00
403 2 33 1 17 7 $5,300.00 3 $10.00
404 2 32 1 8 7 $50,000.00 1 $10.00
405 2 29 1 17 7 $0.00 1 $10.00
406 1 33 1 10 1 $19,000.00 1 $22.00
408 2 75 1 17 5 $4,900.00 3 $10.00
409 1 76 1 18 5 $5,780.00 1 $10.00
410 2 24 1 13 7 $6,000.00 3 $10.00
412 2 23 1 10 2 $8,000.00 3 $16.00
413 2 34 1 11 7 $5,300.00 2 $10.00
414 2 28 1 10 7 $4,346.00 1 $10.00
418 2 54 1 6 7 $5,000.00 1 $10.00
420 2 26 1 10 2 $5,000.00 1 $15.00
421 2 30 1 16 7 $0.00 1 $10.00
423 2 79 1 5 7 $5,000.00 1 $10.00
424 2 29 1 15 2 $4,800.00 3 $25.00
425 2 51 1 10 7 $10,000.00 1 $10.00
426 2 46 1 13 7 $500.00 1 $10.00
427 2 44 1 13 9 $11,000.00 1 $10.00
428 2 29 1 11 7 $6,812.00 3 $10.00
429 2 36 1 10 7 $12,460.00 1 $10.00
430 2 22 1 11 7 $7,000.00 1 $10.00
431 2 50 1 18 7 $4,000.00 1 $10.00
432 2 22 1 11 7 $7,000.00 1 $10.00
433 2 41 1 10 2 $3,840.00 1 $12.00
435 2 22 1 10 7 $7,000.00 1 $10.00
436 2 43 1 9 7 $5,000.00 3 $10.00
437 2 34 1 9 2 $154.00 1 $17.00
439 2 29 1 11 7 $50.00 1 $10.00
440 2 61 1 18 2 $5,006.00 1 $19.00
441 2 30 1 9 7 $10,000.00 1 $10.00
442 2 36 1 11 7 $12,460.00 2 $10.00
443 2 31 1 8 7 $50,000.00 1 $10.00
444 3 99 1 18 7 $5,044.00 1 $10.00
3 2 45 2 16 7 $3,500.00 1 $10.00
5 1 19 2 11 1 $10,000.00 1 $22.00
8 3 23 2 12 4 $4,000.00 2 $10.00
9 1 40 2 12 3 $50,000.00 1 $15.00
15 1 54 2 13 1 $25,000.00 1 $22.00
18 2 32 2 10 1 $16,500.00 1 $26.00
21 1 61 2 8 4 $5,000.00 3 $10.00
22 1 64 2 12 5 $16,100.00 3 $10.00
24 1 30 2 9 1 $50,000.00 3 $18.00
25 1 29 2 14 1 $24,000.00 3 $24.00
26 1 30 2 10 1 $95,000.00 3 $24.00
27 2 22 2 14 1 $12,600.00 3 $15.00
29 1 51 2 13 1 $24,000.00 3 $19.00
34 1 46 2 12 1 $50,000.00 3 $25.00
35 1 19 2 11 1 $12,000.00 3 $24.00
36 2 22 2 13 1 $10,660.00 3 $22.00
37 1 38 2 17 1 $66,000.00 3 $13.00
43 1 49 2 5 1 $5,000.00 3 $15.00
44 1 20 2 8 4 $5,000.00 3 $10.00
46 2 22 2 13 8 $4,082.00 3 $10.00
47 2 23 2 11 1 $18,300.00 3 $30.00
50 1 47 2 17 1 $56,200.00 1 $17.00
52 3 20 2 10 1 $13,000.00 1 $21.00
53 1 32 2 15 2 $5,338.00 1 $22.00
58 1 30 2 15 1 $15,600.00 1 $23.00
60 1 37 2 10 1 $68,000.00 1 $13.00
62 1 33 2 20 1 $10,000.00 1 $26.00
63 1 46 2 21 1 $10,000.00 1 $20.00
64 1 49 2 16 1 $24,500.00 1 $27.00
68 1 68 2 10 5 $6,468.00 2 $10.00
69 2 63 2 6 7 $5,000.00 3 $10.00
70 1 18 2 12 2 $50,000.00 1 $20.00
83 1 51 2 4 7 $4,899.00 1 $10.00
86 2 23 2 13 1 $14,000.00 3 $24.00
87 2 31 2 10 1 $19,700.00 1 $24.00
88 1 45 2 6 1 $5,000.00 1 $17.00
89 2 20 2 10 2 $7,000.00 1 $17.00
91 2 35 2 8 7 $5,000.00 1 $10.00
93 1 60 2 8 1 $5,000.00 1 $17.00
103 3 31 2 11 1 $21,000.00 3 $19.00
104 1 62 2 19 1 $10,000.00 1 $30.00
105 3 38 2 6 8 $5,000.00 1 $10.00
106 1 51 2 6 5 $5,000.00 1 $10.00
110 3 29 2 9 1 $5,000.00 2 $24.00
111 2 34 2 9 1 $5,000.00 1 $11.00
112 1 55 2 9 1 $5,000.00 3 $19.00
113 1 56 2 13 1 $30,300.00 3 $16.00
116 2 76 2 17 5 $8,224.00 3 $10.00
117 1 27 2 13 6 $10,000.00 3 $10.00
119 1 36 2 11 1 $15,600.00 3 $18.00
120 2 75 2 10 7 $5,616.00 3 $10.00
127 1 52 2 11 3 $25,000.00 3 $22.00
130 1 39 2 14 1 $34,615.00 3 $20.00
131 1 47 2 15 8 $65,000.00 3 $10.00
132 1 54 2 13 1 $33,514.00 3 $24.00
133 2 42 2 10 2 $750.00 3 $20.00
134 2 38 2 12 1 $11,960.00 3 $27.00
135 2 39 2 9 7 $5,000.00 3 $10.00
137 1 51 2 12 1 $20,000.00 3 $22.00
140 2 40 2 13 1 $13,500.00 3 $27.00
143 1 35 2 5 1 $5,000.00 3 $18.00
145 1 44 2 12 1 $13,000.00 3 $18.00
147 1 31 2 12 1 $19,660.00 3 $14.00
148 1 56 2 5 3 $5,000.00 3 $26.00
152 1 19 2 11 1 $538.00 3 $33.00
156 2 51 2 20 7 $10,000.00 3 $10.00
158 1 47 2 8 9 $5,000.00 3 $10.00
161 1 72 2 13 5 $2,995.00 3 $10.00
162 1 81 2 12 5 $4,680.00 3 $10.00
163 1 29 2 10 1 $19,600.00 3 $18.00
175 1 64 2 8 5 $5,000.00 3 $10.00
176 1 42 2 10 1 $20,000.00 3 $17.00
177 2 23 2 13 6 $3,224.00 3 $10.00
183 3 30 2 11 1 $12,300.00 3 $25.00
185 1 30 2 20 1 $10,000.00 3 $17.00
187 2 20 2 11 1 $13,500.00 3 $19.00
189 1 51 2 12 1 $16,500.00 3 $13.00
191 1 46 2 7 4 $5,000.00 3 $10.00
197 1 25 2 17 2 $5,000.00 3 $17.00
198 2 28 2 12 1 $25,704.00 3 $21.00
205 1 31 2 15 1 $23,930.00 3 $13.00
206 1 60 2 12 7 $50,000.00 3 $10.00
207 1 34 2 16 1 $40,000.00 3 $11.00
211 2 26 2 13 3 $2,000.00 3 $16.00
212 2 35 2 9 1 $5,000.00 3 $25.00
213 1 52 2 14 1 $27,000.00 3 $17.00
215 2 77 2 12 8 $5,780.00 3 $10.00
218 2 61 2 10 3 $10,000.00 3 $16.00
220 2 48 2 11 1 $8,060.00 3 $22.00
221 2 20 2 14 2 $3,000.00 3 $11.00
222 2 21 2 12 1 $7,268.00 3 $20.00
229 2 70 2 16 5 $5,000.00 3 $10.00
236 1 59 2 11 1 $32,205.00 3 $16.00
242 2 70 2 14 5 $5,954.00 3 $10.00
244 2 26 2 11 1 $17,700.00 3 $29.00
246 2 53 2 8 7 $5,000.00 3 $10.00
248 2 70 2 12 7 $5,954.00 3 $10.00
249 2 24 2 11 2 $4,200.00 3 $19.00
253 2 51 2 10 1 $16,360.00 3 $20.00
256 1 76 2 10 5 $5,780.00 3 $10.00
257 1 70 2 6 5 $5,000.00 3 $10.00
258 2 41 2 10 2 $3,900.00 3 $21.00
259 2 28 2 11 1 $14,714.00 3 $18.00
260 2 75 2 11 7 $4,000.00 3 $10.00
268 2 60 2 11 7 $3,380.00 3 $10.00
269 2 28 2 10 7 $5,564.00 3 $10.00
271 2 36 2 6 1 $5,000.00 3 $21.00
274 2 67 2 10 7 $5,000.00 3 $10.00
275 2 31 2 9 1 $5,000.00 3 $16.00
277 1 68 2 10 5 $16,000.00 1 $10.00
289 1 81 2 10 5 $5,292.00 1 $10.00
294 1 20 2 11 9 $5,000.00 1 $10.00
297 1 42 2 17 1 $30,000.00 1 $23.00
303 2 59 2 8 7 $5,000.00 1 $10.00
304 2 52 2 16 2 $29,700.00 1 $21.00
306 2 35 2 10 7 $1,020.00 1 $10.00
307 1 65 2 13 5 $7,722.00 1 $10.00
312 2 69 2 6 7 $5,000.00 1 $10.00
313 2 48 2 7 2 $5,000.00 1 $28.00
321 2 70 2 6 7 $5,000.00 1 $10.00
323 1 54 2 6 1 $5,000.00 1 $21.00
325 2 70 2 13 7 $4,810.00 1 $10.00
326 2 30 2 10 2 $5,000.00 1 $19.00
332 2 70 2 17 7 $8,292.00 3 $10.00
335 2 69 2 14 7 $2,652.00 3 $10.00
337 2 42 2 7 1 $5,000.00 3 $26.00
339 2 61 2 10 5 $18,888.00 3 $10.00
340 2 47 2 11 2 $6,300.00 3 $16.00
346 2 28 2 9 7 $200.00 2 $10.00
348 1 37 2 6 4 $5,000.00 2 $10.00
353 2 56 2 9 7 $3,600.00 2 $10.00
355 2 68 2 11 7 $3,978.00 2 $10.00
356 2 53 2 8 2 $50,000.00 2 $12.00
358 2 63 2 6 7 $5,000.00 2 $10.00
366 2 61 2 7 7 $5,000.00 2 $10.00
367 2 32 2 12 7 $9,600.00 2 $10.00
370 2 32 2 11 2 $11,565.00 2 $30.00
377 2 39 2 11 1 $5,000.00 2 $27.00
380 2 40 2 17 1 $11,000.00 2 $15.00
382 2 26 2 6 7 $5,000.00 2 $10.00
384 2 54 2 17 7 $7,514.00 2 $10.00
386 2 63 2 8 7 $50,000.00 2 $10.00
389 2 26 2 10 7 $624.00 2 $10.00
390 2 63 2 11 7 $7,500.00 2 $10.00
393 2 21 2 13 1 $12,948.00 2 $32.00
397 2 34 2 11 2 $7,000.00 2 $14.00
402 1 63 2 4 8 $5,720.00 2 $10.00
407 2 42 2 17 7 $5,000.00 2 $10.00
411 2 37 2 8 7 $50,000.00 2 $10.00
415 2 31 2 12 7 $6,214.00 2 $10.00
416 2 29 2 10 7 $8,160.00 2 $10.00
417 2 53 2 7 7 $5,000.00 2 $10.00
419 2 31 2 12 7 $10,608.00 2 $10.00
422 2 23 2 12 7 $6,500.00 2 $10.00
434 2 35 2 9 7 $11,000.00 2 $10.00
438 2 37 2 9 6 $12,460.00 2 $10.00

1. Create a individual Pivot Tables and a Graphs for each of the 4 Categorical Variables. Pivot tables should be formatted into percentages of Grand Total with no decimal places. Include a Graphs suitable for each of the Categorical Variables. (2marks for Pivot table (.5 marks each), 2 marks for graph(.5 marks each), (4mrks) 2. Using the Data Analysis Toolpak create a single graph for the Numeric Variables of Total Income and Weekly Take Away Coffee Expense. You will need to create appropriate 'bins' for each of these two variables. Comment on the distribution (shape) of each of these 2 variables in particular comment on the shape of the distribution reporting how the Mean, Median and Mode measures of central tendency confirm the shape of each distribution. Insert a small text box to include the comments. (2 histograms & 2 sets of Central Tendency (4mrks) and 2 statements about shape (2 marks ) (6 mrks) 3. Show the relationship with an appropriate Pivot Table and Graphs for each of the following relationships: 1. Student Status and Exercise Frequency 2. Gender and Exercise Frequency Pivot tables should be formatted to show percentages of Column Total with no decimal places. Make a brief statement about the relationship between Student Status and and Gym Visits and Gender and Gym Visits. Insert a small text box to include the comments. (2 pivot tables (1 mrks each) 2 graphs (1 mrks each) statement (1.5 marks each) (8 mrks) 18 marks

Task 3

Age Hours of Exercise/Physical Activity Score
18 10
18 15
18 15
18 15
20 15
20 15
20 15
21 15
21 15
21 15
21 15
21 16
21 17
22 17
22 18
22 19
22 19
22 19
22 19
22 19
22 19
22 19
22 19
23 19
19 20
20 20
20 20
21 20
21 20
21 20
21 20
21 20
21 20
22 20
22 20
22 20
22 20
23 20
31 20
18 21
19 21
21 21
21 21
21 21
22 21
23 21
23 21
23 21
23 21
24 21
24 21
24 21
24 21
29 21
30 21
21 22
22 22
21 23
22 23
22 23
23 23
27 23
29 23
29 23
46 23
33 24
18 25
19 25
20 25
22 25
23 25
27 25
30 25
33 25
43 29
21 30
19 33
20 33
21 33
22 33
23 33
23 33
30 33
21 34
23 35
23 35
36 35
21 36
21 36
32 37
48 37
37 38
35 39
36 39
19 40
24 40
24 40
24 40
26 40
30 40
39 40
41 40
23 41
26 41
33 41
20 42
24 42
26 42
26 42
31 42
36 42
42 42
45 42
26 43
26 43
26 43
34 43
42 43
46 43
60 43
30 44
40 44
40 44
45 44
48 44
49 44
25 45
25 45
25 45
26 45
26 45
27 45
27 45
48 45
50 45
26 46
49 46
30 47
31 47
35 47
43 47
26 48
27 48
31 48
39 48
41 48
54 48
35 49
36 49
38 49
42 49
45 49
48 49
49 49
54 49
25 50
27 50
31 50
34 50
42 50
42 50
42 50
36 51
44 51
44 51
46 51
47 51
24 52
28 52
30 52
32 52
35 52
35 52
36 52
42 52
49 52
25 53
27 53
31 53
34 53
38 53
39 53
40 53
47 53
50 53
58 53
59 53
60 53
62 53
23 54
24 54
26 54
27 54
27 54
27 54
28 54
32 54
33 54
35 54
35 54
38 54
47 54
47 54
49 54
50 54
23 55
23 55
23 55
24 55
34 55
41 55
51 55
52 55
24 56
36 56
50 56
55 56
56 56
24 57
25 57
28 57
50 57
56 57
57 57
25 58
27 58
31 58
33 58
34 58
37 58
39 58
41 58
43 58
46 58
48 58
28 59
41 59
45 59
48 59
50 59
54 59
63 59
67 59
29 60
33 60
43 60
44 60
45 60
46 60
48 60
48 60
50 60
53 60
54 60
56 60
27 61
28 61
28 61
32 61
35 61
36 61
44 61
48 61
56 61
25 62
25 62
44 62
45 62
45 62
46 62
47 62
50 62
55 62
24 63
24 63
28 63
31 63
31 63
33 63
36 63
41 63
54 63
70 63
26 64
33 64
33 64
35 64
37 64
37 64
38 64
38 64
41 64
42 64
44 64
46 64
67 64
25 65
36 65
37 65
40 65
40 65
41 65
48 65
50 65
64 65
25 66
28 66
31 66
33 66
34 66
37 66
37 66
38 66
41 66
48 66
51 66
52 66
57 66
32 67
35 67
36 67
40 67
48 67
48 67
53 67
24 68
35 68
36 68
46 68
49 68
62 68
65 68
70 68
30 69
38 69
41 69
44 69
46 69
49 69
50 69
51 69
27 70
29 70
31 70
34 70
35 70
36 70
37 70
41 70
42 70
44 70
52 70
56 70
58 70
31 71
32 71
32 71
33 71
36 71
39 71
46 71
48 71
53 71
31 72
35 72
37 72
42 72
48 72
49 72
50 72
58 72
60 72
61 72
28 73
35 73
36 73
39 73
44 73
44 73
46 73
47 73
57 73
61 73
24 74
42 74
47 74
51 74
55 74
66 74
27 75
31 75
32 75
36 75
46 75
50 75
60 75
25 76
31 76
36 76
51 76
33 77
38 77
39 77
46 77
50 78
51 78
55 78
74 78
78 78
32 79
36 79
40 79
41 79
52 79
63 79
65 79
45 80
49 80
49 80
60 80
63 80
68 80
75 80
82 80
27 81
37 81
55 81
48 82
48 82
74 82
55 83
66 83
68 83
53 84
69 85
28 86
41 86
56 86
45 88

1. You are to undertake a FULL Correlation Analysis with the appropriate graph and statistics to determine the relationship between Age and Physical Activity Score. Insert a text box to include the FULL description of the relationship. (8 marks). Please refer to the lecture notes to include all the steps entailed in a Full Correlation Analysis. The Physical Activity Score has been derived from a survey which asks respondents to record a range of activities they do on a weekly basis and a total score out of 100 was calculated for each person. Low score indicate less physical activity, high scores indicate high levels of physical activity. 2. You are to also undertake a FULL Regression Analysis with the appropriate statistics of the relationship between Age and Physical Activity Score. Insert a text box to include the full description of the analysis. (4 marks) Please refer to the lecture notes to ensure all relevant statistics and interpretations are included in the FULL Regression Analysis. 3. Predict the Physical Activity Score for a 44 year old. Comment on the reliability of this prediction. Insert a text box to include the comment. (3 marks) 3. Predict the Physical Activity Score for a 15 year old. Comment on the reliability of this prediction. Insert a text box to include the comment. (3 marks) (18 marks)

Task 4

Weekly Rent Expenditure $
$ 160.00
$ 230.00 Average Weekly Rent Expenditure
$ 150.00 Standard Deviation of Weekly Rent Expenditure
$ 160.00 0.5 mark
$ 150.00 decimal %
$ 150.00 Spend more than $150.
$ 160.00 Spend less than $175
$ 200.00 Spend between $170 and $230
$ 160.00 Spend between $130 and $180
$ 200.00
$ 230.00 Dollar amount for highest 11% of Rent Amount
$ 150.00 Dollar amount for lowest 4% of Rent Amount
$ 180.00
$ 130.00
$ 130.00
$ 150.00
$ 150.00
$ 180.00
$ 125.00
$ 230.00
$ 200.00
$ 180.00
$ 150.00
$ 150.00
$ 150.00
$ 200.00
$ 180.00
$ 200.00
$ 130.00
$ 150.00
$ 200.00
$ 150.00
$ 150.00
$ 200.00
$ 180.00
$ 125.00
$ 180.00
$ 150.00
$ 150.00
$ 150.00
$ 200.00
$ 180.00
$ 180.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 180.00
$ 150.00
$ 180.00
$ 150.00
$ 180.00
$ 130.00
$ 130.00
$ 150.00
$ 200.00
$ 150.00
$ 150.00
$ 130.00
$ 130.00
$ 120.00
$ 130.00
$ 150.00
$ 120.00
$ 150.00
$ 120.00
$ 180.00
$ 130.00
$ 130.00
$ 150.00
$ 200.00
$ 180.00
$ 120.00

Task 5

Years of Tertiary Education Recoded Years of Tertiary Education Age Category Employ Status Recommend Tertiary Education Sat 1 Sat 2 Sat 3 Sat 4 Sat 5 Sat 6 Sat 7 Sat 8 Sat 9 Sat 10 Satisfaction with Career WB1 WB2 WB3 WB4 WB5 WB6 WB7 WB8 WB9 Total Well Being
7 1 1 1 4 5 3 5 2 3 1 5 3 5 5 2 3 5 5 5 5 5 5
8 2 1 1 4 5 3 5 2 5 4 5 5 5 5 4 5 5 5 3 5 3 5
8 2 1 1 5 5 3 5 4 5 4 5 5 5 5 3 2 5 5 2 5 2 5
8 2 1 1 4 5 3 4 3 4 2 5 3 5 4 3 4 5 5 3 5 3 5
8 2 1 1 3 5 3 5 3 5 4 5 4 5 4 3 4 5 4 2 4 3 5
6 3 1 1 5 5 3 5 1 5 1 5 1 5 5 1 5 5 5 1 5 1 5
6 3 1 1 4 5 3 5 1 5 1 5 1 5 5 3 5 5 5 4 5 1 5
7 2 1 1 5 5 2 5 1 5 2 5 3 2 4 2 5 5 5 5 5 3 5
7 1 1 0 5 5 2 5 1 5 1 5 1 5 5 1 5 5 5 1 5 1 5
8 2 1 1 4 4 4 4 2 3 3 5 4 4 3 4 5 5 5 2 4 5 5
8 2 1 1 4 4 4 4 2 4 3 5 2 4 4 1 4 5 4 4 4 1 4
7 2 1 1 4 4 3 3 2 4 2 5 3 5 5 3 5 5 4 5 5 4 5
7 2 1 1 4 4 3 5 2 5 3 5 4 4 4 2 4 5 4 5 4 2 3
6 2 1 1 4 5 3 5 2 3 2 5 4 4 4 1 3 5 5 2 3 3 4
8 3 1 1 2 5 1 5 2 5 2 5 2 3 5 1 5 5 5 2 3 4 4
8 3 1 1 4 4 4 5 2 2 1 5 3 4 4 2 4 5 4 3 4 2 4
8 3 1 1 5 3 3 5 2 4 4 4 4 4 4 1 4 5 3 3 4 3 3
7 3 1 1 3 4 3 5 2 4 3 4 3 4 4 2 4 5 4 4 4 2 4
6 3 1 1 4 5 3 5 2 4 1 4 3 4 4 3 5 5 5 2 4 3 4
6 3 1 1 3 4 3 5 2 4 4 4 3 3 3 4 4 5 3 4 4 4 4
8 4 1 1 3 4 4 5 2 5 1 5 1 5 5 1 4 5 5 1 5 1 5
8 4 1 1 5 4 3 4 2 1 2 2 4 3 4 4 2 5 5 2 2 4 4
8 4 1 1 4 5 2 5 2 4 1 5 2 5 5 2 5 5 5 3 5 1 5
5 4 1 1 5 5 4 5 2 4 3 4 4 4 4 1 4 5 4 5 4 4
8 5 1 1 5 5 4 5 2 3 5 5 3 4 5 3 3 5 5 1 4 4 4
8 5 1 1 4 4 2 5 2 5 5 5 1 5 5 2 5 5 3 1 5 3 5
8 5 1 1 5 4 3 5 2 5 5 4 3 4 4 1 5 5 4 3 5 3 4
8 5 1 1 4 4 4 4 2 5 5 4 3 3 4 3 4 5 4 5 5 4 4
8 4 1 1 5 5 4 5 2 4 5 5 2 5 5 2 3 5 5 1 5 2 5
8 3 1 1 4 4 4 4 2 3 5 4 2 4 4 3 3 5 4 1 5 3 4
8 1 1 1 4 4 3 4 2 3 5 3 3 3 4 3 3 5 4 1 5 3 3
7 4 1 1 5 3 4 4 2 5 5 3 1 3 3 2 4 5 4 3 5 2 3
7 1 1 1 5 5 3 5 2 5 5 3 2 3 3 3 4 5 4 1 5 2 4
7 2 1 1 4 4 4 4 2 4 5 5 4 4 5 3 5 5 4 4 5 3 5
7 2 1 1 4 4 3 4 2 3 5 4 3 4 3 4 3 5 3 2 5 1 4
8 2 1 1 3 4 2 5 3 3 5 4 3 5 4 4 4 5 5 5
8 2 1 1 5 5 3 5 3 5 5 4 2 5 4 2 4 5 4 4 5 1 5
7 2 1 1 4 5 3 5 3 5 5 5 4 5 5 4 5 5 5 4 5 2 5
7 2 1 1 3 4 4 4 3 3 5 4 5 5 2 2 2 5 3 4 5 4 4
7 2 1 1 4 4 4 5 3 4 5 4 4 4 4 3 4 5 4 3 5 2 5
7 2 1 1 4 4 4 4 3 4 5 4 3 4 4 3 4 5 4 4 5 4 4
6 2 1 1 5 5 5 5 3 3 5 4 3 4 5 3 5 5 4 4 5 4 5
5 2 1 1 4 5 4 5 3 3 5 4 5 5 4 2 3 5 4 5 5 5 5
5 2 1 1 4 5 4 5 3 4 5 5 4 4 3 4 4 5 5 4 5 5 5
8 3 1 1 3 3 4 5 3 3 5 4 2 4 5 2 3 5 5 1 5 4 5
7 3 1 1 4 5 4 5 3 5 5 5 4 5 5 4 3 5 4 4 5 4 5
7 3 1 1 5 5 4 5 3 5 3 4 3 5 4 2 4 5 5 3 5 3 4
7 3 1 1 4 5 2 5 3 5 3 3 4 4 4 3 2 5 4 5 5 4 4
7 3 1 1 5 5 5 5 3 4 4 4 4 4 4 4 4 5 4 4 5 4 4
7 3 1 1 4 5 3 5 3 5 3 5 4 4 3 4 5 5 4 5 2 5
6 3 1 1 4 4 3 5 3 4 1 4 1 4 4 3 4 4 4 1 5 3 4
6 3 1 1 4 4 3 5 3 4 3 5 2 5 4 3 5 3 5 2 5 3 4
6 3 1 1 5 5 4 5 3 4 3 4 3 5 4 4 4 4 4 5 4 5
8 4 1 1 4 4 2 5 3 4 4 5 3 4 4 3 3 4 4 3 5 4 4
8 4 1 1 4 5 3 5 3 4 4 5 3 5 5 3 5 4 4 4 5 2 5
8 4 1 1 4 5 3 5 3 2 2 5 1 5 5 3 3 4 5 4 5 2 5
8 4 1 1 4 5 4 5 3 5 4 4 3 4 4 4 5 4 5 4 5 3 5
8 4 1 1 3 4 4 5 3 3 1 3 2 3 3 1 3 4 4 2 5 3 4
8 4 1 1 4 5 2 5 3 3 4 3 4 4 3 1 1 3 4 3 5 2 4
8 4 1 1 4 5 4 5 3 5 4 5 3 5 5 4 5 4 5 5 5 2 5
8 4 1 1 5 5 4 5 3 3 4 4 4 5 4 4 4 4 4 5 5 3 5
6 4 1 1 4 4 4 5 3 4 4 4 4 4 4 4 4 4 4 3 5 4 4
8 5 1 1 5 4 5 5 3 3 4 3 4 4 3 4 4 5 4 2 5 5 5
8 5 1 1 4 4 4 5 3 3 4 4 4 4 4 4 5 4 4 3 5 4 4
8 5 1 1 5 2 3 5 3 1 4 4 1 3 4 1 3 5 5 1 5 4 5
6 5 1 1 4 4 5 5 3 3 3 3 3 3 4 4 4 4 4 5
6 5 1 1 4 5 5 5 3 5 1 5 1 5 4 4 4 5 3 5 4 5
6 5 1 1 3 4 4 5 3 3 3 3 2 3 4 3 3 3 4 2 5 3 3
5 5 1 1 5 5 4 5 3 4 5 1 5 4 5 5 3 4 5 5 5 4 5
8 4 1 1 5 5 2 5 3 4 2 5 4 5 5 1 5 4 5 3 5 2 5
8 5 1 1 4 4 3 5 3 4 5 4 4 5 2 3 3 4 4 5 3 4
8 5 1 1 5 5 3 5 3 4 3 3 3 4 3 3 3 4 5 3 5 3 4
8 4 1 1 5 5 4 5 3 5 3 5 5 5 5 3 5 3 5 5 5 4 5
8 2 1 1 4 5 4 5 3 4 4 3 4 3 4 3 3 3 4 3 5 4 4
8 2 1 1 4 5 3 5 3 3 1 5 3 2 3 3 4 5 5 1 5 4 4
8 2 1 1 5 5 3 5 3 4 3 4 4 4 4 2 4 5 5 3 5 2 4
8 3 1 1 4 5 4 5 3 2 1 1 1 1 1 2 1 2 1 1 5 2 1
8 4 1 1 4 4 3 4 3 2 1 1 4 3 3 4 3 5 5 2 5 5 4
7 1 1 1 4 5 4 4 3 4 4 5 5 5 4 3 4 3 5 4 5 5 4
6 2 1 1 4 5 4 4 3 4 4 4 4 4 4 3 4 3 4 4 5 3 5
6 5 1 1 5 5 3 5 3 3 1 3 1 5 5 5 5 3 5 1 5 1 5
6 5 1 1 3 3 3 3 3 3 4 4 3 4 3 3 4 3 3 3 5 2 2
6 5 1 1 4 4 4 5 3 4 1 5 1 5 5 2 2 4 4 1 5 3
8 2 1 1 4 5 5 5 4 4 4 5 5 5 5 4 4 4 5 3 5 4 5
6 2 1 1 5 5 3 5 4 3 2 1 3 3 1 1 1 5 5 3 5 3 4
4 2 1 1 4 5 3 5 4 5 2 5 3 5 5 3 3 4 5 3 5 1 5
8 3 1 1 5 5 4 5 4 4 5 5 4 4 5 5 5 4 5 5 5 5 5
8 3 1 1 5 5 5 5 4 5 4 5 4 5 5 3 5 5 5 2 5 4 5
8 3 1 1 4 4 4 5 4 4 3 3 3 3 3 4 5 4 4 3 5 3 3
7 3 1 1 4 4 3 5 4 2 4 5 3 4 4 3 5 4 5 4 5 3 4
7 3 1 1 4 4 4 5 4 3 3 4 3 4 4 4 5 3 4 4 5 4 4
7 3 1 1 4 4 3 5 4 4 4 5 4 4 4 3 5 4 4 4 5 4 4
7 3 1 1 5 5 4 5 4 5 3 5 3 5 5 2 5 2 5 3 5 1 5
7 3 1 1 4 4 3 5 4 3 5 4 5 4 4 3 5 4 5 5 5 4 4
6 3 1 1 5 4 4 5 4 3 4 4 4 4 4 4 5 4 4 4 5 4 4
6 3 1 1 5 4 3 5 4 2 2 4 3 3 3 2 5 4 4 4 5 3 4
6 3 1 1 4 5 4 5 4 5 3 4 3 4 4 3 5 4 5 2 5 4 5
5 3 1 1 5 4 4 5 4 4 5 3 4 4 4 4 5 4 5 5 5 3 5
4 3 1 1 4 4 3 5 4 4 5 5 4 5 5 3 5 5 5 5 5 4 5
8 4 1 1 3 4 3 5 4 4 4 5 4 5 5 4 5 5 5 3 5 4 4
8 4 1 1 3 5 2 5 4 3 1 5 2 5 4 2 5 5 5 1 5 2 5
8 4 1 1 5 5 5 5 4 4 3 4 4 4 4 4 5 4 4 3 5 4 4
8 4 1 1 4 4 4 5 4 4 2 3 4 4 3 3 5 3 4 2 5 4 4
8 4 1 1 5 5 3 5 4 4 3 3 4 4 4 3 5 4 5 3 5 4 5
8 4 1 1 3 5 2 5 4 2 1 5 1 5 4 2 5 4 5 1 5 4 5
8 4 1 1 5 5 4 5 4 5 3 4 4 5 4 3 5 3 4 3 5 3 4
8 4 1 1 3 5 3 5 4 4 1 5 1 4 5 4 5 4 4 3 5 1 5
8 4 1 1 5 5 4 5 4 5 5 1 5 3 4 4 5 5 5 4 5 5 5
8 4 1 1 5 4 3 5 4 4 3 4 4 4 5 4 5 4 5 3 5 3 4
8 4 1 1 4 4 4 5 4 4 3 4 3 3 4 3 5 4 4 3 5 3 3
8 4 1 1 4 4 4 5 4 4 4 4 4 4 5 5 5 4 5 5 5 3 5
7 4 1 1 5 4 3 5 4 3 3 3 4 3 3 3 5 3 3 4 5 3 4
7 4 1 1 4 5 5 5 4 5 4 5 3 4 5 4 5 4 5 5 5 4 5
6 4 1 1 4 4 5 5 4 2 3 4 5 4 4 3 5 5 4 4 5 3 4
6 4 1 1 5 5 3 5 4 4 3 3 3 3 4 4 5 3 4 4 5 4 5
6 4 1 1 4 5 4 5 4 3 1 4 2 4 4 3 5 4 4 1 5 3 4
4 4 1 1 4 4 4 5 4 3 4 4 4 4 4 4 5 4 4 4 5 4 4
7 5 1 1 5 5 4 5 4 4 5 1 4 5 4 5 5 4 4 4 5 4 4
6 5 1 1 4 5 4 5 4 4 5 4 5 4 3 5 4 4 5
6 5 1 1 3 4 3 5 4 3 5 4 4 4 4 4 5 4 4 2 5
6 5 1 1 4 5 4 5 4 5 5 5 3 5 5 5 5 4 5 5 5 3 5
6 5 1 1 4 5 4 5 4 5 5 3 3 3 3 4 5 4 5 3 5 4 4
6 5 1 1 4 5 4 4 4 3 5 3 3 4 3 4 5 4 4 1 5 3 3
6 5 1 1 5 5 4 5 4 4 5 4 4 4 4 4 5 4 4 3 5 3 4
5 5 1 1 5 5 3 4 4 4 5 4 4 4 4 3 5 5 5 4 5 4 4
8 3 1 1 4 2 3 5 4 5 5 1 4 1 2 3 5 4 4 4 5 4 4
8 1 1 1 4 5 3 5 4 5 5 4 2 5 4 3 5 5 5 1 5 3 5
8 2 1 1 5 4 2 5 4 3 5 5 2 5 5 3 5 4 5 1 5 1 5
8 3 1 1 5 3 4 3 4 3 5 3 1 4 4 3 5 4 4 3 5 3 5
8 4 1 1 4 4 4 4 4 3 5 4 3 3 4 3 5 4 4 3 5 3 3
8 3 1 1 5 5 3 5 4 5 5 3 3 4 2 5 5 5 2 5 5
8 3 1 1 4 4 5 5 4 2 5 4 3 3 3 1 5 4 4 1 5 3 3
7 2 1 1 5 5 4 5 4 5 5 5 4 5 5 4 5 3 5 5 5 3 5
7 1 1 1 4 4 4 4 4 4 5 4 4 4 4 4 5 4 4 4 5 4 4
6 2 1 1 4 3 4 4 4 3 5 2 3 3 4 3 5 4 4 4 5 3 3
6 2 1 1 5 5 3 5 4 3 5 4 4 4 4 3 5 3 3 1 5 2 4
5 6 1 1 5 5 4 4 4 3 5 4 4 4 3 4 5 5 5 5 5 4 4
6 2 1 1 5 5 5 5 5 4 5 5 5 3 4 5 5 4 2 5 5 3 3
4 2 1 1 4 4 4 4 5 4 5 5 5 5 5 4 5 5 5 4 5 4 5
8 3 1 1 5 4 3 4 5 1 5 3 4 3 5 2 5 5 4 4 5 3 3
8 3 1 1 5 5 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
8 3 1 1 5 5 3 4 5 5 5 4 4 4 5 4 5 4 5 3 5 5 5
8 3 1 1 5 5 3 5 5 5 5 5 5 5 5 4 5 3 5 3 5 3 5
6 3 1 1 5 5 5 5 5 5 5 5 5 5 3 5 5 5 5 5 5 5 5
4 3 1 1 5 5 5 5 5 5 5 5 4 4 4 5 5 5 5 5 5 5 5
8 4 1 1 5 4 4 4 5 4 5 5 5 5 4 4 5 4 5 5 5 5 5
8 4 1 1 5 5 3 5 5 5 5 5 2 5 5 2 5 3 5 5 5 3 5
6 4 1 1 5 5 5 4 5 5 5 4 5 5 5 5 5 5 5 4 5 5 5
4 4 1 1 5 5 5 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
8 5 1 1 4 4 4 5 5 5 5 5 1 5 5 2 5 5 5 3 5
8 5 1 1 5 5 4 4 5 5 5 3 5 5 4 4 5 5 5 4 5 4 4
7 5 1 1 5 5 3 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
4 5 1 1 5 5 3 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
8 2 1 1 3 5 5 5 5 1 5 1 3 1 5 1 1 3 5 2 5 5 5
6 2 1 1 5 5 4 5 5 5 5 4 5 5 4 3 4 5 5 4 5 4 5
4 6 1 1 5 5 5 5 5 4 5 5 5 5 5 5 5 5 5 5 5 5 5
6 3 1 1 5 5 5 1 5 3 1 5 5 4 5 5 5 5 5
5 5 1 1 4 4 3 4 3 5 5 5 4 4 5 5 5 5 5 5
8 2 2 1 5 5 5 5 5 5 5 4 5 5 5 4 5 5 5 5 5 5 5
8 2 2 1 5 5 5 5 3 3 5 4 4 4 3 3 3 5 5 2 5 4 4
7 3 2 1 1 5 1 5 1 5 5 5 1 5 5 1 5 5 5 1 5 1 5
8 4 2 1 4 4 4 5 1 5 5 5 5 5 5 3 5 5 5 5 5 5 5
7 4 2 1 5 5 3 5 1 3 5 2 1 4 5 1 4 5 5 1 5 1 5
7 4 2 1 3 5 3 5 1 3 5 4 1 5 4 3 5 5 5 1 5 3 4
7 3 2 1 3 5 2 5 2 3 5 3 1 3 3 1 4 3 5 1 5 2 4
8 4 2 1 3 5 3 4 2 3 5 4 2 4 4 1 4 4 5 4 5 3 4
7 4 2 1 3 5 2 5 2 3 5 5 1 5 5 2 4 5 5 1 5 1 3
6 4 2 1 5 5 4 5 2 4 5 3 3 4 4 4 5 5 5 1 5 4 4
4 4 2 1 4 4 3 4 2 4 5 5 2 2 5 3 4 3 5 2 5 3 3
4 4 2 1 5 5 4 5 2 3 5 5 3 4 4 4 4 5 5 3 5 2 4
4 5 2 1 3 5 2 5 2 4 5 5 2 5 5 2 5 3 5 3 5 1 5
8 2 2 1 4 4 4 5 2 3 5 5 2 3 5 2 5 5 5 3 5 3 4
7 2 2 1 4 5 4 5 3 4 5 5 2 5 4 3 4 4 5 2 5 3 4
7 2 2 1 3 3 2 5 3 2 5 4 4 4 5 1 5 4 5 4 5 4 5
6 2 2 1 4 4 5 5 3 3 3 3 2 3 3 1 4 5 5 2 5 2 4
6 2 2 1 5 5 4 5 3 5 4 5 4 5 5 4 5 4 5 3 5 5 5
5 2 2 1 4 5 2 5 3 3 1 5 2 5 4 4 5 5 5 1 5 3 5
4 2 2 1 4 4 2 4 3 3 3 2 2 2 3 3 3 3 5 2 5 4 4
8 3 2 1 4 5 4 5 3 4 4 4 4 4 3 4 5 5 5 4 5
7 3 2 1 4 4 3 4 3 3 3 3 3 3 4 4 4 4 5 2 5 4 4
7 3 2 1 2 5 3 5 3 5 1 5 1 5 5 1 5 5 5 1 5 1 5
5 3 2 1 5 5 4 4 3 4 4 5 4 5 4 4 4 4 5 2 5 5 5
5 3 2 1 5 5 4 4 3 4 2 4 3 4 3 3 3 5 5 3 5 4 4
5 3 2 1 4 4 3 4 3 3 2 4 2 4 3 2 2 4 5 2 5 3
4 3 2 1 4 4 4 5 3 4 4 3 4 3 4 4 4 4 5 4 5 3 3
4 3 2 1 4 4 3 5 3 4 1 3 2 4 4 3 3 4 5 4 5 3 4
4 3 2 1 5 4 4 5 3 4 3 3 1 3 5 2 3 3 5 2 5 3 4
8 4 2 1 4 4 4 4 3 3 4 4 4 4 3 4 4 4 5 3 5 4 4
8 4 2 1 4 4 4 4 3 4 1 4 2 4 4 3 4 4 5 1 5 2 4
7 4 2 1 5 5 3 4 3 5 2 4 2 5 4 3 5 4 5 3 5 3 5
8 5 2 1 3 5 3 4 3 3 1 3 1 1 3 1 2 3 5 1 5 3 3
8 5 2 1 5 5 5 5 3 5 5 3 5 5 4 5 5 5 5 5 5 5 5
8 5 2 1 4 2 5 2 3 3 3 3 4 3 3 3 2 4 5 3 5 4 3
8 5 2 1 5 5 5 5 3 3 3 4 4 3 4 4 4 4 5 2 5 4 4
7 5 2 1 5 5 3 5 3 4 5 5 4 5 4 2 4 4 5 4 5 3 4
7 5 2 1 5 5 3 5 3 5 2 5 3 4 3 1 4 4 5 4 5 4 5
8 1 2 1 4 5 5 5 3 4 3 3 3 4 5 3 4 5 5 5 5 4 4
8 5 2 1 5 4 4 4 3 2 2 2 3 3 4 4 5 5 5 5 4 3
7 1 2 1 5 5 3 4 3 4 1 3 1 2 4 2 4 5 5 5 1 4
7 1 2 1 4 4 3 5 3 3 2 4 2 4 4 2 4 4 5 5 5 4 5
7 2 2 1 5 5 3 5 3 4 5 3 4 4 4 4 3 5 5 5 2 5
7 2 2 1 5 4 3 5 3 3 3 3 4 1 4 1 4 4 5 5 5 4 2
6 2 2 1 5 5 4 5 3 5 3 5 5 5 5 5 5 4 5 5 5 5 5
5 6 2 1 5 5 4 5 3 3 4 5 5 5 5 3 3 5 5 5 5 5 5
8 2 2 1 4 4 3 5 4 4 3 4 3 4 4 3 3 3 5 5 5 4 5
7 2 2 1 3 3 3 5 4 4 1 5 3 5 5 1 5 5 5 5 5 4 5
7 2 2 1 4 4 4 5 4 4 4 4 4 4 4 4 4 4 5 5 5 4 4
7 2 2 1 5 5 3 5 4 4 2 5 4 5 5 3 4 4 5 5 5 4 5
6 2 2 1 5 5 4 5 4 3 1 4 4 5 5 5 5 5 5
6 2 2 1 4 4 4 5 4 3 4 5 4 4 4 4 3 5 5 5 5 4 5
6 2 2 1 4 5 4 5 4 4 4 4 4 5 4 4 4 4 5 5 5 4 5
5 2 2 1 4 5 3 5 4 3 3 4 4 4 3 1 3 5 5 5 5 4 4
5 2 2 1 4 4 3 5 4 3 4 5 4 5 4 3 5 4 3 5 5 4 4
4 2 2 1 4 5 3 5 4 4 3 5 4 4 5 3 4 4 4 5 5 4 5
7 3 2 1 4 4 4 5 4 3 4 5 4 4 4 4 5 5 5 5 5 3 5
7 3 2 1 5 5 2 5 4 4 1 5 2 5 5 3 4 5 5 5 5 2 4
7 3 2 1 5 5 4 5 4 4 2 5 3 4 4 3 4 4 5 5 5 3 4
6 3 2 1 4 5 4 5 4 4 3 5 3 4 4 4 4 4 5 5 5 4 5
6 3 2 1 4 5 4 4 4 3 1 1 3 4 5 4 3 5 5 2 4
6 3 2 1 5 5 5 5 4 4 4 4 5 5 4 5 4 5 5 5 5 5 5
5 3 2 1 4 4 4 4 4 3 3 3 1 3 3 2 3 4 4 5 5 4 4
4 3 2 1 5 5 3 5 4 4 3 4 2 3 4 3 3 5 5 5 5 2 3
4 3 2 1 5 4 3 5 4 5 2 5 2 5 5 3 5 4 5 5 5 3 5
4 3 2 1 5 5 3 5 4 4 3 4 4 3 5 4 4 5 4 5 5 3 3
8 4 2 1 5 5 4 5 4 3 3 4 4 3 3 3 3 5 5 5 5 4 3
7 4 2 0 3 4 3 5 4 4 3 4 3 4 4 1 5 4 4 5 5 3 4
7 4 2 1 5 5 3 4 4 4 4 4 4 4 4 4 4 4 4 5 5 4 4
7 4 2 1 4 5 3 5 4 4 3 5 3 5 4 3 4 4 5 5 5 3 5
6 4 2 1 5 5 4 4 4 4 4 3 5 4 5 5 5 5 5 5 5 5 5
5 4 2 1 4 4 4 4 4 3 4 4 4 4 4 3 4 5 5 5 5 5 5
4 4 2 1 5 5 4 5 4 4 4 5 5 5 5 3 4 5 4 5 5 5 5
8 5 2 1 4 5 3 5 4 4 3 4 4 4 5 4 4 4 4 5 5 3 4
7 5 2 1 3 4 2 5 4 4 1 3 1 2 3 3 3 4 4 5 5 1 3
7 5 2 0 5 5 3 5 4 4 2 4 3 4 4 2 2 4 5 5 5 4 5
7 5 2 1 4 5 2 5 4 4 5 5 4 5 4 4 4 4 5 5 5 4 4
6 5 2 1 5 5 3 5 4 4 3 5 5 4 4 5 5
8 5 2 1 3 4 3 5 4 4 2 4 3 4 4 3 4 4 4 5 5 4 4
8 2 2 1 5 5 5 5 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5
8 1 2 1 4 4 4 5 4 4 4 4 4 4 4 4 4 5 5 5 5 4 4
7 4 2 1 3 3 5 4 3 3 3 2 3 3 3 3 4 4 5 5 4 3
7 1 2 1 4 4 3 5 4 3 4 3 4 4 4 3 3 5 5 5 5 5 5
5 5 2 1 5 5 3 5 4 4 2 3 2 3 3 1 3 2 4 5 5 4
7 2 2 1 5 4 4 5 5 4 1 5 1 5 5 3 3 4 4 5 5 4 5
6 3 2 1 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
6 3 2 1 5 5 4 5 5 3 1 1 5 3 2 5 3 5 4 5 5 4 3
4 3 2 0 4 5 4 5 5 5 1 5 3 5 5 1 5 3 5 5 5 1 5
7 4 2 1 5 5 5 5 5 5 1 3 3 4 3 3 4 4 5 5 5 2 4
5 4 2 1 4 4 3 5 5 4 4 4 4 4 3 4 3 5 4 5 5 5 4
4 4 2 1 5 5 3 5 5 5 5 5 5 5 5 5 5 4 5 5 5 5 5
8 2 2 1 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
8 5 2 1 4 4 4 5 4 3 3 3 3 3 5 4 5 5 5 5 4 4
7 4 1 0 2 4 1 5 2 4 2 3 2 3 3 1 3 2 4 3 5 1 5
4 4 1 1 5 5 2 5 3 3 3 3 4 4 4 2 4 3 4 4 5 2 3
6 5 1 1 5 5 2 5 3 1 1 5 1 1 5 5
6 5 1 1 4 5 3 4 3 4 3 4 4 4 3 3 3 4 4 5 5 4 4
6 4 1 1 4 4 4 4 4 4 4 4 4 4 5 5
3 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 1 1
1 2 1 0 3 5 2 5 1 1 5 5 5 5 1 5 4 1 3 5 4 5
1 2 1 1 5 4 3 4 1 4 4 5 3 3 4 4 3 5 1 4 5 4 3
1 4 1 1 2 5 2 5 1 3 2 4 3 3 4 1 3 4 1 1 5 3 4
1 4 1 1 5 5 3 4 1 4 4 4 3 3 3 4 4 3 1 3 5 4 4
1 4 1 1 5 5 2 4 1 5 2 3 1 5 4 1 4 5 1 1 5 1 1
3 5 1 1 5 4 4 4 1 4 1 2 1 2 3 1 3 4 1 1 5 3 3
1 5 1 0 4 5 3 1 4 1 4 1 3 3 1 2 4 1 1 5 2 3
1 5 1 0 4 5 2 5 1 4 4 3 3 3 4 2 4 4 1 1 5 1 4
1 5 1 0 5 5 3 4 1 5 4 4 4 4 4 3 4 5 1 4 5 3 4
3 6 1 0 5 5 1 5 1 5 1 5 2 5 5 1 5 5 1 1 5 1 5
1 2 1 0 5 5 1 5 1 5 1 3 1 4 5 2 5 3 1 1 5 2 4
3 2 1 0 4 5 4 5 1 4 3 5 4 5 5 3 5 4 1 2 5 4 5
3 2 1 0 4 5 3 5 1 5 4 5 3 4 5 4 5 2 1 5 5 3 5
1 2 1 0 4 5 2 5 1 5 1 4 1 5 4 1 4 3 1 1 5 2 5
3 3 1 0 5 5 3 3 1 3 1 5 4 5 5 2 4 5 1 1 5 3 5
3 3 1 0 4 5 3 5 1 5 1 4 4 5 5 2 5 5 1 2 5 3 4
3 3 1 0 4 4 5 4 1 3 2 3 4 4 3 2 4 4 1 1 5 4 5
3 3 1 0 5 5 3 5 1 4 1 3 3 3 4 2 3 4 1 3 5 3 4
3 3 1 0 5 5 3 5 1 5 3 5 4 5 5 5 5 4 1 2 5 3 5
1 3 1 0 3 5 3 4 1 5 1 3 2 4 3 3 4 4 1 1 5 5
3 4 1 0 5 5 4 4 1 4 1 3 3 3 3 3 4 4 1 2 5 3 3
3 4 1 0 3 3 4 1 1 1 1 5 2 4 4 1 1 4 1 1 5 2 4
3 4 1 0 5 5 3 1 1 4 1 3 3 3 3 2 4 1 1 5 5
3 4 1 0 5 5 3 1 1 3 1 4 3 4 3 2 5 4 1 3 5 3 4
1 4 1 0 4 5 3 1 1 4 1 4 2 4 3 4 3 4 1 1 5 3 3
1 4 1 0 4 4 2 1 1 3 1 3 2 3 4 2 2 4 1 2 5 2 3
1 4 1 0 4 4 4 1 1 4 1 4 3 4 3 3 4 3 1 2 5 2 4
3 5 1 0 5 3 5 1 1 5 1 4 3 3 4 3 3 4 1 4 5 5 5
3 5 1 0 5 4 4 1 1 3 1 4 1 4 3 2 3 4 1 3 5 2 4
3 5 1 0 5 5 4 1 1 3 1 3 2 4 3 2 3 3 1 1 5 4 4
3 5 1 0 4 5 1 2 4 1 5 2 5 5 2 5 3 1 2 5 2 4
3 5 1 0 3 5 2 1 2 3 1 3 3 3 3 2 3 5 1 1 5 3 5
3 5 1 0 5 5 3 1 2 4 1 5 1 5 5 1 5 5 1 1 5 2 5
3 5 1 0 4 4 3 1 2 2 1 4 4 4 3 4 1 5 5 3 3
1 5 1 0 4 5 3 1 2 5 1 1 1 3 4 1 4 5 1 1 5 4 4
1 5 1 0 5 5 3 1 2 5 1 1 4 4 4 1 5 4 1 3 5 5 5
3 6 1 0 4 5 3 1 2 5 1 1 1 5 4 3 4 5 1 1 5 2 5
3 2 1 0 3 4 2 1 2 3 1 1 2 3 3 2 3 3 1 1 5 3
3 4 1 0 5 4 3 1 2 3 1 1 1 3 4 1 1 4 1 1 5 3 4
3 4 1 0 5 5 3 1 2 4 1 1 3 3 3 2 4 5 1 1 5 4 5
3 2 1 0 4 4 3 1 2 4 1 1 2 4 4 3 2 3 1 2 5 4 4
2 4 1 0 5 5 2 1 2 5 1 1 3 5 4 2 4 4 1 4 5 4 5
1 6 1 0 5 5 4 1 2 4 1 1 2 3 3 3 4 4 1 1 5 2 3
1 4 1 0 2 5 1 1 2 4 1 1 2 4 3 4 4 5 1 1 5 1 4
1 5 1 0 4 4 4 1 2 4 1 1 3 3 4 2 4 4 1 3 5 3 4
3 2 1 0 4 3 4 1 3 3 1 1 3 3 3 3 3 4 1 3 5 4 4
3 2 1 0 5 5 4 1 3 3 1 1 3 5 5 2 3 5 1 3 5 4 5
3 3 1 0 4 1 2 1 3 5 1 1 3 4 4 2 4 5 1 1 5 4 4
3 3 1 0 4 1 2 1 3 4 1 1 3 4 5 2 5 4 1 2 5 3 5
3 3 1 0 5 1 2 1 3 2 1 1 2 2 4 1 5 5 1 1 5 5 3
2 3 1 0 4 1 2 1 3 2 1 1 4 3 3 1 3 4 1 3 5 4 3
2 3 1 0 5 1 2 1 3 5 1 1 5 4 4 1 4 4 1 5 5 5 5
2 3 1 0 4 1 2 1 3 5 1 1 3 5 5 1 3 4 1 4 5 4 5
1 3 1 1 4 1 2 1 3 4 1 1 4 4 3 1 4 4 1 4 5 4 4
3 4 1 1 4 1 2 1 3 4 1 1 2 4 5 1 5 4 1 5 5 4 5
3 4 1 1 5 1 2 1 3 3 1 1 4 5 4 1 4 4 1 5 5 5 5
3 4 1 1 3 1 2 1 3 4 1 1 2 3 3 1 2 5 1 2 5 3 4
3 4 1 1 5 1 2 1 3 4 1 1 4 5 4 1 5 5 1 1 5 4 5
3 4 1 1 4 1 2 1 3 2 2 1 3 2 3 1 2 3 1 3 5 4 4
3 4 1 1 4 1 2 1 3 3 3 1 2 4 5 1 2 4 1 3 5 2 3
3 4 1 1 5 1 2 1 3 4 1 1 2 5 5 1 3 5 1 1 5 5 5
3 4 1 1 5 1 2 1 3 4 3 1 4 4 4 1 4 1 5 5 3 4
3 4 1 1 4 1 2 1 3 5 1 1 1 5 5 1 4 3 1 1 5 3 5
3 4 1 1 5 1 2 1 3 3 4 1 5 5 5 1 5 5 1 1 5 5 5
3 4 1 1 4 1 2 1 3 3 3 1 3 3 4 1 2 3 1 2 5 3 2
3 4 1 1 5 1 2 1 3 2 1 1 2 3 4 1 3 4 1 1 5 3 4
3 4 1 1 4 1 2 1 3 3 1 3 3 4 4 1 3 4 1 3 5 2 4
3 4 1 1 4 1 2 1 3 4 1 4 4 4 3 1 3 2 1 4 5 2 4
2 4 1 1 4 1 2 1 3 4 1 4 4 4 4 1 4 4 1 4 5 4 4
3 5 1 1 4 1 2 1 3 4 1 4 3 4 4 1 4 3 1 4 5 3 4
3 5 1 1 5 1 2 1 3 3 1 3 4 4 1 3 1 1 5 4 5
3 5 1 1 4 1 2 1 3 2 1 4 3 4 5 1 3 4 1 3 5 4 3
3 5 1 1 5 1 2 1 3 3 1 4 4 4 5 1 2 4 5 1 5 4 4
3 5 1 1 4 1 2 1 3 4 1 4 5 5 5 1 5 4 5 4 5 5 5
3 5 1 1 5 1 2 1 3 3 1 2 3 2 2 1 3 4 4 3 5 4 3
3 5 1 1 4 1 2 1 3 2 1 4 4 4 4 1 3 5 4 3 5 4 5
3 5 1 1 4 1 2 1 3 3 1 3 3 3 3 1 2 4 4 1 5 3 3
3 5 1 1 5 1 2 1 3 5 1 5 5 5 5 1 4 4 5 5 5 5 3
3 5 1 1 5 1 2 1 3 5 1 5 4 5 5 1 4 4 4 4 5 5 4
3 5 1 1 5 1 2 1 3 4 1 4 1 5 4 1 4 5 5 1 5 1 4
2 5 1 1 3 1 2 1 3 5 1 5 1 5 5 1 3 3 4 1 5 1 4
1 5 1 1 4 1 2 1 3 4 1 3 4 3 4 1 4 3 4 3 5 4 5
1 5 1 1 5 1 2 1 3 5 1 5 3 5 5 1 5 4 5 3 5 5 5
1 5 1 1 4 1 2 1 3 5 1 5 3 4 5 1 4 5 5 3 5 3 4
1 5 1 1 4 1 2 1 3 4 1 5 3 5 4 1 3 4 5 3 5 4 5
1 5 1 1 4 1 2 1 3 4 1 4 3 4 4 1 4 3 4 1 5 2 3
1 5 1 1 5 1 2 1 3 5 1 5 5 5 5 1 5 5 5 5 5 3 5
1 5 1 1 5 1 2 1 3 5 1 3 1 4 5 1 5 2 5 1 5 3 4
3 4 1 1 5 4 2 1 3 3 1 3 2 3 3 1 3 4 3 1 5 2 3
3 2 1 1 4 4 2 1 3 3 1 4 2 3 4 1 3 3 4 1 5 3 4
3 5 1 1 4 4 2 1 3 3 1 5 3 5 4 1 3 4 4 2 5 4 4
3 6 1 1 5 5 2 1 3 3 1 5 2 5 5 1 4 4 5 3 5 3 5
3 6 1 1 5 5 2 1 3 3 1 3 4 4 3 1 4 4 5 4 5 3 4
3 4 1 1 5 4 2 1 3 3 1 5 4 5 5 1 4 3 3 5 5 5 5
2 5 1 1 5 5 2 1 3 3 1 4 5 5 4 1 3 4 4 5 5 3 4
3 2 1 1 4 4 2 1 4 5 1 4 4 4 1 4 4 5 5 5 5
3 2 1 1 5 5 2 1 4 5 1 4 4 5 4 1 3 3 4 5 5 3 4
3 2 1 1 4 5 2 1 4 5 1 5 2 5 4 1 4 4 5 2 5 4 5
2 2 1 1 4 4 2 1 4 4 1 4 4 4 4 1 4 4 4 4 5 4 4
2 2 1 1 5 4 2 1 4 4 1 4 5 5 4 1 4 4 5 4 5 3 5
2 2 1 1 5 5 2 1 4 5 1 5 5 5 5 1 5 3 4 5 5 4 5
2 2 1 1 4 5 2 1 4 4 1 5 4 5 4 1 5 5 5 5 5 5 5
1 2 1 1 3 4 2 1 4 4 1 3 5 3 3 1 3 4 4 5 5 5 5
3 3 1 1 3 3 2 1 4 3 1 3 2 3 3 1 1 4 3 2 5 1 4
3 3 1 1 3 5 2 1 4 3 1 4 4 4 4 1 4 5 5 1 5 5 5
3 3 1 1 3 4 2 1 4 4 1 2 3 3 3 1 3 3 3 1 5 3 3
3 3 1 1 3 5 2 1 4 3 3 2 2 3 3 1 2 3 4 3 5 3 4
3 3 1 1 3 5 2 1 4 2 1 5 1 5 5 1 1 4 3 1 5 1 5
3 3 1 1 3 5 2 1 4 3 1 4 4 4 4 1 3 5 4 1 5 4 5
3 3 1 1 3 3 2 1 4 4 1 5 5 5 4 1 5 3 4 5 5 5 5
2 3 1 1 3 4 2 1 4 4 1 4 3 4 3 1 4 4 4 5 5 3 4
2 3 1 1 3 5 2 1 4 3 1 4 5 4 3 1 3 4 4 5 5 4 5
2 3 1 1 3 5 2 1 4 5 1 5 5 5 5 1 5 5 5 5 5 5
3 4 1 1 3 4 2 1 4 2 1 3 3 3 4 1 5 4 4 1 5 3 3
3 4 1 1 3 4 2 1 4 3 1 4 4 4 4 1 3 4 4 4 5 4 4
3 4 1 1 3 5 2 1 4 4 1 5 5 5 5 1 4 4 5 5 5 5 5
3 4 1 1 3 5 2 1 4 4 1 4 4 5 4 1 3 4 5 1 5 3 4
3 4 1 1 3 3 2 1 4 3 1 2 5 2 4 1 3 5 5 3 5 3 4
3 4 1 1 3 3 2 1 4 5 1 4 5 5 5 1 5 4 5 1 5 1 5
3 4 1 1 3 5 4 1 4 4 1 4 4 4 4 1 4 4 4 4 5 3 4
3 4 1 1 3 5 3 1 4 5 1 5 2 5 4 1 4 3 4 2 5 4 4
3 4 1 1 3 5 5 1 4 5 1 3 5 4 3 1 4 4 4 1 5 3 4
2 4 1 1 3 5 3 1 4 4 1 4 2 4 4 1 4 5 5 5 5 4 5
2 4 1 1 3 5 3 1 4 4 1 3 3 4 5 1 5 4 5 4 5 1 5
2 4 1 1 3 4 4 1 4 4 1 4 4 4 4 1 4 5 5 5 5 4 4
1 4 1 1 3 4 3 4 4 4 1 4 3 4 4 1 3 5 4 5 5 3 4
3 5 1 1 3 5 4 5 4 4 1 3 2 3 3 1 4 4 4 1 5 2 3
3 5 1 1 3 4 4 4 4 2 1 4 3 3 4 1 2 4 4 3 5 3 4
3 5 1 1 3 5 5 5 4 5 1 4 1 1 4 1 4 3 4 1 5 2 2
3 5 1 1 3 5 5 5 4 5 1 5 4 4 4 1 4 5 5 5 5 5 4
3 5 1 1 3 4 3 5 4 2 1 2 1 2 4 1 2 4 4 1 5 3 1
3 5 1 1 3 4 4 4 4 4 1 3 3 2 3 1 3 5 5 1 5 3 4
3 5 1 1 3 5 4 5 4 5 1 4 5 5 3 1 4 4 5 1 5 4 5
2 5 1 1 3 5 5 5 4 4 1 5 4 4 4 1 4 5 5 1 5 5 5
2 5 1 1 3 5 3 5 4 5 1 5 5 5 4 1 5 5 5 1 5 4 4
1 5 1 1 3 5 3 4 4 4 1 4 4 4 4 1 4 4 5 1 5 4 4
1 5 1 1 3 5 4 5 4 5 1 4 5 4 4 1 5 5 5 1 5 4 4
1 5 1 1 3 5 3 5 4 5 1 5 5 5 4 1 4 3 5 1 5 3 5
1 5 1 1 3 5 4 5 4 5 1 5 3 5 5 1 4 5 5 1 5 5 5
3 2 1 1 3 4 4 5 4 3 1 4 2 4 4 1 3 4 4 1 5 3 4
3 4 1 1 3 5 4 5 4 4 1 2 3 4 4 1 2 5 5 1 5 3 5
3 2 1 1 3 4 3 5 4 4 1 4 3 4 4 1 4 5 5 1 5 3 3
3 2 1 1 3 5 4 4 4 4 1 5 4 3 5 1 5 4 5 1 5 5 5
3 5 1 1 3 5 4 5 4 2 1 4 4 4 4 1 5 4 4 1 5 4 4
3 6 1 1 3 5 3 5 4 3 1 5 2 5 5 1 4 4 4 1 5 2 3
3 6 1 1 3 5 4 5 4 5 1 4 5 5 5 1 5 5 5 1 5 4 5
3 2 1 1 3 5 3 5 4 5 1 5 5 5 5 1 1 5 1 5 5 5
3 2 1 1 3 4 3 5 4 4 1 5 4 4 5 1 5 1 5 1 5 1 4
3 4 1 1 3 3 5 4 1 3 3 5 4 1 3 1 5 1 5 4 4
2 2 1 0 3 5 4 5 4 5 1 5 1 5 5 1 2 1 5 1 5 4 5
2 5 1 1 4 4 3 4 4 2 1 4 2 3 3 1 3 1 4 1 5 3 3
1 6 1 1 4 4 1 5 4 3 1 4 3 4 4 1 4 1 5 1 5 3 4
1 6 1 1 4 4 4 4 4 4 1 3 3 2 4 1 3 1 5 1 5 3 4
1 2 1 1 4 3 3 3 4 3 1 4 2 4 4 1 4 1 1 5 1 4
1 4 1 1 4 5 4 5 4 5 1 4 2 5 4 3 5 1 5 1 5 3 5
3 2 1 0 5 5 5 5 5 5 1 5 5 5 5 1 2 1 5 1 5 3 4
2 2 1 1 4 4 3 4 5 5 1 3 5 5 5 3 3 1 4 1 5 3 3
3 3 1 1 5 5 4 5 5 5 1 5 5 5 5 5 5 1 5 1 5 5 5
2 3 1 1 4 5 5 5 5 5 1 5 4 5 5 5 5 1 5 1 5 5 5
3 4 1 1 4 5 5 5 5 5 1 4 5 5 4 5 5 1 4 1 5 5 4
2 4 1 1 5 5 5 5 5 5 1 5 5 5 5 5 5 1 5 1 5 5 5
2 4 1 1 5 5 4 5 5 5 1 5 5 5 5 3 5 1 5 1 5 5 5
2 4 1 1 4 4 4 4 5 5 1 5 4 5 5 4 4 1 5 1 5 4 5
2 4 1 1 5 5 3 5 5 5 1 5 5 5 5 3 5 1 5 1 5 3 5
3 5 1 1 5 5 4 5 5 5 1 5 3 4 5 3 4 1 5 1 5 3 4
3 5 1 1 5 5 1 5 5 5 1 5 5 5 5 5 5 1 5 1 5 5 5
2 5 1 1 5 5 5 5 5 5 1 5 5 5 5 5 5 1 5 1 5 5 5
2 5 1 1 5 5 4 5 5 4 1 4 4 4 4 4 4 1 5 1 5 4 4
2 5 1 1 5 5 5 5 5 5 1 5 5 4 4 5 4 1 5 1 5 4 3
1 3 1 1 5 5 3 5 5 1 5 5 5 5 4 5 1 5 5 5 3 5
3 6 1 1 5 5 4 5 3 1 4 3 4 4 2 4 1 5 3 5 3 5
1 4 2 0 5 4 3 3 1 3 1 2 1 1 3 1 1 1 5 1 5 1 1
1 4 2 1 4 5 2 5 1 5 1 5 4 5 5 1 5 1 5 3 5 3 5
3 2 2 1 4 5 5 5 2 3 1 3 1 2 2 2 2 1 5 1 5 5 5
2 2 2 1 5 5 3 5 2 3 1 5 3 5 4 3 4 1 5 4 5 3 5
1 2 2 1 5 5 4 4 2 3 1 3 3 2 1 3 2 1 5 5 5 3 4
1 2 2 1 3 3 3 3 2 1 1 4 2 3 2 2 3 1 5 1 3 2 4
1 2 2 1 4 5 5 5 2 3 1 4 3 5 4 2 2 1 5 3 5 5 5
3 3 2 0 4 4 3 5 2 4 1 4 2 4 4 1 4 1 5 1 4 2 4
1 3 2 1 4 5 4 5 2 3 1 2 3 4 3 3 3 1 5 3 3 3 3
1 4 2 1 5 4 3 4 2 2 1 3 2 3 3 3 3 1 5 1 3 2 4
1 4 2 1 4 5 3 5 2 5 1 5 2 5 5 3 5 1 5 1 5 3 5
1 4 2 1 5 3 5 2 4 1 4 1 3 4 3 5 1 5 3 3 3 4
1 4 2 0 4 3 2 1 4 1 1 5 2 1
3 5 2 1 5 5 3 5 2 5 1 5 2 5 5 1 5 1 5 1 3 2 4
3 5 2 1 3 4 4 4 2 4 1 4 1 4 3 1 4 1 5 1 3 2 4
2 5 2 0 3 5 3 4 2 3 1 3 1 2 4 1 4 1 5 3 3 3 3
1 6 2 1 5 4 3 2 2 2 1 4 1 4 3 3 3 1 5 1 4 2 4
1 2 2 1 3 5 2 4 2 3 1 4 1 4 5 3 4 1 5 5 4 5 5
2 2 2 1 4 5 4 5 3 4 1 5 1 5 4 5 4 1 4 3 4 3 5
2 2 2 1 4 5 4 5 3 3 1 5 1 5 5 3 4 1 4 4 5 5 5
2 2 2 1 4 5 5 3 3 1 5 1 5 4 3 3 1 4 4 5 5 5
1 2 2 1 4 4 2 4 3 3 1 3 1 3 3 3 4 1 3 3 3 4 4
1 2 2 0 3 5 1 5 3 3 1 2 1 4 4 1 3 1 4 1 3 3 5
3 3 2 1 4 4 1 4 3 2 1 3 1 3 3 2 3 1 4 4 4 3 4
3 3 2 1 3 1 3 1 1 3 1 2 3
3 3 2 1 4 5 1 5 3 4 1 4 1 4 4 4 5 1 4 4 4 3 4
3 3 2 1 5 5 1 5 3 3 1 4 1 4 4 4 1 5 3 3 3 4
2 3 2 0 3 4 1 5 3 4 1 5 1 5 5 3 5 1 4 4 4 4 4
2 3 2 1 4 5 1 5 3 4 1 5 1 5 5 3 4 1 5 3 5 3 5
1 3 2 1 5 4 1 5 3 2 1 4 1 2 3 3 3 1 4 1 1 3 2
1 3 2 1 4 4 1 4 3 2 1 3 1 3 3 3 4 1 4 1 3 4 4
1 3 2 1 4 4 1 5 3 2 1 3 1 3 2 1 3 1 5 3 3 5 5
3 4 2 1 4 5 1 5 3 4 1 3 1 3 4 3 4 1 4 3 4 3 3
3 4 2 1 4 5 1 5 3 2 1 3 1 3 4 1 4 1 5 3 3 4 4
2 4 2 0 3 3 1 4 3 2 1 4 1 4 3 3 4 1 3 4 5 3 5
2 4 2 0 3 5 1 5 3 5 1 4 1 5 5 3 5 1 5 4 5 4 5
2 4 2 1 4 5 1 5 3 3 1 5 1 5 4 3 4 1 5 4 5 3 5
2 4 2 1 3 5 1 5 3 5 1 4 1 4 4 2 3 1 4 4 4 4 4
2 4 2 1 4 4 1 5 3 3 1 5 1 5 3 4 5 1 5 4 4 4 5
1 4 2 1 5 5 3 5 3 5 1 5 1 5 5 1 4 1 4 5 5 4 5
3 5 2 1 5 5 4 5 3 3 1 2 1 1 2 3 2 1 4 1 1 3 2
3 5 2 1 4 4 3 5 3 4 1 4 3 4 4 2 4 1 4 3 3 1 5
2 5 2 1 4 4 4 4 3 4 1 4 3 4 3 2 3 1 4 4 5 3 4
2 5 2 1 1 5 4 5 3 4 1 3 5 3 3 4 3 1 5 5 5 4 4
1 5 2 1 1 4 3 4 3 3 1 3 3 3 3 4 4 1 4 3 3 3 4
1 5 2 1 1 4 3 4 3 4 1 3 3 3 4 4 4 1 4 4 4 4 4
1 5 2 0 1 5 3 5 3 3 1 4 5 4 4 5 1 5 3 5
1 5 2 1 1 4 3 5 3 3 1 5 3 4 4 1 4 3 5 3 4
1 5 2 1 1 5 3 5 3 4 1 5 4 4 4 4 4 1 4 3 4 4 4
3 5 2 1 1 5 4 5 3 4 1 3 2 3 4 2 3 1 2 2 3 3 3
2 5 2 0 1 4 2 4 3 3 1 4 5 4 4 2 4 1 4 5 5 4 5
2 5 2 1 1 5 4 5 3 3 1 3 3 3 4 2 4 1 4 3 3 3 3
2 5 2 1 1 5 4 5 3 4 1 4 4 4 4 4 4 1 5 5 5 5 5
1 2 2 1 1 5 4 5 3 5 1 5 5 5 5 2 5 1 5 2 5 2 5
2 2 2 1 1 5 4 5 4 4 1 5 4 4 5 1 5 3 4 4 4
2 2 2 1 1 5 4 5 4 5 1 5 3 5 5 4 5 1 5 3 5 5 5
2 2 2 1 1 5 3 5 4 1 1 5 5 5 5 1 1 1 5 4 5 2 5
2 2 2 1 1 4 2 5 4 4 1 5 4 4 4 5 5 1 5 5 5 3 5
1 2 2 1 1 5 2 5 4 5 1 4 4 5 4 3 3 1 5 4 4 3 4
3 3 2 1 1 5 2 5 4 5 1 5 3 3 5 3 3 1 5 3 4 3 4
2 3 2 1 1 5 2 5 4 4 1 4 4 4 4 3 5 1 4 3 5 3 4
2 3 2 1 1 5 2 5 4 5 1 4 5 5 5 4 5 1 5 5 5 4 5
2 3 2 1 1 5 2 5 4 2 1 4 4 3 3 4 3 1 4 4 4 4 4
2 3 2 1 1 4 2 4 4 3 1 2 4 3 3 3 2 1 4 4 3 4 3
2 3 2 1 1 4 2 3 4 3 1 3 3 4 4 3 3 1 4 2 3 3 3
2 3 2 1 1 4 2 5 4 3 1 5 2 5 4 1 1 4 1 5
2 3 2 1 1 5 2 5 4 4 1 4 2 3 4 2 2 1 5 1 4 2 3
2 3 2 1 1 5 2 5 4 4 1 5 5 5 4 3 3 1 4 5 5 4 4
1 3 2 1 1 5 2 5 4 4 1 4 5 5 4 4 4 1 5 4 4 5 5
3 4 2 0 1 5 2 5 4 5 1 5 4 5 5 1 5 1 5 4 5 5 5
3 4 2 1 1 4 2 5 4 3 1 3 2 3 3 1 4 1 5 1 3 3 4
2 4 2 1 1 4 2 4 4 4 1 3 5 4 3 3 3 1 5 1 4 4 4
2 4 2 1 1 5 2 5 4 5 1 4 2 4 3 3 4 1 4 3 5 4 5
2 4 2 1 1 5 2 5 4 3 1 3 5 3 4 4 4 1 5 4 3 5 4
2 4 2 1 1 4 2 5 4 3 1 4 4 4 4 3 3 1 5 5 4 4 4
1 4 2 1 1 4 2 4 4 4 1 3 3 2 4 4 4 1 4 4 4 4 4
3 5 2 1 1 4 2 2 4 1 1 3 2 3 3 1 1 1 4 1 2 2 3
3 5 2 1 1 5 2 2 4 3 1 3 4 4 4 3 3 1 4 1 3 4 3
2 5 2 1 1 4 2 2 4 3 1 3 4 4 4 3 3 1 4 4 4 3 4
2 5 2 1 1 4 2 2 4 4 1 4 3 4 4 3 4 1 5 3 4 3 4
2 5 2 1 1 5 2 2 4 5 1 5 5 5 5 3 3 1 5 5 5 5 5
2 5 2 1 1 5 2 2 4 5 1 4 5 4 4 4 4 1 5 5 5 4 4
1 5 2 1 1 4 2 2 4 3 1 1 2 1 3 3 1 1 4 1 1 4 4
3 5 2 1 1 5 2 2 4 3 1 4 3 4 4 1 4 1 5 1 3 4 3
2 4 2 1 1 4 2 2 4 3 1 3 4 4 4 3 4 1 5 3 4 4 4
2 2 2 1 1 4 2 2 4 3 1 4 1 3 3 2 3 1 4 3 3 3 3
2 2 2 1 1 5 2 2 4 5 1 5 4 5 5 4 5 1 5 4 5 4 5
2 2 2 1 1 4 2 2 4 4 1 4 4 4 3 3 4 1 4 5 3 1 3
2 5 2 1 1 5 2 2 4 2 1 5 3 3 5 3 3 1 4 4 2 4 5
1 4 2 1 1 5 2 2 4 4 1 3 5 3 5 1 5 5 2
1 2 2 1 1 4 2 2 4 4 1 3 2 4 4 2 3 1 4 3 3 2 4
1 2 2 0 1 5 2 2 4 4 1 5 4 5 5 1 5 1 5 3 5 2 5
1 5 2 1 1 5 2 2 4 5 1 5 4 5 5 4 5 1 5 1 5 1 5
2 2 2 1 1 5 2 2 5 5 1 5 5 5 4 3 3 1 5 5 5 5 5
2 2 2 1 1 5 2 2 5 3 1 5 3 4 5 4 3 1 4 4 5 4 4
1 2 2 1 1 4 2 2 5 5 1 4 5 5 5 4 3 1 4 5 5 5 5
2 3 2 1 1 4 2 2 5 4 1 5 4 5 5 4 4 1 4 3 5 4 5
2 4 2 1 1 5 2 2 5 5 1 4 3 4 5 5 5 1 5 3 4 4 5
2 4 2 1 1 4 2 2 5 4 1 3 3 3 4 2 4 1 4 5 4 3 4
1 4 2 1 1 5 2 2 5 5 1 1 1 1 1 4 1 1 5 1 1 1 1
2 5 2 1 1 4 2 2 5 4 1 5 5 5 5 4 5 1 5 5 5 4 5
1 5 1 1 1 5 2 2 2 4 1 3 4 3 3 4 4 1 5 5 5
3 3 1 1 1 4 2 2 3 4 1 3 3 3 4 2 3 1 3 2 4 3 4
1 5 1 0 1 5 2 2 3 4 1 4 2 4 5 2 5 1 5 3 5 2 5
1 5 1 1 1 5 2 2 4 4 1 4 5 5 5 5 5 1 5 1 3 5 4
3 5 1 1 1 5 2 2 4 2 1 3 5 4 4 1 5 1 5 1 3 5 5
1 4 1 1 1 5 4 2 4 3 1 4 5 4 4 3 3 1 2 3 3 5 5
1 6 1 1 1 5 5 2 5 5 1 4 3 4 5 4 4 5 5 5 5 3 5
2

Determine the differences between people with < 4 Years of Tertiary Education and people with ≥ 4 Year of Tertiary Education. Use a variety of Graphs, Tables and Statistics to 'tell the story' about people with < 4 Years of Tertiary Education and people with ≥ 4 Years of Tertiary Education in this sample. Use the 5 variables in the data set related to the Recoded Years of Tertiary Education. You will need to do the following: 1. Recode Years of Tertiary Education into a a New Variable using an IF statement. =IF(A#<4,1,2) 2. You will also need to create 2 New Variables that are: i) Satisfaction with Career Score (Sat 1-10), low scores indicating low Satisfaction with their career and high scores indicating high Satisfaction with their career. ii)Total Well Being Score Score (WB1-9), low scores indicating poor Well Being and high score indication good Well Being (3marks) You are to write a brief report (half a page, insert in a textbox in this sheet) that summaries the main findings on the differences between people with < 4 Years Tertiary Education and people with ≥ 4 Years of Tertiary Education. 3 marks for data manipulation 7 marks for Pivot tables and or Graphs and Statistics 10 marks for paragraph 20 marks

Age Category: 1:<20 2: 20-<30 3: 30-<40 4: 40-<50 5: 50-<60 6: 60-<70

Employment Status 1: Full Time 2: Part Time

Recommend Tertiary Education 1: Yes 0: No

Recoded Years of Tertiary Education 1:< 4 Years of Tertiary Education 2: ≥ 4 Years of Tertiary Education