Height (cm) Measure 1 168.00 162.80 182.40 155 164.59 182.75 185.50 160.00 185.55 159.2 174 167.64 191.5 175.21 161.50 159.40 175 170.50 146.50 178 173.00 147.50 153 157.48 Measure 2 168.50 163.00 182.60 156 164.59 183 185.49 161.00 185.62 160 174 170.18 192 175.54 161.50 159.90 174 172.50 146.00 178 174.00 147.40 154.5 158.75 Weight (kg) Measure 1 116.57 46.27 140.91 59 55.79 80.5 98.42 60.80 124.79 138 136.42 81.65 124.1 74.75 60.01 71.21 84.82 157.50 49.90 69.04 118.95 259.90 178 69.85 Measure 2 116.12 45.81 139.76 59.4 55.79 80.35 98.52 60.70 124.96 138 136.53 79.38 124.1 74.75 60.50 71.12 85.28 157.00 49.44 69.04 118.95 259.90 178 69.85 Palm Width (cm) Measure 1 8.00 6.50 10.16 7.10 7.00 8.70 9.53 7.20 8.13 7.4 9.84 6.50 9 8.25 7.62 8.20 8.70 8.26 7.00 8.4 9.35 7.50 7.5 6.80 Measure 2 8.00 6.80 10.18 7.10 7.10 8.80 9.60 7.10 8.13 7.4 9.84 6.70 9 8.11 7.62 8.10 8.70 8.57 7.00 8.45 9.20 7.40 7.5 7.00 Hand Length (cm) Measure 1 17.15 18.29 20.32 16.50 16.40 20.10 19.69 17.78 20.07 17.9 17.15 17.10 19.6 18.05 17.78 16.69 18.42 19.05 17.27 19.2 18.10 16.00 16.7 15.90 Measure 2 17.27 17.78 20.30 16.50 16.30 19.94 19.71 17.78 20.57 17.8 17.15 17 19.6 17.91 17.78 16.69 18.75 18.99 17.53 19.2 18.42 15.90 16.8 15.80 Elbow-grip...

60.1K

Verified Solution

Question

Basic Math

Height (cm)

Measure 1168.00162.80182.40155164.59182.75185.50160.00185.55159.2174167.64191.5175.21161.50159.40175170.50146.50178173.00147.50153157.48
Measure 2168.50163.00182.60156164.59183185.49161.00185.62160174170.18192175.54161.50159.90174172.50146.00178174.00147.40154.5158.75

Weight (kg)

Measure 1116.5746.27140.915955.7980.598.4260.80124.79138136.4281.65124.174.7560.0171.2184.82157.5049.9069.04118.95259.9017869.85
Measure 2116.1245.81139.7659.455.7980.3598.5260.70124.96138136.5379.38124.174.7560.5071.1285.28157.0049.4469.04118.95259.9017869.85

Palm Width (cm)

Measure 18.006.5010.167.107.008.709.537.208.137.49.846.5098.257.628.208.708.267.008.49.357.507.56.80
Measure 28.006.8010.187.107.108.809.607.108.137.49.846.7098.117.628.108.708.577.008.459.207.407.57.00

Hand Length (cm)

Measure 117.1518.2920.3216.5016.4020.1019.6917.7820.0717.917.1517.1019.618.0517.7816.6918.4219.0517.2719.218.1016.0016.715.90
Measure 217.2717.7820.3016.5016.3019.9419.7117.7820.5717.817.151719.617.9117.7816.6918.7518.9917.5319.218.4215.9016.815.80

Elbow-grip length (cm)

Measure 140.6433.5335.5631.7034.0040.0034.2934.7939.3716.2940.9635.5643.232.1131.7533.3438.7438.1030.2335.8837.7832.2033.0033.00
Measure 240.0133.5335.5632.2033.6039.6234.5434.2939.1716.2940.6436.0743.231.8931.7533.3439.0137.7830.7335.8837.4732.1032.4032.50

Upper arm length (cm)

Measure 135.5635.0535.0531.5034.0039.8036.8332.0037.5916.0436.5135.5639.437.5134.2935.7238.3536.3529.9738.140.6431.4035.5030.00
Measure 236.8334.2935.3031.5034.5039.6736.4532.2637.4715.7936.8335.0539.636.2333.6535.5637.8536.9929.2138.140.3231.1035.3030.50

Hand Grip Strength 2.0” (kg)

Measure 145.0020.0048.0014.0019.0052.6028.5812.0049.1514.512122.006131.1218.0033.0063.0095.0018.0030.0046.0029.004237.00
Measure 241.0018.0049.0013.0023.0055.5024.9513.0038.551813021.0058.532.2017.0032.0062.0097.0017.0031.5048.0029.004935.00

Hand Grip Strength 2.5” (kg)

Measure 145.0018.0046.0012.0018.0048.6221.5512.0041.521310719.006229.1814.0034.0048.0084.0012.0035.0044.0026.003225.00
Measure 240.0018.0040.0010.0022.0045.2521.0911.0040.551211218.005427.2110.0035.0046.0079.0014.0032.0045.5026.003427.00

Hand Grip Strength 3.0” (kg)

Measure 140.0012.0038.009.0017.0042.0524.279.0045.751410018.0052.528.5412.0031.0044.0074.0016.0033.5038.0022.003127.00
Measure 238.0012.0032.0010.0018.0039.1024.278.0038.115.59419.0048.525.5012.0030.0040.0071.5011.0034.0041.5023.003024.00

Hand Grip Strength 3.5” (kg)

Measure 138.0012.0032.008.0014.0039.0520.6410.0038.5158212.004124.2011.0026.0040.0059.0010.0032.0034.0021.002917.00
Measure 236.0010.0028.006.0016.0037.2519.7310.0036.1510.58214.0038.523.5012.0025.0042.0056.0010.0030.0039.0020.002822.00

note: 24 total participants.

Determine the mean, standard deviation, 5th, and 95thpercentile values of all the measurements. (2.5% x 4 valuecategories)

please show equation even if done on excel

Answer & Explanation Solved by verified expert
4.5 Ratings (951 Votes)
Here we have to calculate the mean standard deviation 5th and 95th percentile values of all the measurements We have to find these values by using excel Excel formula for finding mean is given as below averagerange Excel formula for finding standard deviation is given as below stdevrange Excel formula for finding 5th percentile is given as below mean    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students