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 student who attended 3 or fewer lecturesdisagrees 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 |
Part 1:
Part 2:
There are no conditions for which the respondent agrees and the lecture attendance is 3 or less.
So, Probability = 0/60 = 0.
End of the Solution...
Count of Grade Column Labels Row Labels Agree 10 or more 21 Grand Total 31 3 or less 4 to 6 7 to 9 4 6 Disagree 8 4 14 Neutral 10 15 Grand Total 39 10 60
Get Answers For Free
Most questions answered within 1 hours.