Homework Sourse1 Conduct the appropriate statistical test that will answer
1. Conduct the appropriate statistical test that will answer your hypothesis. It must be a statistical test covered in this course such as regression analysis, single t-test, independent t-test, cross-tabulations, Chi-square, or One-Way ANOVA. Explain your justification for using the test based on the type of data and the level of measurement that the data lends to for the statistical analysis. Please use excel when solving this problem.
2. Report and interpret your findings.
The hypotheses to be tested in this study are.
Null Hypothesis: There is no significant difference in fatigue symptoms of U.S. Navy carrier air wing pilots who exercise 60 minutes 5 times a week, then U.S. Navy carrier air wing pilots who do not exercise while deployed on the aircraft carrier.
Alternative Hypothesis: U.S. Navy carrier pilots who exercise 60 minutes 5 times a week shows fewer symptoms of fatigue then U.S. Navy carrier air wing pilots who do not exercise while deployed on the aircraft carrier.
pilots
1
2
3
1
5
60
Y
2
5
60
Y
3
6
30
Y
4
5
60
Y
5
4
20
N
6
5
60
Y
7
3
40
Y
8
3
50
Y
9
2
40
N
10
4
40
Y
11
5
60
Y
12
5
60
Y
13
4
20
N
14
3
40
Y
15
6
30
Y
16
5
60
Y
17
5
60
Y
18
4
30
N
19
7
20
N
20
3
50
N
21
2
10
Y
22
5
60
Y
23
5
60
Y
24
3
30
N
25
4
30
N
26
5
60
Y
27
5
60
Y
28
4
30
N
29
5
60
Y
30
5
60
Y
31
3
20
Y
32
6
10
Y
33
2
30
N
34
2
40
Y
35
4
50
Y
36
5
60
Y
37
0
0
N
38
0
0
N
39
0
0
N
40
3
20
N
41
5
60
Y
42
4
60
Y
43
5
60
Y
44
2
10
N
45
5
60
Y
46
3
20
N
47
4
30
N
48
5
40
Y
49
5
60
Y
50
1
15
N
I don\'t know which statistical test to use to answer the hypothesis. Please help. I\'m stuck.
| pilots | 1 | 2 | 3 |
| 1 | 5 | 60 | Y |
| 2 | 5 | 60 | Y |
| 3 | 6 | 30 | Y |
| 4 | 5 | 60 | Y |
| 5 | 4 | 20 | N |
| 6 | 5 | 60 | Y |
| 7 | 3 | 40 | Y |
| 8 | 3 | 50 | Y |
| 9 | 2 | 40 | N |
| 10 | 4 | 40 | Y |
| 11 | 5 | 60 | Y |
| 12 | 5 | 60 | Y |
| 13 | 4 | 20 | N |
| 14 | 3 | 40 | Y |
| 15 | 6 | 30 | Y |
| 16 | 5 | 60 | Y |
| 17 | 5 | 60 | Y |
| 18 | 4 | 30 | N |
| 19 | 7 | 20 | N |
| 20 | 3 | 50 | N |
| 21 | 2 | 10 | Y |
| 22 | 5 | 60 | Y |
| 23 | 5 | 60 | Y |
| 24 | 3 | 30 | N |
| 25 | 4 | 30 | N |
| 26 | 5 | 60 | Y |
| 27 | 5 | 60 | Y |
| 28 | 4 | 30 | N |
| 29 | 5 | 60 | Y |
| 30 | 5 | 60 | Y |
| 31 | 3 | 20 | Y |
| 32 | 6 | 10 | Y |
| 33 | 2 | 30 | N |
| 34 | 2 | 40 | Y |
| 35 | 4 | 50 | Y |
| 36 | 5 | 60 | Y |
| 37 | 0 | 0 | N |
| 38 | 0 | 0 | N |
| 39 | 0 | 0 | N |
| 40 | 3 | 20 | N |
| 41 | 5 | 60 | Y |
| 42 | 4 | 60 | Y |
| 43 | 5 | 60 | Y |
| 44 | 2 | 10 | N |
| 45 | 5 | 60 | Y |
| 46 | 3 | 20 | N |
| 47 | 4 | 30 | N |
| 48 | 5 | 40 | Y |
| 49 | 5 | 60 | Y |
| 50 | 1 | 15 | N |
Solution
