Question
a survey was conducted on sky divers attitudes toward the practise example activities. They were asked...
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.
Use the Pivot Tableto find out the average simulation ratingsfor male and female students at each of the four levels of lecture attendance.
| 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 |
Homework Answers
Answer #1
Part 1:
Part 2:
The solution with mean ratings are provided below:
End of the Solution...
Not the answer you're looking for?
Similar Questions
a survey was conducted on sky divers attitudes toward the practise example activities. They were asked...
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,...
a survey was conducted on sky divers attitudes toward the practise example activities. They were asked...
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,...
The table below shows a set of bivariate data: X and Y. Calculate the covariance and...
The table below shows a set of bivariate data: X and Y.
Calculate the covariance and correlation coefficients by
completing the below table, assuming sample data. Show all
workings. (Note: You can calculate the mean and standard deviation
of X & Y with Excel or your calculator; no working for their
calculation is required.)
X
Y
(X - X bar)
(Y - Y bar)
(X - X bar)(Y - Y bar)
5
5
-0.2
-0.6
0.12
2
3
-3.2
-2.6...
A random sample of 12 college students were surveyed on their social activities. Students were asked...
A random sample of 12 college students were surveyed on their
social activities. Students were asked to state how many times
during the previous year they had gone to the movies or sporting
events.
Student
1
2
3
4
5
6
7
8
9
10
11
12
Movies
12
2
13
17
14
9
24
6
26
22
10
16
Sports
7
4
13
4
9
15
18
4
11
9
5
2
Difference (movies – sports)
Once you have...
1. Consider a survey in which customers’ perceptions of the service at a local store are...
1. Consider a survey in which customers’ perceptions of the
service at a local store are gathered using a Likert Scale. Using
this survey the customer gives a score of 1, 2, 3, 4 or 5 in
response to a statement about the service.
The scores represent
1 – Strongly Disagree
2 – Disagree
3 – Unsure
4 – Agree
5 – Strongly agree
For example, one of the statements might be “The staff member
appears knowledgeable regarding the store’s...
Given below are the durations of and the precedence relationships among the activities required to compute...
Given below are the durations of and the precedence
relationships among the activities required to compute a
project.
1) construct an AOA network of the project
2)what is the critical path? determine the expected duration of
the project.
3)compute the standard deviation of the critical path
Duration(days)
Activity
pre-decessor(s)
a
m
b
A
-
4
7
12
B
A
6
9
13
C
A
5
7
9
D
B,C
3
5
8
E
B
7
8
10
F
A
2...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel...
Bivariate Data & Probability
After completing the calculation by hand in Q1 you can use
Excel to check your answers before submitting. Q2 assesses your
general understanding of probability and linear associations using
Excel to analyse a large dataset.
Question 1
Covariance and Correlation
The table below shows a set of sample bivariate data. Calculate
the covariance and correlation coefficient by completing the below
table. Show all working.
X
Y
(X - )
(Y - )
(X - )(Y -...
Use the following activities and their three duration estimates (in days) to do the following Determine...
Use the following activities and their three duration estimates
(in days) to do the following
Determine the expected duration of the project – use 2 decimals
when determining the duratio
Path
Activity
Optimistic
Most Likely
Pessimistic
a-b-c
A
4
5
6
B
7
8
10
C
3
5
9
d-e-f
D
7
8
11
E
2
3
4
f
1
4
6
3. It is well known that similarity in attitudes, beliefs, and interests plays an important role...
3. It is well known that similarity in attitudes, beliefs, and
interests plays an important role in interpersonal attraction.
Suppose a research developed a questionnaire that measures how
liberal or conservative one’s attitudes are. Low scores means the
person is more liberal, high scores indicate conservative
attitudes. Below is hypothetical data from married couples.
Couple
Wife
Husband
A
11
14
B
6
7
C
16
15
D
4
7
E
1
3
F
10
9
G
3
6
H
5...
Kuya conducted a taste-test study of tofu. He gathered 20 of his friends and took them...
Kuya conducted a taste-test study of tofu. He gathered 20 of his
friends and took them to various tofu dinners on three Sundays.
Firstly, a Chinese tofu dinner. He then asked his friends to rate
how much they enjoyed the tofu (from 1 to 10 with 1 = hate it, and
10 = love it). The following Sunday, they went for a Thai tofu
dinner and collected their ratings. On the third Sunday, he took
these (lucky?) friends to a...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 27 minutes ago
asked 33 minutes ago
asked 43 minutes ago
asked 47 minutes ago
asked 53 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago