Purchase Solution

# Least Influential Parameters

Not what you're looking for?

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, Genda, Height, weight, Bodymass, Blood pressure etc the peoblem is to find the most ,and least influential factors on junp height

##### 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)

Solution provided by:
###### Education
• BSc , Wuhan Univ. China
• MA, Shandong Univ.
###### Recent Feedback
• "Your solution, looks excellent. I recognize things from previous chapters. I have seen the standard deviation formula you used to get 5.154. I do understand the Central Limit Theorem needs the sample size (n) to be greater than 30, we have 100. I do understand the sample mean(s) of the population will follow a normal distribution, and that CLT states the sample mean of population is the population (mean), we have 143.74. But when and WHY do we use the standard deviation formula where you got 5.154. WHEN & Why use standard deviation of the sample mean. I don't understand, why don't we simply use the "100" I understand that standard deviation is the square root of variance. I do understand that the variance is the square of the differences of each sample data value minus the mean. But somehow, why not use 100, why use standard deviation of sample mean? Please help explain."
• "excellent work"
• "Thank you so much for all of your help!!! I will be posting another assignment. Please let me know (once posted), if the credits I'm offering is enough or you ! Thanks again!"
• "Thank you"
• "Thank you very much for your valuable time and assistance!"

##### Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.