Question: Problem 3: Load the xlsx data file 'Top_NFL_Fantasy_Stats'. Use the full xlsread function to get the numerical (num) and the text (txt) data (ignore raw

![(ignore raw for now) using: [num, txt,raw]=xlsread(); Find and print out the](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f4e4490eb29_25666f4e4489878d.jpg)

Problem 3: Load the xlsx data file 'Top_NFL_Fantasy_Stats'. Use the full xlsread function to get the numerical (num) and the text (txt) data (ignore raw for now) using: [num, txt,raw]=xlsread(); Find and print out the name of the player and the top # of passing yards for this NFL season using fprintf while being careful of the header at the top of the txt variable and verifying from that data that the correct player was identified. Hint: Since the txt variable is a cell array of names, you could either convert the txt variable from a cell to a string using the "string" function (i.e, player = string(txt(2,2)) will output 'player = "Russell Wilson") or use Ito index the cell array (ie, player = txt{2,2) will output "player = 'Russell Wilson'"). 0 7 P Q ER Gm int Yes sch Tet RC 1 14 M TD 0 788 0 IE 0 O 0 19 0 O O 0 O 13 6 0 1 Team SEA LAR CAR NE WC PHI WAS DET UM BODO 0 O 0 FF 0 O 0 0 0 0 0 D 9 0 O O 0 0 0 O 0 . O 0 0 D 30 90 0 0 0 22 32 26 23 22 25 28 20 28 22 0 O o 0 0 0 O D WD 0 0 0 ON 0 O 1 Player Pos 2 Russell Wilson QB 3 Todd Gurley RB 4 Cam Newton OR > Tom trady QB Alex Smith OD 7 Carson Wente B Krk Cousins 9 Matthew Stafford 08 10 Philip River 11 Drew Bees 13 Ben Roethlisberer QB 13 Dak Prescott On 14 Von RB 15 lared dat 16 millores 90 IT Kareem Hunt RA 1 Case Kem QA TDA Kamara RB 20 Melvin Gordon HO 21 Mat Ryan 08 22 Tyrad Taylor go 23 Markingam RS 24 DeAndre opkomt w 0 G Pau YsTD 16 15 16 3302 16 4577 15 00:12 13 3296 16 4093 16 4446 16 4515 16 4134 15 16 3324 15 15 3104 10 287 16 D 15 3547 16 D 10 0 16 4505 15 2799 16 15 0 2 0 D 0 D O O O 655 o O 0 Ruth Yds TO 586 1305 16 754 28 5 355 7 299 1) 179 10 9 10 12 14 47 13 357 1291 7 53 13 222 0 1327 2 160 728 0 1105 12 143 . 127 1124 0 0 0 0 0 D 2 0 347,92 319.3 29.4 295.88 295.10 281.74 277.62 273.64 210,4 267.56 260.74 260.00 256.6 255.20 2490 2422 237,85 23.4 -2301 22.1 0 O POG 21.2 0 213 D 182 D 185 D 10. D 217 D 174 D 17.1 D 160 D 16.4 D 174 D 16.3 12.1 D 37 D 156 0 15.1 0 14.5 14- 14.3 143 133 O PIT DAI PIT LAR LAX KC 9 0 0 a 0 O 0 O D O O D O 1 2 8 1 0 O 0 455 3 0 0 NIVE Oly 21 0 22 0 0 30 14 0 0 0 O 0 LAC ATI SUF 8 Woo 0 O D D D D H26 470 0 0 416 1378 5 4 0 0 0 13 0 0 a 4 12 D 0 D D D 0 0 O D ON non 220 D D 0 LU o 1 G 1 1 M N D it O . D TEZE 0 25 11 O 12 15 0 00 312 0 0 O 0 9 0 CIN TEN PIT OAK IND NYU 153) 0 0 101 0 0 13.2 TA 15 0 0 0 O 0 99 0 22 13 18 0 0 D D O D D BET O D D 0 D 0 5 0 0 4 5 6 D 0 0 0 0 0 260 124 113 2 6 0 0 0 2 3496 3098 2926 0 0 3500 O 3468 HU 44 5 210.7 210.18 2003 266.44 205.92 205.41 2046 200 201.66 1942 182.33 185.00 0 D 61 D 0 O 0 15 0 O 25 Andy Non QD 26 Marcus Mariota G0 22 Antonio Brown WA 20 Derek Carr 00 29 Iacoby se 30 osh Mccown 08 31 Sean McCoy RS 12 Backsonvillers OST 33 Lames Wint OB 14 Leonard Fournette RO 35 Manning an 36 loe Haco QU 37 Baltimore Ravens DST 18 in Alles WR 19 free 440 lordans Howard RO 41 Destone Kit 08 Carlos de Greelerle 4 Deshaun Watson 45 Mosley 46 Bobby Warner TLD 47 Dion tew RD 45 Derventa Freeman HD Sheets 36 15 14 15 16 1) 16 16 13 13 15 16 16 16 10 16 15 16 14 7 10 16 10 14 LAX TH MAX NYG BAL KAL LAC DAL CHI CLE 11 O 11 13 0 1010 26 54 0 0 1 1 0 1 0 59 0 0 36 0 0 0 102 26 23 0 0 0 21 0 0 0 0 22 1 0 12 0 0 0 0 0 362 0 0 0 0 55 0 0 0 0 41 0 0 D 0 o 15 D 0 0 0 COET 092 981 O 19 18 0 0 0 0 11 0 0 19 0 0 0 15.8 12.8 127 15.5 145 12.5 11.6 116 114 1. 11 117 10.9 121 221 104 10.4 0 22 0 1 0 0 0 0 2 0 o 0 0 0 0 0 7 9 5 D D 0 0 125 0 0 0 0 a 2294 0 0 1600 D 0 0 0 1122 127 1767 175.66 O 0 1122 419 940 0 269 0 0 0 os 0 175 0 0 o 2 170 00 OSE 0 0 0 0 . 0 0 1 O 0 0 0 0 2 2 0 0 LAR NOU ML SRA NE ATL 0 D 3 WIT 0 0 2 0 0 0 1 0 0 O COON 0 0 190 32 214 117 ON 1065 164 165 1642 0 D 0 166 1 D 0 117 7 DET NE 49 Tyreek Hill WR SO Marvin Jones WA 51 Stephen Gostkowska 15 36 36 DOO HO 59 0 0 0 0 75 61 1183 1101 0 OOO 0 0 0 0 0 OOO 109 103 102 1642 1641 154 0 0 D 10 Type here to search O EI E om 8 ENG 1141 AM 2/1/2021 Extra Credit 2: Using the same NFL Fantasy Stats dataset, sort the top NFL players in descending order by passing yards, TDs, and rushing yards (hint: try using the 'sortrows' function). Print the names of the top 10 players in passing yards, TDs, and rushing yards using fprintf
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
