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?

Income 884 1543 1099 450 255 532 206 386 868 1789 1152 819 556 1614 426 856 950 463 409 781 972 615 849 1217 172 507 24 18 628 392 564 1131 425 713 172 979 927 564 249 868 954 406 249 1084 371 501 222 230 62 1543 532 706 107 475 232 724 781 193 1099 1724 781 1099 952 801 406 375 662 18 240 967 849 952 856 1373 455 768 581 474 172 244 474 795 642 596 425 462 781 710 108 1147 386 497 74 218 232 485 552 532 266 809 44 708 826 431 868 609 835 801 517 287 227 820 462 409 658 985 1163 628 835 954 1145 94 239 925 395 143 402 462 102 450 371 556 596 642 623 517 795 884 642 1724 406 662 856 548 746 768 1152 497 480 309 480 1217 244 218 746 515 386 609 526 548 406 455 508 266 927 371 201 884 231 255 44 506 11 515 172 1145 450 371 927 596 1614 826 564 949 260 406 375 323 426 815 856 409 525 383 426 856 1157 927 630 1097