1) Run a multiple regression (in Excel) with body fat as the dependent variable
ID: 3430583 • Letter: 1
Question
1) Run a multiple regression (in Excel) with body fat as the dependent variable and skinfold, midarm and thigh as independent variables using the table below. Show the results. Comment on the predictive value of the results.
Skinfold
Thigh
Midarm
Body Fat
19.5
43.1
29.1
11.9
24.7
49.8
28.2
22.8
30.7
51.9
37
18.7
29.8
54.3
31.1
20.1
19.1
42.2
30.9
12.9
25.6
53.9
23.7
21.7
31.4
58.5
27.6
27.1
27.9
52.1
30.6
25.4
22.1
49.9
23.2
21.3
25.5
53.5
24.8
19.3
31.1
56.6
30
25.4
30.4
56.7
28.3
27.2
18.7
46.5
23
11.7
19.7
44.2
28.6
17.8
14.6
42.7
21.3
12.8
29.5
54.4
30.1
23.9
27.7
55.3
25.7
22.6
30.2
58.6
24.6
25.4
22.7
48.2
27.1
14.8
25.2
51
27.5
21.1
Skinfold
Thigh
Midarm
Body Fat
19.5
43.1
29.1
11.9
24.7
49.8
28.2
22.8
30.7
51.9
37
18.7
29.8
54.3
31.1
20.1
19.1
42.2
30.9
12.9
25.6
53.9
23.7
21.7
31.4
58.5
27.6
27.1
27.9
52.1
30.6
25.4
22.1
49.9
23.2
21.3
25.5
53.5
24.8
19.3
31.1
56.6
30
25.4
30.4
56.7
28.3
27.2
18.7
46.5
23
11.7
19.7
44.2
28.6
17.8
14.6
42.7
21.3
12.8
29.5
54.4
30.1
23.9
27.7
55.3
25.7
22.6
30.2
58.6
24.6
25.4
22.7
48.2
27.1
14.8
25.2
51
27.5
21.1
Explanation / Answer
The Linear regression equatioon of the given data is
Body fat = 117.08 + 4.3341(Skinfold) + -2.8568(Thigh) + -2.1861Midarm
The Predictive values are
14.855,20.219,20.987,23.127,11.758,22.244,25.714,22.271,19.595,20.548,24.59624.992,15.009,13.672,11.812,23.727,22.974,26.786,18.526,20.488
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.