USA: +1(669)289-8683 
Sign in
The excel sheet is the given information, and the document is the questions.
Comm215/AA, D Fall 2013 – Case/Data Analysis
Due Date November, 26th 2013
Fitness and Body Strength for Today’s Physically Demanding Workplaces:
How do managers select employees to work in challenging and physically demanding environments, such as building industry and construction from a list of applicants?
Through a thorough exploration of this case study, you should be able to apply statistical methods and procedures which you are familiar with.
In addition, you should be able to use common statistical packages or add-ons with Microsoft Excel to carry out the analyses described in this study.
Your report must be typed and include only relevant computer printouts and should not exceed 7 pages. Only hardcopy paper submissions to be handed in class will be accepted.
The submission should include:
Cover Page This should include the title of the project, your team name(s) and team member student I.D. number (s).
Analysis This forms the major part of your report. It consists of the actual statistical results that are needed to make decisions and recommendations. The results may be displayed in tables and/or graphs. Based on your findings; meaningful discussions and interpretations should be presented here. The formulation of the solution to the problem depends on how the results are interpreted.
Conclusion This segment gives a brief account of how and why the conclusions are reached and recommendations (if any) are made.
The data can be found in Moodle / course website in Excel format
”fitness&strength.xlsx”. Variables description is on sheet4.
Analysis In brief:
To answer if being physically strong and fit is still important in today’s physically demanding workplaces;
You may want to address the following issues, but you are not limited to only these.
– First use descriptive statistical procedures( at least one graph per presentation) for each of the seven variables and summarize the data (a discussion of what the descriptive statistics tell about the data).
In particular for the variable Age, show if there is any pattern and whether there exists any outliers. In detecting outliers either do graph/plotting techniques or use numerical approach.
– Construct a cross-tabulation /contingency table between Gender and Age (using Bin; 30,40,50,60 and 70 years) to show whether there is a significant relationship between Gender and Age. In your analysis, comment on the Age variable.
– After applying further inferential statistics techniques, take a random sample of size 30, construct a 95% confidence interval for the mean Performance Rate and mean Performance Simulation.
– In a random sample of size 35, construct a 88% confidence interval for the proportion of workers doing weights & exercise 4 times a week.
– Show separately whether strength measures variables Grasp and Arm are related to physically demanding job performances Rate and Simulation.
– Finally apply two separate multiple regression analysis to predict job performances using strength measures Grasp and Arm as predictors.
– Using your recommended model, predict job performance of a randomly selected worker with Arm = 100 and Grasp =110.
– What conclusions and recommendations can you derive from your analysis?
Example In Construction and Building Industry:
There are still, however, a number of very important jobs that require, in addition to cognitive skills, a significant amount of strength to be able to perform at a high level. For example, the job of a construction worker. It takes a lot of strength to lift, position, and secure many building materials such as gypsum panels, steel bars, and cement bags. The tools used are often heavy and require a lot of strength to properly control. An interesting applied problem that arises is how to select the best candidates from among a group of applicants for physically demanding jobs. One obvious way might be to take them to a job site and have them demonstrate that they are strong enough to do the job. Unfortunately, this approach might be too time consuming if you are having to select a large number of people from a large applicant pool. Also, you risk injury to applicants who are not strong enough to do the job.
A solution to this problem is to develop a measure of physical ability that is easy and quick to administer, does not risk injury, and is related to how well a person performs the actual job.
The data presented in this case study were collected from 150 individuals working in physically demanding jobs including carpenters, electricians, construction and maintenance workers, auto mechanics, and linemen. An analysis of the tasks performed in these jobs showed that a number of them required a substantial amount of strength to perform.
– Physical Strength assessment 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: male code 2 and female code 1
>Sheet study participants were asked to rate
0-point scale.
Gender 4 4 4 4 1 .8
1 4 5 3 1 1 .8
4 5 1 3 3 1 94 .8
3 4 1 3 2 1 .5
.2
4 4 2 3 3 2 .5
1 3 4 3 3 3.5 2 .5
5 4 4 4 5 1 .5
.8
8
.5
39 5 5 3 4 2 2 .6
.5
.1
.5
5
.8
3 4 5 4 3 2 .5
.5
1.2 .5
.5
.4
.5
.5
29 4 4 4 4 1 2 109 94 51 .5
28 4 5 1 3 3 2 84 52.6 .5
3 4 3 3 3 1 39 88 57 0.91 .5
.2
63.5 104.5 .6
6
.5
36 32.4 45.6 4 4 5 4 2.5 2 115 44 0.5 .5 42 85 45 106 0.79 .5
104.5 42 3 5 4 4 2 2 .5
0.8 47 3 4 3 3 3 2 83 0.2 -0.15 104.5 45 94.5 52.4 -0.01 .5 95 .5
2.45 69.5 -0.3 0 36 .5
47.2 108 1
55 24 7
.5
69 .5
51 0.77 29.6 88.5 97 45 2.6 37 1.47 69.5 -0.4 115 89 -1.1 90 36.5 0.94 46 37 54.2 0.68 94 101.5 38.4 34.8 -0.57 -0.29 -0.5 35 39.8 90.5 43.6 1.11 95.5 37.4 113 40 1.64 71 63.5 37 41 0.2 40 0.21
2
4
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
1
5
0
using a
6
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
Strength
GraspStrength
ArmPerformance
RATE Performance
Simulation SIMS
26
3
10
5.5
8
0.5
31
1.
18
24
10
6.5
93
39
0.
94
33
81
46
0.
84
45
90
3
3.5
52
–
2.45
38
104
4
7
3
1.2
36
1
71
1
25
46.6
4.38
23
107
8
1.5
29
-0.3
25 3 2 3 3 1 2
12
4.5
83
-0.01
28
87
65
50
-0.
99
24 2 3 5 3 1.5 1
10
2.5
77
40
-0.04
39 3 4 3 3 3.5 2
1
19
54
29.6
-1.1
18 3 5 2 3 6 2 54
68.5
5
2.6
0.19
47 4 5 2 4 1.5 2
119
101
51
0.58
37
88
109
35
46 3 5 1 3 1 2
1
57
103
45.8
1.
22
33 4 4 3 4 3 1
110
7
9.5
32
-0.15
39 3 5 3 4 4 1
92
85
38.15
1.26
33 5 5 4 5 1.5 2
99.5
91
0.92
34
63.5
42
-0.09
29 5 4 1 3 0 2
1
14
-0.
67
35 4 5 2 4 2.5 2 92
96
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
-0.
62
36 3 3 3 3 5.5 2
1
89
122
49.2
66
4.87
44
115
101.5
45.6
0.77
50 5 4 2 4 5 2
1
21
2.
97
26 1 1 3 2 2 2
128
93.5
46.4
3.
16
31 4 4 3 4 1.5 2 128 84 46
0.
27
56
82
31.3
-3.88
35 4 2 4 3 4 2
128.5
0.91
39 3 4 3 3 1.5 1
118
70.5
26.4
33 4 4 3 4 5 1
104.5
69
38.2
–
0.94
36 3 1 3 2 2 1
122.5
66.5
30
-2.17
42 3 3 1 2 4.5 2 88 25
33.8
-2.05
35 5 3 3 4 2 2
105
26.8
-1.3
31 4 5 2 4 2 2
127
41
0.2
22 2 4 3 3 2.5 1
1
20
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
47.2
-1.08
25 4 4 3 4 2 2
78
69.5
-1.67
27 4 4 2 3 5 2
94.5
88.5
0.72
50 3 4 3 3 1 2 99 62
36.334
-0.
61
48
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
11
7.5
61.5
21 2 4 2 3 3 2 99
80
52.4
0.49
41 3 5 3 4 1 2
121.5
106
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
–
0.42
39 5 4 4 4 5.5 1
124.5
42.8
47 3 4 3 3 4.5 2
130
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
5.17
55
111
95
50.8
41 4 4 4 4 3.5 2
131
77.5
-1.12
43
129
58.5
34.8
0.85
33 2 4 1 2 1 1
112
25.4
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
32 4 4 3 4 1 2
109.5
-2.04
39 4 2 3 3 1 1
118.5
27 3 4 1 3 9.5 2
120
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
54.6
40 2 3 2 2 2 1
98.5
21.6
31 4 5 3 4 4 1 93 61 24
0.
76
25 4 4 2 3 2 2 76 47
50.6
64 4 4 1 3 3 1
80.5
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
82.5
-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
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.4
54 2 5 5 4 2 2
81.5
-0.5
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
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
30.2
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
-1.29
29 4 4 2 3 5.5 2
119.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
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
–
1.47
38 4 5 3 4 0.5 2 123 96.5
32.8
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
44.4
2.37
39 4 4 3 4 3.5 2
86.5
60
35.8
25 4 5 4 4 2.5 2
142
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
41.4
37 4 4 3 4 2 2
1
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
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
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
-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
25 4 2 2 3 4 1 128.5 80 56
1.43
22 4 5 4 4 6 2
144.5
35.2
1.57
40 3 2 2 2 5 1 29 19 28
-4.17
41 3 5 3 4 4 2
135
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
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
14 4 4 3 4 3 2 103.5 77
48.8
22 3 4 1 3 0 1
54.5
-1.68
35 3 4 1 3 2 2
136
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
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
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
0.21
33 3 4 3 3 2.5 2 132.5 99
47.4
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
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
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
34 3 1 109.5
78.5
Sheet2
Sheet3
