Question: The file named Qb2013.xlsx gives NFL quarterback (QB) statistics for the 2013 season. Write formulas in cells J2 and K2 that return the QBs TDs

The file named Qb2013.xlsx gives NFL quarterback (QB) statistics for the 2013 season. Write formulas in cells J2 and K2 that return the QB’s TDs and interceptions when you type a QB’s name in cell I2. In cell 12 I have a dropdown box which I can use to select the name of an NFL QB. Write formulas in J2

In cell 12 I have a dropdown box which I can use to select the name of an NFL QB. Write formulas in J2 and K2 which place the QB's TD's in J2 and Interceptions in K2 10 points. Name Nick Foles Peyton Manning Josh McCown Philip Rivers Aaron Rodgers Drew Brees Russell Wilson Tony Romo Ben Roethlisberger Colin Kaepernick Sam Bradford Matt Ryan Jay Cutler Alex Smith Andy Dalton Cam Newton Tom Brady Andrew Luck Matthew Stafford Mike Glennon Carson Palmer Robert Griffin III Ryan Fitzpatrick Ryan Tannehill Matt Cassel Kellen Clemens Case Keenum Christian Ponder Team PHI DEN CHI SDG GNB NOR SEA DAL PIT SFO STL ATL CHI CIN CAR NWE IND DET TAM ARI WAS TEN MIN STL HOU MIN G 13 16 8 16 9 16 16 15 16 16 7 16 11 15 16 16 16 16 16 13 16 13 11 16 9 10 8 9 QBRat 119.2 115.1 109 105.5 104.9 104.7 101.2 96.7 92 91.6 90.9 89.6 89.2 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 Player Peyton Manning Comp 203 450 149 378 193 446 257 342 375 243 159 439 224 308 363 292 380 343 371 247 362 274 217 355 153 142 137 152 TD Att 11 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 Int Pct 12 64 68.3 66.5 69.5 66.6 68.6 63.1 63.9 64.2 58.4 60.7 67.4 63.1 60.6 61.9 61.7 60.5 60.2 58.5 59.4 63.3 60.1 62 60.4 60.2 58.7 54.2 63.6 Yds 2891 5477 1829 4478 2536 5162 3357 3828 4261 3197 1687 4515 2621 3313 4293 3379 4343 3822 4650 2608 4274 3203 2454 3913 1807 1673 1760 1648 Y/G 222.4 342.3 228.6 279.9 281.8 322.6 209.8 255.2 266.3 199.8 241 282.2 238.3 220.9 268.3 211.2 271.4 238.9 290.6 200.6 267.1 246.4 223.1 244.6 200.8 167.3 220 183.1 Y/A 9.1 8.3 8.2 8.2 8.7 7.9 8.2 7.2 7.3 7.7 6.4 6.9 7.4 6.5 7.3 7.1 6.9 6.7 7.3 6.3 7.5 7 7 6.7 7.1 6.9 7 6.9 TD 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 7 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 9 7 6 9

Step by Step Solution

★★★★★

3.32 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To return the QBs TDs and interceptions when you type a QBs name in cell I2 y... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!

The Accounts ReceivableConfirmation Statistics working paper shown on the next page was prepared by an audit assistant for the 2018 audit of Lewis County Water Company, Inc., a continuing audit...

The NFL rates its passers for statistical purposes against a fixed performance standard based on statistical achievements of all qualified pro passers since 1960. The current system replaced one that...

name in cell 1 2 . 1 3 . The file named NBAplayers.xIsx gives the age and salary for several NBA players. Enter formulas in cells J 5 :K 5 0 that return each player's age and salary. 1 4 . Column F...

(6. A cylinder weighing 120N rests between two frictionless walls as shown in the following figure. B 3 The wall reaction (N) at Point A is most nearly: (A) (B) (C) 96 139 150 200 (7. A body is...

Cell D2 of the file named Problem35data.xlsx gives Year 1 market size. Cell D3 gives market share (the same each year), cell D4 gives product price (the same each year), and cell D5 gives profit...

This problem is a difficult one. The file named Agingdata.xlsx gives the number of insurance claims projected to be received daily and the number of insurance company workers available. Each day, a...

The file named Footballdata.xlsx gives win-loss records for NFL teams during the 2015 season. Write a formula in H13 that can be copied to H14:H31 that gives the winning percentage for each team and...

The file named Assign.xlsx gives the assignment of workers to four groups. The suitability of each worker for each group (on a scale from 0 to 10) is also given. Write a formula that gives the...

The file named Buslist.xlsx gives the amount of time between bus arrivals (in minutes) at 45th Street and Park Avenue in New York City. Write a formula that, for any arrival time after the first bus,...

The file named Assign.xlsx gives the assignment of workers to four groups. The suitability of each worker for each group (on a scale from 0 to 10) is also given. Write a formula that gives the...

Each row of the file named Problem22data.xlsx gives the name of a city, the citys state, and population of the city. Use text functions to extract the state to a separate column.

Corruption and bribery are common in some countries. Would you avoid locating in such a country, or locate there and deal with it? If the latter, how would you deal with it?

When the price of houses increases, the wage rates for housing construction workers increase. What is the connection?

Using the diagram above, which of the following might have caused the outward movement of the production possibility frontier? (A) A decrease in the availability of fertile farmland (B) A plague of...

Language difficulties? P-635

A decision d is said to be dominated by another decision D if, for every outcome, the payoff from D is better than (or no worse than) the payoff from d. a. Explain why you would never choose a...

Besides the maximin, maximax, and EMV criteria, there are other possible criteria for making decisions. One possibility involves regret. The idea behind regret is that if you make any decision and...

Referring to the previous problem, another possible criterion is called expected regret. Here you calculate the regret for each cell, take a weighted average of these regrets in each row, weighted by...

C Part 1: Consider the following perpetual system merchandising transactions of Belton Company. Use a separate account for each receivable and payable, for example, record the sale on June 1 in...

Mo Meek, Lu Ling, and Barb Beck formed the MLB Partnership by making capital contributions of $81,900, $318,500, and $509,600, respectively. They predict annual partnership net income of $534,000 and...

Bonds Payable Bond Rates A bond is a type of note that requires the issuing entity to pay the face value of the bond to the holder when it matures and usually to pay interest at a specified rate....