faculty of business, design and information technology

profilerupali
EXCEL.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 21
Task 2 18 marks 0 please review how to create single and double pivot tables and histograms
Task 3 18 marks 6
Task 4 20 marks 0
Task 5 20 marks 0
Total 100 marks (15%) 4.05

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 $ 1,448,754.55 0.5 simpy divide by 11
Income excluding GST $ 14,487,545.45 0.5
Cost Price (with Mark Up 47.45%) $ 10,807,934.89 0.5 incorrect, use B5
Income excluding Cost Price $ 3,679,610.56 0.5
Depreciation of Assets for the year (See Text Box 1) $ 8,326.28 0.5 good
Income excluding Depreciation $ 3,671,284.28 0.5
Salaries (See Text Box 2) $ 699,000.00 0.5
Income excluding Salaries $ 2,972,284.28 0.5
Donations to Charities $ 650,000.00
Income excluding Donations $ 2,322,284.28 0.5
Insurance, Rates, Telephones etc $ 35,000.00
Income excluding Insurance, Rates, Telephones etc $ 2,287,284.28 0.5
Car Leasing $ 400,000.00
Income excluding Car Leasing $ 1,887,284.28 0.5
Profit Before Company Tax $ 1,887,284.28 0.5 good
Company Tax $ 519,003.18 0.5
Profit After Company Tax $ 1,368,281.11 0.5
PAYE Tax for 6 staff Members each earning $75500 $ 96,507.00 0.5
PAYE Tax for 3staff Members earning $82000 $ 54,591.00 0.5 good
Total Tax to be paid to the ATO by this company $ 1,599,852.55 2.0 include company tax
10 marks
Part 2 Break Even Graph
4 marks Graph
include title and label axes
use scatterplot and join the dots to get a better graph
Part 3 Using Fx function (6marks)
$1,473,173.31 2marks 5% 12 42
$14,949.20 2marks 6% 4 160
$1,992.62 2marks 3.90% 4.5 39000
should be negative
Part 4 Using an appropriate formula (4 marks)
$ 115,879.00 2marks 115878.781672699
$ 235,384.00 2marks 235384.254597242
excellent
* GST rate is 10% in Australia (As per www.ato.gov.au)
* Tax rates as per ATO for 2018-19 (As per www.ato.gov.au)
*Compan tax rate is 27.5% (As per www.ato.gov.au)
PAYE calculation
Base till 37000 Above taxable amount (37000) Rate 32.5C Total tax individual Tax (total)
6 Members (75500 each ) 3572 38500 12512.5 16084.5 96507 good
3 Members (82000 each) 3572 45000 14625 18197 54591
Total Payable 151098
Break Even Point $ 100.00
Units Revenue Fixed Cost Variable Cost Total Cost Profit
60 $ 210.00 230 72 302 $ (92.00)
80 $ 280.00 230 96 326 $ (46.00)
100 $ 350.00 230 120 350 $ - 0
120 $ 420.00 230 144 374 $ 46.00
140 $ 490.00 230 168 398 $ 92.00
160 $ 560.00 230 192 422 $ 138.00

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.

Revenue 60 80 100 120 140 160 210 280 350 420 490 560 Total Cost 302 326 350 374 398 422

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: Break even point=fixed costs/(sales revenue - cost ) =(80+150)/[3.5-(1.1+.1)]

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 Row Labels Sum of Employment Status Sum of Exercise Frequency
65 1 28 1 11 1 $15,000.00 1 $12.00 1 436 324
66 1 37 1 10 3 $48,000.00 1 $23.00 1 257 170
67 1 33 1 16 1 $24,000.00 1 $20.00 2 179 154
71 1 53 1 15 5 $20,000.00 1 $10.00 2 1076 432
72 1 29 1 16 1 $28,500.00 1 $25.00 1 709 237
73 1 24 1 16 1 $13,872.00 1 $26.00 2 367 195
74 1 40 1 8 1 $5,000.00 1 $13.00 3 53 27
75 1 25 1 11 1 $35,000.00 1 $21.00 1 37 15
76 1 38 1 10 1 $23,000.00 1 $23.00 2 16 12
77 1 23 1 12 1 $20,000.00 1 $22.00 Grand Total 1565 783
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 FEMALES WORKING FULL TIME AND PART TIME
90 2 21 1 15 1 $15,120.00 1 $17.00
92 1 34 1 10 1 $26,000.00 1 $14.00 Row Labels Sum of Employment Status Sum of Exercise Frequency
94 1 53 1 12 1 $25,030.00 1 $26.00 1 436 324
95 1 33 1 10 1 $15,470.00 1 $31.00 1 257 170
96 2 25 1 16 1 $25,500.00 1 $17.00 2 179 154
97 1 22 1 14 1 $20,000.00 1 $17.00 Grand Total 436 324
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 MALES WORKING FULL TIME AND PART TIME
141 1 31 1 18 1 $10,000.00 1 $9.00
142 1 39 1 6 1 $5,000.00 1 $16.00 Row Labels Sum of Employment Status Sum of Exercise Frequency
144 2 56 1 9 7 $5,000.00 1 $10.00 2 1076 432
146 2 54 1 18 2 $10,000.00 1 $25.00 1 709 237
149 1 42 1 18 1 $10,000.00 1 $20.00 2 367 195
150 1 49 1 11 5 $12,000.00 1 $10.00 Grand Total 1076 432
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 NON BINARY
181 1 37 1 14 1 $18,018.00 2 $28.00
182 3 61 1 8 1 $5,000.00 2 $31.00 Row Labels Sum of Employment Status Sum of Exercise Frequency
184 1 46 1 10 1 $18,000.00 2 $25.00 3 53 27
186 1 21 1 9 4 $5,000.00 1 $10.00 1 37 15
188 3 33 1 10 1 $19,000.00 1 $15.00 2 16 12
190 1 60 1 13 1 $16,500.00 1 $14.00 Grand Total 53 27
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 2: SINGLE GRAPH WITH 2 VARIABLES
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 the above graphe showes the negetively skewed curved toward left side. Here we can see that the mean is less than the median, and they are both less than the mode. The mean and the median both reflect the skewing, but the mean reflects it more so
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 3: STUDENT STATUS AND EXERCISE FREQUENCY
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 Row Labels Sum of Exercise Frequency
324 2 58 1 10 7 $12,000.00 1 $10.00 1 422
327 2 35 1 12 7 $1,456.00 1 $10.00 2 361
328 2 50 1 8 3 $50,000.00 1 $22.00 Grand Total 783
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 This graph is showing the full time and part time employess and their sum of exercise frequency, here we can see that full time employees tend to visit more in exercise frequecy with part time emplyees by 61 as sum of frequency of full time was 422 while for part time is was 361.
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 3 : GENDER AND EXERCISE FREQUENCY
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 Row Labels Sum of Gender
385 2 31 1 10 7 $648.00 1 $10.00 1 389
387 2 46 1 10 9 $7,500.00 3 $10.00 2 113
388 1 69 1 6 5 $5,000.00 1 $10.00 3 218
391 2 78 1 10 5 $17,100.00 3 $10.00 Grand Total 720
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 This above graph shows that female employees showing more frequency of exercise than males and non binary. Female employees leading this exercise frequency by touching 389 and male employees shoed most less frequeny of exercise by only touching 113. Non binary employees showed second most highest frequency of excercise by touching 218.
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

Sum of Employment Status 1 2 1 257 179 Sum of Exercise Frequency 1 2 1 170 154 Sum of Employment Status 1 2 2 709 367 Sum of Exercise Frequency 1 2 2 237 195 Sum of Employment Status 1 2 3 37 16 Sum of Exercise Frequency 1 2 3 15 12 Total Income 50000 5000 10000 24020 50000 5000 5000 5000 50000 50000 8117 55000 3988 12000 50000 20000 13500 28750 5000 20600 8000 50000 28000 17320 25500 2860 5000 7500 22000 30000 22000 26934 50000 28000 24780 15000 48000 24000 20000 28500 13872 5000 35000 23000 20000 5000 14500 26020 24700 16500 10000 24000 15120 26000 25030 15470 25500 20000 26000 42000 17600 5000 9010 5000 14000 19020 20000 5000 24000 9600 19604 20600 27068 28020 24175 38000 5000 39000 5000 24100 10000 5000 5000 10000 10000 12000 25000 23000 8247 20000 5000 5000 13500 24500 16500 19900 15600 29000 30000 5000 19500 5000 5000 5000 5000 24000 18800 18018 5000 18000 5000 19000 16500 16500 5000 6000 13500 10000 5000 21060 17000 2941 23000 0 13500 5000 17500 20000 5000 5000 53200 10000 4844 5000 5000 10000 12000 10880 5000 7000 6124 4788 21000 35000 10700 45000 25400 5000 16276 5000 5000 5000 5000 10608 7020 1020 120 37000 12500 19312 10000 21000 2500 28000 6500 8512 5000 5000 2995 200 20900 5300 16000 5000 14700 25000 10525 5000 5000 3060 5000 13000 5000 10000 25000 5000 5000 5000 2060 5000 4358 28000 14050 5000 5000 4680 0 1360 5000 5000 26000 50000 12000 1456 50000 3262 5000 50000 50000 5000 50000 5000 5000 2995 19300 6000 5000 5000 5045 4346 50000 15000 1400 5148 4900 1456 5561 5788 4346 1456 4200 8000 7100 5000 10000 4019 30000 8500 50000 16640 20000 6923 6480 648 7500 5000 17100 12000 5000 10000 50000 2444 41000 2160 624 5300 50000 0 19000 4900 5780 6000 8000 5300 4346 5000 5000 0 5000 4800 10000 500 11000 6812 12460 7000 4000 7000 3840 7000 5000 154 50 5006 10000 12460 50000 5044 3500 10000 4000 50000 25000 16500 5000 16100 50000 24000 95000 12600 24000 50000 12000 10660 66000 5000 5000 4082 18300 56200 13000 5338 15600 68000 10000 10000 24500 6468 5000 50000 4899 14000 19700 5000 7000 5000 5000 21000 10000 5000 5000 5000 5000 5000 30300 8224 10000 15600 5616 25000 34615 65000 33514 750 11960 5000 20000 13500 5000 13000 19660 5000 538 10000 5000 2995 4680 19600 5000 20000 3224 12300 10000 13500 16500 5000 5000 25704 23930 50000 40000 2000 5000 27000 5780 10000 8060 3000 7268 5000 32205 5954 17700 5000 5954 4200 16360 5780 5000 3900 14714 4000 3380 5564 5000 5000 5000 16000 5292 5000 30000 5000 29700 1020 7722 5000 5000 5000 5000 4810 5000 8292 2652 5000 18888 6300 200 5000 3600 3978 50000 5000 5000 9600 11565 5000 11000 5000 7514 50000 624 7500 12948 7000 5720 5000 50000 6214 8160 5000 10608 6500 11000 12460 Weekly Take Away Coffee Expense 26 15 19 8 10 21 10 10 15 15 23 27 10 15 15 18 30 17 22 19 26 15 11 24 26 10 19 13 21 26 20 18 20 20 16 12 23 20 10 25 26 13 21 23 22 12 22 22 24 23 20 25 17 14 26 31 17 17 23 24 17 19 19 10 18 13 10 10 16 10 21 19 20 8 27 18 10 16 10 20 9 16 10 25 20 10 9 20 10 9 17 25 17 18 16 10 30 11 19 17 29 10 18 17 10 18 25 28 31 25 10 15 14 20 10 10 27 18 23 17 24 10 19 24 27 17 13 10 10 10 14 25 10 14 11 24 10 24 25 18 10 10 20 13 21 22 22 19 12 20 10 10 16 10 27 10 10 24 19 20 24 21 11 21 10 10 10 10 10 10 23 10 17 15 25 16 23 10 10 10 10 21 10 20 21 10 10 10 10 10 10 21 10 10 10 10 26 10 10 10 23 10 10 10 22 16 22 10 19 10 10 17 16 10 10 10 10 10 10 10 10 10 19 10 10 10 10 32 10 10 22 10 10 10 10 10 23 10 10 20 10 17 31 10 10 10 10 10 10 10 10 21 22 10 10 10 10 10 22 10 10 10 16 10 10 10 15 10 10 25 10 10 10 10 10 10 10 10 12 10 10 17 10 19 10 10 10 10 10 22 10 15 22 26 10 10 18 24 24 15 19 25 24 22 13 15 10 10 30 17 21 22 23 13 26 20 27 10 10 20 10 24 24 17 17 10 17 19 30 10 10 24 11 19 16 10 10 18 10 22 20 10 24 20 27 10 22 27 18 18 14 26 33 10 10 10 10 18 10 17 10 25 17 19 13 10 17 21 13 10 11 16 25 17 10 16 22 11 20 10 16 10 29 10 10 19 20 10 10 21 18 10 10 10 21 10 16 10 10 10 23 10 21 10 10 10 28 10 21 10 19 10 10 26 10 16 10 10 10 10 12 10 10 10 30 27 15 10 10 10 10 10 32 14 10 10 10 10 10 10 10 10 10 10 FULL TIME 422 PART TIME 361 FEMALE 389 MALE 113 NON BINARY 218

Task 3

Age Hours of Exercise/Physical Activity Score Estimated Value
18 10 35.7911751891
18 15 35.7911751891
18 15 35.7911751891
18 15 35.7911751891
20 15 37.5982934801
20 15 37.5982934801
20 15 37.5982934801
21 15 38.5018526257
21 15 38.5018526257
21 15 38.5018526257
21 15 38.5018526257
21 16 38.5018526257
21 17 38.5018526257
22 17 39.4054117712
22 18 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
22 19 39.4054117712
23 19 40.3089709168
19 20 36.6947343346
20 20 37.5982934801 Description of Correlation
20 20 37.5982934801
21 20 38.5018526257
21 20 38.5018526257
21 20 38.5018526257
21 20 38.5018526257
21 20 38.5018526257
21 20 38.5018526257
22 20 39.4054117712
22 20 39.4054117712
22 20 39.4054117712 Answer 1 0.63 what does this value tell us?
22 20 39.4054117712 what about r2
23 20 40.3089709168 Graph
31 20 47.5374440811
18 21 35.7911751891
19 21 36.6947343346
21 21 38.5018526257
21 21 38.5018526257
21 21 38.5018526257
22 21 39.4054117712
23 21 40.3089709168 label x and y axis
23 21 40.3089709168 include equation in the graph
23 21 40.3089709168
23 21 40.3089709168
24 21 41.2125300623
24 21 41.2125300623
24 21 41.2125300623
24 21 41.2125300623
29 21 45.73032579
30 21 46.6338849356
21 22 38.5018526257
22 22 39.4054117712
21 23 38.5018526257
22 23 39.4054117712
22 23 39.4054117712
23 23 40.3089709168
27 23 43.923207499
29 23 45.73032579 Answer 2
29 23 45.73032579 Intercept 19.5271105692
46 23 61.0908312643 Slope 0.9035591455 Dependent Variable= Physical Excersice Score
33 24 49.3445623722 Independent Variable= Age
18 25 35.7911751891 Age=A+B*score
19 25 36.6947343346 y=a+bx
20 25 37.5982934801 a= intercept
22 25 39.4054117712 b= slope please review how to interpret the slope and intercept value in relation to the data you have
23 25 40.3089709168
27 25 43.923207499 Description of Regression
30 25 46.6338849356
33 25 49.3445623722
43 29 58.3801538277
21 30 38.5018526257
19 33 36.6947343346
20 33 37.5982934801
21 33 38.5018526257
22 33 39.4054117712
23 33 40.3089709168
23 33 40.3089709168
30 33 46.6338849356
21 34 38.5018526257
23 35 40.3089709168 Answer 3 (a)
23 35 40.3089709168 need to show how you used Excel to get the predicted value
36 35 52.0552398089
21 36 38.5018526257
21 36 38.5018526257 Answer 3 (b)
32 37 48.4410032267
48 37 62.8979495554
37 38 52.9587989544
35 39 51.1516806633
36 39 52.0552398089
19 40 36.6947343346
24 40 41.2125300623
24 40 41.2125300623
24 40 41.2125300623
26 40 43.0196483534
30 40 46.6338849356
39 40 54.7659172455
41 40 56.5730355366
23 41 40.3089709168
26 41 43.0196483534
33 41 49.3445623722
20 42 37.5982934801
24 42 41.2125300623
26 42 43.0196483534
26 42 43.0196483534
31 42 47.5374440811
36 42 52.0552398089
42 42 57.4765946821
45 42 60.1872721188
26 43 43.0196483534
26 43 43.0196483534
26 43 43.0196483534
34 43 50.2481215178
42 43 57.4765946821
46 43 61.0908312643
60 43 73.7406593019
30 44 46.6338849356
40 44 55.669476391
40 44 55.669476391
45 44 60.1872721188
48 44 62.8979495554
49 44 63.8015087009
25 45 42.1160892079
25 45 42.1160892079
25 45 42.1160892079
26 45 43.0196483534
26 45 43.0196483534
27 45 43.923207499
27 45 43.923207499
48 45 62.8979495554
50 45 64.7050678465
26 46 43.0196483534
49 46 63.8015087009
30 47 46.6338849356
31 47 47.5374440811
35 47 51.1516806633
43 47 58.3801538277
26 48 43.0196483534
27 48 43.923207499
31 48 47.5374440811
39 48 54.7659172455
41 48 56.5730355366
54 48 68.3193044287
35 49 51.1516806633
36 49 52.0552398089
38 49 53.8623581
42 49 57.4765946821
45 49 60.1872721188
48 49 62.8979495554
49 49 63.8015087009
54 49 68.3193044287
25 50 42.1160892079
27 50 43.923207499
31 50 47.5374440811
34 50 50.2481215178
42 50 57.4765946821
42 50 57.4765946821
42 50 57.4765946821
36 51 52.0552398089
44 51 59.2837129732
44 51 59.2837129732
46 51 61.0908312643
47 51 61.9943904099
24 52 41.2125300623
28 52 44.8267666445
30 52 46.6338849356
32 52 48.4410032267
35 52 51.1516806633
35 52 51.1516806633
36 52 52.0552398089
42 52 57.4765946821
49 52 63.8015087009
25 53 42.1160892079
27 53 43.923207499
31 53 47.5374440811
34 53 50.2481215178
38 53 53.8623581
39 53 54.7659172455
40 53 55.669476391
47 53 61.9943904099
50 53 64.7050678465
58 53 71.9335410109
59 53 72.8371001564
60 53 73.7406593019
62 53 75.547777593
23 54 40.3089709168
24 54 41.2125300623
26 54 43.0196483534
27 54 43.923207499
27 54 43.923207499
27 54 43.923207499
28 54 44.8267666445
32 54 48.4410032267
33 54 49.3445623722
35 54 51.1516806633
35 54 51.1516806633
38 54 53.8623581
47 54 61.9943904099
47 54 61.9943904099
49 54 63.8015087009
50 54 64.7050678465
23 55 40.3089709168
23 55 40.3089709168
23 55 40.3089709168
24 55 41.2125300623
34 55 50.2481215178
41 55 56.5730355366
51 55 65.608626992
52 55 66.5121861376
24 56 41.2125300623
36 56 52.0552398089
50 56 64.7050678465
55 56 69.2228635742
56 56 70.1264227198
24 57 41.2125300623
25 57 42.1160892079
28 57 44.8267666445
50 57 64.7050678465
56 57 70.1264227198
57 57 71.0299818653
25 58 42.1160892079
27 58 43.923207499
31 58 47.5374440811
33 58 49.3445623722
34 58 50.2481215178
37 58 52.9587989544
39 58 54.7659172455
41 58 56.5730355366
43 58 58.3801538277
46 58 61.0908312643
48 58 62.8979495554
28 59 44.8267666445
41 59 56.5730355366
45 59 60.1872721188
48 59 62.8979495554
50 59 64.7050678465
54 59 68.3193044287
63 59 76.4513367386
67 59 80.0655733208
29 60 45.73032579
33 60 49.3445623722
43 60 58.3801538277
44 60 59.2837129732
45 60 60.1872721188
46 60 61.0908312643
48 60 62.8979495554
48 60 62.8979495554
50 60 64.7050678465
53 60 67.4157452831
54 60 68.3193044287
56 60 70.1264227198
27 61 43.923207499
28 61 44.8267666445
28 61 44.8267666445
32 61 48.4410032267
35 61 51.1516806633
36 61 52.0552398089
44 61 59.2837129732
48 61 62.8979495554
56 61 70.1264227198
25 62 42.1160892079
25 62 42.1160892079
44 62 59.2837129732
45 62 60.1872721188
45 62 60.1872721188
46 62 61.0908312643
47 62 61.9943904099
50 62 64.7050678465
55 62 69.2228635742
24 63 41.2125300623
24 63 41.2125300623
28 63 44.8267666445
31 63 47.5374440811
31 63 47.5374440811
33 63 49.3445623722
36 63 52.0552398089
41 63 56.5730355366
54 63 68.3193044287
70 63 82.7762507574
26 64 43.0196483534
33 64 49.3445623722
33 64 49.3445623722
35 64 51.1516806633
37 64 52.9587989544
37 64 52.9587989544
38 64 53.8623581
38 64 53.8623581
41 64 56.5730355366
42 64 57.4765946821
44 64 59.2837129732
46 64 61.0908312643
67 64 80.0655733208
25 65 42.1160892079
36 65 52.0552398089
37 65 52.9587989544
40 65 55.669476391
40 65 55.669476391
41 65 56.5730355366
48 65 62.8979495554
50 65 64.7050678465
64 65 77.3548958841
25 66 42.1160892079
28 66 44.8267666445
31 66 47.5374440811
33 66 49.3445623722
34 66 50.2481215178
37 66 52.9587989544
37 66 52.9587989544
38 66 53.8623581
41 66 56.5730355366
48 66 62.8979495554
51 66 65.608626992
52 66 66.5121861376
57 66 71.0299818653
32 67 48.4410032267
35 67 51.1516806633
36 67 52.0552398089
40 67 55.669476391
48 67 62.8979495554
48 67 62.8979495554
53 67 67.4157452831
24 68 41.2125300623
35 68 51.1516806633
36 68 52.0552398089
46 68 61.0908312643
49 68 63.8015087009
62 68 75.547777593
65 68 78.2584550297
70 68 82.7762507574
30 69 46.6338849356
38 69 53.8623581
41 69 56.5730355366
44 69 59.2837129732
46 69 61.0908312643
49 69 63.8015087009
50 69 64.7050678465
51 69 65.608626992
27 70 43.923207499
29 70 45.73032579
31 70 47.5374440811
34 70 50.2481215178
35 70 51.1516806633
36 70 52.0552398089
37 70 52.9587989544
41 70 56.5730355366
42 70 57.4765946821
44 70 59.2837129732
52 70 66.5121861376
56 70 70.1264227198
58 70 71.9335410109
31 71 47.5374440811
32 71 48.4410032267
32 71 48.4410032267
33 71 49.3445623722
36 71 52.0552398089
39 71 54.7659172455
46 71 61.0908312643
48 71 62.8979495554
53 71 67.4157452831
31 72 47.5374440811
35 72 51.1516806633
37 72 52.9587989544
42 72 57.4765946821
48 72 62.8979495554
49 72 63.8015087009
50 72 64.7050678465
58 72 71.9335410109
60 72 73.7406593019
61 72 74.6442184475
28 73 44.8267666445
35 73 51.1516806633
36 73 52.0552398089
39 73 54.7659172455
44 73 59.2837129732
44 73 59.2837129732
46 73 61.0908312643
47 73 61.9943904099
57 73 71.0299818653
61 73 74.6442184475
24 74 41.2125300623
42 74 57.4765946821
47 74 61.9943904099
51 74 65.608626992
55 74 69.2228635742
66 74 79.1620141752
27 75 43.923207499
31 75 47.5374440811
32 75 48.4410032267
36 75 52.0552398089
46 75 61.0908312643
50 75 64.7050678465
60 75 73.7406593019
25 76 42.1160892079
31 76 47.5374440811
36 76 52.0552398089
51 76 65.608626992
33 77 49.3445623722
38 77 53.8623581
39 77 54.7659172455
46 77 61.0908312643
50 78 64.7050678465
51 78 65.608626992
55 78 69.2228635742
74 78 86.3904873396
78 78 90.0047239218
32 79 48.4410032267
36 79 52.0552398089
40 79 55.669476391
41 79 56.5730355366
52 79 66.5121861376
63 79 76.4513367386
65 79 78.2584550297
45 80 60.1872721188
49 80 63.8015087009
49 80 63.8015087009
60 80 73.7406593019
63 80 76.4513367386
68 80 80.9691324663
75 80 87.2940464851
82 80 93.6189605039
27 81 43.923207499
37 81 52.9587989544
55 81 69.2228635742
48 82 62.8979495554
48 82 62.8979495554
74 82 86.3904873396
55 83 69.2228635742
66 83 79.1620141752
68 83 80.9691324663
53 84 67.4157452831
69 85 81.8726916119
28 86 44.8267666445
41 86 56.5730355366
56 86 70.1264227198
45 88 60.1872721188
44 59.28
15 33.08

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)

Hours of Exercise/Physical Activity Score

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

The Correlation is tells us the relation between the two data set measn how much similarity and relation between the two data sets. It also tells us that how much is significance is between two data sets. Correlation is also tells us the what is magnitude of relation between both data sets. Significane tell us that either the correlation is negative or positive and magnitude tells us tha either the relationshio is high corelation or low corelation. This shows that there is positive relation betwee age and physical activity score. If age will increase physical activity hours should be increase and vice versa. The standard value for Correlation is (-1 to 1). So this is directly propotional to each other . Here the Magnitude is 0.63 and Sign is Positive.

Regression is used correlation and design equation for dependent variable and Independent variable. To find any value from data set and the value which have to find is dependent variable. So If I want to predict the score for the some given age means if age will be greater then how it effects the score rate and vice versa. So here the dependent variable is Physical Score and independent Variable is Age. So Y=a+bx which is linear regression Equation where a in intercept and if age 0 so how it effects and b is here is called slope. Slope is a rate of change in two sets. To find regression in equation we need the value of intercept and slope and we need the value of known Set A and Know Set B. So Now we have to measure the estimaed physical score we will just Add (Intercept (a) with (slope) *(Age). In this slope and intercept always remain same so I am going to fix it with F4 and now I am copying the formuale and paste it and put any value of agg you will get the prediction value of average physical hours. Prediction Values are puted at very bottom of the Columm A.

If the age is 44 then the predictible physical activity score will be 59.28 it means that if the age of the person is higher then the hours of excersice will be greater .

If the age is 15 then the predictible physical activity score will be 33.08 it means that if the age of the person is less then the hours of excersice will be less.

Task 4

Weekly Rent Expenditure $
$ 230.00
$ 230.00 Average Weekly Rent Expenditure $ 160.96
$ 230.00 Standard Deviation of Weekly Rent Expenditure $ 27.79
$ 200.00 0.5 mark
$ 200.00 decimal %
$ 200.00 Spend more than $150. 57.00 78%
$ 200.00 Spend less than $175 26 36%
$ 200.00 Spend between $170 and $230 26 36% please review how to use Excel to work out % in the normal distribution
$ 200.00 Spend between $130 and $180 54 74%
$ 200.00
$ 200.00 Dollar amount for highest 11% of Rent Amount 1290 11%
$ 200.00 Dollar amount for lowest 4% of Rent Amount 480 4%
$ 200.00
$ 180.00
$ 180.00
$ 180.00
$ 180.00 1. $135 129.2083431634
$ 180.00 A positive z-score indicates the raw score is higher than the mean average. 129.8 positive meance this amount is above the mean value. incorrect
$ 180.00
$ 180.00
$ 180.00
$ 180.00 2. $175 169.2083431634
$ 180.00 A positive z-score indicates the raw score is higher than the mean average. 169.2 positive meance this amount is above the mean value.
$ 180.00
$ 180.00
$ 180.00
$ 160.00
$ 160.00 3. $255 249.2083431634
$ 160.00 A positive z-score indicates the raw score is higher than the mean average. 249.2 positive meance this amount is above the mean value.
$ 160.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 150.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 130.00
$ 125.00
$ 125.00
$ 120.00
$ 120.00
$ 120.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 36 5 2 3 5 5 5 5 5 5 40
8 2 1 1 4 5 3 5 2 5 4 5 5 5 43 5 4 5 5 5 3 5 3 5 40
8 2 1 1 5 5 3 5 4 5 4 5 5 5 46 5 3 2 5 5 2 5 2 5 34
8 2 1 1 4 5 3 4 3 4 2 5 3 5 38 4 3 4 5 5 3 5 3 5 37
8 2 1 1 3 5 3 5 3 5 4 5 4 5 42 4 3 4 5 4 2 4 3 5 34
6 3 1 1 5 5 3 5 1 5 1 5 1 5 36 5 1 5 5 5 1 5 1 5 33
6 3 1 1 4 5 3 5 1 5 1 5 1 5 35 5 3 5 5 5 4 5 1 5 38
7 2 1 1 5 5 2 5 1 5 2 5 3 2 35 4 2 5 5 5 5 5 3 5 39
7 1 1 0 5 5 2 5 1 5 1 5 1 5 35 5 1 5 5 5 1 5 1 5 33
8 2 1 1 4 4 4 4 2 3 3 5 4 4 37 3 4 5 5 5 2 4 5 5 38
8 2 1 1 4 4 4 4 2 4 3 5 2 4 36 4 1 4 5 4 4 4 1 4 31
7 2 1 1 4 4 3 3 2 4 2 5 3 5 35 5 3 5 5 4 5 5 4 5 41
7 2 1 1 4 4 3 5 2 5 3 5 4 4 39 4 2 4 5 4 5 4 2 3 33
6 2 1 1 4 5 3 5 2 3 2 5 4 4 37 4 1 3 5 5 2 3 3 4 30
8 3 1 1 2 5 1 5 2 5 2 5 2 3 32 5 1 5 5 5 2 3 4 4 34
8 3 1 1 4 4 4 5 2 2 1 5 3 4 34 4 2 4 5 4 3 4 2 4 32
8 3 1 1 5 3 3 5 2 4 4 4 4 4 38 4 1 4 5 3 3 4 3 3 30
7 3 1 1 3 4 3 5 2 4 3 4 3 4 35 4 2 4 5 4 4 4 2 4 33
6 3 1 1 4 5 3 5 2 4 1 4 3 4 35 4 3 5 5 5 2 4 3 4 35
6 3 1 1 3 4 3 5 2 4 4 4 3 3 35 3 4 4 5 3 4 4 4 4 35
8 4 1 1 3 4 4 5 2 5 1 5 1 5 35 5 1 4 5 5 1 5 1 5 32
8 4 1 1 5 4 3 4 2 1 2 2 4 3 30 4 4 2 5 5 2 2 4 4 32
8 4 1 1 4 5 2 5 2 4 1 5 2 5 35 5 2 5 5 5 3 5 1 5 36
5 4 1 1 5 5 4 5 2 4 3 4 4 4 40 4 1 4 5 4 5 4 4 31
8 5 1 1 5 5 4 5 2 3 5 5 3 4 41 5 3 3 5 5 1 4 4 4 34
8 5 1 1 4 4 2 5 2 5 5 5 1 5 38 5 2 5 5 3 1 5 3 5 34
8 5 1 1 5 4 3 5 2 5 5 4 3 4 40 4 1 5 5 4 3 5 3 4 34
8 5 1 1 4 4 4 4 2 5 5 4 3 3 38 4 3 4 5 4 5 5 4 4 38
8 4 1 1 5 5 4 5 2 4 5 5 2 5 42 5 2 3 5 5 1 5 2 5 33
8 3 1 1 4 4 4 4 2 3 5 4 2 4 36 4 3 3 5 4 1 5 3 4 32
8 1 1 1 4 4 3 4 2 3 5 3 3 3 34 4 3 3 5 4 1 5 3 3 31
7 4 1 1 5 3 4 4 2 5 5 3 1 3 35 3 2 4 5 4 3 5 2 3 31
7 1 1 1 5 5 3 5 2 5 5 3 2 3 38 3 3 4 5 4 1 5 2 4 31
7 2 1 1 4 4 4 4 2 4 5 5 4 4 40 5 3 5 5 4 4 5 3 5 39
7 2 1 1 4 4 3 4 2 3 5 4 3 4 36 3 4 3 5 3 2 5 1 4 30
8 2 1 1 3 4 2 5 3 3 5 4 3 5 37 4 4 4 5 5 5 27
8 2 1 1 5 5 3 5 3 5 5 4 2 5 42 4 2 4 5 4 4 5 1 5 34
7 2 1 1 4 5 3 5 3 5 5 5 4 5 44 5 4 5 5 5 4 5 2 5 40
7 2 1 1 3 4 4 4 3 3 5 4 5 5 40 2 2 2 5 3 4 5 4 4 31
7 2 1 1 4 4 4 5 3 4 5 4 4 4 41 4 3 4 5 4 3 5 2 5 35
7 2 1 1 4 4 4 4 3 4 5 4 3 4 39 4 3 4 5 4 4 5 4 4 37
6 2 1 1 5 5 5 5 3 3 5 4 3 4 42 5 3 5 5 4 4 5 4 5 40
5 2 1 1 4 5 4 5 3 3 5 4 5 5 43 4 2 3 5 4 5 5 5 5 38
5 2 1 1 4 5 4 5 3 4 5 5 4 4 43 3 4 4 5 5 4 5 5 5 40
8 3 1 1 3 3 4 5 3 3 5 4 2 4 36 5 2 3 5 5 1 5 4 5 35
7 3 1 1 4 5 4 5 3 5 5 5 4 5 45 5 4 3 5 4 4 5 4 5 39
7 3 1 1 5 5 4 5 3 5 3 4 3 5 42 4 2 4 5 5 3 5 3 4 35
7 3 1 1 4 5 2 5 3 5 3 3 4 4 38 4 3 2 5 4 5 5 4 4 36
7 3 1 1 5 5 5 5 3 4 4 4 4 4 43 4 4 4 5 4 4 5 4 4 38
7 3 1 1 4 5 3 5 3 5 3 5 4 37 4 3 4 5 5 4 5 2 5 37
6 3 1 1 4 4 3 5 3 4 1 4 1 4 33 4 3 4 4 4 1 5 3 4 32
6 3 1 1 4 4 3 5 3 4 3 5 2 5 38 4 3 5 3 5 2 5 3 4 34
6 3 1 1 5 5 4 5 3 4 3 4 3 5 41 4 4 4 4 4 5 4 5 34
8 4 1 1 4 4 2 5 3 4 4 5 3 4 38 4 3 3 4 4 3 5 4 4 34
8 4 1 1 4 5 3 5 3 4 4 5 3 5 41 5 3 5 4 4 4 5 2 5 37
8 4 1 1 4 5 3 5 3 2 2 5 1 5 35 5 3 3 4 5 4 5 2 5 36
8 4 1 1 4 5 4 5 3 5 4 4 3 4 41 4 4 5 4 5 4 5 3 5 39
8 4 1 1 3 4 4 5 3 3 1 3 2 3 31 3 1 3 4 4 2 5 3 4 29
8 4 1 1 4 5 2 5 3 3 4 3 4 4 37 3 1 1 3 4 3 5 2 4 26
8 4 1 1 4 5 4 5 3 5 4 5 3 5 43 5 4 5 4 5 5 5 2 5 40
8 4 1 1 5 5 4 5 3 3 4 4 4 5 42 4 4 4 4 4 5 5 3 5 38
6 4 1 1 4 4 4 5 3 4 4 4 4 4 40 4 4 4 4 4 3 5 4 4 36
8 5 1 1 5 4 5 5 3 3 4 3 4 4 40 3 4 4 5 4 2 5 5 5 37
8 5 1 1 4 4 4 5 3 3 4 4 4 4 39 4 4 5 4 4 3 5 4 4 37
8 5 1 1 5 2 3 5 3 1 4 4 1 3 31 4 1 3 5 5 1 5 4 5 33
6 5 1 1 4 4 5 5 3 3 3 3 3 3 36 4 4 4 4 4 5 25
6 5 1 1 4 5 5 5 3 5 1 5 1 5 39 4 4 4 5 3 5 4 5 34
6 5 1 1 3 4 4 5 3 3 3 3 2 3 33 4 3 3 3 4 2 5 3 3 30
5 5 1 1 5 5 4 5 3 4 5 1 5 4 41 5 5 3 4 5 5 5 4 5 41
8 4 1 1 5 5 2 5 3 4 2 5 4 5 40 5 1 5 4 5 3 5 2 5 35
8 5 1 1 4 4 3 5 3 4 5 4 4 5 41 2 3 3 4 4 5 3 4 28
8 5 1 1 5 5 3 5 3 4 3 3 3 4 38 3 3 3 4 5 3 5 3 4 33
8 4 1 1 5 5 4 5 3 5 3 5 5 5 45 5 3 5 3 5 5 5 4 5 40
8 2 1 1 4 5 4 5 3 4 4 3 4 3 39 4 3 3 3 4 3 5 4 4 33
8 2 1 1 4 5 3 5 3 3 1 5 3 2 34 3 3 4 5 5 1 5 4 4 34
8 2 1 1 5 5 3 5 3 4 3 4 4 4 40 4 2 4 5 5 3 5 2 4 34
8 3 1 1 4 5 4 5 3 2 1 1 1 1 27 1 2 1 2 1 1 5 2 1 16
8 4 1 1 4 4 3 4 3 2 1 1 4 3 29 3 4 3 5 5 2 5 5 4 36
7 1 1 1 4 5 4 4 3 4 4 5 5 5 43 4 3 4 3 5 4 5 5 4 37
6 2 1 1 4 5 4 4 3 4 4 4 4 4 40 4 3 4 3 4 4 5 3 5 35
6 5 1 1 5 5 3 5 3 3 1 3 1 5 34 5 5 5 3 5 1 5 1 5 35
6 5 1 1 3 3 3 3 3 3 4 4 3 4 33 3 3 4 3 3 3 5 2 2 28
6 5 1 1 4 4 4 5 3 4 1 5 1 5 36 5 2 2 4 4 1 5 3 26
8 2 1 1 4 5 5 5 4 4 4 5 5 5 46 5 4 4 4 5 3 5 4 5 39
6 2 1 1 5 5 3 5 4 3 2 1 3 3 34 1 1 1 5 5 3 5 3 4 28
4 2 1 1 4 5 3 5 4 5 2 5 3 5 41 5 3 3 4 5 3 5 1 5 34
8 3 1 1 5 5 4 5 4 4 5 5 4 4 45 5 5 5 4 5 5 5 5 5 44
8 3 1 1 5 5 5 5 4 5 4 5 4 5 47 5 3 5 5 5 2 5 4 5 39
8 3 1 1 4 4 4 5 4 4 3 3 3 3 37 3 4 5 4 4 3 5 3 3 34
7 3 1 1 4 4 3 5 4 2 4 5 3 4 38 4 3 5 4 5 4 5 3 4 37
7 3 1 1 4 4 4 5 4 3 3 4 3 4 38 4 4 5 3 4 4 5 4 4 37
7 3 1 1 4 4 3 5 4 4 4 5 4 4 41 4 3 5 4 4 4 5 4 4 37
7 3 1 1 5 5 4 5 4 5 3 5 3 5 44 5 2 5 2 5 3 5 1 5 33
7 3 1 1 4 4 3 5 4 3 5 4 5 4 41 4 3 5 4 5 5 5 4 4 39
6 3 1 1 5 4 4 5 4 3 4 4 4 4 41 4 4 5 4 4 4 5 4 4 38
6 3 1 1 5 4 3 5 4 2 2 4 3 3 35 3 2 5 4 4 4 5 3 4 34
6 3 1 1 4 5 4 5 4 5 3 4 3 4 41 4 3 5 4 5 2 5 4 5 37
5 3 1 1 5 4 4 5 4 4 5 3 4 4 42 4 4 5 4 5 5 5 3 5 40
4 3 1 1 4 4 3 5 4 4 5 5 4 5 43 5 3 5 5 5 5 5 4 5 42
8 4 1 1 3 4 3 5 4 4 4 5 4 5 41 5 4 5 5 5 3 5 4 4 40
8 4 1 1 3 5 2 5 4 3 1 5 2 5 35 4 2 5 5 5 1 5 2 5 34
8 4 1 1 5 5 5 5 4 4 3 4 4 4 43 4 4 5 4 4 3 5 4 4 37
8 4 1 1 4 4 4 5 4 4 2 3 4 4 38 3 3 5 3 4 2 5 4 4 33
8 4 1 1 5 5 3 5 4 4 3 3 4 4 40 4 3 5 4 5 3 5 4 5 38
8 4 1 1 3 5 2 5 4 2 1 5 1 5 33 4 2 5 4 5 1 5 4 5 35
8 4 1 1 5 5 4 5 4 5 3 4 4 5 44 4 3 5 3 4 3 5 3 4 34
8 4 1 1 3 5 3 5 4 4 1 5 1 4 35 5 4 5 4 4 3 5 1 5 36
8 4 1 1 5 5 4 5 4 5 5 1 5 3 42 4 4 5 5 5 4 5 5 5 42
8 4 1 1 5 4 3 5 4 4 3 4 4 4 40 5 4 5 4 5 3 5 3 4 38
8 4 1 1 4 4 4 5 4 4 3 4 3 3 38 4 3 5 4 4 3 5 3 3 34
8 4 1 1 4 4 4 5 4 4 4 4 4 4 41 5 5 5 4 5 5 5 3 5 42
7 4 1 1 5 4 3 5 4 3 3 3 4 3 37 3 3 5 3 3 4 5 3 4 33
7 4 1 1 4 5 5 5 4 5 4 5 3 4 44 5 4 5 4 5 5 5 4 5 42
6 4 1 1 4 4 5 5 4 2 3 4 5 4 40 4 3 5 5 4 4 5 3 4 37
6 4 1 1 5 5 3 5 4 4 3 3 3 3 38 4 4 5 3 4 4 5 4 5 38
6 4 1 1 4 5 4 5 4 3 1 4 2 4 36 4 3 5 4 4 1 5 3 4 33
4 4 1 1 4 4 4 5 4 3 4 4 4 4 40 4 4 5 4 4 4 5 4 4 38
7 5 1 1 5 5 4 5 4 4 5 1 4 5 42 4 5 5 4 4 4 5 4 4 39
6 5 1 1 4 5 4 5 4 4 5 4 5 40 4 3 5 4 4 5 25
6 5 1 1 3 4 3 5 4 3 5 4 4 4 39 4 4 5 4 4 2 5 28
6 5 1 1 4 5 4 5 4 5 5 5 3 5 45 5 5 5 4 5 5 5 3 5 42
6 5 1 1 4 5 4 5 4 5 5 3 3 3 41 3 4 5 4 5 3 5 4 4 37
6 5 1 1 4 5 4 4 4 3 5 3 3 4 39 3 4 5 4 4 1 5 3 3 32
6 5 1 1 5 5 4 5 4 4 5 4 4 4 44 4 4 5 4 4 3 5 3 4 36
5 5 1 1 5 5 3 4 4 4 5 4 4 4 42 4 3 5 5 5 4 5 4 4 39
8 3 1 1 4 2 3 5 4 5 5 1 4 1 34 2 3 5 4 4 4 5 4 4 35
8 1 1 1 4 5 3 5 4 5 5 4 2 5 42 4 3 5 5 5 1 5 3 5 36
8 2 1 1 5 4 2 5 4 3 5 5 2 5 40 5 3 5 4 5 1 5 1 5 34
8 3 1 1 5 3 4 3 4 3 5 3 1 4 35 4 3 5 4 4 3 5 3 5 36
8 4 1 1 4 4 4 4 4 3 5 4 3 3 38 4 3 5 4 4 3 5 3 3 34
8 3 1 1 5 5 3 5 4 5 5 3 3 4 42 2 5 5 5 2 5 5 29
8 3 1 1 4 4 5 5 4 2 5 4 3 3 39 3 1 5 4 4 1 5 3 3 29
7 2 1 1 5 5 4 5 4 5 5 5 4 5 47 5 4 5 3 5 5 5 3 5 40
7 1 1 1 4 4 4 4 4 4 5 4 4 4 41 4 4 5 4 4 4 5 4 4 38
6 2 1 1 4 3 4 4 4 3 5 2 3 3 35 4 3 5 4 4 4 5 3 3 35
6 2 1 1 5 5 3 5 4 3 5 4 4 4 42 4 3 5 3 3 1 5 2 4 30
5 6 1 1 5 5 4 4 4 3 5 4 4 4 42 3 4 5 5 5 5 5 4 4 40
6 2 1 1 5 5 5 5 5 4 5 5 5 3 47 4 5 5 4 2 5 5 3 3 36
4 2 1 1 4 4 4 4 5 4 5 5 5 5 45 5 4 5 5 5 4 5 4 5 42
8 3 1 1 5 4 3 4 5 1 5 3 4 3 37 5 2 5 5 4 4 5 3 3 36
8 3 1 1 5 5 4 5 5 5 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
8 3 1 1 5 5 3 4 5 5 5 4 4 4 44 5 4 5 4 5 3 5 5 5 41
8 3 1 1 5 5 3 5 5 5 5 5 5 5 48 5 4 5 3 5 3 5 3 5 38
6 3 1 1 5 5 5 5 5 5 5 5 5 5 50 3 5 5 5 5 5 5 5 5 43
4 3 1 1 5 5 5 5 5 5 5 5 4 4 48 4 5 5 5 5 5 5 5 5 44
8 4 1 1 5 4 4 4 5 4 5 5 5 5 46 4 4 5 4 5 5 5 5 5 42
8 4 1 1 5 5 3 5 5 5 5 5 2 5 45 5 2 5 3 5 5 5 3 5 38
6 4 1 1 5 5 5 4 5 5 5 4 5 5 48 5 5 5 5 5 4 5 5 5 44
4 4 1 1 5 5 5 4 5 5 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
8 5 1 1 4 4 4 5 5 5 5 5 1 5 43 5 2 5 5 5 3 5 30
8 5 1 1 5 5 4 4 5 5 5 3 5 5 46 4 4 5 5 5 4 5 4 4 40
7 5 1 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 5 5 5 5 5 5 45
4 5 1 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 5 5 5 5 5 5 45
8 2 1 1 3 5 5 5 5 1 5 1 3 1 34 5 1 1 3 5 2 5 5 5 32
6 2 1 1 5 5 4 5 5 5 5 4 5 5 48 4 3 4 5 5 4 5 4 5 39
4 6 1 1 5 5 5 5 5 4 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
6 3 1 1 5 5 5 1 5 3 24 1 5 5 4 5 5 5 5 5 40
5 5 1 1 4 4 3 4 3 5 5 5 4 37 4 5 5 5 5 5 5 34
8 2 2 1 5 5 5 5 5 5 5 4 5 5 49 5 4 5 5 5 5 5 5 5 44
8 2 2 1 5 5 5 5 3 3 5 4 4 4 43 3 3 3 5 5 2 5 4 4 34
7 3 2 1 1 5 1 5 1 5 5 5 1 5 34 5 1 5 5 5 1 5 1 5 33
8 4 2 1 4 4 4 5 1 5 5 5 5 5 43 5 3 5 5 5 5 5 5 5 43
7 4 2 1 5 5 3 5 1 3 5 2 1 4 34 5 1 4 5 5 1 5 1 5 32
7 4 2 1 3 5 3 5 1 3 5 4 1 5 35 4 3 5 5 5 1 5 3 4 35
7 3 2 1 3 5 2 5 2 3 5 3 1 3 32 3 1 4 3 5 1 5 2 4 28
8 4 2 1 3 5 3 4 2 3 5 4 2 4 35 4 1 4 4 5 4 5 3 4 34
7 4 2 1 3 5 2 5 2 3 5 5 1 5 36 5 2 4 5 5 1 5 1 3 31
6 4 2 1 5 5 4 5 2 4 5 3 3 4 40 4 4 5 5 5 1 5 4 4 37
4 4 2 1 4 4 3 4 2 4 5 5 2 2 35 5 3 4 3 5 2 5 3 3 33
4 4 2 1 5 5 4 5 2 3 5 5 3 4 41 4 4 4 5 5 3 5 2 4 36
4 5 2 1 3 5 2 5 2 4 5 5 2 5 38 5 2 5 3 5 3 5 1 5 34
8 2 2 1 4 4 4 5 2 3 5 5 2 3 37 5 2 5 5 5 3 5 3 4 37
7 2 2 1 4 5 4 5 3 4 5 5 2 5 42 4 3 4 4 5 2 5 3 4 34
7 2 2 1 3 3 2 5 3 2 5 4 4 4 35 5 1 5 4 5 4 5 4 5 38
6 2 2 1 4 4 5 5 3 3 3 3 2 3 35 3 1 4 5 5 2 5 2 4 31
6 2 2 1 5 5 4 5 3 5 4 5 4 5 45 5 4 5 4 5 3 5 5 5 41
5 2 2 1 4 5 2 5 3 3 1 5 2 5 35 4 4 5 5 5 1 5 3 5 37
4 2 2 1 4 4 2 4 3 3 3 2 2 2 29 3 3 3 3 5 2 5 4 4 32
8 3 2 1 4 5 4 5 3 4 4 4 4 4 41 3 4 5 5 5 4 5 31
7 3 2 1 4 4 3 4 3 3 3 3 3 3 33 4 4 4 4 5 2 5 4 4 36
7 3 2 1 2 5 3 5 3 5 1 5 1 5 35 5 1 5 5 5 1 5 1 5 33
5 3 2 1 5 5 4 4 3 4 4 5 4 5 43 4 4 4 4 5 2 5 5 5 38
5 3 2 1 5 5 4 4 3 4 2 4 3 4 38 3 3 3 5 5 3 5 4 4 35
5 3 2 1 4 4 3 4 3 3 2 4 2 4 33 3 2 2 4 5 2 5 3 26
4 3 2 1 4 4 4 5 3 4 4 3 4 3 38 4 4 4 4 5 4 5 3 3 36
4 3 2 1 4 4 3 5 3 4 1 3 2 4 33 4 3 3 4 5 4 5 3 4 35
4 3 2 1 5 4 4 5 3 4 3 3 1 3 35 5 2 3 3 5 2 5 3 4 32
8 4 2 1 4 4 4 4 3 3 4 4 4 4 38 3 4 4 4 5 3 5 4 4 36
8 4 2 1 4 4 4 4 3 4 1 4 2 4 34 4 3 4 4 5 1 5 2 4 32
7 4 2 1 5 5 3 4 3 5 2 4 2 5 38 4 3 5 4 5 3 5 3 5 37
8 5 2 1 3 5 3 4 3 3 1 3 1 1 27 3 1 2 3 5 1 5 3 3 26
8 5 2 1 5 5 5 5 3 5 5 3 5 5 46 4 5 5 5 5 5 5 5 5 44
8 5 2 1 4 2 5 2 3 3 3 3 4 3 32 3 3 2 4 5 3 5 4 3 32
8 5 2 1 5 5 5 5 3 3 3 4 4 3 40 4 4 4 4 5 2 5 4 4 36
7 5 2 1 5 5 3 5 3 4 5 5 4 5 44 4 2 4 4 5 4 5 3 4 35
7 5 2 1 5 5 3 5 3 5 2 5 3 4 40 3 1 4 4 5 4 5 4 5 35
8 1 2 1 4 5 5 5 3 4 3 3 3 4 39 5 3 4 5 5 5 5 4 4 40
8 5 2 1 5 4 4 4 3 2 2 2 3 3 32 4 4 5 5 5 5 4 3 35
7 1 2 1 5 5 3 4 3 4 1 3 1 2 31 4 2 4 5 5 5 1 4 30
7 1 2 1 4 4 3 5 3 3 2 4 2 4 34 4 2 4 4 5 5 5 4 5 38
7 2 2 1 5 5 3 5 3 4 5 3 4 37 4 4 4 3 5 5 5 2 5 37
7 2 2 1 5 4 3 5 3 3 3 3 4 1 34 4 1 4 4 5 5 5 4 2 34
6 2 2 1 5 5 4 5 3 5 3 5 5 5 45 5 5 5 4 5 5 5 5 5 44
5 6 2 1 5 5 4 5 3 3 4 5 5 5 44 5 3 3 5 5 5 5 5 5 41
8 2 2 1 4 4 3 5 4 4 3 4 3 4 38 4 3 3 3 5 5 5 4 5 37
7 2 2 1 3 3 3 5 4 4 1 5 3 5 36 5 1 5 5 5 5 5 4 5 40
7 2 2 1 4 4 4 5 4 4 4 4 4 4 41 4 4 4 4 5 5 5 4 4 39
7 2 2 1 5 5 3 5 4 4 2 5 4 5 42 5 3 4 4 5 5 5 4 5 40
6 2 2 1 5 5 4 5 4 3 1 4 31 4 5 5 5 5 5 5 34
6 2 2 1 4 4 4 5 4 3 4 5 4 4 41 4 4 3 5 5 5 5 4 5 40
6 2 2 1 4 5 4 5 4 4 4 4 4 5 43 4 4 4 4 5 5 5 4 5 40
5 2 2 1 4 5 3 5 4 3 3 4 4 4 39 3 1 3 5 5 5 5 4 4 35
5 2 2 1 4 4 3 5 4 3 4 5 4 5 41 4 3 5 4 3 5 5 4 4 37
4 2 2 1 4 5 3 5 4 4 3 5 4 4 41 5 3 4 4 4 5 5 4 5 39
7 3 2 1 4 4 4 5 4 3 4 5 4 4 41 4 4 5 5 5 5 5 3 5 41
7 3 2 1 5 5 2 5 4 4 1 5 2 5 38 5 3 4 5 5 5 5 2 4 38
7 3 2 1 5 5 4 5 4 4 2 5 3 4 41 4 3 4 4 5 5 5 3 4 37
6 3 2 1 4 5 4 5 4 4 3 5 3 4 41 4 4 4 4 5 5 5 4 5 40
6 3 2 1 4 5 4 4 4 3 1 1 3 4 33 5 4 3 5 5 2 4 28
6 3 2 1 5 5 5 5 4 4 4 4 5 5 46 4 5 4 5 5 5 5 5 5 43
5 3 2 1 4 4 4 4 4 3 3 3 1 3 33 3 2 3 4 4 5 5 4 4 34
4 3 2 1 5 5 3 5 4 4 3 4 2 3 38 4 3 3 5 5 5 5 2 3 35
4 3 2 1 5 4 3 5 4 5 2 5 2 5 40 5 3 5 4 5 5 5 3 5 40
4 3 2 1 5 5 3 5 4 4 3 4 4 3 40 5 4 4 5 4 5 5 3 3 38
8 4 2 1 5 5 4 5 4 3 3 4 4 3 40 3 3 3 5 5 5 5 4 3 36
7 4 2 0 3 4 3 5 4 4 3 4 3 4 37 4 1 5 4 4 5 5 3 4 35
7 4 2 1 5 5 3 4 4 4 4 4 4 4 41 4 4 4 4 4 5 5 4 4 38
7 4 2 1 4 5 3 5 4 4 3 5 3 5 41 4 3 4 4 5 5 5 3 5 38
6 4 2 1 5 5 4 4 4 4 4 3 5 4 42 5 5 5 5 5 5 5 5 5 45
5 4 2 1 4 4 4 4 4 3 4 4 4 4 39 4 3 4 5 5 5 5 5 5 41
4 4 2 1 5 5 4 5 4 4 4 5 5 5 46 5 3 4 5 4 5 5 5 5 41
8 5 2 1 4 5 3 5 4 4 3 4 4 4 40 5 4 4 4 4 5 5 3 4 38
7 5 2 1 3 4 2 5 4 4 1 3 1 2 29 3 3 3 4 4 5 5 1 3 31
7 5 2 0 5 5 3 5 4 4 2 4 3 4 39 4 2 2 4 5 5 5 4 5 36
7 5 2 1 4 5 2 5 4 4 5 5 4 5 43 4 4 4 4 5 5 5 4 4 39
6 5 2 1 5 5 3 5 4 4 3 29 5 5 4 4 5 5 28
8 5 2 1 3 4 3 5 4 4 2 4 3 4 36 4 3 4 4 4 5 5 4 4 37
8 2 2 1 5 5 5 5 4 5 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
8 1 2 1 4 4 4 5 4 4 4 4 4 4 41 4 4 4 5 5 5 5 4 4 40
7 4 2 1 3 3 5 4 3 3 3 2 3 29 3 3 3 4 4 5 5 4 3 34
7 1 2 1 4 4 3 5 4 3 4 3 4 4 38 4 3 3 5 5 5 5 5 5 40
5 5 2 1 5 5 3 5 4 4 2 3 2 3 36 3 1 3 2 4 5 5 4 27
7 2 2 1 5 4 4 5 5 4 1 5 1 5 39 5 3 3 4 4 5 5 4 5 38
6 3 2 1 5 5 5 5 5 5 5 5 5 5 50 5 5 5 5 5 5 5 5 5 45
6 3 2 1 5 5 4 5 5 3 1 1 5 3 37 2 5 3 5 4 5 5 4 3 36
4 3 2 0 4 5 4 5 5 5 1 5 3 5 42 5 1 5 3 5 5 5 1 5 35
7 4 2 1 5 5 5 5 5 5 1 3 3 4 41 3 3 4 4 5 5 5 2 4 35
5 4 2 1 4 4 3 5 5 4 4 4 4 4 41 3 4 3 5 4 5 5 5 4 38
4 4 2 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 4 5 5 5 5 5 44
8 2 2 1 5 5 5 5 5 5 5 5 5 5 50 5 5 5 5 5 5 5 5 5 45
8 5 2 1 4 4 4 5 4 3 3 3 3 33 3 5 4 5 5 5 5 4 4 40
7 4 1 0 2 4 1 5 2 4 2 3 2 3 28 3 1 3 2 4 3 5 1 5 27
4 4 1 1 5 5 2 5 3 3 3 3 4 4 37 4 2 4 3 4 4 5 2 3 31
6 5 1 1 5 5 2 5 3 1 1 22 5 1 1 5 5 17
6 5 1 1 4 5 3 4 3 4 3 4 4 4 38 3 3 3 4 4 5 5 4 4 35
6 4 1 1 4 4 4 4 4 4 24 4 4 4 4 5 5 26
3 1 1 0 1 1 1 1 1 1 1 1 1 1 10 1 1 1 1 1 1 5 1 1 13
1 2 1 0 3 5 2 5 1 1 5 5 5 32 5 1 5 4 1 3 5 4 5 33
1 2 1 1 5 4 3 4 1 4 4 5 3 3 36 4 4 3 5 1 4 5 4 3 33
1 4 1 1 2 5 2 5 1 3 2 4 3 3 30 4 1 3 4 1 1 5 3 4 26
1 4 1 1 5 5 3 4 1 4 4 4 3 3 36 3 4 4 3 1 3 5 4 4 31
1 4 1 1 5 5 2 4 1 5 2 3 1 5 33 4 1 4 5 1 1 5 1 1 23
3 5 1 1 5 4 4 4 1 4 1 2 1 2 28 3 1 3 4 1 1 5 3 3 24
1 5 1 0 4 5 3 1 4 1 4 1 3 26 3 1 2 4 1 1 5 2 3 22
1 5 1 0 4 5 2 5 1 4 4 3 3 3 34 4 2 4 4 1 1 5 1 4 26
1 5 1 0 5 5 3 4 1 5 4 4 4 4 39 4 3 4 5 1 4 5 3 4 33
3 6 1 0 5 5 1 5 1 5 1 5 2 5 35 5 1 5 5 1 1 5 1 5 29
1 2 1 0 5 5 1 5 1 5 1 3 1 4 31 5 2 5 3 1 1 5 2 4 28
3 2 1 0 4 5 4 5 1 4 3 5 4 5 40 5 3 5 4 1 2 5 4 5 34
3 2 1 0 4 5 3 5 1 5 4 5 3 4 39 5 4 5 2 1 5 5 3 5 35
1 2 1 0 4 5 2 5 1 5 1 4 1 5 33 4 1 4 3 1 1 5 2 5 26
3 3 1 0 5 5 3 3 1 3 1 5 4 5 35 5 2 4 5 1 1 5 3 5 31
3 3 1 0 4 5 3 5 1 5 1 4 4 5 37 5 2 5 5 1 2 5 3 4 32
3 3 1 0 4 4 5 4 1 3 2 3 4 4 34 3 2 4 4 1 1 5 4 5 29
3 3 1 0 5 5 3 5 1 4 1 3 3 3 33 4 2 3 4 1 3 5 3 4 29
3 3 1 0 5 5 3 5 1 5 3 5 4 5 41 5 5 5 4 1 2 5 3 5 35
1 3 1 0 3 5 3 4 1 5 1 3 2 4 31 3 3 4 4 1 1 5 5 26
3 4 1 0 5 5 4 4 1 4 1 3 3 3 33 3 3 4 4 1 2 5 3 3 28
3 4 1 0 3 3 4 1 1 1 1 5 2 4 25 4 1 1 4 1 1 5 2 4 23
3 4 1 0 5 5 3 1 1 4 1 3 3 3 29 3 2 4 1 1 5 5 21
3 4 1 0 5 5 3 1 1 3 1 4 3 4 30 3 2 5 4 1 3 5 3 4 30
1 4 1 0 4 5 3 1 1 4 1 4 2 4 29 3 4 3 4 1 1 5 3 3 27
1 4 1 0 4 4 2 1 1 3 1 3 2 3 24 4 2 2 4 1 2 5 2 3 25
1 4 1 0 4 4 4 1 1 4 1 4 3 4 30 3 3 4 3 1 2 5 2 4 27
3 5 1 0 5 3 5 1 1 5 1 4 3 3 31 4 3 3 4 1 4 5 5 5 34
3 5 1 0 5 4 4 1 1 3 1 4 1 4 28 3 2 3 4 1 3 5 2 4 27
3 5 1 0 5 5 4 1 1 3 1 3 2 4 29 3 2 3 3 1 1 5 4 4 26
3 5 1 0 4 5 1 2 4 1 5 2 5 29 5 2 5 3 1 2 5 2 4 29
3 5 1 0 3 5 2 1 2 3 1 3 3 3 26 3 2 3 5 1 1 5 3 5 28
3 5 1 0 5 5 3 1 2 4 1 5 1 5 32 5 1 5 5 1 1 5 2 5 30
3 5 1 0 4 4 3 1 2 2 1 4 4 4 29 3 4 1 5 5 3 3 24
1 5 1 0 4 5 3 1 2 5 1 1 1 3 26 4 1 4 5 1 1 5 4 4 29
1 5 1 0 5 5 3 1 2 5 1 1 4 4 31 4 1 5 4 1 3 5 5 5 33
3 6 1 0 4 5 3 1 2 5 1 1 1 5 28 4 3 4 5 1 1 5 2 5 30
3 2 1 0 3 4 2 1 2 3 1 1 2 3 22 3 2 3 3 1 1 5 3 21
3 4 1 0 5 4 3 1 2 3 1 1 1 3 24 4 1 1 4 1 1 5 3 4 24
3 4 1 0 5 5 3 1 2 4 1 1 3 3 28 3 2 4 5 1 1 5 4 5 30
3 2 1 0 4 4 3 1 2 4 1 1 2 4 26 4 3 2 3 1 2 5 4 4 28
2 4 1 0 5 5 2 1 2 5 1 1 3 5 30 4 2 4 4 1 4 5 4 5 33
1 6 1 0 5 5 4 1 2 4 1 1 2 3 28 3 3 4 4 1 1 5 2 3 26
1 4 1 0 2 5 1 1 2 4 1 1 2 4 23 3 4 4 5 1 1 5 1 4 28
1 5 1 0 4 4 4 1 2 4 1 1 3 3 27 4 2 4 4 1 3 5 3 4 30
3 2 1 0 4 3 4 1 3 3 1 1 3 3 26 3 3 3 4 1 3 5 4 4 30
3 2 1 0 5 5 4 1 3 3 1 1 3 5 31 5 2 3 5 1 3 5 4 5 33
3 3 1 0 4 1 2 1 3 5 1 1 3 4 25 4 2 4 5 1 1 5 4 4 30
3 3 1 0 4 1 2 1 3 4 1 1 3 4 24 5 2 5 4 1 2 5 3 5 32
3 3 1 0 5 1 2 1 3 2 1 1 2 2 20 4 1 5 5 1 1 5 5 3 30
2 3 1 0 4 1 2 1 3 2 1 1 4 3 22 3 1 3 4 1 3 5 4 3 27
2 3 1 0 5 1 2 1 3 5 1 1 5 4 28 4 1 4 4 1 5 5 5 5 34
2 3 1 0 4 1 2 1 3 5 1 1 3 5 26 5 1 3 4 1 4 5 4 5 32
1 3 1 1 4 1 2 1 3 4 1 1 4 4 25 3 1 4 4 1 4 5 4 4 30
3 4 1 1 4 1 2 1 3 4 1 1 2 4 23 5 1 5 4 1 5 5 4 5 35
3 4 1 1 5 1 2 1 3 3 1 1 4 5 26 4 1 4 4 1 5 5 5 5 34
3 4 1 1 3 1 2 1 3 4 1 1 2 3 21 3 1 2 5 1 2 5 3 4 26
3 4 1 1 5 1 2 1 3 4 1 1 4 5 27 4 1 5 5 1 1 5 4 5 31
3 4 1 1 4 1 2 1 3 2 2 1 3 2 21 3 1 2 3 1 3 5 4 4 26
3 4 1 1 4 1 2 1 3 3 3 1 2 4 24 5 1 2 4 1 3 5 2 3 26
3 4 1 1 5 1 2 1 3 4 1 1 2 5 25 5 1 3 5 1 1 5 5 5 31
3 4 1 1 5 1 2 1 3 4 3 1 4 4 28 4 1 4 1 5 5 3 4 27
3 4 1 1 4 1 2 1 3 5 1 1 1 5 24 5 1 4 3 1 1 5 3 5 28
3 4 1 1 5 1 2 1 3 3 4 1 5 5 30 5 1 5 5 1 1 5 5 5 33
3 4 1 1 4 1 2 1 3 3 3 1 3 3 24 4 1 2 3 1 2 5 3 2 23
3 4 1 1 5 1 2 1 3 2 1 1 2 3 21 4 1 3 4 1 1 5 3 4 26
3 4 1 1 4 1 2 1 3 3 1 3 3 4 25 4 1 3 4 1 3 5 2 4 27
3 4 1 1 4 1 2 1 3 4 1 4 4 4 28 3 1 3 2 1 4 5 2 4 25
2 4 1 1 4 1 2 1 3 4 1 4 4 4 28 4 1 4 4 1 4 5 4 4 31
3 5 1 1 4 1 2 1 3 4 1 4 3 4 27 4 1 4 3 1 4 5 3 4 29
3 5 1 1 5 1 2 1 3 3 1 3 4 23 4 1 3 1 1 5 4 5 24
3 5 1 1 4 1 2 1 3 2 1 4 3 4 25 5 1 3 4 1 3 5 4 3 29
3 5 1 1 5 1 2 1 3 3 1 4 4 4 28 5 1 2 4 5 1 5 4 4 31
3 5 1 1 4 1 2 1 3 4 1 4 5 5 30 5 1 5 4 5 4 5 5 5 39
3 5 1 1 5 1 2 1 3 3 1 2 3 2 23 2 1 3 4 4 3 5 4 3 29
3 5 1 1 4 1 2 1 3 2 1 4 4 4 26 4 1 3 5 4 3 5 4 5 34
3 5 1 1 4 1 2 1 3 3 1 3 3 3 24 3 1 2 4 4 1 5 3 3 26
3 5 1 1 5 1 2 1 3 5 1 5 5 5 33 5 1 4 4 5 5 5 5 3 37
3 5 1 1 5 1 2 1 3 5 1 5 4 5 32 5 1 4 4 4 4 5 5 4 36
3 5 1 1 5 1 2 1 3 4 1 4 1 5 27 4 1 4 5 5 1 5 1 4 30
2 5 1 1 3 1 2 1 3 5 1 5 1 5 27 5 1 3 3 4 1 5 1 4 27
1 5 1 1 4 1 2 1 3 4 1 3 4 3 26 4 1 4 3 4 3 5 4 5 33
1 5 1 1 5 1 2 1 3 5 1 5 3 5 31 5 1 5 4 5 3 5 5 5 38
1 5 1 1 4 1 2 1 3 5 1 5 3 4 29 5 1 4 5 5 3 5 3 4 35
1 5 1 1 4 1 2 1 3 4 1 5 3 5 29 4 1 3 4 5 3 5 4 5 34
1 5 1 1 4 1 2 1 3 4 1 4 3 4 27 4 1 4 3 4 1 5 2 3 27
1 5 1 1 5 1 2 1 3 5 1 5 5 5 33 5 1 5 5 5 5 5 3 5 39
1 5 1 1 5 1 2 1 3 5 1 3 1 4 26 5 1 5 2 5 1 5 3 4 31
3 4 1 1 5 4 2 1 3 3 1 3 2 3 27 3 1 3 4 3 1 5 2 3 25
3 2 1 1 4 4 2 1 3 3 1 4 2 3 27 4 1 3 3 4 1 5 3 4 28
3 5 1 1 4 4 2 1 3 3 1 5 3 5 31 4 1 3 4 4 2 5 4 4 31
3 6 1 1 5 5 2 1 3 3 1 5 2 5 32 5 1 4 4 5 3 5 3 5 35
3 6 1 1 5 5 2 1 3 3 1 3 4 4 31 3 1 4 4 5 4 5 3 4 33
3 4 1 1 5 4 2 1 3 3 1 5 4 5 33 5 1 4 3 3 5 5 5 5 36
2 5 1 1 5 5 2 1 3 3 1 4 5 5 34 4 1 3 4 4 5 5 3 4 33
3 2 1 1 4 4 2 1 4 5 1 4 4 29 4 1 4 4 5 5 5 5 33
3 2 1 1 5 5 2 1 4 5 1 4 4 5 36 4 1 3 3 4 5 5 3 4 32
3 2 1 1 4 5 2 1 4 5 1 5 2 5 34 4 1 4 4 5 2 5 4 5 34
2 2 1 1 4 4 2 1 4 4 1 4 4 4 32 4 1 4 4 4 4 5 4 4 34
2 2 1 1 5 4 2 1 4 4 1 4 5 5 35 4 1 4 4 5 4 5 3 5 35
2 2 1 1 5 5 2 1 4 5 1 5 5 5 38 5 1 5 3 4 5 5 4 5 37
2 2 1 1 4 5 2 1 4 4 1 5 4 5 35 4 1 5 5 5 5 5 5 5 40
1 2 1 1 3 4 2 1 4 4 1 3 5 3 30 3 1 3 4 4 5 5 5 5 35
3 3 1 1 3 3 2 1 4 3 1 3 2 3 25 3 1 1 4 3 2 5 1 4 24
3 3 1 1 3 5 2 1 4 3 1 4 4 4 31 4 1 4 5 5 1 5 5 5 35
3 3 1 1 3 4 2 1 4 4 1 2 3 3 27 3 1 3 3 3 1 5 3 3 25
3 3 1 1 3 5 2 1 4 3 3 2 2 3 28 3 1 2 3 4 3 5 3 4 28
3 3 1 1 3 5 2 1 4 2 1 5 1 5 29 5 1 1 4 3 1 5 1 5 26
3 3 1 1 3 5 2 1 4 3 1 4 4 4 31 4 1 3 5 4 1 5 4 5 32
3 3 1 1 3 3 2 1 4 4 1 5 5 5 33 4 1 5 3 4 5 5 5 5 37
2 3 1 1 3 4 2 1 4 4 1 4 3 4 30 3 1 4 4 4 5 5 3 4 33
2 3 1 1 3 5 2 1 4 3 1 4 5 4 32 3 1 3 4 4 5 5 4 5 34
2 3 1 1 3 5 2 1 4 5 1 5 5 5 36 5 1 5 5 5 5 5 5 36
3 4 1 1 3 4 2 1 4 2 1 3 3 3 26 4 1 5 4 4 1 5 3 3 30
3 4 1 1 3 4 2 1 4 3 1 4 4 4 30 4 1 3 4 4 4 5 4 4 33
3 4 1 1 3 5 2 1 4 4 1 5 5 5 35 5 1 4 4 5 5 5 5 5 39
3 4 1 1 3 5 2 1 4 4 1 4 4 5 33 4 1 3 4 5 1 5 3 4 30
3 4 1 1 3 3 2 1 4 3 1 2 5 2 26 4 1 3 5 5 3 5 3 4 33
3 4 1 1 3 3 2 1 4 5 1 4 5 5 33 5 1 5 4 5 1 5 1 5 32
3 4 1 1 3 5 4 1 4 4 1 4 4 4 34 4 1 4 4 4 4 5 3 4 33
3 4 1 1 3 5 3 1 4 5 1 5 2 5 34 4 1 4 3 4 2 5 4 4 31
3 4 1 1 3 5 5 1 4 5 1 3 5 4 36 3 1 4 4 4 1 5 3 4 29
2 4 1 1 3 5 3 1 4 4 1 4 2 4 31 4 1 4 5 5 5 5 4 5 38
2 4 1 1 3 5 3 1 4 4 1 3 3 4 31 5 1 5 4 5 4 5 1 5 35
2 4 1 1 3 4 4 1 4 4 1 4 4 4 33 4 1 4 5 5 5 5 4 4 37
1 4 1 1 3 4 3 4 4 4 1 4 3 4 34 4 1 3 5 4 5 5 3 4 34
3 5 1 1 3 5 4 5 4 4 1 3 2 3 34 3 1 4 4 4 1 5 2 3 27
3 5 1 1 3 4 4 4 4 2 1 4 3 3 32 4 1 2 4 4 3 5 3 4 30
3 5 1 1 3 5 5 5 4 5 1 4 1 1 34 4 1 4 3 4 1 5 2 2 26
3 5 1 1 3 5 5 5 4 5 1 5 4 4 41 4 1 4 5 5 5 5 5 4 38
3 5 1 1 3 4 3 5 4 2 1 2 1 2 27 4 1 2 4 4 1 5 3 1 25
3 5 1 1 3 4 4 4 4 4 1 3 3 2 32 3 1 3 5 5 1 5 3 4 30
3 5 1 1 3 5 4 5 4 5 1 4 5 5 41 3 1 4 4 5 1 5 4 5 32
2 5 1 1 3 5 5 5 4 4 1 5 4 4 40 4 1 4 5 5 1 5 5 5 35
2 5 1 1 3 5 3 5 4 5 1 5 5 5 41 4 1 5 5 5 1 5 4 4 34
1 5 1 1 3 5 3 4 4 4 1 4 4 4 36 4 1 4 4 5 1 5 4 4 32
1 5 1 1 3 5 4 5 4 5 1 4 5 4 40 4 1 5 5 5 1 5 4 4 34
1 5 1 1 3 5 3 5 4 5 1 5 5 5 41 4 1 4 3 5 1 5 3 5 31
1 5 1 1 3 5 4 5 4 5 1 5 3 5 40 5 1 4 5 5 1 5 5 5 36
3 2 1 1 3 4 4 5 4 3 1 4 2 4 34 4 1 3 4 4 1 5 3 4 29
3 4 1 1 3 5 4 5 4 4 1 2 3 4 35 4 1 2 5 5 1 5 3 5 31
3 2 1 1 3 4 3 5 4 4 1 4 3 4 35 4 1 4 5 5 1 5 3 3 31
3 2 1 1 3 5 4 4 4 4 1 5 4 3 37 5 1 5 4 5 1 5 5 5 36
3 5 1 1 3 5 4 5 4 2 1 4 4 4 36 4 1 5 4 4 1 5 4 4 32
3 6 1 1 3 5 3 5 4 3 1 5 2 5 36 5 1 4 4 4 1 5 2 3 29
3 6 1 1 3 5 4 5 4 5 1 4 5 5 41 5 1 5 5 5 1 5 4 5 36
3 2 1 1 3 5 3 5 4 5 1 5 5 5 41 5 1 1 5 1 5 5 5 28
3 2 1 1 3 4 3 5 4 4 1 5 4 4 37 5 1 5 1 5 1 5 1 4 28
3 4 1 1 3 3 5 4 1 3 3 5 27 4 1 3 1 5 1 5 4 4 28
2 2 1 0 3 5 4 5 4 5 1 5 1 5 38 5 1 2 1 5 1 5 4 5 29
2 5 1 1 4 4 3 4 4 2 1 4 2 3 31 3 1 3 1 4 1 5 3 3 24
1 6 1 1 4 4 1 5 4 3 1 4 3 4 33 4 1 4 1 5 1 5 3 4 28
1 6 1 1 4 4 4 4 4 4 1 3 3 2 33 4 1 3 1 5 1 5 3 4 27
1 2 1 1 4 3 3 3 4 3 1 4 2 4 31 4 1 4 1 1 5 1 4 21
1 4 1 1 4 5 4 5 4 5 1 4 2 5 39 4 3 5 1 5 1 5 3 5 32
3 2 1 0 5 5 5 5 5 5 1 5 5 5 46 5 1 2 1 5 1 5 3 4 27
2 2 1 1 4 4 3 4 5 5 1 3 5 5 39 5 3 3 1 4 1 5 3 3 28
3 3 1 1 5 5 4 5 5 5 1 5 5 5 45 5 5 5 1 5 1 5 5 5 37
2 3 1 1 4 5 5 5 5 5 1 5 4 5 44 5 5 5 1 5 1 5 5 5 37
3 4 1 1 4 5 5 5 5 5 1 4 5 5 44 4 5 5 1 4 1 5 5 4 34
2 4 1 1 5 5 5 5 5 5 1 5 5 5 46 5 5 5 1 5 1 5 5 5 37
2 4 1 1 5 5 4 5 5 5 1 5 5 5 45 5 3 5 1 5 1 5 5 5 35
2 4 1 1 4 4 4 4 5 5 1 5 4 5 41 5 4 4 1 5 1 5 4 5 34
2 4 1 1 5 5 3 5 5 5 1 5 5 5 44 5 3 5 1 5 1 5 3 5 33
3 5 1 1 5 5 4 5 5 5 1 5 3 4 42 5 3 4 1 5 1 5 3 4 31
3 5 1 1 5 5 1 5 5 5 1 5 5 5 42 5 5 5 1 5 1 5 5 5 37
2 5 1 1 5 5 5 5 5 5 1 5 5 5 46 5 5 5 1 5 1 5 5 5 37
2 5 1 1 5 5 4 5 5 4 1 4 4 4 41 4 4 4 1 5 1 5 4 4 32
2 5 1 1 5 5 5 5 5 5 1 5 5 4 45 4 5 4 1 5 1 5 4 3 32
1 3 1 1 5 5 3 5 5 1 5 5 5 39 5 4 5 1 5 5 5 3 5 38
3 6 1 1 5 5 4 5 3 1 4 3 4 34 4 2 4 1 5 3 5 3 5 32
1 4 2 0 5 4 3 3 1 3 1 2 1 1 24 3 1 1 1 5 1 5 1 1 19
1 4 2 1 4 5 2 5 1 5 1 5 4 5 37 5 1 5 1 5 3 5 3 5 33
3 2 2 1 4 5 5 5 2 3 1 3 1 2 31 2 2 2 1 5 1 5 5 5 28
2 2 2 1 5 5 3 5 2 3 1 5 3 5 37 4 3 4 1 5 4 5 3 5 34
1 2 2 1 5 5 4 4 2 3 1 3 3 2 32 1 3 2 1 5 5 5 3 4 29
1 2 2 1 3 3 3 3 2 1 1 4 2 3 25 2 2 3 1 5 1 3 2 4 23
1 2 2 1 4 5 5 5 2 3 1 4 3 5 37 4 2 2 1 5 3 5 5 5 32
3 3 2 0 4 4 3 5 2 4 1 4 2 4 33 4 1 4 1 5 1 4 2 4 26
1 3 2 1 4 5 4 5 2 3 1 2 3 4 33 3 3 3 1 5 3 3 3 3 27
1 4 2 1 5 4 3 4 2 2 1 3 2 3 29 3 3 3 1 5 1 3 2 4 25
1 4 2 1 4 5 3 5 2 5 1 5 2 5 37 5 3 5 1 5 1 5 3 5 33
1 4 2 1 5 3 5 2 4 1 4 1 3 28 4 3 5 1 5 3 3 3 4 31
1 4 2 0 4 3 2 1 4 14 1 1 5 2 1 10
3 5 2 1 5 5 3 5 2 5 1 5 2 5 38 5 1 5 1 5 1 3 2 4 27
3 5 2 1 3 4 4 4 2 4 1 4 1 4 31 3 1 4 1 5 1 3 2 4 24
2 5 2 0 3 5 3 4 2 3 1 3 1 2 27 4 1 4 1 5 3 3 3 3 27
1 6 2 1 5 4 3 2 2 2 1 4 1 4 28 3 3 3 1 5 1 4 2 4 26
1 2 2 1 3 5 2 4 2 3 1 4 1 4 29 5 3 4 1 5 5 4 5 5 37
2 2 2 1 4 5 4 5 3 4 1 5 1 5 37 4 5 4 1 4 3 4 3 5 33
2 2 2 1 4 5 4 5 3 3 1 5 1 5 36 5 3 4 1 4 4 5 5 5 36
2 2 2 1 4 5 5 3 3 1 5 1 5 32 4 3 3 1 4 4 5 5 5 34
1 2 2 1 4 4 2 4 3 3 1 3 1 3 28 3 3 4 1 3 3 3 4 4 28
1 2 2 0 3 5 1 5 3 3 1 2 1 4 28 4 1 3 1 4 1 3 3 5 25
3 3 2 1 4 4 1 4 3 2 1 3 1 3 26 3 2 3 1 4 4 4 3 4 28
3 3 2 1 3 1 3 1 1 9 3 1 2 3 9
3 3 2 1 4 5 1 5 3 4 1 4 1 4 32 4 4 5 1 4 4 4 3 4 33
3 3 2 1 5 5 1 5 3 3 1 4 1 4 32 4 4 1 5 3 3 3 4 27
2 3 2 0 3 4 1 5 3 4 1 5 1 5 32 5 3 5 1 4 4 4 4 4 34
2 3 2 1 4 5 1 5 3 4 1 5 1 5 34 5 3 4 1 5 3 5 3 5 34
1 3 2 1 5 4 1 5 3 2 1 4 1 2 28 3 3 3 1 4 1 1 3 2 21
1 3 2 1 4 4 1 4 3 2 1 3 1 3 26 3 3 4 1 4 1 3 4 4 27
1 3 2 1 4 4 1 5 3 2 1 3 1 3 27 2 1 3 1 5 3 3 5 5 28
3 4 2 1 4 5 1 5 3 4 1 3 1 3 30 4 3 4 1 4 3 4 3 3 29
3 4 2 1 4 5 1 5 3 2 1 3 1 3 28 4 1 4 1 5 3 3 4 4 29
2 4 2 0 3 3 1 4 3 2 1 4 1 4 26 3 3 4 1 3 4 5 3 5 31
2 4 2 0 3 5 1 5 3 5 1 4 1 5 33 5 3 5 1 5 4 5 4 5 37
2 4 2 1 4 5 1 5 3 3 1 5 1 5 33 4 3 4 1 5 4 5 3 5 34
2 4 2 1 3 5 1 5 3 5 1 4 1 4 32 4 2 3 1 4 4 4 4 4 30
2 4 2 1 4 4 1 5 3 3 1 5 1 5 32 3 4 5 1 5 4 4 4 5 35
1 4 2 1 5 5 3 5 3 5 1 5 1 5 38 5 1 4 1 4 5 5 4 5 34
3 5 2 1 5 5 4 5 3 3 1 2 1 1 30 2 3 2 1 4 1 1 3 2 19
3 5 2 1 4 4 3 5 3 4 1 4 3 4 35 4 2 4 1 4 3 3 1 5 27
2 5 2 1 4 4 4 4 3 4 1 4 3 4 35 3 2 3 1 4 4 5 3 4 29
2 5 2 1 1 5 4 5 3 4 1 3 5 3 34 3 4 3 1 5 5 5 4 4 34
1 5 2 1 1 4 3 4 3 3 1 3 3 3 28 3 4 4 1 4 3 3 3 4 29
1 5 2 1 1 4 3 4 3 4 1 3 3 3 29 4 4 4 1 4 4 4 4 4 33
1 5 2 0 1 5 3 5 3 3 1 4 5 30 4 4 5 1 5 3 5 27
1 5 2 1 1 4 3 5 3 3 1 5 3 4 32 4 1 4 3 5 3 4 24
1 5 2 1 1 5 3 5 3 4 1 5 4 4 35 4 4 4 1 4 3 4 4 4 32
3 5 2 1 1 5 4 5 3 4 1 3 2 3 31 4 2 3 1 2 2 3 3 3 23
2 5 2 0 1 4 2 4 3 3 1 4 5 4 31 4 2 4 1 4 5 5 4 5 34
2 5 2 1 1 5 4 5 3 3 1 3 3 3 31 4 2 4 1 4 3 3 3 3 27
2 5 2 1 1 5 4 5 3 4 1 4 4 4 35 4 4 4 1 5 5 5 5 5 38
1 2 2 1 1 5 4 5 3 5 1 5 5 5 39 5 2 5 1 5 2 5 2 5 32
2 2 2 1 1 5 4 5 4 4 1 5 4 4 37 5 1 5 3 4 4 4 26
2 2 2 1 1 5 4 5 4 5 1 5 3 5 38 5 4 5 1 5 3 5 5 5 38
2 2 2 1 1 5 3 5 4 1 1 5 5 5 35 5 1 1 1 5 4 5 2 5 29
2 2 2 1 1 4 2 5 4 4 1 5 4 4 34 4 5 5 1 5 5 5 3 5 38
1 2 2 1 1 5 2 5 4 5 1 4 4 5 36 4 3 3 1 5 4 4 3 4 31
3 3 2 1 1 5 2 5 4 5 1 5 3 3 34 5 3 3 1 5 3 4 3 4 31
2 3 2 1 1 5 2 5 4 4 1 4 4 4 34 4 3 5 1 4 3 5 3 4 32
2 3 2 1 1 5 2 5 4 5 1 4 5 5 37 5 4 5 1 5 5 5 4 5 39
2 3 2 1 1 5 2 5 4 2 1 4 4 3 31 3 4 3 1 4 4 4 4 4 31
2 3 2 1 1 4 2 4 4 3 1 2 4 3 28 3 3 2 1 4 4 3 4 3 27
2 3 2 1 1 4 2 3 4 3 1 3 3 4 28 4 3 3 1 4 2 3 3 3 26
2 3 2 1 1 4 2 5 4 3 1 5 2 5 32 4 1 1 4 1 5 16
2 3 2 1 1 5 2 5 4 4 1 4 2 3 31 4 2 2 1 5 1 4 2 3 24
2 3 2 1 1 5 2 5 4 4 1 5 5 5 37 4 3 3 1 4 5 5 4 4 33
1 3 2 1 1 5 2 5 4 4 1 4 5 5 36 4 4 4 1 5 4 4 5 5 36
3 4 2 0 1 5 2 5 4 5 1 5 4 5 37 5 1 5 1 5 4 5 5 5 36
3 4 2 1 1 4 2 5 4 3 1 3 2 3 28 3 1 4 1 5 1 3 3 4 25
2 4 2 1 1 4 2 4 4 4 1 3 5 4 32 3 3 3 1 5 1 4 4 4 28
2 4 2 1 1 5 2 5 4 5 1 4 2 4 33 3 3 4 1 4 3 5 4 5 32
2 4 2 1 1 5 2 5 4 3 1 3 5 3 32 4 4 4 1 5 4 3 5 4 34
2 4 2 1 1 4 2 5 4 3 1 4 4 4 32 4 3 3 1 5 5 4 4 4 33
1 4 2 1 1 4 2 4 4 4 1 3 3 2 28 4 4 4 1 4 4 4 4 4 33
3 5 2 1 1 4 2 2 4 1 1 3 2 3 23 3 1 1 1 4 1 2 2 3 18
3 5 2 1 1 5 2 2 4 3 1 3 4 4 29 4 3 3 1 4 1 3 4 3 26
2 5 2 1 1 4 2 2 4 3 1 3 4 4 28 4 3 3 1 4 4 4 3 4 30
2 5 2 1 1 4 2 2 4 4 1 4 3 4 29 4 3 4 1 5 3 4 3 4 31
2 5 2 1 1 5 2 2 4 5 1 5 5 5 35 5 3 3 1 5 5 5 5 5 37
2 5 2 1 1 5 2 2 4 5 1 4 5 4 33 4 4 4 1 5 5 5 4 4 36
1 5 2 1 1 4 2 2 4 3 1 1 2 1 21 3 3 1 1 4 1 1 4 4 22
3 5 2 1 1 5 2 2 4 3 1 4 3 4 29 4 1 4 1 5 1 3 4 3 26
2 4 2 1 1 4 2 2 4 3 1 3 4 4 28 4 3 4 1 5 3 4 4 4 32
2 2 2 1 1 4 2 2 4 3 1 4 1 3 25 3 2 3 1 4 3 3 3 3 25
2 2 2 1 1 5 2 2 4 5 1 5 4 5 34 5 4 5 1 5 4 5 4 5 38
2 2 2 1 1 4 2 2 4 4 1 4 4 4 30 3 3 4 1 4 5 3 1 3 27
2 5 2 1 1 5 2 2 4 2 1 5 3 3 28 5 3 3 1 4 4 2 4 5 31
1 4 2 1 1 5 2 2 4 4 1 3 5 3 30 5 1 5 5 2 18
1 2 2 1 1 4 2 2 4 4 1 3 2 4 27 4 2 3 1 4 3 3 2 4 26
1 2 2 0 1 5 2 2 4 4 1 5 4 5 33 5 1 5 1 5 3 5 2 5 32
1 5 2 1 1 5 2 2 4 5 1 5 4 5 34 5 4 5 1 5 1 5 1 5 32
2 2 2 1 1 5 2 2 5 5 1 5 5 5 36 4 3 3 1 5 5 5 5 5 36
2 2 2 1 1 5 2 2 5 3 1 5 3 4 31 5 4 3 1 4 4 5 4 4 34
1 2 2 1 1 4 2 2 5 5 1 4 5 5 34 5 4 3 1 4 5 5 5 5 37
2 3 2 1 1 4 2 2 5 4 1 5 4 5 33 5 4 4 1 4 3 5 4 5 35
2 4 2 1 1 5 2 2 5 5 1 4 3 4 32 5 5 5 1 5 3 4 4 5 37
2 4 2 1 1 4 2 2 5 4 1 3 3 3 28 4 2 4 1 4 5 4 3 4 31
1 4 2 1 1 5 2 2 5 5 1 1 1 1 24 1 4 1 1 5 1 1 1 1 16
2 5 2 1 1 4 2 2 5 4 1 5 5 5 34 5 4 5 1 5 5 5 4 5 39
1 5 1 1 1 5 2 2 2 4 1 3 4 3 27 3 4 4 1 5 5 5 27
3 3 1 1 1 4 2 2 3 4 1 3 3 3 26 4 2 3 1 3 2 4 3 4 26
1 5 1 0 1 5 2 2 3 4 1 4 2 4 28 5 2 5 1 5 3 5 2 5 33
1 5 1 1 1 5 2 2 4 4 1 4 5 5 33 5 5 5 1 5 1 3 5 4 34
3 5 1 1 1 5 2 2 4 2 1 3 5 4 29 4 1 5 1 5 1 3 5 5 30
1 4 1 1 1 5 4 2 4 3 1 4 5 4 33 4 3 3 1 2 3 3 5 5 29
1 6 1 1 1 5 5 2 5 5 1 4 3 4 35 5 4 4 5 5 5 5 3 5 41
2
Years of Tertiary Education
<4
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 Column Labels
4 5 2 1 3 5 2 5 2 4 5 5 2 5 38 5 2 5 3 5 3 5 1 5 34 Sum of Recommend Tertiary Education Sum of Satisfaction with Career Sum of Total Well Being Total Sum of Recommend Tertiary Education Total Sum of Satisfaction with Career Total Sum of Total Well Being
4 2 2 1 4 4 2 4 3 3 3 2 2 2 29 3 3 3 3 5 2 5 4 4 32 Row Labels 1 2 3 4 5 6 1 2 3 4 5 6 1 2 3 4 5 6
4 3 2 1 4 4 4 5 3 4 4 3 4 3 38 4 4 4 4 5 4 5 3 3 36 1 12 7 14 19 4 541 245 600 838 157 508 233 534 836 148 56 2381 2259
4 3 2 1 4 4 3 5 3 4 1 3 2 4 33 4 3 3 4 5 4 5 3 4 35 1 3 2 6 13 3 193 95 311 629 129 176 94 282 637 122 27 1357 1311
4 3 2 1 5 4 4 5 3 4 3 3 1 3 35 5 2 3 3 5 2 5 3 4 32 2 9 5 8 6 1 348 150 289 209 28 332 139 252 199 26 29 1024 948
4 2 2 1 4 5 3 5 4 4 3 5 4 4 41 5 3 4 4 4 5 5 4 5 39 2 18 14 18 18 659 575 702 685 631 564 707 647 68 2621 2549
4 3 2 1 5 5 3 5 4 4 3 4 2 3 38 4 3 3 5 5 5 5 2 3 35 1 5 4 8 8 217 218 329 305 203 233 313 254 25 1069 1003
4 3 2 1 5 4 3 5 4 5 2 5 2 5 40 5 3 5 4 5 5 5 3 5 40 2 13 10 10 10 442 357 373 380 428 331 394 393 43 1552 1546
4 3 2 1 5 5 3 5 4 4 3 4 4 3 40 5 4 4 5 4 5 5 3 3 38 3 0 10 14 31 32 5 10 571 690 1092 1197 237 13 515 672 1117 1125 224 92 3797 3666
4 4 2 1 5 5 4 5 4 4 4 5 5 5 46 5 3 4 5 4 5 5 5 5 41 1 0 9 9 28 24 5 10 540 524 969 951 237 13 487 518 998 935 224 75 3231 3175
4 3 2 0 4 5 4 5 5 5 1 5 3 5 42 5 1 5 3 5 5 5 1 5 35 2 1 5 3 8 31 166 123 246 28 154 119 190 17 566 491
4 4 2 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 4 5 5 5 5 5 44 4 2 6 3 1 70 266 131 38 71 251 116 34 12 505 472
4 4 1 1 5 5 2 5 3 3 3 3 4 4 37 4 2 4 3 4 4 5 2 3 31 1 1 37 31 1 37 31
3 1 1 0 1 1 1 1 1 1 1 1 1 1 10 1 1 1 1 1 1 5 1 1 13 2 2 6 2 1 70 266 94 38 71 251 85 34 11 468 441
1 2 1 0 3 5 2 5 1 1 5 5 5 32 5 1 5 4 1 3 5 4 5 33 Grand Total 0 42 41 66 70 9 10 1841 1776 2525 2758 394 13 1725 1720 2474 2642 372 228 9304 8946
1 2 1 1 5 4 3 4 1 4 4 5 3 3 36 4 4 3 5 1 4 5 4 3 33
1 4 1 1 2 5 2 5 1 3 2 4 3 3 30 4 1 3 4 1 1 5 3 4 26
1 4 1 1 5 5 3 4 1 4 4 4 3 3 36 3 4 4 3 1 3 5 4 4 31
1 4 1 1 5 5 2 4 1 5 2 3 1 5 33 4 1 4 5 1 1 5 1 1 23 Report
3 5 1 1 5 4 4 4 1 4 1 2 1 2 28 3 1 3 4 1 1 5 3 3 24
1 5 1 0 4 5 3 1 4 1 4 1 3 26 3 1 2 4 1 1 5 2 3 22 This report shoes that for territy education of 1, full time employees are more where more employess age fall under 50 to 60 years , and the same group has most satisfaction with career and most of total well being numbers. Under 2 years of tertiary education, 40 to 50 age employees are more saisfied with career and with well being. under 3 years of tertiary education, 50 to 60 years of employees are most satisfied with career and total well being. under 4 years of tertiary education, part time employees of age 30 to 40 are most satisfied with career and with well being.
1 5 1 0 4 5 2 5 1 4 4 3 3 3 34 4 2 4 4 1 1 5 1 4 26
1 5 1 0 5 5 3 4 1 5 4 4 4 4 39 4 3 4 5 1 4 5 3 4 33
3 6 1 0 5 5 1 5 1 5 1 5 2 5 35 5 1 5 5 1 1 5 1 5 29
1 2 1 0 5 5 1 5 1 5 1 3 1 4 31 5 2 5 3 1 1 5 2 4 28
3 2 1 0 4 5 4 5 1 4 3 5 4 5 40 5 3 5 4 1 2 5 4 5 34
3 2 1 0 4 5 3 5 1 5 4 5 3 4 39 5 4 5 2 1 5 5 3 5 35
1 2 1 0 4 5 2 5 1 5 1 4 1 5 33 4 1 4 3 1 1 5 2 5 26
3 3 1 0 5 5 3 3 1 3 1 5 4 5 35 5 2 4 5 1 1 5 3 5 31
3 3 1 0 4 5 3 5 1 5 1 4 4 5 37 5 2 5 5 1 2 5 3 4 32
3 3 1 0 4 4 5 4 1 3 2 3 4 4 34 3 2 4 4 1 1 5 4 5 29
3 3 1 0 5 5 3 5 1 4 1 3 3 3 33 4 2 3 4 1 3 5 3 4 29
3 3 1 0 5 5 3 5 1 5 3 5 4 5 41 5 5 5 4 1 2 5 3 5 35
1 3 1 0 3 5 3 4 1 5 1 3 2 4 31 3 3 4 4 1 1 5 5 26
3 4 1 0 5 5 4 4 1 4 1 3 3 3 33 3 3 4 4 1 2 5 3 3 28
3 4 1 0 3 3 4 1 1 1 1 5 2 4 25 4 1 1 4 1 1 5 2 4 23
3 4 1 0 5 5 3 1 1 4 1 3 3 3 29 3 2 4 1 1 5 5 21
3 4 1 0 5 5 3 1 1 3 1 4 3 4 30 3 2 5 4 1 3 5 3 4 30
1 4 1 0 4 5 3 1 1 4 1 4 2 4 29 3 4 3 4 1 1 5 3 3 27
1 4 1 0 4 4 2 1 1 3 1 3 2 3 24 4 2 2 4 1 2 5 2 3 25
1 4 1 0 4 4 4 1 1 4 1 4 3 4 30 3 3 4 3 1 2 5 2 4 27
3 5 1 0 5 3 5 1 1 5 1 4 3 3 31 4 3 3 4 1 4 5 5 5 34
3 5 1 0 5 4 4 1 1 3 1 4 1 4 28 3 2 3 4 1 3 5 2 4 27
3 5 1 0 5 5 4 1 1 3 1 3 2 4 29 3 2 3 3 1 1 5 4 4 26
3 5 1 0 4 5 1 2 4 1 5 2 5 29 5 2 5 3 1 2 5 2 4 29
3 5 1 0 3 5 2 1 2 3 1 3 3 3 26 3 2 3 5 1 1 5 3 5 28
3 5 1 0 5 5 3 1 2 4 1 5 1 5 32 5 1 5 5 1 1 5 2 5 30
3 5 1 0 4 4 3 1 2 2 1 4 4 4 29 3 4 1 5 5 3 3 24
1 5 1 0 4 5 3 1 2 5 1 1 1 3 26 4 1 4 5 1 1 5 4 4 29
1 5 1 0 5 5 3 1 2 5 1 1 4 4 31 4 1 5 4 1 3 5 5 5 33
3 6 1 0 4 5 3 1 2 5 1 1 1 5 28 4 3 4 5 1 1 5 2 5 30
3 2 1 0 3 4 2 1 2 3 1 1 2 3 22 3 2 3 3 1 1 5 3 21
3 4 1 0 5 4 3 1 2 3 1 1 1 3 24 4 1 1 4 1 1 5 3 4 24
3 4 1 0 5 5 3 1 2 4 1 1 3 3 28 3 2 4 5 1 1 5 4 5 30
3 2 1 0 4 4 3 1 2 4 1 1 2 4 26 4 3 2 3 1 2 5 4 4 28
2 4 1 0 5 5 2 1 2 5 1 1 3 5 30 4 2 4 4 1 4 5 4 5 33
1 6 1 0 5 5 4 1 2 4 1 1 2 3 28 3 3 4 4 1 1 5 2 3 26
1 4 1 0 2 5 1 1 2 4 1 1 2 4 23 3 4 4 5 1 1 5 1 4 28
1 5 1 0 4 4 4 1 2 4 1 1 3 3 27 4 2 4 4 1 3 5 3 4 30
3 2 1 0 4 3 4 1 3 3 1 1 3 3 26 3 3 3 4 1 3 5 4 4 30
3 2 1 0 5 5 4 1 3 3 1 1 3 5 31 5 2 3 5 1 3 5 4 5 33
3 3 1 0 4 1 2 1 3 5 1 1 3 4 25 4 2 4 5 1 1 5 4 4 30
3 3 1 0 4 1 2 1 3 4 1 1 3 4 24 5 2 5 4 1 2 5 3 5 32
3 3 1 0 5 1 2 1 3 2 1 1 2 2 20 4 1 5 5 1 1 5 5 3 30
2 3 1 0 4 1 2 1 3 2 1 1 4 3 22 3 1 3 4 1 3 5 4 3 27
2 3 1 0 5 1 2 1 3 5 1 1 5 4 28 4 1 4 4 1 5 5 5 5 34
2 3 1 0 4 1 2 1 3 5 1 1 3 5 26 5 1 3 4 1 4 5 4 5 32
1 3 1 1 4 1 2 1 3 4 1 1 4 4 25 3 1 4 4 1 4 5 4 4 30
3 4 1 1 4 1 2 1 3 4 1 1 2 4 23 5 1 5 4 1 5 5 4 5 35
3 4 1 1 5 1 2 1 3 3 1 1 4 5 26 4 1 4 4 1 5 5 5 5 34
3 4 1 1 3 1 2 1 3 4 1 1 2 3 21 3 1 2 5 1 2 5 3 4 26
3 4 1 1 5 1 2 1 3 4 1 1 4 5 27 4 1 5 5 1 1 5 4 5 31
3 4 1 1 4 1 2 1 3 2 2 1 3 2 21 3 1 2 3 1 3 5 4 4 26
3 4 1 1 4 1 2 1 3 3 3 1 2 4 24 5 1 2 4 1 3 5 2 3 26
3 4 1 1 5 1 2 1 3 4 1 1 2 5 25 5 1 3 5 1 1 5 5 5 31
3 4 1 1 5 1 2 1 3 4 3 1 4 4 28 4 1 4 1 5 5 3 4 27
3 4 1 1 4 1 2 1 3 5 1 1 1 5 24 5 1 4 3 1 1 5 3 5 28
3 4 1 1 5 1 2 1 3 3 4 1 5 5 30 5 1 5 5 1 1 5 5 5 33
3 4 1 1 4 1 2 1 3 3 3 1 3 3 24 4 1 2 3 1 2 5 3 2 23
3 4 1 1 5 1 2 1 3 2 1 1 2 3 21 4 1 3 4 1 1 5 3 4 26
3 4 1 1 4 1 2 1 3 3 1 3 3 4 25 4 1 3 4 1 3 5 2 4 27
3 4 1 1 4 1 2 1 3 4 1 4 4 4 28 3 1 3 2 1 4 5 2 4 25
2 4 1 1 4 1 2 1 3 4 1 4 4 4 28 4 1 4 4 1 4 5 4 4 31
3 5 1 1 4 1 2 1 3 4 1 4 3 4 27 4 1 4 3 1 4 5 3 4 29
3 5 1 1 5 1 2 1 3 3 1 3 4 23 4 1 3 1 1 5 4 5 24
3 5 1 1 4 1 2 1 3 2 1 4 3 4 25 5 1 3 4 1 3 5 4 3 29
3 5 1 1 5 1 2 1 3 3 1 4 4 4 28 5 1 2 4 5 1 5 4 4 31
3 5 1 1 4 1 2 1 3 4 1 4 5 5 30 5 1 5 4 5 4 5 5 5 39
3 5 1 1 5 1 2 1 3 3 1 2 3 2 23 2 1 3 4 4 3 5 4 3 29
3 5 1 1 4 1 2 1 3 2 1 4 4 4 26 4 1 3 5 4 3 5 4 5 34
3 5 1 1 4 1 2 1 3 3 1 3 3 3 24 3 1 2 4 4 1 5 3 3 26
3 5 1 1 5 1 2 1 3 5 1 5 5 5 33 5 1 4 4 5 5 5 5 3 37
3 5 1 1 5 1 2 1 3 5 1 5 4 5 32 5 1 4 4 4 4 5 5 4 36
3 5 1 1 5 1 2 1 3 4 1 4 1 5 27 4 1 4 5 5 1 5 1 4 30
2 5 1 1 3 1 2 1 3 5 1 5 1 5 27 5 1 3 3 4 1 5 1 4 27
1 5 1 1 4 1 2 1 3 4 1 3 4 3 26 4 1 4 3 4 3 5 4 5 33
1 5 1 1 5 1 2 1 3 5 1 5 3 5 31 5 1 5 4 5 3 5 5 5 38
1 5 1 1 4 1 2 1 3 5 1 5 3 4 29 5 1 4 5 5 3 5 3 4 35
1 5 1 1 4 1 2 1 3 4 1 5 3 5 29 4 1 3 4 5 3 5 4 5 34
1 5 1 1 4 1 2 1 3 4 1 4 3 4 27 4 1 4 3 4 1 5 2 3 27
1 5 1 1 5 1 2 1 3 5 1 5 5 5 33 5 1 5 5 5 5 5 3 5 39
1 5 1 1 5 1 2 1 3 5 1 3 1 4 26 5 1 5 2 5 1 5 3 4 31
3 4 1 1 5 4 2 1 3 3 1 3 2 3 27 3 1 3 4 3 1 5 2 3 25
3 2 1 1 4 4 2 1 3 3 1 4 2 3 27 4 1 3 3 4 1 5 3 4 28
3 5 1 1 4 4 2 1 3 3 1 5 3 5 31 4 1 3 4 4 2 5 4 4 31
3 6 1 1 5 5 2 1 3 3 1 5 2 5 32 5 1 4 4 5 3 5 3 5 35
3 6 1 1 5 5 2 1 3 3 1 3 4 4 31 3 1 4 4 5 4 5 3 4 33
3 4 1 1 5 4 2 1 3 3 1 5 4 5 33 5 1 4 3 3 5 5 5 5 36
2 5 1 1 5 5 2 1 3 3 1 4 5 5 34 4 1 3 4 4 5 5 3 4 33
3 2 1 1 4 4 2 1 4 5 1 4 4 29 4 1 4 4 5 5 5 5 33
3 2 1 1 5 5 2 1 4 5 1 4 4 5 36 4 1 3 3 4 5 5 3 4 32
3 2 1 1 4 5 2 1 4 5 1 5 2 5 34 4 1 4 4 5 2 5 4 5 34
2 2 1 1 4 4 2 1 4 4 1 4 4 4 32 4 1 4 4 4 4 5 4 4 34
2 2 1 1 5 4 2 1 4 4 1 4 5 5 35 4 1 4 4 5 4 5 3 5 35
2 2 1 1 5 5 2 1 4 5 1 5 5 5 38 5 1 5 3 4 5 5 4 5 37
2 2 1 1 4 5 2 1 4 4 1 5 4 5 35 4 1 5 5 5 5 5 5 5 40
1 2 1 1 3 4 2 1 4 4 1 3 5 3 30 3 1 3 4 4 5 5 5 5 35
3 3 1 1 3 3 2 1 4 3 1 3 2 3 25 3 1 1 4 3 2 5 1 4 24
3 3 1 1 3 5 2 1 4 3 1 4 4 4 31 4 1 4 5 5 1 5 5 5 35
3 3 1 1 3 4 2 1 4 4 1 2 3 3 27 3 1 3 3 3 1 5 3 3 25
3 3 1 1 3 5 2 1 4 3 3 2 2 3 28 3 1 2 3 4 3 5 3 4 28
3 3 1 1 3 5 2 1 4 2 1 5 1 5 29 5 1 1 4 3 1 5 1 5 26
3 3 1 1 3 5 2 1 4 3 1 4 4 4 31 4 1 3 5 4 1 5 4 5 32
3 3 1 1 3 3 2 1 4 4 1 5 5 5 33 4 1 5 3 4 5 5 5 5 37
2 3 1 1 3 4 2 1 4 4 1 4 3 4 30 3 1 4 4 4 5 5 3 4 33
2 3 1 1 3 5 2 1 4 3 1 4 5 4 32 3 1 3 4 4 5 5 4 5 34
2 3 1 1 3 5 2 1 4 5 1 5 5 5 36 5 1 5 5 5 5 5 5 36
3 4 1 1 3 4 2 1 4 2 1 3 3 3 26 4 1 5 4 4 1 5 3 3 30
3 4 1 1 3 4 2 1 4 3 1 4 4 4 30 4 1 3 4 4 4 5 4 4 33
3 4 1 1 3 5 2 1 4 4 1 5 5 5 35 5 1 4 4 5 5 5 5 5 39
3 4 1 1 3 5 2 1 4 4 1 4 4 5 33 4 1 3 4 5 1 5 3 4 30
3 4 1 1 3 3 2 1 4 3 1 2 5 2 26 4 1 3 5 5 3 5 3 4 33
3 4 1 1 3 3 2 1 4 5 1 4 5 5 33 5 1 5 4 5 1 5 1 5 32
3 4 1 1 3 5 4 1 4 4 1 4 4 4 34 4 1 4 4 4 4 5 3 4 33
3 4 1 1 3 5 3 1 4 5 1 5 2 5 34 4 1 4 3 4 2 5 4 4 31
3 4 1 1 3 5 5 1 4 5 1 3 5 4 36 3 1 4 4 4 1 5 3 4 29
2 4 1 1 3 5 3 1 4 4 1 4 2 4 31 4 1 4 5 5 5 5 4 5 38
2 4 1 1 3 5 3 1 4 4 1 3 3 4 31 5 1 5 4 5 4 5 1 5 35
2 4 1 1 3 4 4 1 4 4 1 4 4 4 33 4 1 4 5 5 5 5 4 4 37
1 4 1 1 3 4 3 4 4 4 1 4 3 4 34 4 1 3 5 4 5 5 3 4 34
3 5 1 1 3 5 4 5 4 4 1 3 2 3 34 3 1 4 4 4 1 5 2 3 27
3 5 1 1 3 4 4 4 4 2 1 4 3 3 32 4 1 2 4 4 3 5 3 4 30
3 5 1 1 3 5 5 5 4 5 1 4 1 1 34 4 1 4 3 4 1 5 2 2 26
3 5 1 1 3 5 5 5 4 5 1 5 4 4 41 4 1 4 5 5 5 5 5 4 38
3 5 1 1 3 4 3 5 4 2 1 2 1 2 27 4 1 2 4 4 1 5 3 1 25
3 5 1 1 3 4 4 4 4 4 1 3 3 2 32 3 1 3 5 5 1 5 3 4 30
3 5 1 1 3 5 4 5 4 5 1 4 5 5 41 3 1 4 4 5 1 5 4 5 32
2 5 1 1 3 5 5 5 4 4 1 5 4 4 40 4 1 4 5 5 1 5 5 5 35
2 5 1 1 3 5 3 5 4 5 1 5 5 5 41 4 1 5 5 5 1 5 4 4 34
1 5 1 1 3 5 3 4 4 4 1 4 4 4 36 4 1 4 4 5 1 5 4 4 32
1 5 1 1 3 5 4 5 4 5 1 4 5 4 40 4 1 5 5 5 1 5 4 4 34
1 5 1 1 3 5 3 5 4 5 1 5 5 5 41 4 1 4 3 5 1 5 3 5 31
1 5 1 1 3 5 4 5 4 5 1 5 3 5 40 5 1 4 5 5 1 5 5 5 36
3 2 1 1 3 4 4 5 4 3 1 4 2 4 34 4 1 3 4 4 1 5 3 4 29
3 4 1 1 3 5 4 5 4 4 1 2 3 4 35 4 1 2 5 5 1 5 3 5 31
3 2 1 1 3 4 3 5 4 4 1 4 3 4 35 4 1 4 5 5 1 5 3 3 31
3 2 1 1 3 5 4 4 4 4 1 5 4 3 37 5 1 5 4 5 1 5 5 5 36
3 5 1 1 3 5 4 5 4 2 1 4 4 4 36 4 1 5 4 4 1 5 4 4 32
3 6 1 1 3 5 3 5 4 3 1 5 2 5 36 5 1 4 4 4 1 5 2 3 29
3 6 1 1 3 5 4 5 4 5 1 4 5 5 41 5 1 5 5 5 1 5 4 5 36
3 2 1 1 3 5 3 5 4 5 1 5 5 5 41 5 1 1 5 1 5 5 5 28
3 2 1 1 3 4 3 5 4 4 1 5 4 4 37 5 1 5 1 5 1 5 1 4 28
3 4 1 1 3 3 5 4 1 3 3 5 27 4 1 3 1 5 1 5 4 4 28
2 2 1 0 3 5 4 5 4 5 1 5 1 5 38 5 1 2 1 5 1 5 4 5 29
2 5 1 1 4 4 3 4 4 2 1 4 2 3 31 3 1 3 1 4 1 5 3 3 24
1 6 1 1 4 4 1 5 4 3 1 4 3 4 33 4 1 4 1 5 1 5 3 4 28
1 6 1 1 4 4 4 4 4 4 1 3 3 2 33 4 1 3 1 5 1 5 3 4 27
1 2 1 1 4 3 3 3 4 3 1 4 2 4 31 4 1 4 1 1 5 1 4 21
1 4 1 1 4 5 4 5 4 5 1 4 2 5 39 4 3 5 1 5 1 5 3 5 32
3 2 1 0 5 5 5 5 5 5 1 5 5 5 46 5 1 2 1 5 1 5 3 4 27
2 2 1 1 4 4 3 4 5 5 1 3 5 5 39 5 3 3 1 4 1 5 3 3 28
3 3 1 1 5 5 4 5 5 5 1 5 5 5 45 5 5 5 1 5 1 5 5 5 37
2 3 1 1 4 5 5 5 5 5 1 5 4 5 44 5 5 5 1 5 1 5 5 5 37
3 4 1 1 4 5 5 5 5 5 1 4 5 5 44 4 5 5 1 4 1 5 5 4 34
2 4 1 1 5 5 5 5 5 5 1 5 5 5 46 5 5 5 1 5 1 5 5 5 37
2 4 1 1 5 5 4 5 5 5 1 5 5 5 45 5 3 5 1 5 1 5 5 5 35
2 4 1 1 4 4 4 4 5 5 1 5 4 5 41 5 4 4 1 5 1 5 4 5 34
2 4 1 1 5 5 3 5 5 5 1 5 5 5 44 5 3 5 1 5 1 5 3 5 33
3 5 1 1 5 5 4 5 5 5 1 5 3 4 42 5 3 4 1 5 1 5 3 4 31
3 5 1 1 5 5 1 5 5 5 1 5 5 5 42 5 5 5 1 5 1 5 5 5 37
2 5 1 1 5 5 5 5 5 5 1 5 5 5 46 5 5 5 1 5 1 5 5 5 37
2 5 1 1 5 5 4 5 5 4 1 4 4 4 41 4 4 4 1 5 1 5 4 4 32
2 5 1 1 5 5 5 5 5 5 1 5 5 4 45 4 5 4 1 5 1 5 4 3 32
1 3 1 1 5 5 3 5 5 1 5 5 5 39 5 4 5 1 5 5 5 3 5 38
3 6 1 1 5 5 4 5 3 1 4 3 4 34 4 2 4 1 5 3 5 3 5 32
1 4 2 0 5 4 3 3 1 3 1 2 1 1 24 3 1 1 1 5 1 5 1 1 19
1 4 2 1 4 5 2 5 1 5 1 5 4 5 37 5 1 5 1 5 3 5 3 5 33
3 2 2 1 4 5 5 5 2 3 1 3 1 2 31 2 2 2 1 5 1 5 5 5 28
2 2 2 1 5 5 3 5 2 3 1 5 3 5 37 4 3 4 1 5 4 5 3 5 34
1 2 2 1 5 5 4 4 2 3 1 3 3 2 32 1 3 2 1 5 5 5 3 4 29
1 2 2 1 3 3 3 3 2 1 1 4 2 3 25 2 2 3 1 5 1 3 2 4 23
1 2 2 1 4 5 5 5 2 3 1 4 3 5 37 4 2 2 1 5 3 5 5 5 32
3 3 2 0 4 4 3 5 2 4 1 4 2 4 33 4 1 4 1 5 1 4 2 4 26
1 3 2 1 4 5 4 5 2 3 1 2 3 4 33 3 3 3 1 5 3 3 3 3 27
1 4 2 1 5 4 3 4 2 2 1 3 2 3 29 3 3 3 1 5 1 3 2 4 25
1 4 2 1 4 5 3 5 2 5 1 5 2 5 37 5 3 5 1 5 1 5 3 5 33
1 4 2 1 5 3 5 2 4 1 4 1 3 28 4 3 5 1 5 3 3 3 4 31
1 4 2 0 4 3 2 1 4 14 1 1 5 2 1 10
3 5 2 1 5 5 3 5 2 5 1 5 2 5 38 5 1 5 1 5 1 3 2 4 27
3 5 2 1 3 4 4 4 2 4 1 4 1 4 31 3 1 4 1 5 1 3 2 4 24
2 5 2 0 3 5 3 4 2 3 1 3 1 2 27 4 1 4 1 5 3 3 3 3 27
1 6 2 1 5 4 3 2 2 2 1 4 1 4 28 3 3 3 1 5 1 4 2 4 26
1 2 2 1 3 5 2 4 2 3 1 4 1 4 29 5 3 4 1 5 5 4 5 5 37
2 2 2 1 4 5 4 5 3 4 1 5 1 5 37 4 5 4 1 4 3 4 3 5 33
2 2 2 1 4 5 4 5 3 3 1 5 1 5 36 5 3 4 1 4 4 5 5 5 36
2 2 2 1 4 5 5 3 3 1 5 1 5 32 4 3 3 1 4 4 5 5 5 34
1 2 2 1 4 4 2 4 3 3 1 3 1 3 28 3 3 4 1 3 3 3 4 4 28
1 2 2 0 3 5 1 5 3 3 1 2 1 4 28 4 1 3 1 4 1 3 3 5 25
3 3 2 1 4 4 1 4 3 2 1 3 1 3 26 3 2 3 1 4 4 4 3 4 28
3 3 2 1 3 1 3 1 1 9 3 1 2 3 9
3 3 2 1 4 5 1 5 3 4 1 4 1 4 32 4 4 5 1 4 4 4 3 4 33
3 3 2 1 5 5 1 5 3 3 1 4 1 4 32 4 4 1 5 3 3 3 4 27
2 3 2 0 3 4 1 5 3 4 1 5 1 5 32 5 3 5 1 4 4 4 4 4 34
2 3 2 1 4 5 1 5 3 4 1 5 1 5 34 5 3 4 1 5 3 5 3 5 34
1 3 2 1 5 4 1 5 3 2 1 4 1 2 28 3 3 3 1 4 1 1 3 2 21
1 3 2 1 4 4 1 4 3 2 1 3 1 3 26 3 3 4 1 4 1 3 4 4 27
1 3 2 1 4 4 1 5 3 2 1 3 1 3 27 2 1 3 1 5 3 3 5 5 28
3 4 2 1 4 5 1 5 3 4 1 3 1 3 30 4 3 4 1 4 3 4 3 3 29
3 4 2 1 4 5 1 5 3 2 1 3 1 3 28 4 1 4 1 5 3 3 4 4 29
2 4 2 0 3 3 1 4 3 2 1 4 1 4 26 3 3 4 1 3 4 5 3 5 31
2 4 2 0 3 5 1 5 3 5 1 4 1 5 33 5 3 5 1 5 4 5 4 5 37
2 4 2 1 4 5 1 5 3 3 1 5 1 5 33 4 3 4 1 5 4 5 3 5 34
2 4 2 1 3 5 1 5 3 5 1 4 1 4 32 4 2 3 1 4 4 4 4 4 30
2 4 2 1 4 4 1 5 3 3 1 5 1 5 32 3 4 5 1 5 4 4 4 5 35
1 4 2 1 5 5 3 5 3 5 1 5 1 5 38 5 1 4 1 4 5 5 4 5 34
3 5 2 1 5 5 4 5 3 3 1 2 1 1 30 2 3 2 1 4 1 1 3 2 19
3 5 2 1 4 4 3 5 3 4 1 4 3 4 35 4 2 4 1 4 3 3 1 5 27
2 5 2 1 4 4 4 4 3 4 1 4 3 4 35 3 2 3 1 4 4 5 3 4 29
2 5 2 1 1 5 4 5 3 4 1 3 5 3 34 3 4 3 1 5 5 5 4 4 34
1 5 2 1 1 4 3 4 3 3 1 3 3 3 28 3 4 4 1 4 3 3 3 4 29
1 5 2 1 1 4 3 4 3 4 1 3 3 3 29 4 4 4 1 4 4 4 4 4 33
1 5 2 0 1 5 3 5 3 3 1 4 5 30 4 4 5 1 5 3 5 27
1 5 2 1 1 4 3 5 3 3 1 5 3 4 32 4 1 4 3 5 3 4 24
1 5 2 1 1 5 3 5 3 4 1 5 4 4 35 4 4 4 1 4 3 4 4 4 32
3 5 2 1 1 5 4 5 3 4 1 3 2 3 31 4 2 3 1 2 2 3 3 3 23
2 5 2 0 1 4 2 4 3 3 1 4 5 4 31 4 2 4 1 4 5 5 4 5 34
2 5 2 1 1 5 4 5 3 3 1 3 3 3 31 4 2 4 1 4 3 3 3 3 27
2 5 2 1 1 5 4 5 3 4 1 4 4 4 35 4 4 4 1 5 5 5 5 5 38
1 2 2 1 1 5 4 5 3 5 1 5 5 5 39 5 2 5 1 5 2 5 2 5 32
2 2 2 1 1 5 4 5 4 4 1 5 4 4 37 5 1 5 3 4 4 4 26
2 2 2 1 1 5 4 5 4 5 1 5 3 5 38 5 4 5 1 5 3 5 5 5 38
2 2 2 1 1 5 3 5 4 1 1 5 5 5 35 5 1 1 1 5 4 5 2 5 29
2 2 2 1 1 4 2 5 4 4 1 5 4 4 34 4 5 5 1 5 5 5 3 5 38
1 2 2 1 1 5 2 5 4 5 1 4 4 5 36 4 3 3 1 5 4 4 3 4 31
3 3 2 1 1 5 2 5 4 5 1 5 3 3 34 5 3 3 1 5 3 4 3 4 31
2 3 2 1 1 5 2 5 4 4 1 4 4 4 34 4 3 5 1 4 3 5 3 4 32
2 3 2 1 1 5 2 5 4 5 1 4 5 5 37 5 4 5 1 5 5 5 4 5 39
2 3 2 1 1 5 2 5 4 2 1 4 4 3 31 3 4 3 1 4 4 4 4 4 31
2 3 2 1 1 4 2 4 4 3 1 2 4 3 28 3 3 2 1 4 4 3 4 3 27
2 3 2 1 1 4 2 3 4 3 1 3 3 4 28 4 3 3 1 4 2 3 3 3 26
2 3 2 1 1 4 2 5 4 3 1 5 2 5 32 4 1 1 4 1 5 16
2 3 2 1 1 5 2 5 4 4 1 4 2 3 31 4 2 2 1 5 1 4 2 3 24
2 3 2 1 1 5 2 5 4 4 1 5 5 5 37 4 3 3 1 4 5 5 4 4 33
1 3 2 1 1 5 2 5 4 4 1 4 5 5 36 4 4 4 1 5 4 4 5 5 36
3 4 2 0 1 5 2 5 4 5 1 5 4 5 37 5 1 5 1 5 4 5 5 5 36
3 4 2 1 1 4 2 5 4 3 1 3 2 3 28 3 1 4 1 5 1 3 3 4 25
2 4 2 1 1 4 2 4 4 4 1 3 5 4 32 3 3 3 1 5 1 4 4 4 28
2 4 2 1 1 5 2 5 4 5 1 4 2 4 33 3 3 4 1 4 3 5 4 5 32
2 4 2 1 1 5 2 5 4 3 1 3 5 3 32 4 4 4 1 5 4 3 5 4 34
2 4 2 1 1 4 2 5 4 3 1 4 4 4 32 4 3 3 1 5 5 4 4 4 33
1 4 2 1 1 4 2 4 4 4 1 3 3 2 28 4 4 4 1 4 4 4 4 4 33
3 5 2 1 1 4 2 2 4 1 1 3 2 3 23 3 1 1 1 4 1 2 2 3 18
3 5 2 1 1 5 2 2 4 3 1 3 4 4 29 4 3 3 1 4 1 3 4 3 26
2 5 2 1 1 4 2 2 4 3 1 3 4 4 28 4 3 3 1 4 4 4 3 4 30
2 5 2 1 1 4 2 2 4 4 1 4 3 4 29 4 3 4 1 5 3 4 3 4 31
2 5 2 1 1 5 2 2 4 5 1 5 5 5 35 5 3 3 1 5 5 5 5 5 37
2 5 2 1 1 5 2 2 4 5 1 4 5 4 33 4 4 4 1 5 5 5 4 4 36
1 5 2 1 1 4 2 2 4 3 1 1 2 1 21 3 3 1 1 4 1 1 4 4 22
3 5 2 1 1 5 2 2 4 3 1 4 3 4 29 4 1 4 1 5 1 3 4 3 26
2 4 2 1 1 4 2 2 4 3 1 3 4 4 28 4 3 4 1 5 3 4 4 4 32
2 2 2 1 1 4 2 2 4 3 1 4 1 3 25 3 2 3 1 4 3 3 3 3 25
2 2 2 1 1 5 2 2 4 5 1 5 4 5 34 5 4 5 1 5 4 5 4 5 38
2 2 2 1 1 4 2 2 4 4 1 4 4 4 30 3 3 4 1 4 5 3 1 3 27
2 5 2 1 1 5 2 2 4 2 1 5 3 3 28 5 3 3 1 4 4 2 4 5 31
1 4 2 1 1 5 2 2 4 4 1 3 5 3 30 5 1 5 5 2 18
1 2 2 1 1 4 2 2 4 4 1 3 2 4 27 4 2 3 1 4 3 3 2 4 26
1 2 2 0 1 5 2 2 4 4 1 5 4 5 33 5 1 5 1 5 3 5 2 5 32
1 5 2 1 1 5 2 2 4 5 1 5 4 5 34 5 4 5 1 5 1 5 1 5 32
2 2 2 1 1 5 2 2 5 5 1 5 5 5 36 4 3 3 1 5 5 5 5 5 36
2 2 2 1 1 5 2 2 5 3 1 5 3 4 31 5 4 3 1 4 4 5 4 4 34
1 2 2 1 1 4 2 2 5 5 1 4 5 5 34 5 4 3 1 4 5 5 5 5 37
2 3 2 1 1 4 2 2 5 4 1 5 4 5 33 5 4 4 1 4 3 5 4 5 35
2 4 2 1 1 5 2 2 5 5 1 4 3 4 32 5 5 5 1 5 3 4 4 5 37
2 4 2 1 1 4 2 2 5 4 1 3 3 3 28 4 2 4 1 4 5 4 3 4 31
1 4 2 1 1 5 2 2 5 5 1 1 1 1 24 1 4 1 1 5 1 1 1 1 16
2 5 2 1 1 4 2 2 5 4 1 5 5 5 34 5 4 5 1 5 5 5 4 5 39
1 5 1 1 1 5 2 2 2 4 1 3 4 3 27 3 4 4 1 5 5 5 27
3 3 1 1 1 4 2 2 3 4 1 3 3 3 26 4 2 3 1 3 2 4 3 4 26
1 5 1 0 1 5 2 2 3 4 1 4 2 4 28 5 2 5 1 5 3 5 2 5 33
1 5 1 1 1 5 2 2 4 4 1 4 5 5 33 5 5 5 1 5 1 3 5 4 34
3 5 1 1 1 5 2 2 4 2 1 3 5 4 29 4 1 5 1 5 1 3 5 5 30
1 4 1 1 1 5 4 2 4 3 1 4 5 4 33 4 3 3 1 2 3 3 5 5 29
1 6 1 1 1 5 5 2 5 5 1 4 3 4 35 5 4 4 5 5 5 5 3 5 41
Years of Tertiary Education
>=4
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 36 5 2 3 5 5 5 5 5 5 40
8 2 1 1 4 5 3 5 2 5 4 5 5 5 43 5 4 5 5 5 3 5 3 5 40
8 2 1 1 5 5 3 5 4 5 4 5 5 5 46 5 3 2 5 5 2 5 2 5 34 Column Labels
8 2 1 1 4 5 3 4 3 4 2 5 3 5 38 4 3 4 5 5 3 5 3 5 37 Sum of Age Category Sum of Satisfaction with Career Sum of Total Well Being Total Sum of Age Category Total Sum of Satisfaction with Career Total Sum of Total Well Being
8 2 1 1 3 5 3 5 3 5 4 5 4 5 42 4 3 4 5 4 2 4 3 5 34 Row Labels (blank) (blank) (blank)
6 3 1 1 5 5 3 5 1 5 1 5 1 5 36 5 1 5 5 5 1 5 1 5 33 4 79 944 876 79 944 876
6 3 1 1 4 5 3 5 1 5 1 5 1 5 35 5 3 5 5 5 4 5 1 5 38 1 33 400 366 33 400 366
7 2 1 1 5 5 2 5 1 5 2 5 3 2 35 4 2 5 5 5 5 5 3 5 39 2 46 544 510 46 544 510
7 1 1 0 5 5 2 5 1 5 1 5 1 5 35 5 1 5 5 5 1 5 1 5 33 5 69 752 692 69 752 692
8 2 1 1 4 4 4 4 2 3 3 5 4 4 37 3 4 5 5 5 2 4 5 5 38 1 32 330 303 32 330 303
8 2 1 1 4 4 4 4 2 4 3 5 2 4 36 4 1 4 5 4 4 4 1 4 31 2 37 422 389 37 422 389
7 2 1 1 4 4 3 3 2 4 2 5 3 5 35 5 3 5 5 4 5 5 4 5 41 6 186 2072 1882 186 2072 1882
7 2 1 1 4 4 3 5 2 5 3 5 4 4 39 4 2 4 5 4 5 4 2 3 33 1 146 1514 1350 146 1514 1350
6 2 1 1 4 5 3 5 2 3 2 5 4 4 37 4 1 3 5 5 2 3 3 4 30 2 40 558 532 40 558 532
8 3 1 1 2 5 1 5 2 5 2 5 2 3 32 5 1 5 5 5 2 3 4 4 34 7 185 2455 2307 185 2455 2307
8 3 1 1 4 4 4 5 2 2 1 5 3 4 34 4 2 4 5 4 3 4 2 4 32 1 84 1265 1162 84 1265 1162
8 3 1 1 5 3 3 5 2 4 4 4 4 4 38 4 1 4 5 3 3 4 3 3 30 2 101 1190 1145 101 1190 1145
7 3 1 1 3 4 3 5 2 4 3 4 3 4 35 4 2 4 5 4 4 4 2 4 33 8 333 3751 3413 333 3751 3413
6 3 1 1 4 5 3 5 2 4 1 4 3 4 35 4 3 5 5 5 2 4 3 4 35 1 256 2888 2591 256 2888 2591
6 3 1 1 3 4 3 5 2 4 4 4 3 3 35 3 4 4 5 3 4 4 4 4 35 2 77 863 822 77 863 822
8 4 1 1 3 4 4 5 2 5 1 5 1 5 35 5 1 4 5 5 1 5 1 5 32 Grand Total 852 9974 9170 852 9974 9170
8 4 1 1 5 4 3 4 2 1 2 2 4 3 30 4 4 2 5 5 2 2 4 4 32
8 4 1 1 4 5 2 5 2 4 1 5 2 5 35 5 2 5 5 5 3 5 1 5 36
5 4 1 1 5 5 4 5 2 4 3 4 4 4 40 4 1 4 5 4 5 4 4 31
8 5 1 1 5 5 4 5 2 3 5 5 3 4 41 5 3 3 5 5 1 4 4 4 34 Report
8 5 1 1 4 4 2 5 2 5 5 5 1 5 38 5 2 5 5 3 1 5 3 5 34
8 5 1 1 5 4 3 5 2 5 5 4 3 4 40 4 1 5 5 4 3 5 3 4 34 This table shows that under 4 years of tertiary education, part time employees are more than full time, where part time employees are more satisfy with their career and well being. Under 5 years of tertiary education, part time employees are more, with moth satisfaction level of career and well bieng. under 6 years of education, full time employees are more, with most satisfactory level in career and well being. Under 7 years of education, part time employees are more, but full time employees are more satisfied in their career and well being. under 8 years of education, full time emplyees are more, with more satidfied in their career and well being.
8 5 1 1 4 4 4 4 2 5 5 4 3 3 38 4 3 4 5 4 5 5 4 4 38
8 4 1 1 5 5 4 5 2 4 5 5 2 5 42 5 2 3 5 5 1 5 2 5 33
8 3 1 1 4 4 4 4 2 3 5 4 2 4 36 4 3 3 5 4 1 5 3 4 32
8 1 1 1 4 4 3 4 2 3 5 3 3 3 34 4 3 3 5 4 1 5 3 3 31
7 4 1 1 5 3 4 4 2 5 5 3 1 3 35 3 2 4 5 4 3 5 2 3 31
7 1 1 1 5 5 3 5 2 5 5 3 2 3 38 3 3 4 5 4 1 5 2 4 31
7 2 1 1 4 4 4 4 2 4 5 5 4 4 40 5 3 5 5 4 4 5 3 5 39
7 2 1 1 4 4 3 4 2 3 5 4 3 4 36 3 4 3 5 3 2 5 1 4 30
8 2 1 1 3 4 2 5 3 3 5 4 3 5 37 4 4 4 5 5 5 27
8 2 1 1 5 5 3 5 3 5 5 4 2 5 42 4 2 4 5 4 4 5 1 5 34
7 2 1 1 4 5 3 5 3 5 5 5 4 5 44 5 4 5 5 5 4 5 2 5 40
7 2 1 1 3 4 4 4 3 3 5 4 5 5 40 2 2 2 5 3 4 5 4 4 31
7 2 1 1 4 4 4 5 3 4 5 4 4 4 41 4 3 4 5 4 3 5 2 5 35
7 2 1 1 4 4 4 4 3 4 5 4 3 4 39 4 3 4 5 4 4 5 4 4 37
6 2 1 1 5 5 5 5 3 3 5 4 3 4 42 5 3 5 5 4 4 5 4 5 40
5 2 1 1 4 5 4 5 3 3 5 4 5 5 43 4 2 3 5 4 5 5 5 5 38
5 2 1 1 4 5 4 5 3 4 5 5 4 4 43 3 4 4 5 5 4 5 5 5 40
8 3 1 1 3 3 4 5 3 3 5 4 2 4 36 5 2 3 5 5 1 5 4 5 35
7 3 1 1 4 5 4 5 3 5 5 5 4 5 45 5 4 3 5 4 4 5 4 5 39
7 3 1 1 5 5 4 5 3 5 3 4 3 5 42 4 2 4 5 5 3 5 3 4 35
7 3 1 1 4 5 2 5 3 5 3 3 4 4 38 4 3 2 5 4 5 5 4 4 36
7 3 1 1 5 5 5 5 3 4 4 4 4 4 43 4 4 4 5 4 4 5 4 4 38
7 3 1 1 4 5 3 5 3 5 3 5 4 37 4 3 4 5 5 4 5 2 5 37
6 3 1 1 4 4 3 5 3 4 1 4 1 4 33 4 3 4 4 4 1 5 3 4 32
6 3 1 1 4 4 3 5 3 4 3 5 2 5 38 4 3 5 3 5 2 5 3 4 34
6 3 1 1 5 5 4 5 3 4 3 4 3 5 41 4 4 4 4 4 5 4 5 34
8 4 1 1 4 4 2 5 3 4 4 5 3 4 38 4 3 3 4 4 3 5 4 4 34
8 4 1 1 4 5 3 5 3 4 4 5 3 5 41 5 3 5 4 4 4 5 2 5 37
8 4 1 1 4 5 3 5 3 2 2 5 1 5 35 5 3 3 4 5 4 5 2 5 36
8 4 1 1 4 5 4 5 3 5 4 4 3 4 41 4 4 5 4 5 4 5 3 5 39
8 4 1 1 3 4 4 5 3 3 1 3 2 3 31 3 1 3 4 4 2 5 3 4 29
8 4 1 1 4 5 2 5 3 3 4 3 4 4 37 3 1 1 3 4 3 5 2 4 26
8 4 1 1 4 5 4 5 3 5 4 5 3 5 43 5 4 5 4 5 5 5 2 5 40
8 4 1 1 5 5 4 5 3 3 4 4 4 5 42 4 4 4 4 4 5 5 3 5 38
6 4 1 1 4 4 4 5 3 4 4 4 4 4 40 4 4 4 4 4 3 5 4 4 36
8 5 1 1 5 4 5 5 3 3 4 3 4 4 40 3 4 4 5 4 2 5 5 5 37
8 5 1 1 4 4 4 5 3 3 4 4 4 4 39 4 4 5 4 4 3 5 4 4 37
8 5 1 1 5 2 3 5 3 1 4 4 1 3 31 4 1 3 5 5 1 5 4 5 33
6 5 1 1 4 4 5 5 3 3 3 3 3 3 36 4 4 4 4 4 5 25
6 5 1 1 4 5 5 5 3 5 1 5 1 5 39 4 4 4 5 3 5 4 5 34
6 5 1 1 3 4 4 5 3 3 3 3 2 3 33 4 3 3 3 4 2 5 3 3 30
5 5 1 1 5 5 4 5 3 4 5 1 5 4 41 5 5 3 4 5 5 5 4 5 41
8 4 1 1 5 5 2 5 3 4 2 5 4 5 40 5 1 5 4 5 3 5 2 5 35
8 5 1 1 4 4 3 5 3 4 5 4 4 5 41 2 3 3 4 4 5 3 4 28
8 5 1 1 5 5 3 5 3 4 3 3 3 4 38 3 3 3 4 5 3 5 3 4 33
8 4 1 1 5 5 4 5 3 5 3 5 5 5 45 5 3 5 3 5 5 5 4 5 40
8 2 1 1 4 5 4 5 3 4 4 3 4 3 39 4 3 3 3 4 3 5 4 4 33
8 2 1 1 4 5 3 5 3 3 1 5 3 2 34 3 3 4 5 5 1 5 4 4 34
8 2 1 1 5 5 3 5 3 4 3 4 4 4 40 4 2 4 5 5 3 5 2 4 34
8 3 1 1 4 5 4 5 3 2 1 1 1 1 27 1 2 1 2 1 1 5 2 1 16
8 4 1 1 4 4 3 4 3 2 1 1 4 3 29 3 4 3 5 5 2 5 5 4 36
7 1 1 1 4 5 4 4 3 4 4 5 5 5 43 4 3 4 3 5 4 5 5 4 37
6 2 1 1 4 5 4 4 3 4 4 4 4 4 40 4 3 4 3 4 4 5 3 5 35
6 5 1 1 5 5 3 5 3 3 1 3 1 5 34 5 5 5 3 5 1 5 1 5 35
6 5 1 1 3 3 3 3 3 3 4 4 3 4 33 3 3 4 3 3 3 5 2 2 28
6 5 1 1 4 4 4 5 3 4 1 5 1 5 36 5 2 2 4 4 1 5 3 26
8 2 1 1 4 5 5 5 4 4 4 5 5 5 46 5 4 4 4 5 3 5 4 5 39
6 2 1 1 5 5 3 5 4 3 2 1 3 3 34 1 1 1 5 5 3 5 3 4 28
4 2 1 1 4 5 3 5 4 5 2 5 3 5 41 5 3 3 4 5 3 5 1 5 34
8 3 1 1 5 5 4 5 4 4 5 5 4 4 45 5 5 5 4 5 5 5 5 5 44
8 3 1 1 5 5 5 5 4 5 4 5 4 5 47 5 3 5 5 5 2 5 4 5 39
8 3 1 1 4 4 4 5 4 4 3 3 3 3 37 3 4 5 4 4 3 5 3 3 34
7 3 1 1 4 4 3 5 4 2 4 5 3 4 38 4 3 5 4 5 4 5 3 4 37
7 3 1 1 4 4 4 5 4 3 3 4 3 4 38 4 4 5 3 4 4 5 4 4 37
7 3 1 1 4 4 3 5 4 4 4 5 4 4 41 4 3 5 4 4 4 5 4 4 37
7 3 1 1 5 5 4 5 4 5 3 5 3 5 44 5 2 5 2 5 3 5 1 5 33
7 3 1 1 4 4 3 5 4 3 5 4 5 4 41 4 3 5 4 5 5 5 4 4 39
6 3 1 1 5 4 4 5 4 3 4 4 4 4 41 4 4 5 4 4 4 5 4 4 38
6 3 1 1 5 4 3 5 4 2 2 4 3 3 35 3 2 5 4 4 4 5 3 4 34
6 3 1 1 4 5 4 5 4 5 3 4 3 4 41 4 3 5 4 5 2 5 4 5 37
5 3 1 1 5 4 4 5 4 4 5 3 4 4 42 4 4 5 4 5 5 5 3 5 40
4 3 1 1 4 4 3 5 4 4 5 5 4 5 43 5 3 5 5 5 5 5 4 5 42
8 4 1 1 3 4 3 5 4 4 4 5 4 5 41 5 4 5 5 5 3 5 4 4 40
8 4 1 1 3 5 2 5 4 3 1 5 2 5 35 4 2 5 5 5 1 5 2 5 34
8 4 1 1 5 5 5 5 4 4 3 4 4 4 43 4 4 5 4 4 3 5 4 4 37
8 4 1 1 4 4 4 5 4 4 2 3 4 4 38 3 3 5 3 4 2 5 4 4 33
8 4 1 1 5 5 3 5 4 4 3 3 4 4 40 4 3 5 4 5 3 5 4 5 38
8 4 1 1 3 5 2 5 4 2 1 5 1 5 33 4 2 5 4 5 1 5 4 5 35
8 4 1 1 5 5 4 5 4 5 3 4 4 5 44 4 3 5 3 4 3 5 3 4 34
8 4 1 1 3 5 3 5 4 4 1 5 1 4 35 5 4 5 4 4 3 5 1 5 36
8 4 1 1 5 5 4 5 4 5 5 1 5 3 42 4 4 5 5 5 4 5 5 5 42
8 4 1 1 5 4 3 5 4 4 3 4 4 4 40 5 4 5 4 5 3 5 3 4 38
8 4 1 1 4 4 4 5 4 4 3 4 3 3 38 4 3 5 4 4 3 5 3 3 34
8 4 1 1 4 4 4 5 4 4 4 4 4 4 41 5 5 5 4 5 5 5 3 5 42
7 4 1 1 5 4 3 5 4 3 3 3 4 3 37 3 3 5 3 3 4 5 3 4 33
7 4 1 1 4 5 5 5 4 5 4 5 3 4 44 5 4 5 4 5 5 5 4 5 42
6 4 1 1 4 4 5 5 4 2 3 4 5 4 40 4 3 5 5 4 4 5 3 4 37
6 4 1 1 5 5 3 5 4 4 3 3 3 3 38 4 4 5 3 4 4 5 4 5 38
6 4 1 1 4 5 4 5 4 3 1 4 2 4 36 4 3 5 4 4 1 5 3 4 33
4 4 1 1 4 4 4 5 4 3 4 4 4 4 40 4 4 5 4 4 4 5 4 4 38
7 5 1 1 5 5 4 5 4 4 5 1 4 5 42 4 5 5 4 4 4 5 4 4 39
6 5 1 1 4 5 4 5 4 4 5 4 5 40 4 3 5 4 4 5 25
6 5 1 1 3 4 3 5 4 3 5 4 4 4 39 4 4 5 4 4 2 5 28
6 5 1 1 4 5 4 5 4 5 5 5 3 5 45 5 5 5 4 5 5 5 3 5 42
6 5 1 1 4 5 4 5 4 5 5 3 3 3 41 3 4 5 4 5 3 5 4 4 37
6 5 1 1 4 5 4 4 4 3 5 3 3 4 39 3 4 5 4 4 1 5 3 3 32
6 5 1 1 5 5 4 5 4 4 5 4 4 4 44 4 4 5 4 4 3 5 3 4 36
5 5 1 1 5 5 3 4 4 4 5 4 4 4 42 4 3 5 5 5 4 5 4 4 39
8 3 1 1 4 2 3 5 4 5 5 1 4 1 34 2 3 5 4 4 4 5 4 4 35
8 1 1 1 4 5 3 5 4 5 5 4 2 5 42 4 3 5 5 5 1 5 3 5 36
8 2 1 1 5 4 2 5 4 3 5 5 2 5 40 5 3 5 4 5 1 5 1 5 34
8 3 1 1 5 3 4 3 4 3 5 3 1 4 35 4 3 5 4 4 3 5 3 5 36
8 4 1 1 4 4 4 4 4 3 5 4 3 3 38 4 3 5 4 4 3 5 3 3 34
8 3 1 1 5 5 3 5 4 5 5 3 3 4 42 2 5 5 5 2 5 5 29
8 3 1 1 4 4 5 5 4 2 5 4 3 3 39 3 1 5 4 4 1 5 3 3 29
7 2 1 1 5 5 4 5 4 5 5 5 4 5 47 5 4 5 3 5 5 5 3 5 40
7 1 1 1 4 4 4 4 4 4 5 4 4 4 41 4 4 5 4 4 4 5 4 4 38
6 2 1 1 4 3 4 4 4 3 5 2 3 3 35 4 3 5 4 4 4 5 3 3 35
6 2 1 1 5 5 3 5 4 3 5 4 4 4 42 4 3 5 3 3 1 5 2 4 30
5 6 1 1 5 5 4 4 4 3 5 4 4 4 42 3 4 5 5 5 5 5 4 4 40
6 2 1 1 5 5 5 5 5 4 5 5 5 3 47 4 5 5 4 2 5 5 3 3 36
4 2 1 1 4 4 4 4 5 4 5 5 5 5 45 5 4 5 5 5 4 5 4 5 42
8 3 1 1 5 4 3 4 5 1 5 3 4 3 37 5 2 5 5 4 4 5 3 3 36
8 3 1 1 5 5 4 5 5 5 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
8 3 1 1 5 5 3 4 5 5 5 4 4 4 44 5 4 5 4 5 3 5 5 5 41
8 3 1 1 5 5 3 5 5 5 5 5 5 5 48 5 4 5 3 5 3 5 3 5 38
6 3 1 1 5 5 5 5 5 5 5 5 5 5 50 3 5 5 5 5 5 5 5 5 43
4 3 1 1 5 5 5 5 5 5 5 5 4 4 48 4 5 5 5 5 5 5 5 5 44
8 4 1 1 5 4 4 4 5 4 5 5 5 5 46 4 4 5 4 5 5 5 5 5 42
8 4 1 1 5 5 3 5 5 5 5 5 2 5 45 5 2 5 3 5 5 5 3 5 38
6 4 1 1 5 5 5 4 5 5 5 4 5 5 48 5 5 5 5 5 4 5 5 5 44
4 4 1 1 5 5 5 4 5 5 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
8 5 1 1 4 4 4 5 5 5 5 5 1 5 43 5 2 5 5 5 3 5 30
8 5 1 1 5 5 4 4 5 5 5 3 5 5 46 4 4 5 5 5 4 5 4 4 40
7 5 1 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 5 5 5 5 5 5 45
4 5 1 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 5 5 5 5 5 5 45
8 2 1 1 3 5 5 5 5 1 5 1 3 1 34 5 1 1 3 5 2 5 5 5 32
6 2 1 1 5 5 4 5 5 5 5 4 5 5 48 4 3 4 5 5 4 5 4 5 39
4 6 1 1 5 5 5 5 5 4 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
6 3 1 1 5 5 5 1 5 3 24 1 5 5 4 5 5 5 5 5 40
5 5 1 1 4 4 3 4 3 5 5 5 4 37 4 5 5 5 5 5 5 34
8 2 2 1 5 5 5 5 5 5 5 4 5 5 49 5 4 5 5 5 5 5 5 5 44
8 2 2 1 5 5 5 5 3 3 5 4 4 4 43 3 3 3 5 5 2 5 4 4 34
7 3 2 1 1 5 1 5 1 5 5 5 1 5 34 5 1 5 5 5 1 5 1 5 33
8 4 2 1 4 4 4 5 1 5 5 5 5 5 43 5 3 5 5 5 5 5 5 5 43
7 4 2 1 5 5 3 5 1 3 5 2 1 4 34 5 1 4 5 5 1 5 1 5 32
7 4 2 1 3 5 3 5 1 3 5 4 1 5 35 4 3 5 5 5 1 5 3 4 35
7 3 2 1 3 5 2 5 2 3 5 3 1 3 32 3 1 4 3 5 1 5 2 4 28
8 4 2 1 3 5 3 4 2 3 5 4 2 4 35 4 1 4 4 5 4 5 3 4 34
7 4 2 1 3 5 2 5 2 3 5 5 1 5 36 5 2 4 5 5 1 5 1 3 31
6 4 2 1 5 5 4 5 2 4 5 3 3 4 40 4 4 5 5 5 1 5 4 4 37
4 4 2 1 4 4 3 4 2 4 5 5 2 2 35 5 3 4 3 5 2 5 3 3 33
4 4 2 1 5 5 4 5 2 3 5 5 3 4 41 4 4 4 5 5 3 5 2 4 36
4 5 2 1 3 5 2 5 2 4 5 5 2 5 38 5 2 5 3 5 3 5 1 5 34
8 2 2 1 4 4 4 5 2 3 5 5 2 3 37 5 2 5 5 5 3 5 3 4 37
7 2 2 1 4 5 4 5 3 4 5 5 2 5 42 4 3 4 4 5 2 5 3 4 34
7 2 2 1 3 3 2 5 3 2 5 4 4 4 35 5 1 5 4 5 4 5 4 5 38
6 2 2 1 4 4 5 5 3 3 3 3 2 3 35 3 1 4 5 5 2 5 2 4 31
6 2 2 1 5 5 4 5 3 5 4 5 4 5 45 5 4 5 4 5 3 5 5 5 41
5 2 2 1 4 5 2 5 3 3 1 5 2 5 35 4 4 5 5 5 1 5 3 5 37
4 2 2 1 4 4 2 4 3 3 3 2 2 2 29 3 3 3 3 5 2 5 4 4 32
8 3 2 1 4 5 4 5 3 4 4 4 4 4 41 3 4 5 5 5 4 5 31
7 3 2 1 4 4 3 4 3 3 3 3 3 3 33 4 4 4 4 5 2 5 4 4 36
7 3 2 1 2 5 3 5 3 5 1 5 1 5 35 5 1 5 5 5 1 5 1 5 33
5 3 2 1 5 5 4 4 3 4 4 5 4 5 43 4 4 4 4 5 2 5 5 5 38
5 3 2 1 5 5 4 4 3 4 2 4 3 4 38 3 3 3 5 5 3 5 4 4 35
5 3 2 1 4 4 3 4 3 3 2 4 2 4 33 3 2 2 4 5 2 5 3 26
4 3 2 1 4 4 4 5 3 4 4 3 4 3 38 4 4 4 4 5 4 5 3 3 36
4 3 2 1 4 4 3 5 3 4 1 3 2 4 33 4 3 3 4 5 4 5 3 4 35
4 3 2 1 5 4 4 5 3 4 3 3 1 3 35 5 2 3 3 5 2 5 3 4 32
8 4 2 1 4 4 4 4 3 3 4 4 4 4 38 3 4 4 4 5 3 5 4 4 36
8 4 2 1 4 4 4 4 3 4 1 4 2 4 34 4 3 4 4 5 1 5 2 4 32
7 4 2 1 5 5 3 4 3 5 2 4 2 5 38 4 3 5 4 5 3 5 3 5 37
8 5 2 1 3 5 3 4 3 3 1 3 1 1 27 3 1 2 3 5 1 5 3 3 26
8 5 2 1 5 5 5 5 3 5 5 3 5 5 46 4 5 5 5 5 5 5 5 5 44
8 5 2 1 4 2 5 2 3 3 3 3 4 3 32 3 3 2 4 5 3 5 4 3 32
8 5 2 1 5 5 5 5 3 3 3 4 4 3 40 4 4 4 4 5 2 5 4 4 36
7 5 2 1 5 5 3 5 3 4 5 5 4 5 44 4 2 4 4 5 4 5 3 4 35
7 5 2 1 5 5 3 5 3 5 2 5 3 4 40 3 1 4 4 5 4 5 4 5 35
8 1 2 1 4 5 5 5 3 4 3 3 3 4 39 5 3 4 5 5 5 5 4 4 40
8 5 2 1 5 4 4 4 3 2 2 2 3 3 32 4 4 5 5 5 5 4 3 35
7 1 2 1 5 5 3 4 3 4 1 3 1 2 31 4 2 4 5 5 5 1 4 30
7 1 2 1 4 4 3 5 3 3 2 4 2 4 34 4 2 4 4 5 5 5 4 5 38
7 2 2 1 5 5 3 5 3 4 5 3 4 37 4 4 4 3 5 5 5 2 5 37
7 2 2 1 5 4 3 5 3 3 3 3 4 1 34 4 1 4 4 5 5 5 4 2 34
6 2 2 1 5 5 4 5 3 5 3 5 5 5 45 5 5 5 4 5 5 5 5 5 44
5 6 2 1 5 5 4 5 3 3 4 5 5 5 44 5 3 3 5 5 5 5 5 5 41
8 2 2 1 4 4 3 5 4 4 3 4 3 4 38 4 3 3 3 5 5 5 4 5 37
7 2 2 1 3 3 3 5 4 4 1 5 3 5 36 5 1 5 5 5 5 5 4 5 40
7 2 2 1 4 4 4 5 4 4 4 4 4 4 41 4 4 4 4 5 5 5 4 4 39
7 2 2 1 5 5 3 5 4 4 2 5 4 5 42 5 3 4 4 5 5 5 4 5 40
6 2 2 1 5 5 4 5 4 3 1 4 31 4 5 5 5 5 5 5 34
6 2 2 1 4 4 4 5 4 3 4 5 4 4 41 4 4 3 5 5 5 5 4 5 40
6 2 2 1 4 5 4 5 4 4 4 4 4 5 43 4 4 4 4 5 5 5 4 5 40
5 2 2 1 4 5 3 5 4 3 3 4 4 4 39 3 1 3 5 5 5 5 4 4 35
5 2 2 1 4 4 3 5 4 3 4 5 4 5 41 4 3 5 4 3 5 5 4 4 37
4 2 2 1 4 5 3 5 4 4 3 5 4 4 41 5 3 4 4 4 5 5 4 5 39
7 3 2 1 4 4 4 5 4 3 4 5 4 4 41 4 4 5 5 5 5 5 3 5 41
7 3 2 1 5 5 2 5 4 4 1 5 2 5 38 5 3 4 5 5 5 5 2 4 38
7 3 2 1 5 5 4 5 4 4 2 5 3 4 41 4 3 4 4 5 5 5 3 4 37
6 3 2 1 4 5 4 5 4 4 3 5 3 4 41 4 4 4 4 5 5 5 4 5 40
6 3 2 1 4 5 4 4 4 3 1 1 3 4 33 5 4 3 5 5 2 4 28
6 3 2 1 5 5 5 5 4 4 4 4 5 5 46 4 5 4 5 5 5 5 5 5 43
5 3 2 1 4 4 4 4 4 3 3 3 1 3 33 3 2 3 4 4 5 5 4 4 34
4 3 2 1 5 5 3 5 4 4 3 4 2 3 38 4 3 3 5 5 5 5 2 3 35
4 3 2 1 5 4 3 5 4 5 2 5 2 5 40 5 3 5 4 5 5 5 3 5 40
4 3 2 1 5 5 3 5 4 4 3 4 4 3 40 5 4 4 5 4 5 5 3 3 38
8 4 2 1 5 5 4 5 4 3 3 4 4 3 40 3 3 3 5 5 5 5 4 3 36
7 4 2 0 3 4 3 5 4 4 3 4 3 4 37 4 1 5 4 4 5 5 3 4 35
7 4 2 1 5 5 3 4 4 4 4 4 4 4 41 4 4 4 4 4 5 5 4 4 38
7 4 2 1 4 5 3 5 4 4 3 5 3 5 41 4 3 4 4 5 5 5 3 5 38
6 4 2 1 5 5 4 4 4 4 4 3 5 4 42 5 5 5 5 5 5 5 5 5 45
5 4 2 1 4 4 4 4 4 3 4 4 4 4 39 4 3 4 5 5 5 5 5 5 41
4 4 2 1 5 5 4 5 4 4 4 5 5 5 46 5 3 4 5 4 5 5 5 5 41
8 5 2 1 4 5 3 5 4 4 3 4 4 4 40 5 4 4 4 4 5 5 3 4 38
7 5 2 1 3 4 2 5 4 4 1 3 1 2 29 3 3 3 4 4 5 5 1 3 31
7 5 2 0 5 5 3 5 4 4 2 4 3 4 39 4 2 2 4 5 5 5 4 5 36
7 5 2 1 4 5 2 5 4 4 5 5 4 5 43 4 4 4 4 5 5 5 4 4 39
6 5 2 1 5 5 3 5 4 4 3 29 5 5 4 4 5 5 28
8 5 2 1 3 4 3 5 4 4 2 4 3 4 36 4 3 4 4 4 5 5 4 4 37
8 2 2 1 5 5 5 5 4 5 5 5 5 5 49 5 5 5 5 5 5 5 5 5 45
8 1 2 1 4 4 4 5 4 4 4 4 4 4 41 4 4 4 5 5 5 5 4 4 40
7 4 2 1 3 3 5 4 3 3 3 2 3 29 3 3 3 4 4 5 5 4 3 34
7 1 2 1 4 4 3 5 4 3 4 3 4 4 38 4 3 3 5 5 5 5 5 5 40
5 5 2 1 5 5 3 5 4 4 2 3 2 3 36 3 1 3 2 4 5 5 4 27
7 2 2 1 5 4 4 5 5 4 1 5 1 5 39 5 3 3 4 4 5 5 4 5 38
6 3 2 1 5 5 5 5 5 5 5 5 5 5 50 5 5 5 5 5 5 5 5 5 45
6 3 2 1 5 5 4 5 5 3 1 1 5 3 37 2 5 3 5 4 5 5 4 3 36
4 3 2 0 4 5 4 5 5 5 1 5 3 5 42 5 1 5 3 5 5 5 1 5 35
7 4 2 1 5 5 5 5 5 5 1 3 3 4 41 3 3 4 4 5 5 5 2 4 35
5 4 2 1 4 4 3 5 5 4 4 4 4 4 41 3 4 3 5 4 5 5 5 4 38
4 4 2 1 5 5 3 5 5 5 5 5 5 5 48 5 5 5 4 5 5 5 5 5 44
8 2 2 1 5 5 5 5 5 5 5 5 5 5 50 5 5 5 5 5 5 5 5 5 45
8 5 2 1 4 4 4 5 4 3 3 3 3 33 3 5 4 5 5 5 5 4 4 40
7 4 1 0 2 4 1 5 2 4 2 3 2 3 28 3 1 3 2 4 3 5 1 5 27
4 4 1 1 5 5 2 5 3 3 3 3 4 4 37 4 2 4 3 4 4 5 2 3 31
6 5 1 1 5 5 2 5 3 1 1 22 5 1 1 5 5 17
6 5 1 1 4 5 3 4 3 4 3 4 4 4 38 3 3 3 4 4 5 5 4 4 35
6 4 1 1 4 4 4 4 4 4 24 4 4 4 4 5 5 26
Column Labels
Values 0 1 (blank) Grand Total
Count of Satisfaction with Career 69 467 536
Count of Total Well Being 69 467 536

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

0 Count of Satisfaction with Career Count of Total Well Being 69 69 1 Count of Satisfaction with Career Count of Total Well Being 467 467 (blank) Count of Satisfaction with Career Count of Total Well Being

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