In: Statistics and Probability
a survey was conducted on sky divers attitudes toward the practise example activities. They were asked to state the extent to which they found the example activities helpful for their learning in sky diving on a 7 point scale (1 = strongly disagree; 4 = neutral; 7 = strongly agree). Gender and Lecture Attendance in sky diving were also recorded. A random sample of 60 students was selected Rating_catwas created to re-group the simulation ratings into three categories: Disagree (1, 2 & 3), Neutral (4), Agree (5, 6 & 7).
Using the Pivot Tablein Excel cross tabulate Lecture Attendanceand Rating_cat.
What is the probability that a randomly selected respondent agrees the simulation activities were helpful for their learning?
Student ID | Gender | Lecture Attendance | Simulation_Rating | Rating_cat |
1 | M | 10 or more | 6 | Agree |
2 | M | 3 or less | 3 | Disagree |
3 | F | 10 or more | 5 | Agree |
4 | M | 10 or more | 7 | Agree |
5 | F | 10 or more | 4 | Neutral |
6 | F | 10 or more | 4 | Neutral |
7 | F | 10 or more | 2 | Disagree |
8 | M | 10 or more | 4 | Neutral |
9 | F | 10 or more | 5 | Agree |
10 | M | 7 to 9 | 7 | Agree |
11 | F | 10 or more | 4 | Neutral |
12 | F | 10 or more | 7 | Agree |
13 | F | 10 or more | 4 | Neutral |
14 | M | 4 to 6 | 5 | Agree |
15 | M | 10 or more | 4 | Neutral |
16 | M | 10 or more | 3 | Disagree |
17 | M | 10 or more | 5 | Agree |
18 | M | 7 to 9 | 6 | Agree |
19 | M | 10 or more | 6 | Agree |
20 | F | 10 or more | 5 | Agree |
21 | M | 10 or more | 6 | Agree |
22 | F | 10 or more | 3 | Disagree |
23 | F | 10 or more | 7 | Agree |
24 | F | 10 or more | 5 | Agree |
25 | F | 10 or more | 5 | Agree |
26 | F | 4 to 6 | 3 | Disagree |
27 | M | 7 to 9 | 4 | Neutral |
28 | F | 7 to 9 | 6 | Agree |
29 | M | 10 or more | 5 | Agree |
30 | F | 10 or more | 5 | Agree |
31 | M | 7 to 9 | 5 | Agree |
32 | F | 3 or less | 4 | Neutral |
33 | F | 10 or more | 3 | Disagree |
34 | M | 10 or more | 5 | Agree |
35 | M | 4 to 6 | 5 | Agree |
36 | M | 3 or less | 1 | Disagree |
37 | M | 7 to 9 | 4 | Neutral |
38 | M | 7 to 9 | 5 | Agree |
39 | M | 10 or more | 5 | Agree |
40 | F | 7 to 9 | 4 | Neutral |
41 | F | 10 or more | 3 | Disagree |
42 | F | 3 or less | 1 | Disagree |
43 | F | 10 or more | 4 | Neutral |
44 | M | 10 or more | 7 | Agree |
45 | M | 10 or more | 6 | Agree |
46 | F | 10 or more | 4 | Neutral |
47 | F | 10 or more | 4 | Neutral |
48 | M | 10 or more | 3 | Disagree |
49 | F | 10 or more | 5 | Agree |
50 | M | 10 or more | 1 | Disagree |
51 | F | 3 or less | 3 | Disagree |
52 | F | 4 to 6 | 6 | Agree |
53 | M | 4 to 6 | 4 | Neutral |
54 | F | 10 or more | 2 | Disagree |
55 | F | 10 or more | 4 | Neutral |
56 | F | 7 to 9 | 6 | Agree |
57 | F | 7 to 9 | 1 | Disagree |
58 | M | 10 or more | 5 | Agree |
59 | M | 10 or more | 6 | Agree |
60 | F | 4 to 6 | 6 | Agree |