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.
Would you say respondents’ Lecture attendanceand Attitudetowards simulations activitiesare dependent or independent? Explain briefly.
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:
No, Lecture Attendance and Attitude Towards Simulation Activities are not dependent on each other.
This is because, the correlation between the two variables is 0.252 which is much smaller than 1. If the value is close to 1 or more than 0.75, it means that there is a strong relationship between the variables but in this case, there is a weak relationship between the variables as the value is 0.252 (much smaller than 1)...
End of the Solution...
Get Answers For Free
Most questions answered within 1 hours.