The file named FootballProblem8.xlsx shows statistics on NFL quarterbacks. Enter a QB’s name in cell G3 and a statistic in cell H3. Then write a formula that returns in cell I3 the QB’s statistic.

Transcribed Image Text:

1 UN. 2 A 3 Name 4 Statistic 5 Row Name 6 Column Statistic 7 Value 8 9 Name 10 Nick Foles 11 Peyton Manning 12 Josh McCown 13 Philip Rivers 14 Aaron Rodgers 15 Drew Brees 16 Russell Wilson 24 Andy Dalton 25 Cam Newton 26 Tom Brady 27 Andrew Luck 28 Matthew Stafford 29 Mike Glennon 30 Carson Palmer 31 Robert Griffin III 32 Ryan Fitzpatrick 33 Ryan Tannehill 34 Matt Cassel GNB NOR SEA 17 Tony Romo DAL 18 Ben Roethlisberger PIT 19 Colin Kaepernick SFO 20 Sam Bradford STL 21 Matt Ryan ATL 22 Jay Cutler 23 Alex Smith 35 Kellen Clemens 36 Case Keenum 37 Christian Ponder 38 EJ Manuel 39 Jason Campbell 40 Chad Henne Team 41 Joe Flacco 42 Matt Schaub 43 Brandon Weeden 44 Eli Manning 45 Terrelle Pryor 46 Geno Smith 47 Team PHI DEN CHI SDG CHI KAN CIN CAR NWE IND DET TAM ARI WAS TEN ΜΙΑ MIN STL HOU MIN BUF CLE JAC BAL HOU CLE NYG OAK NYJ B с 13 22 16 8 16 = 16 16 15 16 16 Enter answers in yellow section Enter Name Enter Statistic Enter function to find Row of Name (use cell references from above in function) Enter function to find Column of Statistic (use cell references from above in function) Enter function to show value found (use cell references from above in function) G Y/G 109 105.5 9 104.9 104.7 101.2 96.7 92 91.6 90.9 89.6 89.2 === 7 16 11 15 16 111 16 16 16 == 16 13 16 13 11 16 9 10 8 9 29 10 9 15 16 10 8 D 616 QBRat Comp Att 119.2 115.1 16 11] 16 89.1 88.8 88.8 87.3 87 84.2 83.9 83.9 82.2 82 81.7 81.6 78.8 78.2 77.9 77.7 76.9 E 76.5 73.1 73 70.3 69.4 69.1 66.5 203 450 149 378 193 446 257 342 375 243 159 439 224 308 363 292 380 343 371 247 362 F LL 274 217 355 153 142 137 152 180 180 305 362 219 141 317 156 247 317 659 224 544 290 650 407 535 584 416 262 651 355 508 586 473 628 570 634 416 572 456 350 588 254 242 253 239 306 317 503 614 358 267 551 272 443 G Pct 64 2891 222.4 5477 68.3 342.3 66.5 1829 228.6 69.5 4478 279.9 66.6 2536 281.8 68.6 5162 322.6 63.1 3357 209.8 63.9 3828 255.2 4261 64.2 58.4 3197 1687 4515 2621 3313 4293 60.7 67.4 266.3 199.8 241 282.2 238.3 220.9 268.3 3379 211.2 4343 271.4 60.2 3822 238.9 58.5 4650 290.6 59.4 2608 200.6 63.3 4274 267.1 60.1 3203 246.4 62 2454 223.1 60.4 3913 244.6 60.2 1807 200.8 58.7 1673 167.3 54.2 1760 220 63.6 1648 58.8 1972 56.8 60.6 63.1 60.6 H Yds 61.9 61.7 60.5 59 61.2 52.8 57.5 57.4 55.8 183.1 197.2 2015 223.9 3241 3912 244.5 216.1 2310 1731 216.4 3818 238.6 1798 163.5 3046 190.4 231 J Y/A 9.1 o co co co co cotto 8.3 8.2 1322792231 8.2 8.7 7.9 8.2 7.2 7.3 7.7 6.4 6.9 7.4 6torT66767 6.5 7.3 7.1 6.9 6.7 7.3 الناقد 6.3 7.5 979 577 6666666666 7 6.7 7.1 7 6.9 97 7 6.9 6.4 6.4 6.4 6.4 6.5 55969 6.5 6.9 6.6 6.9 TD K 27 55 13 32 17 39 26 31 28 21 14 26 19 23 33 24 25 23 29 19 24 16 14 24 11 8 9 or 7 11 11 13 19 10 9 18 7 12 Int 2 10 1 11 6 12 9 10 14 8 4 17 12 7 20 13 11 9 19 9 22 12 12 17 R66996 NNWONEN 7 8 14 22 14 9 27 11 21