This is the information for the term project in this course. Th
This is the information for the term project in this course. This assignment will be due at the end of Module 7.
For your Final Paper, you will have the opportunity to apply your knowledge for a real data set in order to understand the applicability of all the Statistical tools learned in this course.
Attached is a dataset that lists estimates of the percentage of body fat determined by underwater weighing and various body circumference measurements for 252 men from K.W. Penrose, A.G. Nelson, A.G. Fisher, FACSM, Human Performance Research Center, Brigham Young University, Provo, Utah 84602 as listed in Medicine and Science in Sports and Exercise, vol. 17, no. 2, April 1985, p. 189.
Some experts claim BMI (Body Mass Index) as the most accurate and simple way to determine the effect of weight on your health. Meanwhile, in September 2000, the American Journal of Clinical Nutrition published a study showing that body-fat percentage may be a better measure of your risk of weight-related diseases than BMI.
An important question that arises is whether there is a relationship between ‘Body Fat Percentage’ and ‘Body Mass Index’ as a predictor.
Body Mass Index is defined as
With the use of the statistical techniques used in this programme (especially simple linear regression), explain whether BMI can be used to explain the Body Fat percentage for an individual based on the dataset provided. Clearly explain and interpret your results.
• Use introduction, body paragraph, and conclusion headings• Your paper should have 1,500 words maximum• At least 5 references of an academic or scholarly source are required for this paper. You are expected to use academic sources in peer-reviewed databases or Internet sources, such as: “.org”, “.edu”, “.mil”, “.gov”, ".zm" Sources not allowed are Dictionaries, wikis, or blogs.• Use APA, writing style for in-text citations, and each reference source that you use. Remember, all wording that is not your own must be cited.• Limit the use of direct quotes. Direct quotes should not exceed 1/4 page in total. Deductions will result if this rule is violated.• The cover sheet should include name and course information• Include a reference page in APA style
TOPICS COVERED
1.Categorical and Numerical Data
2. a) Association between categorical variable, b)Association between quantitative variables
3. Probability/Rules
4. a) Random variables, b)Association between random variables/independent/correlation random variables.
5. a) Discrete and continuous random variables b) Bernoulli distribution. c) Binomial probability
6. a)Sample and Survey b)Sampling Variation and quality c) The Normal probability model
t
• Use introduction, body paragraph, and conclusion headings• Your paper should have 1,500 words maximum• At least 5 references of an academic or scholarly source are required for this paper. You are expected to use academic sources in peer-reviewed databases or Internet sources, such as: “.org”, “.edu”, “.mil”, “.gov”, ".zm" Sources not allowed are Dictionaries, wikis, or blogs.• Use APA, writing style for in-text citations, and each reference source that you use. Remember, all wording that is not your own must be cited.• Limit the use of direct quotes. Direct quotes should not exceed 1/4 page in total. Deductions will result if this rule is violated.• The cover sheet should include name and course information• Include a reference page in APA styleT
Sheet2
Sheet3
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.3713947591 | |||||||
R Square | 0.1379340671 | |||||||
Adjusted R Square | 0.1344858033 | |||||||
Standard Error | 7.7856915628 | |||||||
Observations | 252 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 2424.7415636673 | 2424.7415636673 | 40.0010201636 | 0.0000000012 | |||
Residual | 250 | 15154.2482776025 | 60.6169931104 | |||||
Total | 251 | 17578.9898412698 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 10.7152106899 | 1.4210822463 | 7.5401763113 | 0 | 7.9163914889 | 13.5140298908 | 7.9163914889 | 13.5140298908 |
X Variable 1 | 0.3251681195 | 0.0514129384 | 6.3246359708 | 0.0000000012 | 0.22391042 | 0.4264258191 | 0.22391042 | 0.4264258191 |
Chart1
12.3 6.1 25.3 10.4 28.7 20.9 19.2 12.4 4.0999999999999996 11.7 7.1 7.8 20.8 21.2 22.1 20.9 29 22.9 16 16.5 19.100000000000001 15.2 15.6 17.7 14 3.7 7.9 22.9 3.7 8.8000000000000007 11.9 5.7 11.8 21.3 32.299999999999997 40.1 24.2 28.4 35.200000000000003 32.6 34.5 32.9 31.6 32 7.7 13.9 10.8 5.6 13.6 4 10.199999999999999 6.6 8 6.3 3.9 22.6 20.399999999999999 28 31.5 24.6 26.1 29.8 30.7 25.8 32.299999999999997 30 21.5 13.8 6.3 12.9 24.3 8.8000000000000007 8.5 13.5 11.8 18.5 8.8000000000000007 22.2 21.5 18.8 31.4 26.8 18.399999999999999 27 27 26.6 14.9 23.1 8.3000000000000007 14.1 20.5 18.2 8.5 24.9 9 17.399999999999999 9.6 11.3 17.8 22.2 21.2 20.399999999999999 20.100000000000001 22.3 25.4 18 19.3 18.3 17.3 21.4 19.7 28 22.1 21.3 26.7 16.7 20.100000000000001 13.9 25.8 18.100000000000001 27.9 25.3 14.7 16 13.8 17.5 27.2 17.399999999999999 20.8 14.9 18.100000000000001 22.7 23.6 26.1 24.4 27.1 21.8 29.4 22.4 20.399999999999999 24.9 18.3 23.3 9.4 10.3 14.2 19.2 29.6 5.3 25.2 9.4 19.600000000000001 10.1 16.5 21 17.3 31.2 10 12.5 22.5 9.4 14.6 13 15.1 27.3 19.2 21.8 20.3 34.299999999999997 16.5 3 0.7 20. 5 16.899999999999999 25.3 9.9 13.1 29.9 22.5 16.899999999999999 26.6 0 11.5 12.1 17.5 8.6 23.6 20.399999999999999 20.5 24.4 11.4 38.1 15.9 24.7 22.8 25.5 22 17.7 6.6 23.6 12.2 22.1 28.7 6 34.799999999999997 16.600000000000001 32.9 32.799999999999997 9.6 10.8 7.1 27.2 19.5 18.7 19.5 47.5 13.6 7.5 24.5 15 12.4 26 11.5 5.2 10.9 12.5 14.8 25.2 14.9 17 10.6 16.100000000000001 15.4 26.7 25.8 18.600000000000001 24.8 27.3 12.4 29.9 17 35 30.4 32.6 29 15.2 30.2 11 33.6 29.3 26 31.9
Sheet1
Body Fat (%) | Height (m) | Weight(kg) |
12.3 | 1.72085 | 69.96662 |
6.1 | 1.83515 | 78.58488 |
25.3 | 1.68275 | 69.85322 |
10.4 | 1.83515 | 83.80119 |
28.7 | 1.80975 | 83.57439 |
20.9 | 1.89865 | 95.3678 |
19.2 | 1.77165 | 82.10022 |
12.4 | 1.8415 | 79.83226 |
4.1 | 1.8796 | 86.63614 |
11.7 | 1.8669 | 89.92469 |
7.1 | 1.8923 | 84.48158 |
7.8 | 1.9304 | 97.97595 |
20.8 | 1.7653 | 81.87342 |
21.2 | 1.80975 | 93.09983 |
22.1 | 1.7653 | 85.16197 |
20.9 | 1.6764 | 73.82216 |
29 | 1.8034 | 88.79071 |
22.9 | 1.8034 | 94.9142 |
16 | 1.72085 | 83.3476 |
16.5 | 1.8669 | 96.04818 |
19.1 | 1.7272 | 81.19303 |
15.2 | 1.77165 | 90.94527 |
15.6 | 1.73355 | 63.61633 |
17.7 | 1.778 | 67.47187 |
14 | 1.72085 | 68.60585 |
3.7 | 1.8161 | 72.23458 |
7.9 | 1.7145 | 59.6474 |
22.9 | 1.7145 | 67.13167 |
3.7 | 1.64465 | 60.44118 |
8.8 | 1.7526 | 72.91497 |
11.9 | 1.87325 | 82.55381 |
5.7 | 1.80975 | 72.68818 |
11.8 | 1.80975 | 76.20352 |
21.3 | 1.8034 | 99.10993 |
32.3 | 1.8669 | 112.1507 |
40.1 | 1.651 | 86.97634 |
24.2 | 1.778 | 91.73906 |
28.4 | 1.73355 | 89.2443 |
35.2 | 1.83515 | 164.7221 |
32.6 | 1.7018 | 92.07925 |
34.5 | 1.74625 | 119.1814 |
32.9 | 1.7493 | 92.98644 |
31.6 | 1.778 | 98.42954 |
32 | 1.8161 | 96.16158 |
7.7 | 1.7272 | 56.81244 |
13.9 | 1.86055 | 74.50255 |
10.8 | 1.7145 | 60.55458 |
5.6 | 1.80975 | 67.35847 |
13.6 | 1.7399 | 61.57516 |
4 | 1.69545 | 57.83303 |
10.2 | 1.83515 | 71.78099 |
6.6 | 1.7526 | 63.16274 |
8 | 1.72085 | 62.25555 |
6.3 | 1.8669 | 69.28623 |
3.9 | 1.7145 | 61.80196 |
22.6 | 1.8288 | 89.81129 |
20.4 | 1.7272 | 82.32702 |
28 | 1.7653 | 91.28546 |
31.5 | 1.79705 | 91.85245 |
24.6 | 1.67005 | 81.53323 |
26.1 | 1.86055 | 97.97595 |
29.8 | 1.7399 | 81.07964 |
30.7 | 1.78435 | 87.65673 |
25.8 | 1.7018 | 80.73944 |
32.3 | 1.778 | 93.21323 |
30 | 1.7145 | 83.2342 |
21.5 | 1.79705 | 68.71924 |
13.8 | 1.8161 | 70.19342 |
6.3 | 1.75895 | 70.42022 |
12.9 | 1.8161 | 71.1006 |
24.3 | 1.8161 | 75.97672 |
8.8 | 1.74625 | 66.56468 |
8.5 | 1.87325 | 72.91497 |
13.5 | 1.6256 | 56.69905 |
11.8 | 1.67005 | 64.86371 |
18.5 | 1.7145 | 67.24507 |
8.8 | 1.7653 | 73.70876 |
22.2 | 1.7399 | 80.62604 |
21.5 | 1.78435 | 73.14177 |
18.8 | 1.75895 | 77.67769 |
31.4 | 1.72085 | 74.27575 |
26.8 | 1.70815 | 68.15225 |
18.4 | 1.84785 | 86.29595 |
27 | 1.778 | 77.4509 |
27 | 1.75895 | 76.20352 |
26.6 | 1.7145 | 75.74993 |
14.9 | 1.70815 | 71.5542 |
23.1 | 1.67005 | 72.57478 |
8.3 | 1.8415 | 80.17245 |
14.1 | 1.8542 | 79.83226 |
20.5 | 1.778 | 80.28585 |
18.2 | 1.7653 | 81.53323 |
8.5 | 1.7907 | 74.95614 |
24.9 | 1.82245 | 87.31653 |
9 | 1.8923 | 83.57439 |
17.4 | 1.97485 | 101.8315 |
9.6 | 1.86055 | 85.61556 |
11.3 | 1.6891 | 73.70876 |
17.8 | 1.73355 | 70.98721 |
22.2 | 1.8288 | 89.3577 |
21.2 | 1.8669 | 90.03809 |
20.4 | 1.8288 | 78.81167 |
20.1 | 1.80975 | 78.35808 |
22.3 | 1.87325 | 89.2443 |
25.4 | 1.75895 | 80.28585 |
18 | 1.7399 | 75.06954 |
19.3 | 1.8669 | 90.83187 |
18.3 | 1.88595 | 92.19265 |
17.3 | 1.9177 | 87.99692 |
21.4 | 1.75895 | 76.43031 |
19.7 | 1.7399 | 77.4509 |
28 | 1.778 | 83.1208 |
22.1 | 1.778 | 80.85284 |
21.3 | 1.78435 | 73.93556 |
26.7 | 1.82245 | 79.49206 |
16.7 | 1.75895 | 71.66759 |
20.1 | 1.84785 | 80.39925 |
13.9 | 1.8288 | 81.19303 |
25.8 | 1.8796 | 86.63614 |
18.1 | 1.83515 | 85.04857 |
27.9 | 1.8923 | 93.66682 |
25.3 | 1.8161 | 84.02799 |
14.7 | 1.74625 | 72.68818 |
16 | 1.69545 | 68.71924 |
13.8 | 1.6891 | 73.02837 |
17.5 | 1.7018 | 75.74993 |
27.2 | 1.74625 | 80.51265 |
17.4 | 1.72085 | 69.05944 |
20.8 | 1.86055 | 87.20313 |
14.9 | 1.77165 | 74.95614 |
18.1 | 1.8161 | 77.90449 |
22.7 | 1.7907 | 77.67769 |
23.6 | 1.86055 | 89.3577 |
26.1 | 1.69545 | 71.214 |
24.4 | 1.7653 | 76.31692 |
27.1 | 1.77165 | 84.36818 |
21.8 | 1.79705 | 75.63653 |
29.4 | 1.8796 | 85.16197 |
22.4 | 1.80975 | 76.31692 |
20.4 | 1.905 | 96.50178 |
24.9 | 1.8034 | 80.17245 |
18.3 | 1.7653 | 78.58488 |
23.3 | 1.72085 | 75.74993 |
9.4 | 1.83515 | 72.46138 |
10.3 | 1.9685 | 85.3434 |
14.2 | 1.79705 | 70.76041 |
19.2 | 1.84785 | 94.57401 |
29.6 | 1.77165 | 93.66682 |
5.3 | 1.8415 | 65.2039 |
25.2 | 1.78435 | 101.1511 |
9.4 | 1.7526 | 69.05944 |
19.6 | 1.8923 | 109.656 |
10.1 | 1.83515 | 66.22449 |
16.5 | 1.70815 |