Least Influential Parameters

Solution Summary

Making sense of the data in Excel, in order to predict the two most influential , and the two least influential parameters.

The enclosed table shows details from a sample of students.

All students had to jump as high as possible, the results were measured in CMs.

Out of all the personal details, Gender, Height, weight, Bodymass, Blood pressure etc the peoblem is to find the most ,and least influential factors jump height.

SEX M/F AGE YEARS HEIGHT CM WEIGHT KG SYSTOLIC BP DIASTOLIC BP ADIPOSITY % PEF L/M FEV FEV1 LUNG ELAS JUMP CM
M 31 183 123 115 72 17 710 5.3 4.6 86.79 44
F 31 171 91 171 94 16 560 4.6 4 86.96 44
M 23 174 66 112 63 12.5 540 4.2 3.8 90.48 46
M 23 182 100 106 82 23 670 5.8 4.9 84.48 57
F 18 162 55 115 61 16 500 3.8 3.7 97.37 44
F 19 170 68 126 76 20 510 4.7 4.4 93.62 57
F 19 171 64 122 79 13 560 4.4 4 90.91 41
M 19 178 65 109 89 7 610 4.7 4.3 91.49 59
M 22 183 91 114 66 22 640 5.1 4.6 90.2 59
M 18 183 71 113 69 9 500 6.1 5.1 83.61 50
M 19 189 75 119 74 12 680 6.4 5.5 85.94 44
F 23 172 66 115 80 17 440 4.2 3.4 80.95 34
F 21 178 62 123 59 21.5 450 4.1 3.8 92.68 35
M 18 171 69 122 79 16 570 5.2 4.5 86.54 42
F 18 154.5 55 108 66 20 470 2.9 2.75 94.83 27
M 19 189 106 118 65 14 620 6.7 5.4 80.6 44
M 19 183.5 75 133 73 12 610 6.4 5.4 84.38 56
M 19 166 61 112 69 7 610 4.5 4.25 94.44 61
M 20 171 70 124 73 17 510 3.1 2.8 90.32 51
F 21 161.5 57 116 62 20 410 3.3 2.7 81.82 34
F 18 150 54 138 80 26 390 2.5 2 80 30
F 18 166.1 77 113 70 21.5 500 3.9 3.4 87.18 47
F 20 165.5 50 107 63 14.5 390 3.4 3.1 91.18 34
F 32 158.9 54 136 78 15.5 490 4.2 3.7 88.1 27
F 18 166 73 112 49 24.5 470 3.9 3.8 97.44 34
F 19 160.5 82 109 79 26.5 490 3.5 3.2 91.43 33
F 21 152 82 100 72 28 480 2.8 2.6 92.86 31
M 34 176 78 118 67 13.5 720 6.4 5 78.13 45

PEF L/M = peak expiatory flow
FEV = forced expiratory volume
FEV 1 = forced expiratory volume in 1 sec
lung elasticity (fev1/fev)