Statistics Help
Week 6.doc
Homework Week 6
You will be submitting a Word file and an Excel file this week.
Part 1
(worth 60 points)
|
|
|
|
1a. Unlike the spinner on p. 90 of the OLI module, imagine a spinner that also has 3 colors - - Red, White, Green - - but all the colors are the same size. Someone spins the pointer 2 times. List all the possible outcomes of this random experiment. [Use the letters R, W, G.] 1b. What is another name for the list you just made?
|
|
|
2. What is the probability that the color red will come up exactly once in the two spins?
|
|
|
3. What is the probability that red will come up on both spins?
|
|
|
4. There are 10 males and 12 females in a statistics class. If one student is chosen at random, what is the probability that the student is a female?
|
|
|
5. What is the probability of rolling a pair of dice and getting one (only one) 6? Explain how you arrived at your answer. [Hint: The table on p. 184 in your text could be helpful.]
|
|
|
6. Last week we had the following homework question: In New York State there is a fairly strong positive correlation between principals’ salaries and the reading scores of their students. (This is true.) Upon learning this, a politician recommends that principals’ salaries be increased because this will cause students’ reading scores to increase. Good idea? The answer of course was that it was not a good idea at all since association does not imply causation. Suggest a lurking variable that could reasonably account for the association between students’ reading scores and principals’ salaries. [Hint: The lurking variable must be plausibly related to both principals’ salaries and reading scores.] |
|
Part 2
(worth 40 points)
The point of the Learn by Doing activity on the bottom of OLI p. 67 is to teach you about sampling and to demonstrate how you can select a random sample using Excel. The activity contains three text boxes with open-ended questions.
Submit one Excel file that includes the work necessary to answer the three open-ended questions. Put your answers to the three open-ended questions on the first worksheet which you name Answers. Choose appropriate names for the additional worksheets showing the work you did to arrive at the answers including your random samples.
Week 6.xls
Sheet1
| Course | Handed | Sex | Verbal | Age |
| Social | left | male | 470 | 18.83 |
| Social | right | female | 650 | 18.67 |
| Social | right | male | 580 | 20.08 |
| Social | right | female | 660 | 18.5 |
| Social | right | female | 790 | 24.25 |
| Social | right | female | 640 | 20.33 |
| Social | left | female | 660 | 19.17 |
| Social | right | female | 560 | 19.25 |
| Social | right | female | 560 | 18.92 |
| Social | right | female | 540 | 19.08 |
| Social | right | female | 620 | 18.42 |
| Social | left | male | 640 | 18.75 |
| Social | right | female | 550 | 18.25 |
| Social | right | male | 400 | 19.25 |
| Social | right | male | 430 | 21 |
| Social | right | male | 630 | 20.42 |
| Social | right | female | 630 | 18.5 |
| Social | right | male | 720 | 22.67 |
| Social | right | female | * | 23 |
| Social | right | female | 660 | 18.83 |
| Social | right | female | 520 | 18.83 |
| Social | right | female | 640 | 18.5 |
| Social | right | male | 580 | 19.08 |
| Social | left | female | 730 | 18.08 |
| Social | left | female | 550 | 20.33 |
| Social | right | male | 600 | 18.33 |
| Social | right | female | 530 | 18.67 |
| Social | right | female | 650 | 18.58 |
| Social | right | female | 800 | 20.92 |
| Social | right | female | 730 | 18.5 |
| Social | right | male | 730 | 20.17 |
| Social | right | female | 610 | 19.67 |
| Social | right | female | 530 | 18.83 |
| Social | right | female | 550 | 18.42 |
| Social | left | male | 590 | 19.17 |
| Social | right | female | 650 | * |
| Social | right | female | * | 19.67 |
| Social | right | male | 690 | 19.17 |
| Social | right | female | 600 | 19 |
| Social | right | female | * | 19.42 |
| Social | right | female | * | 20.83 |
| Social | right | female | 510 | 18.83 |
| Social | right | female | 530 | 20.33 |
| Social | right | female | 700 | 18.83 |
| Social | left | female | 550 | 19.33 |
| Social | right | female | 660 | 18 |
| Social | right | male | * | 26.33 |
| Social | right | female | 600 | 18.33 |
| Social | right | female | 680 | 20.08 |
| Social | left | female | 560 | 18.92 |
| Social | right | male | 530 | 20.75 |
| Social | right | male | 550 | 18.92 |
| Social | right | female | 600 | 19.67 |
| Social | left | male | 630 | 19.83 |
| Social | right | female | 540 | 18.75 |
| Social | right | female | 580 | 18.42 |
| Social | left | female | 710 | 18.83 |
| Social | right | male | 750 | 19.08 |
| Social | right | female | 600 | 20.33 |
| Social | left | male | 650 | 21.5 |
| Social | right | female | 680 | 18.83 |
| Social | right | female | * | 20.25 |
| Social | right | female | 580 | 20.42 |
| Social | right | male | 480 | 20.92 |
| Social | right | female | 600 | 21.42 |
| Social | left | female | 600 | 19.92 |
| Social | left | male | 510 | 23 |
| Social | right | female | 610 | 21.33 |
| Social | right | female | 650 | 30.92 |
| Social | right | female | 520 | 20 |
| Social | right | male | 540 | 20.25 |
| Social | right | female | 650 | 20.17 |
| Natural | right | female | 610 | 31.17 |
| Natural | right | female | 540 | 19.17 |
| Natural | right | female | 680 | 20.75 |
| Natural | right | male | 580 | 19.92 |
| Natural | right | male | 640 | 24.92 |
| Natural | right | female | 400 | 20.08 |
| Natural | right | female | * | 19.83 |
| Natural | right | male | 670 | 21.83 |
| Social | right | female | 640 | 18.33 |
| Natural | right | male | 720 | 19.92 |
| Natural | right | female | * | 23.42 |
| Natural | right | male | 770 | 19.75 |
| Natural | right | female | 520 | 20.67 |
| Natural | right | male | 630 | 18.83 |
| Natural | right | male | 480 | 18.42 |
| Natural | right | male | * | 20.5 |
| Natural | right | male | 660 | 18.5 |
| Natural | right | male | 700 | 19.33 |
| Natural | right | male | 490 | 21 |
| Natural | right | female | 670 | 19.67 |
| Natural | right | male | 660 | 20.25 |
| Natural | right | female | 550 | 19.67 |
| Natural | right | female | 650 | 19.5 |
| Natural | right | male | 620 | 19.25 |
| Natural | right | female | 610 | 18.75 |
| Natural | right | male | 450 | 22.33 |
| Natural | right | female | 530 | 18.92 |
| Natural | right | male | 580 | 20.83 |
| Natural | left | female | 630 | 18.92 |
| Natural | right | male | 620 | 18.83 |
| Natural | left | male | 600 | 19.92 |
| Natural | right | female | 500 | 19.42 |
| Natural | right | female | 620 | 20.5 |
| Natural | right | female | 710 | 18.75 |
| Natural | right | female | 580 | 19.58 |
| Natural | right | male | 580 | 19.5 |
| Natural | right | female | 590 | 18.92 |
| Natural | right | female | 560 | 19.5 |
| Natural | right | female | 460 | 18.17 |
| Natural | right | female | * | 19.08 |
| Natural | left | female | 560 | 18.92 |
| Natural | right | male | 590 | 18.75 |
| Natural | right | female | 600 | 19.75 |
| Natural | right | female | 560 | 22.58 |
| Natural | right | female | 540 | 44.67 |
| Natural | right | female | 710 | * |
| Business | right | male | 500 | 18.08 |
| Business | right | female | 640 | 19.92 |
| Business | right | male | 530 | 19.58 |
| Business | left | male | 480 | 18.5 |
| Natural | right | male | 540 | 20.08 |
| Natural | right | male | 540 | 21.25 |
| Natural | right | female | 740 | 19.75 |
| Natural | right | male | 650 | 22.25 |
| Natural | right | male | * | 19.67 |
| Natural | right | female | 550 | 20.67 |
| Natural | right | male | 540 | 19.58 |
| Natural | right | male | 490 | 20.83 |
| Natural | left | female | 580 | 20.08 |
| Natural | right | male | 650 | 20.17 |
| Natural | right | male | 540 | 18.58 |
| Natural | right | female | 520 | 22.08 |
| Natural | right | male | 560 | 19.42 |
| Natural | right | male | * | 27.33 |
| Natural | right | female | 670 | 19.5 |
| Natural | right | male | 550 | 20.25 |
| Natural | right | male | 600 | 19.5 |
| Business | right | male | 520 | 19.42 |
| Business | left | male | 590 | 19.17 |
| Social | left | female | 670 | 18.5 |
| Business | right | male | 570 | 18.42 |
| Business | right | female | 550 | 19.75 |
| Business | right | male | 700 | 20.17 |
| Natural | right | female | 700 | 18.25 |
| Social | right | female | 670 | 19.25 |
| Natural | right | male | 720 | 18.92 |
| Natural | right | male | 630 | 19.25 |
| Natural | right | male | 760 | 21.42 |
| Natural | right | male | 490 | 19.92 |
| Natural | right | male | 580 | 22.08 |
| Business | right | female | * | 22 |
| Natural | left | male | 580 | 22 |
| Natural | right | female | 700 | 18.5 |
| Natural | right | male | 530 | 22.5 |
| Natural | right | male | 670 | 18.83 |
| Natural | right | female | 720 | 17.92 |
| Natural | left | female | 590 | 18.17 |
| Natural | right | female | 570 | 18.58 |
| Natural | left | male | 700 | 18.25 |
| Natural | right | female | 750 | 18.58 |
| Natural | right | male | 650 | 19.33 |
| Natural | left | female | 610 | 19.58 |
| Natural | left | male | 680 | 19.33 |
| Natural | right | female | 580 | 18.58 |
| Natural | right | male | 640 | 19.42 |
| Natural | left | female | 610 | 19.58 |
| Natural | right | female | 720 | 18.75 |
| Natural | right | female | 600 | 18.58 |
| Natural | left | female | 550 | 18.92 |
| Natural | right | female | 670 | 19.08 |
| Natural | right | male | 560 | 19.67 |
| Natural | right | male | 520 | 19.58 |
| Natural | right | female | 570 | 18.75 |
| Natural | right | female | 560 | 20 |
| Natural | right | male | 530 | 21.33 |
| Natural | right | male | 600 | 18.5 |
| Natural | right | female | 560 | 19.17 |
| Natural | left | female | 560 | 20.25 |
| Social | right | female | 670 | 18.42 |
| Social | right | female | 500 | 21.08 |
| Social | left | male | 640 | 24.5 |
| Social | right | male | 550 | 19.5 |
| Social | right | female | 730 | 18.33 |
| Social | right | male | 660 | 21.08 |
| Social | right | male | 660 | 20.75 |
| Social | right | female | 720 | 21.67 |
| Social | right | female | 520 | 18.75 |
| Social | right | male | 490 | 19.83 |
| Social | right | female | 600 | 18.92 |
| Social | right | male | 760 | 21.5 |
| Social | right | male | 660 | 18.58 |
| Social | right | female | 570 | 18.67 |
| Social | right | male | 500 | 20.83 |
| Social | left | male | 700 | 19.83 |
| Social | right | female | 590 | 18.25 |
| Social | right | male | 580 | 20.5 |
| Social | right | male | 490 | 18.5 |
| Natural | left | female | 590 | 21.5 |
| Natural | right | female | 550 | 18.67 |
| Natural | right | male | 540 | 19.08 |
| Social | right | female | 600 | 19.08 |
| Natural | right | female | 580 | 19.25 |
| Natural | right | male | 750 | 19.17 |
| Natural | left | male | 540 | 18.75 |
| Natural | right | female | 600 | 18.75 |
| Social | right | female | 560 | 18.83 |
| Natural | right | female | 640 | 19.25 |
| Social | right | female | 600 | 19 |
| Natural | right | female | * | 32.08 |
| Social | right | male | 600 | 20.08 |
| Social | right | male | 520 | 21.17 |
| Social | left | male | 640 | 18.25 |
| Social | right | female | 640 | 19.5 |
| Natural | right | female | 800 | 18.92 |
| Social | right | female | 570 | 19.08 |
| Social | left | male | 600 | 21.5 |
| Natural | right | male | 650 | 20 |
| Natural | right | female | 720 | 25.25 |
| Social | right | male | 540 | 19.75 |
| Natural | right | female | 630 | 19 |
| Natural | right | female | 680 | 18.58 |
| Social | right | female | 610 | 18.75 |
| Natural | right | male | 690 | 18.42 |
| Social | right | female | * | 21.58 |
| Natural | right | female | 700 | 19.25 |
| Social | right | female | 620 | 18.92 |
| Natural | right | male | 580 | 19 |
| Natural | left | female | 520 | 18.67 |
| Social | right | female | 550 | 20.25 |
| Social | right | female | 550 | 19.08 |
| Social | right | male | 680 | 18.58 |
| Social | right | female | * | 18.42 |
| Social | left | female | * | * |
| Social | right | female | 490 | 19 |
| Natural | right | male | 740 | 24.5 |
| Natural | right | female | 630 | 18.5 |
| Natural | right | female | 550 | 19.5 |
| Natural | right | female | 600 | 18.92 |
| Natural | right | female | 590 | 19.33 |
| Natural | right | female | 610 | 20.25 |
| Natural | right | female | 400 | 19.75 |
| Natural | right | male | 750 | 19.58 |
| Natural | right | female | 610 | 18.83 |
| Business | right | male | * | 22.92 |
| Social | right | male | 540 | 22.75 |
| Natural | right | female | 600 | 20.92 |
| Natural | right | male | 400 | 22.25 |
| Social | right | female | 590 | 19.25 |
| Natural | right | female | 635 | 21.75 |
| Social | left | female | 550 | 19.25 |
| Social | right | male | 610 | 18.75 |
| Social | right | female | 490 | 18.58 |
| Social | right | female | * | 21.5 |
| Social | right | male | 610 | 19.83 |
| Social | right | female | 690 | 18.42 |
| Social | right | male | 540 | 18.83 |
| Natural | right | male | 550 | 18.75 |
| Social | right | female | 460 | 20.42 |
| Social | right | female | 580 | 19.17 |
| Social | right | male | 600 | 30.33 |
| Natural | right | male | 600 | 20.08 |
| Natural | right | male | 430 | 18.75 |
| Social | right | female | 600 | 20.58 |
| Social | right | female | 570 | 18.5 |
| Natural | right | female | 670 | 19.17 |
| Social | right | male | 540 | 18.67 |
| Natural | right | male | 560 | 20.25 |
| Social | right | female | 550 | 19.17 |
| Social | right | female | * | 21.92 |
| Natural | right | male | 660 | 18.75 |
| Social | right | female | * | 22.33 |
| Social | right | female | 590 | 19.92 |
| Natural | right | female | 530 | 21.58 |
| Social | left | male | 500 | 22.67 |
| Social | right | female | 620 | 18.58 |
| Natural | right | female | 560 | 18.83 |
| Natural | right | male | 600 | 22.58 |
| Social | right | female | 570 | 19.33 |
| Social | right | male | 600 | 20.67 |
| Social | right | female | 550 | 22.5 |
| Social | right | female | 650 | 20.17 |
| Social | right | male | 670 | 20.83 |
| Social | right | female | 570 | 20 |
| Social | right | female | 510 | 21.33 |
| Social | right | female | 600 | 19.92 |
| Social | left | male | 510 | 19.25 |
| Social | right | female | 490 | 19.08 |
| Social | right | male | 555 | 21.42 |
| Social | right | female | 500 | 19 |
| Social | right | male | 670 | 19.33 |
| Social | right | female | 600 | 19.42 |
| Social | right | male | 540 | 29.75 |
| Social | right | female | * | 18.67 |
| Social | right | male | 580 | 20.83 |
| Social | right | female | 400 | 20.17 |
| Social | right | female | 580 | 24.17 |
| Social | left | female | 560 | 18 |
| Social | right | male | 540 | 19.08 |
| Social | left | female | 520 | 20.83 |
| Social | right | male | 620 | 20 |
| Social | right | female | * | 22.25 |
| Social | left | female | 800 | 19.58 |
| Social | right | female | 510 | 20.17 |
| Social | left | female | 520 | 21.67 |
| Social | right | male | 480 | 20.42 |
| Social | right | female | 500 | 19.25 |
| Business | right | female | * | 25.75 |
| Social | right | female | * | 21.92 |
| Social | right | female | 560 | 21.42 |
| Social | right | male | 600 | 28.75 |
| Social | right | female | 500 | 19.67 |
| Social | right | male | 580 | 20.08 |
| Social | right | female | 590 | 19.08 |
| Social | right | female | 540 | 19.67 |
| Social | right | female | 700 | 18.5 |
| Social | right | female | * | 18.5 |
| Social | right | female | 590 | 19.17 |
| Social | right | female | * | 19.75 |
| Social | right | female | 560 | 20.42 |
| Social | right | female | 510 | 19.17 |
| Social | left | female | 680 | 20.25 |
| Social | right | male | 520 | 20.42 |
| Social | right | male | 600 | 19.67 |
| Social | right | male | 710 | 19.42 |
| Social | right | female | 600 | 19.17 |
| Social | right | male | * | 22.25 |
| Social | right | female | 480 | 19.25 |
| Social | right | female | 560 | 19.42 |
| Social | right | female | 480 | 19.08 |
| Social | right | male | 550 | 18.58 |
| Social | right | male | 650 | 20.17 |
| Social | right | female | * | 20.83 |
| Social | right | male | 560 | 19.33 |
| Social | right | male | 520 | 19.83 |
| Social | right | female | 650 | 19.42 |
| Social | right | male | * | 19.33 |
| Social | left | female | 620 | 20.67 |
| Social | right | male | 530 | 19.58 |
| Social | right | male | 500 | 19.67 |
| Social | right | female | 760 | 19.17 |
| Social | right | female | * | 19.5 |
| Social | right | female | * | 20.83 |
| Social | right | female | 675 | 21.58 |
| Social | right | female | 300 | 25.5 |
| Social | right | female | 640 | 31.75 |
| Social | right | male | 640 | 19.83 |
| Social | right | female | 640 | 19.33 |
| Social | right | male | 670 | 19.17 |
| Social | right | female | 660 | 19.58 |
| Business | right | female | 440 | 18.33 |
| Social | left | male | 660 | 24.75 |
| Social | right | male | 520 | 21.58 |
| Social | right | male | 550 | 20.33 |
| Social | right | female | * | 19.75 |
| Social | left | female | 610 | 20.5 |
| Social | right | female | 620 | 19.25 |
| Social | right | female | 590 | 19.92 |
| Social | right | female | 550 | 20 |
| Social | right | female | * | 21.5 |
| Social | right | female | 560 | 18.83 |
| Social | right | female | 680 | 19.08 |
| Social | right | female | 590 | 20.92 |
| Social | right | female | 500 | 19.75 |
| Social | right | female | * | 21.58 |
| Social | right | male | 540 | * |
| Social | right | female | 540 | 19.42 |
| Social | right | female | 480 | 21.17 |
| Social | right | female | 640 | 20.08 |
| Social | right | female | 660 | 19.58 |
| Social | right | female | 600 | 18.42 |
| Social | left | female | 570 | 20.92 |
| Social | right | female | 560 | 20.5 |
| Social | right | male | 520 | 19.58 |
| Social | right | female | 540 | 19.17 |
| Natural | right | female | 600 | 17.92 |
| Social | right | male | * | 19.25 |
| Social | right | female | 550 | 21 |
| Social | right | female | 560 | 20.42 |
| Social | left | female | 580 | 19.17 |
| Social | left | male | 550 | 20.25 |
| Social | right | female | 620 | 18.92 |
| Social | right | male | 780 | 19.67 |
| Social | right | female | * | 19.83 |
| Natural | right | female | 670 | 34.67 |
| Natural | left | male | 630 | 19.25 |
| Natural | right | female | 570 | 19.5 |
| Natural | right | male | 590 | 18.17 |
| Natural | right | female | 670 | 19.25 |
| Natural | right | male | 610 | 19.08 |
| Natural | right | male | 580 | 21.83 |
| Natural | right | female | 650 | 19.58 |
| Natural | right | male | 600 | 24.92 |
| Natural | right | female | 590 | 18.75 |
| Natural | right | female | 600 | 19.83 |
| Natural | right | male | 660 | 19.5 |
| Natural | right | female | 610 | 24.42 |
| Natural | right | female | * | 19.08 |
| Business | right | male | * | 20.75 |
| Natural | right | female | 600 | 33.92 |
| Natural | right | female | 500 | 20 |
| Natural | right | male | * | 20.75 |
| Natural | right | female | 550 | 22.17 |
| Natural | left | female | * | 19.5 |
| Natural | right | male | 570 | 25.17 |
| Natural | right | female | 700 | 20.67 |
| Natural | right | female | 670 | 18.83 |
| Natural | right | male | * | 19 |
| Social | right | female | 620 | 19 |
| Natural | right | female | 640 | 20.67 |
| Natural | right | female | 620 | 19.42 |
| Business | right | male | 610 | 20.17 |
| Natural | right | female | 720 | 19.58 |
| Natural | right | female | 720 | 18 |
| Natural | right | male | 600 | 20.5 |
| Natural | right | female | 680 | 19.33 |
| Natural | right | female | * | 17.92 |
| Natural | right | female | * | 20.83 |
| Natural | right | female | 700 | 19.33 |
| Natural | right | female | * | 19.42 |
| Business | right | male | 600 | 20 |
| Natural | right | female | 590 | 20.67 |
| Natural | right | female | 640 | 18.42 |
| Natural | right | male | 600 | 18.58 |
| Natural | right | female | * | 20.25 |
| Natural | right | female | 500 | 19.08 |
| Natural | right | male | * | 19.75 |
| Natural | right | male | 600 | 20.08 |
| Natural | left | female | 570 | 21 |
| Natural | right | female | 670 | 19 |
| Natural | right | male | 480 | 19.83 |
| Natural | right | male | 660 | 21.67 |
| Natural | right | female | 620 | 20.17 |
| Natural | right | female | 800 | 19.67 |
| Natural | right | male | 550 | 20 |
| Natural | right | male | 600 | 28.25 |
| Natural | right | female | 540 | 19.75 |
| Natural | right | male | 590 | 21.08 |
| Natural | right | male | 500 | 20.17 |
| Natural | left | male | 450 | 22.08 |
| Natural | right | male | 590 | 34.42 |
| Natural | right | female | 660 | 19.08 |
| Natural | right | male | 640 | 21.58 |
| Natural | right | female | 580 | 19.75 |
| Natural | right | male | 590 | 23.5 |
| Natural | right | female | 580 | 19.33 |
| Natural | right | female | 600 | 19.33 |
| Natural | right | female | 520 | 19.58 |
| Natural | right | male | 690 | 19.92 |
| Natural | right | female | 630 | 18.42 |
| Natural | right | female | 550 | 20.17 |
| Natural | left | male | 550 | 18.5 |
| Natural | right | female | 500 | 20.08 |
| Natural | right | female | 580 | 19.25 |
| Natural | right | female | 520 | 18.67 |
| Natural | left | male | 480 | 19.08 |
| Natural | right | male | 540 | 19.67 |
| Natural | right | female | 710 | 17.92 |
| Natural | left | male | 590 | 21.25 |
| Natural | right | female | 560 | 19.33 |
| Natural | right | female | 520 | 19 |
| Natural | right | female | 790 | 19.92 |
| Natural | right | female | 600 | 21.17 |
| Natural | right | male | 540 | 22.83 |
| Social | right | female | 610 | 19.5 |
| Natural | right | female | 500 | 20.83 |
| Natural | left | female | 670 | 20.5 |
| Natural | right | male | 500 | 19.25 |
| Natural | right | male | 550 | 23 |
| Natural | right | female | 610 | 19.33 |
| Natural | right | female | 520 | 19.33 |
| Natural | right | female | 500 | 19.25 |
| Natural | right | female | * | 19.5 |
| Business | right | male | 700 | 25 |
| Social | right | female | 590 | 20.25 |
| Natural | right | male | * | 20 |
| Natural | right | female | * | 20.33 |
| Social | left | female | 590 | 20.75 |
| Social | right | male | 600 | 20.83 |
| Natural | right | female | 690 | 19.5 |
| Natural | right | male | 710 | 18.67 |
| Natural | right | female | 620 | 19.17 |
| Natural | right | female | 600 | 19 |
| Natural | right | female | 620 | 21.92 |
| Natural | right | male | 600 | 18.92 |
| Natural | right | female | 620 | 19.92 |
| Natural | right | male | 560 | 19 |
| Natural | right | female | 620 | 19.33 |
| Natural | right | female | * | 19.42 |
| Natural | right | female | 500 | 23 |
| Social | right | female | 660 | 19.25 |
| Natural | right | male | 500 | 20.42 |
| Natural | right | male | 650 | 20 |
| Social | right | male | 630 | 20.58 |
| Natural | left | female | 630 | 18.5 |
| Natural | right | female | 560 | 20.58 |
| Natural | right | female | 600 | 19.33 |
| Natural | right | male | 700 | 19.58 |
| Natural | right | female | 620 | 20.25 |
| Natural | right | female | 650 | 19.08 |
| Natural | right | female | 580 | 19.25 |
| Natural | right | female | 600 | 19.08 |
| Natural | right | male | 660 | 19 |
| Natural | right | female | 560 | 19.25 |
| Natural | right | female | 710 | 19.58 |
| Natural | right | female | 500 | 19.42 |
| Natural | right | male | 680 | 24.17 |
| Social | right | female | 630 | 18.75 |
| Natural | left | female | 600 | 19.17 |
| Natural | right | male | 740 | 20.83 |
| Natural | right | female | 530 | 20.17 |
| Natural | right | female | 650 | 19.17 |
| Natural | left | female | 560 | 19.58 |
| Social | right | female | 620 | 19.42 |
| Social | right | female | 670 | 19.58 |
| Social | right | female | 650 | 20.75 |
| Social | right | female | 720 | 19.92 |
| Social | right | male | 560 | 21.25 |
| Social | right | female | 560 | 19.83 |
| Social | right | male | 630 | 20.83 |
| Social | right | female | * | 19 |
| Social | right | male | 540 | 19.42 |
| Social | right | female | 460 | 19.67 |
| Social | left | female | * | 19.83 |
| Social | right | female | 500 | 20.67 |
| Social | right | female | 700 | 20.17 |
| Social | left | male | * | 20.75 |
| Social | left | female | 510 | 45.58 |
| Social | right | female | 560 | 18.58 |
| Social | right | female | 680 | 19.5 |
| Social | right | male | 480 | 18.83 |
| Social | right | female | 520 | 19.17 |
| Social | right | female | 720 | 19.42 |
| Social | right | female | 790 | 19.25 |
| Social | right | female | 610 | 20.17 |
| Social | right | female | * | 18.67 |
| Social | right | female | 650 | 22 |
| Social | right | female | 680 | 19.17 |
| Social | right | female | 590 | 20.58 |
| Social | right | female | 590 | 19 |
| Social | right | female | 700 | 19.5 |
| Social | right | male | 550 | 22.17 |
| Social | right | female | 580 | 22.67 |
| Social | right | male | 610 | 19.83 |
| Social | right | female | 580 | 19.25 |
| Social | right | male | 520 | 19.42 |
| Social | right | female | 670 | 19.33 |
| Social | left | female | 535 | 18.08 |
| Social | right | female | 640 | 19.25 |
| Social | right | male | 600 | 19 |
| Social | right | female | 500 | 18 |
| Social | right | female | 620 | 19.25 |
| Social | right | female | * | 19.92 |
| Social | right | male | 580 | 23.08 |
| Social | right | male | 610 | 19.42 |
| Social | right | male | 570 | 19.25 |
| Social | left | female | 570 | 19 |
| Social | right | male | 570 | 19.33 |
| Social | right | female | 610 | 19.58 |
| Social | right | female | 600 | 19.58 |
| Social | right | male | 520 | 19.92 |
| Social | right | male | 580 | 20 |
| Social | right | female | 620 | 19 |
| Social | left | female | 550 | 19.58 |
| Social | right | female | 530 | 19.75 |
| Social | left | female | 660 | 20.83 |
| Social | right | female | 500 | 19.08 |
| Social | right | female | 640 | 23.83 |
| Social | right | female | 510 | 19.33 |
| Social | right | female | 600 | 19.17 |
| Social | right | male | 650 | 19.83 |
| Social | right | male | * | 20.25 |
| Social | right | female | 600 | 19.17 |
| Social | left | male | 470 | 19.92 |
| Social | right | female | 600 | 19.33 |
| Social | left | female | 550 | 21.92 |
| Social | right | female | 610 | 20 |
| Social | right | female | 570 | 19.58 |
| Social | right | female | 560 | 19.08 |
| Social | left | male | 590 | 22.17 |
| Social | left | female | 500 | 20 |
| Social | right | female | 610 | 19.58 |
| Social | right | female | 550 | 19.33 |
| Social | right | female | 550 | 21.75 |
| Social | left | male | 640 | 19.5 |
| Social | right | male | 400 | 19.5 |
| Social | right | female | 580 | 20.67 |
| Social | right | female | 650 | 19.58 |
| Social | right | female | 500 | 20.08 |
| Social | right | female | 620 | 20.83 |
| Natural | right | female | 500 | 19.17 |
| Natural | right | female | 590 | 20.33 |
| Natural | right | female | 600 | 19.83 |
| Natural | left | female | 600 | 20.17 |
| Natural | right | male | * | 19.58 |
| Natural | right | male | 600 | 19.67 |
| Natural | right | male | 600 | 19.67 |
| Natural | right | male | 450 | 19.58 |
| Natural | left | male | 690 | 21.17 |
| Natural | right | male | 470 | 19.58 |
| Natural | left | male | 520 | 21.17 |
| Natural | right | female | 630 | 19.33 |
| Natural | right | male | 620 | 21.17 |
| Natural | right | female | 510 | 19.83 |
| Natural | right | female | 560 | 18.92 |
| Natural | right | female | 600 | 19.25 |
| Natural | right | female | 660 | 18.17 |
| Natural | right | female | 460 | 20.33 |
| Natural | right | male | * | 19.42 |
| Natural | right | male | * | 22.58 |
| Natural | right | female | 510 | 20.33 |
| Natural | right | female | 640 | 20 |
| Natural | right | female | * | 19.17 |
| Natural | right | female | 700 | 19.08 |
| Natural | right | male | 600 | 20.25 |
| Social | right | female | 760 | 21.25 |
| Natural | right | female | 790 | 19.25 |
| Natural | right | female | 670 | 18.92 |
| Natural | right | male | 660 | 21 |
| Natural | right | female | 540 | 18.5 |
| Natural | right | female | 510 | 19.42 |
| Natural | right | female | 570 | 22.33 |
| Natural | left | male | 400 | 19.08 |
| Natural | right | female | 630 | 22.75 |
| Natural | right | female | 750 | 20.5 |
| Natural | right | female | 700 | 19.75 |
| Natural | right | male | 580 | 19.58 |
| Natural | right | male | 600 | 19.92 |
| Natural | right | female | 720 | 22.75 |
| Natural | right | female | 590 | 19.92 |
| Natural | right | male | 540 | 19.25 |
| Natural | right | male | 580 | 19.08 |
| Natural | left | female | * | 21.25 |
| Social | right | female | 520 | 19.17 |
| Natural | right | male | 680 | 20.25 |
| Natural | right | female | 600 | 19.17 |
| Natural | right | male | 780 | 21.75 |
| Natural | right | female | 540 | 23.5 |
| Natural | right | male | 570 | 19.83 |
| Natural | right | male | 680 | 20.25 |
| Natural | right | male | 620 | 20.75 |
| Natural | right | male | 540 | 19.42 |
| Natural | right | male | * | 20.67 |
| Natural | left | male | 580 | 21 |
| Natural | right | female | * | 17.92 |
| Natural | right | male | 650 | 20.42 |
| Natural | left | male | 650 | 19.25 |
| Natural | right | female | 600 | 19.58 |
| Natural | right | male | 750 | 20.42 |
| Natural | right | male | 520 | 20 |
| Natural | right | male | * | 19.42 |
| Natural | right | male | 550 | 21.67 |
| Natural | right | female | 720 | 19.5 |
| Natural | right | female | 630 | 18.83 |
| Natural | right | male | 550 | 21.33 |
| Natural | right | female | * | 19.75 |
| Natural | right | female | 540 | 19.58 |
| Natural | right | male | 690 | 20.08 |
| Natural | right | female | 540 | 18.5 |
| Natural | right | male | 590 | 20.5 |
| Natural | right | male | 510 | 19.75 |
| Natural | right | female | 590 | 19 |
| Natural | right | female | 560 | 19.08 |
| Natural | right | male | 530 | 19.33 |
| Natural | left | male | 550 | 19.33 |
| Natural | right | male | 510 | 19.67 |
| Natural | right | female | 680 | 21.17 |
| Natural | right | female | 600 | 19.08 |
| Natural | right | male | 520 | 22.58 |
| Natural | right | female | 600 | 19.5 |
| Natural | left | male | 540 | 20.67 |
| Business | right | male | 500 | 18.58 |
| Business | right | female | 620 | 17.67 |
| Business | right | male | 560 | 19.75 |
| Social | left | male | 550 | 20.42 |
| Business | right | female | 640 | 20 |
| Business | right | female | 500 | 18.92 |
| Business | right | male | 530 | 20.67 |
| Business | left | male | 500 | 19.08 |
| Business | right | male | 540 | 19.33 |
| Business | right | female | * | 19.42 |
| Business | left | female | 590 | 22.75 |
| Natural | right | male | 580 | 19.83 |
| Business | right | male | 580 | 19 |
| Business | right | female | 580 | 19 |
| Business | right | female | 590 | 18.92 |
| Business | right | female | 680 | 19.25 |
| Business | right | male | 600 | 21.67 |
| Business | right | male | 680 | 21.92 |
| Business | left | male | 420 | 28.42 |
| Social | left | female | 640 | 20.17 |
| Social | right | male | 530 | 22.92 |
| Business | right | male | 600 | 19.5 |
| Business | right | male | 500 | 21.58 |
| Business | right | male | 530 | 19.92 |
| Business | right | male | * | 20.25 |
| Social | right | female | 600 | 40 |
| Business | right | male | * | 19.5 |
| Social | right | female | * | 44 |
| Natural | right | female | 450 | * |
| Business | right | male | 540 | 18.33 |
| Business | right | male | 450 | 19.08 |
| Business | right | male | 700 | 23.42 |
| Business | right | female | * | 19.67 |
| Business | right | female | 490 | 21.67 |
| Social | right | female | 600 | 19.67 |
| Social | right | female | * | 19.33 |
| Social | right | female | 550 | 19 |
| Social | right | female | 730 | 19.58 |
| Social | left | female | 630 | 19.5 |
| Social | right | female | * | 19 |
| Social | right | female | 670 | 19.58 |
| Social | left | female | 580 | 19.5 |
| Social | right | male | 580 | 19.83 |
| Social | right | male | 620 | 19.58 |
| Social | right | female | 580 | 19.67 |
| Social | right | female | 530 | 18.92 |
| Social | left | female | * | 19 |
| Social | right | male | 590 | 20.92 |
| Social | right | male | 340 | 18.92 |
| Social | right | male | 640 | 19.25 |
| Social | right | female | 640 | 19.92 |
| Social | right | female | 740 | 19.58 |
| Social | right | female | 580 | 19.42 |
| Social | right | female | * | 19.67 |
| Social | right | female | 520 | 20.33 |
| Social | right | male | 590 | 20.67 |
| Social | right | female | * | 19.33 |
| Social | right | male | 560 | 22.92 |
| Social | right | female | 560 | 19.75 |
| Social | right | female | 580 | 19.67 |
| Social | right | female | * | 20.5 |
| Social | right | female | 550 | 19.42 |
| Social | right | male | * | 19 |
| Social | right | female | 650 | 19.58 |
| Social | right | female | 600 | 19.17 |
| Social | right | female | 620 | 20.25 |
| Social | right | male | 540 | 21.17 |
| Social | left | male | 600 | 19.83 |
| Social | right | female | * | 19.83 |
| Social | right | female | 620 | 19.17 |
| Social | right | female | * | 20.67 |
| Social | right | female | 590 | 45.33 |
| Social | right | female | 620 | 19.83 |
| Social | left | female | 600 | 22.25 |
| Social | right | female | 470 | 20.92 |
| Social | left | male | 580 | 23.83 |
| Social | right | female | 600 | 19.83 |
| Social | left | female | 590 | 20.42 |
| Social | right | male | 560 | 20.25 |
| Social | right | female | 660 | 20 |
| Social | right | female | 420 | 22 |
| Social | left | female | 630 | 19.92 |
| Social | right | female | 540 | 19.42 |
| Social | right | female | 700 | 20.25 |
| Social | right | male | 690 | 19.58 |
| Business | right | male | 650 | 20.25 |
| Social | right | female | 620 | 24.33 |
| Social | right | male | 670 | 20.92 |
| Social | right | male | 480 | 20.42 |
| Social | right | male | 560 | 18.75 |
| Social | right | female | 550 | 19.83 |
| Social | right | male | * | 22.58 |
| Social | right | female | 730 | 20 |
| Social | left | female | 520 | 28.08 |
| Social | left | female | 520 | 21.83 |
| Social | right | female | * | 19.83 |
| Social | right | female | 510 | 19.42 |
| Social | right | female | 410 | 19.17 |
| Social | right | female | * | 20.83 |
| Social | right | male | * | 21.67 |
| Social | right | male | 530 | 25.42 |
| Social | right | female | * | 20 |
| Social | right | female | 450 | 32.83 |
| Social | right | female | 580 | 20.42 |
| Social | right | male | 650 | 22.92 |
| Social | left | male | 580 | 22.33 |
| Social | right | female | 550 | 19 |
| Social | right | female | 520 | 19.75 |
| Social | right | female | * | 19.92 |
| Social | right | female | 500 | 20.42 |
| Social | right | male | 540 | 20 |
| Social | right | male | 520 | 19.08 |
| Social | right | female | * | 19.92 |
| Social | right | female | 650 | 19.58 |
| Social | right | female | 600 | 19.42 |
| Social | right | female | 650 | 19.75 |
| Social | right | female | 580 | 19.67 |
| Social | right | female | 650 | 19.75 |
| Social | right | male | 670 | 20.92 |
| Social | left | female | 640 | 20.08 |
| Social | right | male | 680 | 24.08 |
| Social | left | female | * | 19.5 |
| Social | right | female | 550 | 21.25 |
| Social | right | female | * | 20.08 |
| Social | right | female | 750 | 19.17 |
| Social | right | male | 580 | 19.42 |
| Social | right | female | 450 | 19.42 |
| Social | right | male | 490 | 20.08 |
| Social | right | female | 540 | 19.08 |
| Social | right | female | 490 | 19.17 |
| Social | right | female | * | 18.5 |
| Social | right | male | * | 37.42 |
| Social | right | female | 640 | 20.08 |
| Social | right | female | * | 20.92 |
| Social | right | female | 540 | 21.5 |
| Social | right | female | * | 20.83 |
| Social | right | female | * | 25.25 |
| Social | right | female | 500 | 19.25 |
| Social | right | female | 530 | 24.42 |
| Social | right | female | 550 | 18.33 |
| Social | left | female | 610 | 20 |
| Social | right | male | 510 | 25 |
| Social | right | female | 600 | 20.75 |
| Social | right | female | 690 | 18.67 |
| Social | right | female | 550 | 18.33 |
| Social | right | female | * | 19.75 |
| Social | left | male | * | 24.08 |
| Social | right | female | 480 | 29.58 |
| Social | right | male | 590 | 22 |
| Social | right | female | 580 | 19.33 |
| Social | left | male | 650 | 21.33 |
| Social | left | female | 600 | 19.33 |
| Social | right | female | 500 | 18.42 |
| Social | left | female | 520 | 20.5 |
| Social | right | female | 600 | 18.75 |
| Social | right | male | 560 | 19.58 |
| Social | right | female | 520 | 26.17 |
| Social | right | female | 500 | 18.83 |
| Social | right | female | 620 | 21.08 |
| Social | right | female | 460 | 19.33 |
| Social | right | male | 410 | 19.75 |
| Social | right | male | 500 | 20.42 |
| Social | left | female | 520 | 21.75 |
| Social | right | female | * | 18.67 |
| Social | right | male | 510 | 19.5 |
| Social | left | male | 530 | 22 |
| Social | right | female | 510 | 19.67 |
| Social | right | male | 550 | 19.58 |
| Social | right | female | 640 | 19.42 |
| Social | right | female | 510 | 20 |
| Social | right | male | 490 | 19.75 |
| Social | right | male | 630 | 21.58 |
| Social | right | female | * | 21.75 |
| Social | right | male | 530 | 23.58 |
| Social | right | male | 600 | 20.58 |
| Social | right | female | * | 18.83 |
| Social | right | female | 600 | 19 |
| Social | left | male | 650 | 19.25 |
| Social | right | male | * | 24.83 |
| Social | right | female | * | 18.92 |
| Social | right | female | 680 | 19 |
| Social | right | female | 600 | 20.5 |
| Social | left | female | * | 19.92 |
| Social | right | female | * | 19.92 |
| Social | right | female | 700 | 22.83 |
| Social | right | female | 540 | 23.25 |
| Social | left | female | 550 | 19.42 |
| Social | right | female | 600 | 20.17 |
| Social | left | female | 600 | 18.75 |
| Social | right | female | * | 21.08 |
| Social | right | female | 440 | 20.67 |
| Social | right | female | * | 20.83 |
| Social | left | male | 540 | 25.83 |
| Social | left | male | 530 | 18.58 |
| Social | right | female | 600 | 20.5 |
| Social | left | female | 550 | 19.67 |
| Social | left | male | 550 | 22 |
| Social | right | female | 600 | 19.25 |
| Social | right | female | 590 | 19.25 |
| Social | right | female | 530 | 18.25 |
| Social | left | male | 675 | 20.42 |
| Social | right | female | 650 | 19.25 |
| Social | right | male | * | 18.83 |
| Social | right | female | * | 31.08 |
| Social | right | male | 520 | 20.58 |
| Social | right | male | * | 20.08 |
| Social | right | female | 540 | 22.67 |
| Social | right | female | 620 | 19.5 |
| Social | right | female | * | 20 |
| Social | right | female | 590 | 20.67 |
| Social | right | male | 600 | 19.67 |
| Social | right | male | 520 | 20 |
| Social | right | female | 440 | 20.33 |
| Social | right | female | 520 | 19.75 |
| Social | left | female | 610 | 19.17 |
| Social | right | female | 420 | 18.75 |
| Social | right | male | 530 | 19.83 |
| Social | right | female | 680 | 19.33 |
| Natural | right | male | 710 | 24.17 |
| Social | left | male | 630 | 19.08 |
| Social | left | female | 690 | 19.42 |
| Social | left | female | 420 | 20.17 |
| Social | left | female | 460 | 20.58 |
| Social | right | female | 680 | 21 |
| Social | right | female | 750 | 21.33 |
| Social | right | male | 550 | 18.58 |
| Social | right | female | * | 20.08 |
| Social | right | female | 630 | 22.08 |
| Natural | right | female | * | 19.92 |
| Natural | left | male | 560 | * |
| Natural | right | male | * | 20.25 |
| Natural | right | female | 670 | 22.83 |
| Natural | left | female | 700 | 21 |
| Natural | right | female | 350 | 24.92 |
| Natural | right | male | 500 | 21.33 |
| Natural | left | male | 650 | 19.83 |
| Natural | right | male | 595 | 20 |
| Social | left | female | 650 | 21.08 |
| Natural | left | male | 570 | 19.92 |
| Natural | left | male | * | 18.33 |
| Natural | right | female | 610 | 20.25 |
| Natural | right | male | 630 | 21.25 |
| Natural | right | female | 800 | 19.33 |
| Natural | right | male | 650 | 19.58 |
| Natural | right | male | * | 18.5 |
| Natural | left | male | 640 | 19.75 |
| Natural | right | female | 700 | 20.08 |
| Natural | right | male | 600 | 18.92 |
| Natural | right | female | 625 | 19.5 |
| Natural | right | female | 550 | 19.42 |
| Natural | right | male | 620 | 19.5 |
| Natural | right | male | 650 | 21.58 |
| Natural | right | female | 540 | 19.67 |
| Natural | right | female | 600 | 19.25 |
| Natural | right | female | 690 | 18.25 |
| Natural | right | female | 680 | 18.25 |
| Natural | left | female | 535 | 20.75 |
| Natural | right | male | 490 | 21.42 |
| Natural | right | female | 670 | 19.75 |
| Natural | left | female | 560 | 18 |
| Natural | right | male | 600 | 19.25 |
| Natural | right | male | 530 | 21.17 |
| Natural | right | female | 643 | 18.5 |
| Natural | left | female | 540 | 19.92 |
| Natural | right | female | 600 | 20.08 |
| Natural | right | male | 720 | 21.42 |
| Natural | right | female | 620 | 19.08 |
| Natural | right | male | 650 | 18.58 |
| Natural | right | female | 610 | 18.33 |
| Natural | right | female | 630 | 20.17 |
| Natural | left | male | 650 | 18.42 |
| Natural | right | female | * | 18.92 |
| Natural | right | female | 670 | 20.25 |
| Natural | right | male | 740 | 23.92 |
| Natural | right | male | 630 | 19.83 |
| Natural | right | female | 690 | 20.08 |
| Natural | right | female | 700 | 20 |
| Natural | right | female | 670 | 23.17 |
| Natural | right | female | 540 | 19.42 |
| Natural | right | female | 440 | 19.67 |
| Natural | right | female | 720 | 24.75 |
| Natural | right | female | * | 22.08 |
| Natural | right | male | 420 | 26.25 |
| Natural | right | female | 630 | 18.67 |
| Natural | right | male | 600 | 19.25 |
| Natural | right | female | 600 | 19 |
| Natural | right | female | 600 | 19.33 |
| Natural | right | female | 600 | 19.92 |
| Natural | right | female | 450 | 34.08 |
| Social | left | male | 500 | 21.58 |
| Social | left | female | 550 | 20.83 |
| Business | right | female | 610 | 18.58 |
| Business | left | female | 590 | 18.75 |
| Business | right | male | 480 | 18.17 |
| Business | right | female | 620 | 18.75 |
| Business | right | female | 720 | 20.08 |
| Business | right | female | 690 | 20.67 |
| Business | left | male | 530 | 19.08 |
| Business | right | female | 500 | 20.25 |
| Business | right | female | 550 | 19.17 |
| Business | right | female | 580 | 20.92 |
| Business | right | female | 640 | 19.42 |
| Business | right | male | 580 | 18.92 |
| Business | left | male | 540 | 22.58 |
| Business | right | male | 560 | 18.67 |
| Business | left | female | 460 | 19.67 |
| Business | right | female | 400 | 18.17 |
| Business | right | female | 530 | 18.75 |
| Business | right | male | * | 20.17 |
| Business | right | female | 510 | 29 |
| Business | right | male | 500 | 20.25 |
| Business | right | female | 620 | 19 |
| Business | right | female | 560 | 19.17 |
| Business | right | female | 580 | 18.83 |
| Business | right | female | * | 19.5 |
| Business | right | female | 490 | 22.25 |
| Business | right | male | 600 | 19.5 |
| Business | right | male | 450 | 20.25 |
| Business | right | male | 580 | 19.08 |
| Business | right | female | 570 | 18.67 |
| Business | left | female | 650 | 19.08 |
| Business | right | female | 660 | 18.67 |
| Business | right | male | 390 | 18.42 |
| Business | right | male | 470 | 18.83 |
| Business | left | female | 500 | 19.75 |
| Business | right | male | 520 | 18.83 |
| Business | right | male | 500 | 19.58 |
| Business | right | male | 495 | 18.83 |
| Business | right | female | 540 | 19.17 |
| Business | right | female | 650 | 19.92 |
| Business | right | female | 680 | 18.58 |
| Business | right | female | 620 | 19.25 |
| Business | right | male | 560 | 18.58 |
| Business | right | male | * | 18.33 |
| Business | right | male | 600 | 22.92 |
| Business | right | female | 610 | 18.58 |
| Business | right | female | 500 | 18.33 |
| Business | left | male | 580 | 20.5 |
| Business | right | female | 510 | 18.42 |
| Business | right | female | * | 18.5 |
| Business | right | male | 500 | 20.17 |
| Business | right | male | 590 | 19.42 |
| Business | right | female | 530 | 18.25 |
| Business | right | female | 650 | 19.17 |
| Business | right | female | 670 | 20.08 |
| Business | left | male | 450 | 21.58 |
| Business | right | female | * | 18.75 |
| Business | left | male | 690 | 20 |
| Business | right | female | 440 | 18.83 |
| Business | right | male | 560 | 20.42 |
| Business | right | female | 580 | 19.67 |
| Social | left | male | 630 | 20.58 |
| Business | right | male | 640 | 74.17 |
| Business | right | female | 690 | 20.83 |
| Business | right | female | 690 | 19.67 |
| Business | right | male | 550 | 19.5 |
| Business | right | female | 590 | 19.33 |
| Business | right | male | 600 | 20.25 |
| Business | right | male | 620 | 20.5 |
| Business | right | male | 590 | 19.5 |
| Business | right | male | 530 | 18 |
| Business | right | female | 660 | 19.42 |
| Business | right | female | 550 | 18.25 |
| Business | right | female | 640 | 20.83 |
| Business | right | male | * | 18.75 |
| Business | right | male | * | 18.67 |
| Business | right | female | 660 | 20.92 |
| Business | right | female | 500 | 18.5 |
| Business | right | male | 590 | 20.17 |
| Business | right | male | 650 | 18.17 |
| Business | right | female | 625 | 19.33 |
| Social | right | male | 640 | 23.75 |
| Social | right | female | 550 | 22.58 |
| Social | left | female | 480 | 21.5 |
| Social | right | female | 640 | 21.5 |
| Social | right | female | 480 | 20.5 |
| Business | right | female | 600 | 18.33 |
| Social | right | male | 570 | 18.67 |
| Social | right | female | 600 | 18.58 |
| Business | right | male | 620 | 22 |
| Business | right | female | 630 | 20.25 |
| Business | left | male | 760 | 23 |
| Social | right | male | 470 | 18.75 |
| Business | right | male | 580 | 18.83 |
| Business | right | female | 590 | 19.42 |
| Social | right | male | 540 | 18.08 |
| Business | right | male | 610 | 19.33 |
| Business | right | male | 540 | 20.25 |
| Business | right | female | 620 | 19.42 |
| Business | right | male | 600 | 19.83 |
| Business | left | female | * | 20.08 |
| Business | right | female | 550 | 50.83 |
| Business | right | female | 510 | 20.5 |
| Business | right | female | 680 | 19.08 |
| Business | right | male | 620 | 19.17 |
| Business | right | female | 540 | 18.67 |
| Business | right | female | 670 | 18.33 |
| Business | right | female | 650 | 18.67 |
| Business | right | male | 550 | 19.08 |
| Business | right | male | 620 | 19.67 |
| Business | right | female | 630 | 19.5 |
| Business | right | male | 620 | 19.42 |
| Business | right | male | 660 | 19.33 |
| Business | right | female | 590 | 18.75 |
| Business | right | female | 340 | 19.75 |
| Business | right | female | 560 | 20.33 |
| Business | right | male | 540 | 18.92 |
| Business | right | male | * | 20.17 |
| Business | right | male | 580 | 20.92 |
| Business | right | male | 430 | 18.92 |
| Business | right | female | 550 | 19.33 |
| Business | right | female | 530 | 19.92 |
| Business | right | female | 620 | 19.67 |
| Business | right | female | 600 | 18.58 |
| Business | right | female | * | 18.67 |
| Business | right | male | 640 | 21.5 |
| Business | right | female | 560 | 20.33 |
| Business | right | male | 570 | 19.58 |
| Business | left | female | 680 | 18.42 |
| Business | right | female | 490 | 18.67 |
| Business | right | female | 640 | 19.58 |
| Business | right | female | 620 | 21.33 |
| Business | right | female | 410 | 18.75 |
| Business | right | male | 560 | 23.17 |
| Business | right | male | 620 | 19.58 |
| Business | right | female | 560 | 20.5 |
| Business | right | female | 630 | 18.75 |
| Business | right | female | 540 | 18.67 |
| Business | right | female | 520 | 19.92 |
| Business | right | male | 730 | 21.58 |
| Business | right | male | 570 | 19.5 |
| Business | right | female | 530 | 18.17 |
| Business | right | female | 550 | 19.08 |
| Business | right | male | 670 | 21.08 |
| Business | right | female | 570 | 20.25 |
| Business | right | female | 520 | 19.92 |
| Business | left | female | * | 20.42 |
| Business | right | male | 500 | 26.42 |
| Business | right | male | * | 20.08 |
| Business | right | female | 580 | 19.75 |
| Business | right | male | 425 | 20.58 |
| Business | right | female | 680 | 21.5 |
| Business | right | female | 650 | 19 |
| Business | right | male | * | 19.25 |
| Business | right | female | 560 | 19.25 |
| Social | right | male | 580 | 20.42 |
| Social | right | female | 530 | 19.33 |
| Social | right | female | * | 19.67 |
| Social | right | male | 500 | 19.58 |
| Social | right | female | 430 | 19.5 |
| Business | right | male | 670 | 20.67 |
| Business | right | female | 550 | 21.17 |
| Business | right | male | 570 | 19.67 |
| Natural | right | female | 555 | 19.83 |
| Natural | right | female | 600 | 22 |
| Natural | right | female | 520 | 21.83 |
| Natural | right | female | * | 22.25 |
Sheet2
Sheet3
Week 6_instruction.doc
Homework Week 6
You will be submitting a Word file and an Excel file this week.
Part 1
(worth 60 points)
|
|
|
|
1a. imagine a spinner that also has 3 colors - - Red, White, Green - - but all the colors are the same size. Someone spins the pointer 2 times. List all the possible outcomes of this random experiment. [Use the letters R, W, G.] 1b. What is another name for the list you just made?
|
|
|
2. What is the probability that the color red will come up exactly once in the two spins?
|
|
|
3. What is the probability that red will come up on both spins?
|
|
|
4. There are 10 males and 12 females in a statistics class. If one student is chosen at random, what is the probability that the student is a female?
|
|
|
5. What is the probability of rolling a pair of dice and getting one (only one) 6? Explain how you arrived at your answer. [Hint: The table on p. 184 in your text could be helpful.]
|
|
|
6. Last week we had the following homework question: In New York State there is a fairly strong positive correlation between principals’ salaries and the reading scores of their students. (This is true.) Upon learning this, a politician recommends that principals’ salaries be increased because this will cause students’ reading scores to increase. Good idea? The answer of course was that it was not a good idea at all since association does not imply causation. Suggest a lurking variable that could reasonably account for the association between students’ reading scores and principals’ salaries. [Hint: The lurking variable must be plausibly related to both principals’ salaries and reading scores.] |
|
Part 2
(worth 40 points)
The point of the Learn by Doing activity on the bottom of OLI p. 67 is to teach you about sampling and to demonstrate how you can select a random sample using Excel. The activity contains three text boxes with open-ended questions.
Submit one Excel file that includes the work necessary to answer the three open-ended questions. Put your answers to the three open-ended questions on the first worksheet which you name Answers. Choose appropriate names for the additional worksheets showing the work you did to arrive at the answers including your random samples.