Using the Income per week data:

1. What is the probability a randomly selected individual from your sample has an income over $239.99 per week?[Hint: consider using the Sort feature.]
2. Consider a randomly selected sample of five individuals from your sample (assume for the moment that an individual could be selected more than once into this sample).What is the distribution of the number (out of five) that have an income greater than $239.99 per week (i.e. distribution name and parameters)?
3. Use the BINOM.DIST function in Excel to calculate the probability distribution of the number of individuals in the sample of five in b who have an income over $239.99 per week.Copy this table into your assignment.What is the most likely number (i.e. the mode)?What is the probability none in the sample have an income over $239.99 per week?What is the probability that more than half do?What is the expected number of individuals?Finally, what is the standard deviation of the number?Make sure you label each of these quantities with suitable notation, i.e. using P, E, etc.
4. If an individual could not be selected more than once into the sample, what implications does this have for the binomial assumptions?

Gender Age Ethnicity Marital Qualification PostSchool Hours Income Male 23 European Never Vocational Yes 70 884 Female 29 European Never Degree Yes 60 1543 Male 18 European Other Vocational Yes 40 1099 Female 30 European Married Vocational Yes 18 450 Female 18 European Never School No 17 255 Female 34 European Previously Vocational Yes 38 532 Female 43 European Married None No 6 206 Female 34 European Other None No 25 386 Female 21 European Other School No 36 868 Male 26 European Never Degree Yes 50 1789 Female 39 European Other Degree Yes 55 1152 Female 30 Maori Never School No 40 819 Female 43 European Never None No 40 556 Male 45 European Married Degree Yes 50 1614 Male 36 European Married None No 35 426 Male 42 European Previously Degree Yes 54 856 Male 43 European Married Degree Yes 45 950 Female 38 European Married Vocational Yes 32 463 Female 36 European Married School No 20 409 Female 16 European Married Vocational Yes 45 781 Male 31 European Never School No 50 972 Male 16 Other Never School No 54 615 Male 38 European Married None No 50 849 Male 34 European Married Vocational Yes 60 1217 Female 15 European Never None No 8 172 Male 25 European Never School No 40 507 Female 22 European Never School No 6 24 Female 41 European Married Vocational Yes 17 18 Female 18 Maori Never School No 45 628 Female 45 European Married School No 24 392 Male 45 European Never Vocational Yes 40 564 Male 35 European Married School No 70 1131 Female 40 European Never Degree Yes 13 425 Female 27 European Other Vocational Yes 38 713 Female 15 European Never None No 8 172 Male 31 European Never Degree Yes 40 979 Male 45 European Married Vocational Yes 44 927 Female 32 European Married Degree Yes 40 564 Female 33 Pacific Never School No 17 249 Male 21 Maori Never School No 50 868 Male 31 European Never School No 50 954 Female 32 European Married None No 40 406 Female 18 European Never School No 17 249 Female 38 European Never Vocational Yes 40 1084 Female 34 European Married School No 24 371 Male 38 Maori Married None No 40 501 Male 17 European Never None No 15 222 Female 19 European Married School No 15 230 Female 17 Maori Never School No 4 62 Female 29 European Never Degree Yes 60 1543 Female 34 European Previously Vocational Yes 38 532 Male 35 European Married Vocational Yes 45 706 Female 16 European Never None No 3 107 Male 22 European Never School No 44 475 Female 16 European Never School No 9 232 Male 27 Maori Never School No 45 724 Female 16 European Married Vocational Yes 46 781 Female 36 European Married Vocational Yes 5 193 Male 34 European Previously Vocational Yes 45 1099 Male 32 European Married Degree Yes 70 1724 Male 40 European Married Vocational Yes 45 781 Male 18 European Other Vocational Yes 40 1099 Male 27 European Never Vocational Yes 40 952 Female 33 European Married Vocational Yes 48 801 Female 36 European Married Vocational Yes 24 406 Male 22 European Never School No 40 375 Male 40 European Other None No 36 662 Female 21 European Never School No 6 18 Male 18 European Never None No 14 240 Female 34 European Married Vocational Yes 40 967 Male 34 European Married Vocational Yes 55 849 Male 27 European Never Vocational Yes 40 952 Male 41 European Previously Degree Yes 54 856 Male 35 European Married Vocational Yes 60 1373 Male 23 European Never Vocational Yes 25 455 Male 18 Other Never School No 60 768 Female 32 European Married Degree Yes 40 581 Female 27 European Never None No 40 474 Female 15 European Never None No 8 172 Female 33 Pacific Never School No 17 244 Female 27 European Never None No 40 474 Female 16 European Married Vocational Yes 47 795 Male 17 European Never School No 40 642 Female 40 European Married Vocational Yes 42 596 Female 40 European Never Degree Yes 13 425 Male 22 European Never Vocational Yes 25 462 Male 29 European Married Vocational Yes 37 781 Male 25 European Never Vocational Yes 40 710 Female 16 European Never None No 2 108 Male 20 Other Other Vocational Yes 60 1147 Female 16 European Never School No 20 386 Male 38 Maori Married None No 40 497 Female 20 European Never School No 12 74 Female 43 European Married None No 9 218 Female 16 European Never School No 9 232 Female 21 European Never School No 34 485 Female 45 Maori Married None No 40 552 Male 37 European Previously School No 50 532 Female 30 European Never School No 19 266 Male 26 European Never Degree Yes 38 809 Male 18 Maori Never School No 5 44 Male 25 European Never Vocational Yes 40 708 Female 31 Maori Never School No 40 826 Female 45 European Never None No 40 431 Male 24 European Never Vocational Yes 54 868 Male 44 European Previously None No 45 609 Male 38 European Married None No 50 835 Male 29 European Married Vocational Yes 37 801 Female 23 Maori Never Vocational Yes 38 517 Female 24 Pacific Married None No 6 287 Male 17 European Never None No 15 227 Female 31 Maori Never School No 40 820 Male 30 European Never Vocational Yes 25 462 Female 25 Maori Never Vocational Yes 25 409 Female 23 Other Never Degree Yes 45 658 Female 37 European Previously Degree Yes 50 985 Male 38 Maori Previously Degree Yes 50 1163 Female 24 European Never Vocational Yes 40 628 Male 34 European Married Vocational Yes 55 835 Male 31 European Never School No 50 954 Male 35 European Married School No 70 1145 Female 19 European Never None No 3 94 Male 18 European Never None No 14 239 Female 36 European Previously Degree Yes 40 925 Male 34 European Never None No 30 395 Female 31 European Other School No 24 143 Female 42 European Married None No 40 402 Male 23 European Never Vocational Yes 25 462 Female 18 Pacific Other School No 9 102 Female 30 European Married Vocational Yes 19 450 Female 33 European Never Vocational Yes 15 371 Male 32 European Married Vocational Yes 38 556 Female 40 European Married Vocational Yes 42 596 Male 17 European Never School No 40 642 Female 19 European Married School No 40 623 Female 23 Maori Never Vocational Yes 38 517 Male 29 European Married Vocational Yes 37 795 Male 22 European Never Vocational Yes 70 884 Male 17 European Never School No 40 642 Male 26 European Never Degree Yes 50 1724 Female 27 Maori Never School No 20 406 Male 35 European Married Vocational Yes 45 662 Male 42 European Previously Degree Yes 54 856 Male 35 European Married School No 40 548 Female 45 European Married Vocational Yes 48 746 Female 16 European Married Vocational Yes 46 768 Male 22 Maori Never Vocational Yes 70 1152 Male 33 Maori Married None No 40 497 Male 28 European Married None No 54 480 Female 22 European Never School No 15 309 Female 21 European Never School No 35 480 Male 38 Maori Previously Degree Yes 50 1217 Female 33 Pacific Never School No 17 244 Female 31 European Previously School No 9 218 Female 20 Other Never Vocational Yes 50 746 Female 23 Maori Never Vocational Yes 38 515 Female 45 European Married School No 24 386 Male 44 European Previously None No 45 609 Female 42 Other Married Vocational Yes 26 526 Female 28 European Married Degree Yes 50 548 Female 32 European Married None No 40 406 Male 22 European Never Vocational Yes 25 455 Male 18 Pacific Never None No 35 508 Female 43 European Previously None No 25 266 Male 36 European Other Vocational Yes 40 927 Female 33 European Never Vocational Yes 14 371 Female 42 European Married None No 6 201 Male 22 European Never Vocational Yes 65 884 Female 18 European Married School No 15 231 Female 18 European Never School No 17 255 Male 18 Maori Never School No 4 44 Male 18 Pacific Never None No 35 506 Female 21 Maori Never School No 2 11 Male 23 European Never School No 45 515 Female 15 European Never None No 8 172 Male 41 Other Married Degree Yes 45 1145 Female 30 European Married Vocational Yes 18 450 Male 22 European Never School No 40 371 Male 36 European Other Vocational Yes 40 927 Female 32 European Married Degree Yes 40 596 Male 45 European Married Degree Yes 50 1614 Male 34 European Never None No 54 826 Female 34 European Married School No 38 564 Male 37 European Married None No 50 949 Female 16 European Never School No 20 260 Female 27 Maori Never School No 20 406 Female 34 European Married School No 24 375 Female 39 Maori Married School No 16 323 Female 45 European Never None No 40 426 Male 37 European Married Vocational Yes 40 815 Male 39 European Married None No 54 856 Female 32 European Married None No 40 409 Male 40 Maori Previously Vocational Yes 39 525 Female 45 European Married School No 24 383 Female 26 European Married Vocational Yes 42 426 Male 41 European Previously Degree Yes 50 856 Male 21 Maori Never Vocational Yes 70 1157 Female 36 European Previously Degree Yes 40 927 Male 17 European Never School No 40 630 Female 38 European Never Vocational Yes 40 1097