FIND ANY TWO OR THREE OF THE FOLLOWING THAT IS GIVEN BELOW. THANK YOU.

1-Identify the columns and type of data (nominal, scale, interval, ordinal)

2-Calculate the mean, median, mode, and geometric mean of columns wherever applicable

3-Calculate range, variance, std dev

4-Find Q1, Q3, IQR, box plot. Identify any outlier

5-Plot scatter graph, calculate the coefficient of variation, and identify if data has interdependencies

6- For all questions, 1-6, interpret the results

Submission: Excel file for calculations and word file for interpretation

D L M N o Inns 50s Os 4s 6s 52 0 17 5 191 28 20 E F G Not Outs Runs HS 50 7 1774 90* 20 4 605 80* 31 3 1020 94* 15 2 459 73* 18 9 316 48" 0 4 0 61 14 31 0 10 4 116 50 15 0 4 1 14 51 20 23 0 0 1 22 19 17 1 0 2 0 61 19 22 20 5 540 80* 504 99* 701 0 3 0 35 30 28 25 4 0 5 1 67 31 30 5 0 7 3 42 32 45 33 66 88 42 11 1 3 2 38 30 10 833 1012 100* 650 1361 91* 507 61* 0 3 2 48 B 1 PlayerNar Span Mat 2 Babar Aza 2016-2021 3 Tamim Iqt 2016-2020 4 L Ronchi 2018-2020 5 JJ Roy 2017-2020 6 D Wiese 2018-2021 7 AD Hales 2018-2021 8 BR Dunk 2019-2021 9 DR Smith 2016-2019 10 Umar Akm 2016-2019 11 RR Rossou 2017-2021 12 KA Pollarc 2017-2019 13 SR Watsor 2016-2020 14 Misbah ul 2016-2019 15 Mohamm: 2016-2021 16 Shoaib Me 2016-2021 17 CA Ingram 2018-2021 18 DJ Malan 2016-2020 19 JL Denly 2018-2021 20 Sarfaraz A 2016-2021 21 Fakhar Zar 2017-2021 22 CA Lynn 2020-2021 23 Mohamm: 2016-2021 24 RS Bopara 2016-2021 25 LS Livingsi 2019-2020 44 H J K Avg Balls Face SR 100s 41.25 1471 120.59 37.81 535 113.08 36.42 614 166.12 35.3 356 128.93 35.11 195 162.05 33.75 376 143.61 33.6 333 151.35 73 33.38 611 114.72 93 33.32 604 137.91 32.64 770 131.42 73 32.5 391 166.24 32.4 982 138.59 31.68 453 111.92 76 31.68 557 125.13 68 31.48 1000 122.8 30.33 558 146.77 64 29.88 428 118.69 29.5 287 123.34 81 29.25 820 128.41 94 29.13 907 138.14 28.9 183 173.77 28.85 957 123.61 28.7 658 117.78 82 28.6 318 134.9 46 46 0 9 2 123 81 29 22 0 2 0 42 18 18 40 29 0 4 1 697 1228 53 49 10 0 7 2 61 80 69 46 40 37 35 1 3 2 20 20 0 3 0 50 16 14 13 819 127* 508 354 79* 1053 1253 0 3 2 42 11 www cova 48 12 0 5 2 95 57 44 21 49 44 0 9 9 3 129 12 12 318 113* 1 1 2 38 17 52 49 1183 98* 0 8 4 49 111 63 39 775 71* 0 0 5 1 18 36 18 19 429 0 4 2 2 31 20 T50 fox D E E F G H 1 K L L M M N O P J 121.4 33 21 7 397 71 28.35 327 0 0 1 0 48 6 25 1 84 487 137.78 0 3 1 80 21 25 10 671 279 10 0 0 70 27.95 27.9 27.86 205 0 2 0 26 12 136.09 126.39 24 23 1 613 65 485 0 5 2 64 17 61 60 2 1606 107* 1174 136.79 3 9 8 168 79 29 28 2 716 117 27.68 27.53 27.53 479 149.47 2 3 2 64 50 15 15 2 358 69 162.72 0 2 2 31 21 220 544 36 34 9 9 75 26.68 122.61 0 3 1 61 28 27 2 439 139.17 0 4 4 43 30 25 15 0 61 0 1 0 47 3 16 45 667 611 88* 396 1077 524 863 117* 43 2 99 306 897 411 0 9 4 109 32 20 20 0 59 0 5 2 49 A B 26 SR Patel 2018-2021 27 JM Vince 2016-2021 28 AP Devcic 2018-2019 29 KC Sangak 2016-2018 30 Kamran Al 2016-2021 31 Sharjeel K 2016-2021 32 Haider Ali 2020-2021 33 Sohail Akt 2018-2021 34 KP Pieters 2016-2018 35 Shan Mas 2019-2021 36 Ahmed Sh 2016-2020 37 Imam ul H 2019-2021 38 CS Delpor 2016-2021 39 Asif Ali 2016-2021 40 Sohaib Ma 2016-2021 41 DJG Sam 2016-2020 42 BJ Haddin 2016-2017 43 Umar Ami 2016-2020 44 Hussain T: 2017-2021 45 CH Gayle 2016-2021 46 C Munro 2019-2020 47 Khushdil s 2017-2021 48 L Dawsoi 2018-2020 49 DT Christi: 2019-2021 50 CAK Walte 2018-2020 13 36 35 2 674 1 5 4 33 79 44 47 40 12 70 0 2 3 55 720 538 85 26.56 26.4 26.26 26.2 26.15 25.71 25.61 25.59 25.15 24.53 23.39 23.12 29 27 0 3 3 6 12 24 44 49 39 48 129.41 120.06 127.49 128.04 163.26 118.5 146.39 130.8 109.24 123.11 136.53 140 127.57 0 0 2 17 44 48 25 35 691 327 319 61* 73 441 454 472 250 292 437 271 0 4 17 17 2 4 4 15 0 2 2 4 20 33 16 28 5 538 56 0 1 2 41 17 0 68 0 2 2 24 29 16 16 17 370 343 87* 16 1 22.86 245 0 3 3 27 19 20 5 22.75 214 0 1 0 16 13 273 70* 363 24 19 3 62 289 0 0 2 2 18 16 13 10 3 152 27 22.68 21.71 21.29 103 125.6 147.57 141.4 0 0 0 0 0 14 6 21 19 2 362 48 256 0 0 2 30 18