1 Run a multiple regression in Excel with body fat as the de

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

Solution

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