Behavourial Statistics Please use the following link to open up the excel file.

Question

Behavourial Statistics

Please use the following link to open up the excel file. Anyone can open it and download it or just choose to edit it online.

https://1drv.ms/x/s!Anz5KbeKd0mcpWLwlGvLlFs5uO4d

Please use excel function; DATA to solve this question is below this table. Show your work

1 a)  You are helping with the CFL combine and have been asked to determine a method to compare each athlete's "score" in the 5 events to dermine which event the athlete did the best in. You can identify each athlete's best event by color.

b) Calculate and determine the skewness and kurtosis for the data sets for each event.

Athlete Bench 40 m Vertical Jump 3-Cone Drill Shuttle 1 270.00 7.99 30.00 9.49 6.28 2 299.00 6.41 35.00 7.74 5.20 3 273.00 6.37 36.00 8.43 4.18 4 289.00 6.99 40.00 8.11 7.14 5 235.00 5.66 29.00 9.17 4.31 6 278.00 7.92 31.00 9.45 4.67 7 223.00 6.68 25.00 8.59 6.49 8 208.00 4.50 38.00 8.08 7.30 9 206.00 7.92 38.00 7.56 6.16 10 215.00 6.35 24.00 8.45 7.71 11 208.00 5.53 28.00 9.78 6.60 12 241.00 4.94 30.00 8.03 6.59 13 245.00 5.18 31.00 9.93 7.41 14 211.00 6.96 35.00 7.65 4.38 15 228.00 4.64 40.00 6.26 7.31 16 232.00 7.91 26.00 7.56 6.47 17 237.00 6.07 34.00 8.04 6.28 18 282.00 5.51 38.00 8.46 7.28 19 221.00 7.07 31.00 8.94 7.82 20 220.00 4.52 33.00 7.27 4.09 21 215.00 5.51 31.00 7.36 7.28 22 242.00 5.21 29.00 8.57 7.76 23 273.00 4.67 31.00 9.03 4.63 24 300.00 5.45 26.00 6.85 4.81 25 201.00 5.24 26.00 9.56 6.57 26 203.00 6.05 40.00 7.66 4.60 27 207.00 6.22 33.00 6.40 7.37 28 270.00 7.47 40.00 7.17 6.87 29 240.00 7.49 40.00 9.27 4.62 30 247.00 7.31 30.00 9.92 5.09 31 206.00 5.96 38.00 6.43 6.52 32 205.00 6.83 28.00 9.90 6.74 33 208.00 5.16 32.00 9.97 4.75 34 255.00 7.52 35.00 6.05 4.47 35 270.00 6.87 27.00 7.51 7.93 36 253.00 4.02 32.00 8.01 7.50 37 245.00 6.27 39.00 8.20 4.08 38 250.00 5.63 40.00 8.03 4.52 39 206.00 6.34 29.00 9.68 7.87 40 274.00 5.93 24.00 6.57 5.39 41 208.00 5.36 27.00 9.31 7.27 42 224.00 5.17 39.00 8.39 7.16 43 276.00 5.51 38.00 8.69 7.77 44 258.00 5.94 40.00 7.69 6.68 45 236.00 5.77 24.00 6.03 7.91 46 273.00 6.85 25.00 7.33 5.95 47 223.00 6.09 29.00 6.62 5.47 48 252.00 5.04 38.00 8.35 7.84 49 224.00 6.32 39.00 8.73 5.90 50 215.00 4.36 28.00 7.37 7.17

Explanation / Answer

a) we find mean and SD of each Athlete and also find CV. An Athlete who as least CV the Athlete is best

Least CV is 152.4281 Athlete 49 is best

b)

Variable Skewness Kurtosis
Bench 0.42 -0.97
40 m 0.18 -0.70
Vertical Jump 0.03 -1.36
3-Cone Drill -0.11 -0.80
Shuttle -0.36 -1.32

Mean SD CV 54.12667 106.2226 196.2481 59.225 118.0783 199.3724 55.16333 107.4292 194.7475 59.20667 113.3755 191.4911 48.02333 92.07416 191.728 56.17333 109.1074 194.2335 46.12667 86.9454 188.4927 45.64667 80.50977 176.376 45.77333 79.43253 173.5345 45.25167 83.4097 184.324 44.81833 80.35757 179.2962 50.42667 93.80855 186.0296 51.92 95.03813 183.0472 46.49833 81.35795 174.9696 50.20167 88.09303 175.4783 49.32333 89.80071 182.0654 51.39833 91.54692 178.1126 59.875 109.4868 182.859 49.13833 84.69546 172.3613 48.14667 84.93574 176.4104 47.85833 82.4888 172.3604 52.42333 93.33871 178.048 57.555 106.0833 184.3164 61.185 117.3798 191.8441 45.56167 76.69266 168.3272 47.885 77.25749 161.3396 47.83167 78.83369 164.8149 59.91833 103.824 173.2759 55.06333 91.66521 166.4723 54.88667 94.77497 172.6739 48.985 78.18337 159.6068 48.07833 77.65814 161.5242 48.81333 79.03055 161.9036 57.00667 98.00059 171.9107 59.05167 104.0172 176.1461 56.755 97.09664 171.0803 56.59167 93.61891 165.4288 57.69667 95.58993 165.6767 49.64833 77.7227 156.5464 59.315 106.0658 178.8178 49.65667 78.80045 158.6906 54.28667 84.7669 156.1468 63.16167 105.5451 167.1031 60.385 98.3473 162.8671 54.11833 90.3952 167.0325 60.68833 105.1738 173.3015 52.86333 84.99723 160.7867 59.87167 95.81325 160.031 55.49167 84.58489 152.4281 51.98333 81.7559 157.2733

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.