Government College University Examining Relationships Part 2 Linear Regression and Prediction Analysis

Y = PFT ScoreX = BMI Score
93
25.2
93.3
27.2
84.1
28.8
75
29.4
87.3
25.8
99.6
23.4
78
31.2
85.5
29.2
90.4
25.4
90.9
24.6
80.25
26.5
71.6
20.3
87.7
28.4
78
29.5
88.8
25.4
98.7
23.7
96.7
22.7
93
30.5
81.7
25.3
97.5
21.8
9.5
37
81.8
30.8
90.2
24.9
38
26.5
84.2
23.3
90.6
26.3
68.7
31
78.25
33
94.9
22.1
84.6
27.8
95.4
20.9
85.11
27.3
96.7
21
86.8
28.4
87.3
25.6
91.9
22.2
77.2
26.1
88.4
24.8
94.6
24.4
98.8
24.5
92.4
19.9
44
31
47.6
29.6
77.6
29.9
93.8
24.4
93.9
22.8
81.3
84.4
90.8
98.2
75.1
92.8
73.2
93.1
93.5
73.6
89.4
90.3
86.9
86.2
89.1
96.6
93.7
90.8
79.8
90.4
79
82.8
89.7
93.5
84
94.8
90.9
97
86.5
83.22
75
82.3
67.1
96.9
94
91.9
82.2
81.3
84.5
92.1
81.9
77.8
88.4
99.4
75.9
13.2
95.2
28
25.4
27.3
23.9
28.7
26.3
25.7
19.4
24
24.9
25.1
26.9
25.3
24.7
24.1
26.8
21.4
29.4
30.3
23
31.1
28.8
28.1
25.9
26
25.5
31.1
22.8
26.2
23.3
31.7
28.3
34.4
20.4
25.6
23.3
21.7
24.7
26.8
25.3
31.7
28.6
27.8
22.9
26
31.4
25.5
90.1
74.4
89.9
97.2
80.7
85
77.9
85
27.6
25.6
29.8
24.2
30.9
30.4
32
22.7
Y = Salary
51876
54511
53425
61863
52926
47034
66432
61100
41934
47454
49832
47047
39115
59677
61458
54528
60327
56600
52542
50455
51647
62895
53740
75822
56596
55682
62091
42162
52646
74199
50729
70011
37939
39652
68987
55579
54671
57704
44045
51122
47082
60009
58632
38340
71219
53712
X = Sex
1
1
1
0
1
0
0
0
0
0
1
0
1
0
0
0
1
0
1
1
1
0
0
0
0
1
1
1
1
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
54782
83503
47212
52840
53650
50931
66784
49751
74343
57710
52676
41195
45662
47606
44301
58582
1
0
0
1
0
0
1
1
1
1
0
1
1
1
1
1
Week 11
Examining Relationships (Part 2): Linear Regression and Prediction
Graded Assignment
This week’s graded assignment involves the U.S. Air Force’s physical fitness testing standards,
which the Air Force strengthens and refines periodically. A recent change to these standards took
effect Oct. 21, 2013, and included the following (see http://www.afpc.af.mil/affitnessprogram/):
• body composition, which is evaluated by abdominal circumference measurements;
• an aerobics component, which is evaluated by a 1.5-mile timed run; and
• muscular fitness, which is evaluated by the number of push-up and sit-ups completed
within 1 minute.
According to the new standards, members who fail the abdominal circumference component but
pass the other components will be administered a body mass index (BMI) screen, and members
who do not pass the BMI will be administered a body fat analysis.
The data contained in the corresponding Excel file were acquired from the records of
members of the 114th Range Operations Squadron (114 ROPS) of the Florida Air National
Guard, which makes up one arm of the reserve component to the U.S. Air Force. The data file
consists of 114 ROPS’ physical fitness test (PFT) and BMI scores. For PFT scores, the higher the
score the more physically fit is the person. For BMI scores—which are calculated based on a
person’s height and weight and measure obesity—the higher the BMI score, the more overweight
and obese is the person. Your assignment is to analyze these data to determine the extent to
which the Air Force can predict service members’ PFT scores by their BMI scores. You are to
import this data set into your statistical software program and do the following (see the
corresponding “Guided Example” from the Gallo document for guidance):
A. Pre-Data Analysis
1. What is the research question and corresponding operational definitions?
2. What is the research methodology/design and why is this methodology appropriate?
3. Conduct an a priori power analysis to determine the minimum sample size needed. Is the
given data set sufficient relative to this minimum sample size? In what way do you think
the size of the given sample will impact the results?
B. Data Analysis
Using the data from the Excel file, conduct a hypothesis test as follows:
1. Formulate the null and alternative hypotheses in symbols and words.
2. Determine the test criteria.
3. Test for the four main assumptions of regression.
4. Run the analysis and record the results.
5. Perform an outlier analysis using Jackknife distances (there should be six outliers).
Compare the results of the analysis without outliers to the results with outliers present.
Determine whether you will keep the outliers or deleted them and explain the reasons for
your decision.
6. Make a decision to reject or fail to reject the null hypothesis and write a concluding
statement.
C. Post-Data Analysis
1. Determine and interpret the effect size.
2. Determine and interpret the power of the study.
3. Determine and interpret the 95% confidence interval and comment on the AIPE.
4. Present at least three plausible explanations for the results.
5. Interpret the findings from a practical perspective.