Need help with my Statistics

profileWolverineX
fitnessstrength.xlsx
Home>Mathematics homework help>Need help with my Statistics

Sheet4

Variables Description
Physical Strength Measures
Two measures of strength were gathered from each participant.
These included grasp strength and arm strength.
To increase the accuracy of the measure, participants were asked to perform each test twice.
The two scores were then averaged together for each of the two strength measures (grasp and arm).
 Job Performance measures
Two separate measures of job performance are presented in this case study.
First, the supervisors for each of the 150 study participants were asked to rate
using a 60-point scale.
Higher numbers indicate better performance on the physically demanding aspects of the job.
Second, two work simulations were standardized and summed together to form one single measure.
Larger scores indicate better performance on the work simulations.
Gender 2 male, 1 female

Sheet1

Age Weights & Exercise Club Staff Satisfaction Exercise Programs Satisfaction Overall Service Satisfaction Years With the Club Gender Strength Grasp Strength Arm Performance RATE Performance Simulation SIMS
26 4 4 3 4 4 1 105.5 80.5 31.8 1.18
24 1 4 5 3 1 1 106.5 93 39.8 0.94
33 4 5 1 3 3 1 94 81 46.8 0.84
45 3 4 1 3 2 1 90.5 33.5 52.2 -2.45
38 4 4 2 3 3 2 104 47.5 31.2 1
36 3 4 3 3 3.5 2 171 125.5 46.6 4.38
23 5 4 4 4 5 1 107.5 81.5 29.8 -0.38
25 3 2 3 3 1 2 124.5 83.5 39 -0.01
28 5 5 3 4 2 2 87 65 50.6 -0.99
24 2 3 5 3 1.5 1 102.5 77.5 40.1 -0.04
39 3 4 3 3 3.5 2 119 54.5 29.6 -1.15
18 3 5 2 3 6 2 54 68.5 52.6 0.19
47 4 5 2 4 1.5 2 119 101 51.8 0.58
37 3 4 5 4 3 2 88.5 109.5 35 1.2
46 3 5 1 3 1 2 157.5 103.5 45.8 1.22
33 4 4 3 4 3 1 110 79.5 32.4 -0.15
39 3 5 3 4 4 1 92.5 85 38.15 1.26
33 5 5 4 5 1.5 2 99.5 91.5 29 0.92
34 4 4 4 4 1 2 109 63.5 42 -0.09
29 5 4 1 3 0 2 114 94 51 -0.67
35 4 5 2 4 2.5 2 92 96.5 38.6 -1.17
37 3 4 1 3 3.5 1 138 84.5 49 1.84
40 2 4 2 3 4 2 91.5 64 28 -0.62
36 3 3 3 3 5.5 2 189 122 49.266 4.87
44 4 5 1 3 3 2 115 101.5 45.6 0.77
50 5 4 2 4 5 2 121 84 52.6 2.97
26 1 1 3 2 2 2 128.5 93.5 46.4 3.16
31 4 4 3 4 1.5 2 128 84 46 0.27
56 3 4 3 3 3 1 82 39 31.3 -3.88
35 4 2 4 3 4 2 128.5 88 57 0.91
39 3 4 3 3 1.5 1 118 70.5 26.4 0.91
33 4 4 3 4 5 1 104.5 69.5 38.2 -0.94
36 3 1 3 2 2 1 122.5 66.5 30.2 -2.17
42 3 3 1 2 4.5 2 88 25 33.8 -2.05
35 5 3 3 4 2 2 105 63.5 26.8 -1.3
31 4 5 2 4 2 2 127 104.5 41.6 0.26
22 2 4 3 3 2.5 1 120.5 86 32.4 0.13
23 3 5 3 4 0 1 103 85.5 53.8 0.71
34 3 5 3 4 3 2 115.5 36 47.2 -1.08
25 4 4 3 4 2 2 78 69.5 32.4 -1.67
27 4 4 2 3 5 2 94.5 88.5 45.6 0.72
50 3 4 3 3 1 2 99 62 36.334 -0.61
48 4 4 5 4 2.5 2 115 96.5 54.2 -1.11
21 5 4 2 4 1.5 1 122 90.5 39.8 0.16
26 4 2 3 3 1 2 91.5 71 42.5 -0.79
49 4 5 3 4 4 2 117.5 61.5 44 0.5
21 2 4 2 3 3 2 99 80 52.4 0.49
41 3 5 3 4 1 2 121.5 106.5 42 2.3
45 4 4 2 3 4.5 1 99.5 44 41.3 -2.34
30 4 5 3 4 6.5 2 89 77 38.8 0.51
21 4 4 3 4 0 1 92.5 85 45 -0.42
39 5 4 4 4 5.5 1 124.5 106 42.8 0.79
47 3 4 3 3 4.5 2 130.5 104.5 31.4 1.83
38 5 5 1 4 2.5 2 103 52.5 38.4 -0.8
21 3 5 4 4 6 2 103 89.5 37.4 -1.21
34 5 2 2 3 3.5 1 153 132 42 5.17
55 3 5 4 4 2 2 111.5 95 50.8 0.8
41 4 4 4 4 3.5 2 131 77.5 47 -1.12
43 3 4 3 3 3 2 129 58.5 34.8 0.85
33 2 4 1 2 1 1 112 83 25.4 0.2
48 4 4 4 4 3 2 94 97.5 31.6 0.44
21 4 5 3 4 1 1 106 94.5 27.2 -0.15
32 4 4 3 4 1 2 109.5 104.5 45 -2.04
39 4 2 3 3 1 1 118.5 94.5 52.4 -0.01
27 3 4 1 3 9.5 2 120.5 95 48.4 3.09
34 5 5 4 5 0 2 77 29 43.6 -3.38
19 5 4 4 4 2.5 2 130 84 50.4 1.85
50 4 4 3 4 3.5 2 118.5 113.5 54.6 2.45
40 2 3 2 2 2 1 98.5 69.5 21.6 -0.3
31 4 5 3 4 4 1 93 61 24 0.76
25 4 4 2 3 2 2 76 47 50.6 0
64 4 4 1 3 3 1 80.5 36 22.6 -2.65
31 4 2 3 3 1 1 85 83 51.4 -1.14
25 3 4 3 3 4.5 2 114.5 82.5 47.2 -1.16
36 4 4 1 3 3 2 128 79.5 29.2 0.38
40 1 4 3 3 3 2 146 108 47.6 2.18
39 4 4 3 4 3 2 125 108 37.2 1.01
29 5 4 3 4 2.5 2 153 67 39.2 -0.05
48 4 4 3 4 4 1 103 64.5 40.8 -0.41
54 2 5 5 4 2 2 81.5 55 24 -0.57
20 3 4 2 3 3.5 2 107 70.5 48.4 -0.68
33 4 4 1 3 2.5 2 113 96 50.4 0.42
41 4 4 3 4 1 2 123.5 69 42.3 -0.36
22 4 5 3 4 3.5 1 82 78 55 -1.65
24 1 4 5 3 1 2 100.5 51 30.2 0.77
28 3 4 4 4 4 2 95 64.5 36 -1.97
45 3 5 1 3 3.5 2 75.5 57.5 42.1 0.35
31 3 5 4 4 1.5 2 131 93 50.2 1.92
16 3 4 3 3 3.5 2 98.5 65.5 29.6 -1.29
29 4 4 2 3 5.5 2 119.5 88.5 32.6 0.47
34 4 4 5 4 3 1 99 75.5 40.8 -0.38
33 3 1 4 3 0 2 101 89 42.2 1.35
33 2 4 3 3 2 1 152.5 97 45 2.6
32 4 1 2 2 3.5 1 64 48.5 45.2 -0.55
31 3 5 3 4 2 2 91 59.5 37 -1.47
38 4 5 3 4 0.5 2 123 96.5 32.8 1.47
41 4 5 3 4 3 2 111.5 70.5 55.6 -0.29
22 3 4 1 3 2.5 2 112.5 69.5 44.4 2.37
39 4 4 3 4 3.5 2 86.5 60 35.8 -0.4
25 4 5 4 4 2.5 2 142 115 26.6 2.69
40 4 5 3 4 3 2 71 66 38 0.2
52 3 5 3 4 5 2 95.5 89 41.4 -1.1
37 4 4 3 4 2 2 136.5 90 36.5 2.13
62 4 5 4 4 5 2 94.5 62.5 56.6 -1.59
47 1 4 3 3 2 1 90.5 64.5 47.8 -2.79
30 3 4 1 3 2 2 111.5 95.5 33 1.53
21 3 4 4 4 7 2 111 101 51.602 0.94
28 3 4 2 3 5 2 119 82.5 31.4 1.21
45 4 4 2 3 5.5 2 119.5 90.5 48.4 3.04
36 2 4 4 3 5.5 1 134 103.5 46 3.51
55 2 5 1 3 4 2 134 89 48.4 1.62
25 2 5 2 3 7.5 2 132.5 83.5 37 -0.62
25 3 3 1 2 0.5 2 121.5 89 45.4 -0.89
18 4 2 3 3 4.5 2 91.5 73 33.6 -0.82
30 4 3 4 4 2 2 173.5 117 54.2 0.68
25 4 2 2 3 4 1 128.5 80 56 1.43
22 4 5 4 4 6 2 144.5 94 35.2 1.57
40 3 2 2 2 5 1 29 19 28 -4.17
41 3 5 3 4 4 2 135 101.5 38.4 4.52
51 4 4 5 4 4.5 2 89 60 49.4 -1.92
37 3 5 4 4 0.5 2 87 101.5 40 -1.51
34 4 5 1 3 3 2 104.5 69 38 -1.43
21 4 3 3 3 4 2 120 100 52.4 1.24
39 2 2 3 2 2.5 1 117.5 56.5 34.8 -0.57
48 4 4 3 4 3.5 2 100 75.5 32.4 0.03
31 3 2 3 3 2 2 92 57 39.5 -1.64
39 3 4 3 3 5.5 2 124.5 82 44.6 -0.29
14 4 4 3 4 3 2 103.5 77 48.8 -0.5
22 3 4 1 3 0 1 54.5 35 39.8 -1.68
35 3 4 1 3 2 2 136 90.5 43.6 1.11
36 4 3 3 3 1.5 2 124.5 76.5 33.2 -1.11
43 3 4 3 3 2 2 97.5 58.5 52.8 -0.35
23 2 3 3 3 4 1 114 62 34.4 -1.87
42 2 5 1 3 0.5 2 127.5 95.5 37.4 0.73
33 4 2 1 2 3.5 2 104 68.5 35.6 -0.92
41 3 2 4 3 1.5 2 141 113 35.5 4.95
40 3 4 2 3 2 2 84.5 83 30.6 -1.09
43 3 3 1 2 3.5 2 123 66.5 48.8 0.32
28 3 4 3 3 5 2 133.5 87.5 40 0.21
33 3 4 3 3 2.5 2 132.5 99 47.4 1.64
51 4 4 1 3 1.5 2 82.5 57.5 44.8 -0.25
54 4 4 1 3 2 2 131 86 37 1.03
23 4 3 4 4 0.5 2 147 71 57.2 0.53
60 3 4 1 3 4 2 109.5 86.5 43 2.89
33 4 5 2 4 3 1 54 67.5 41.7 -1.38
29 3 5 2 3 0.5 1 126 63.5 37 1.33
52 5 2 2 3 3 2 94 38 37.3 -1.53
35 4 2 110.23 78.75 41.02 0.202
35 3 2 110 78.2 41 0.2
34 3 1 109.5 78.5 40 0.21

Sheet2

Sheet3