Question: I am having a big issue trying to figure out how to complete this question. I have search for instruction but haven't found anything that
I am having a big issue trying to figure out how to complete this question. I have search for instruction but haven't found anything that helps. Can you please help me?
Create a pivot tables using the data provided to answer the following questions. Based on the information provided in the pivot table create a frequency table for gender and hand.
| ID | Hand | Gender | Height |
| 1 | Right | M | 73 |
| 2 | Right | F | 65 |
| 3 | Right | F | 64 |
| 4 | Right | M | 71 |
| 5 | Left | M | 74 |
| 6 | Right | F | 68 |
| 7 | Right | M | 70 |
| 8 | Left | F | 65 |
| 9 | Right | M | 68 |
| 10 | Right | F | 70 |
| 11 | Right | F | 63 |
| 12 | Right | F | 65 |
| 13 | Left | M | 71 |
| 14 | Right | F | 64 |
| 15 | Right | F | 67 |
| 16 | Right | M | 71 |
| 17 | Left | M | 70 |
| 18 | Right | M | 69 |
| 19 | Right | M | 54 |
| 20 | Left | F | 65 |
| 21 | Right | M | 89 |
| 22 | Right | F | 72 |
| 23 | Right | F | 32 |
| 24 | Right | F | 65 |
| 25 | Left | M | 65 |
| 26 | Right | F | 74 |
| 27 | Right | F | 68 |
| 28 | Left | M | 70 |
| 29 | Right | F | 65 |
| 30 | Right | F | 68 |
| 31 | Right | M | 70 |
| 32 | Right | M | 64 |
12. The number of left handers
13. The percent of females
14. The percent of males that are right-handed.
15. The average height of the study participants
16. The average height of females
17. What is the probability that a participant is left-handed?
18. What is the probability that a study participant was female and right-handed?
19. Given a participant is left-handed what is the probability they are male?
20. Given a participant is a male, what is the probability that study participants are left-handed?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
