The file named Qb2013.xlsx gives NFL quarterback (QB) statistics for the 2013 season. Write formulas in cells
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 QB’s TDs and interceptions when you type a QB’s name in cell I2.
Transcribed Image Text:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 57% (7 reviews)
To return the QBs TDs and interceptions when you type a QBs name in cell I2 y...View the full answer
Answered By
Devesh Singh
I am a professional academic writer, content creator and, copywriter with 4 years of research based experience. My passion for research, writing, and editing makes me the perfect professional for varying topics. I have graduated with a bachelor's degree in nursing and I understand the value of detailed research and original content that is plagiarism-free. I have a knack of paying attention in detail and adhering to rules. I will deliver professionally tasks and according to my client's instructions and expectations. I can speak and write fluent English. I'm also conversant with different writing styles including APA, MLA, Turabian/Chicago, IEEE, Vancouver and many others. Through my high school and University i was able to interact and learn different subjects including Engineering, computer science, human resource management, marketing, finance, accounting, biology, Sociology, English, Science, Nursing and many others.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
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...
-
(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...
-
The Assembly Department of Interface, Inc., manufacturer of computers, had 4500 units of beginning inventory in September, and 8000 units wore transferred to it from the Production Department. The...
-
In order to demonstrate the use of the re-measurement process, assume that at the beginning of the year a U.S. parent company invested 100,000 foreign currency B (FCB) to form a 100% owned...
-
Law Management Services began business on January 1, 2012, with a capital investment of $120,000. The company manages condominiums for owners (Service Revenue) and rents space in its own office...
-
What four components comprise the IT security defense-in-depth model?
-
The Town of Thomaston has a Solid Waste Landfill Enterprise Fund with the following trial balance as of January 1, 2012, the first day of the fiscal year. During the year, the following transactions...
-
Find the solution of the exponential equation, correct to four decimal places. e-3x=9 x=
-
It is December of 2020 and Frankie and Kensley Nguyen have come to you to discuss their 2020 tax situation and some changes they are proposing for the future. They are a married couple and have no...
-
The file named Employees.xlsx contains the rating (on a 010 scale) that each of 35 workers has given to three jobs. The file also gives the job to which each worker is assigned. Use a formula to...
-
In the file named Pinevalley.xlsx, the first worksheet contains the salaries of several employees at Pine Valley University, the second worksheet contains the ages of the employees, and the third...
-
Using an alphabetical list of all the students in your class, try the following methods of selecting a representative sample. a. Choose the first 10 students on the list. b. Has this method picked a...
-
Which method should be used if management anticipates a period of inflation? Why?
-
What are the four methods used to account for inventory?
-
What is high-frequency trading? Describe a strategy through which a high-frequency trader makes a profit.
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. The general rule of law regarding the passing of title is that title passes when the...
-
Can the EOQ model be used when a company faces seasonal demand fluctuations?
-
Consider the two graphs depicting the influence of advertisements on making large purchases for two different age groups, those 1834 years old and those 4554 years old (based on a Harris Poll of...
-
A genetically engineered strain of Escherichia coli (E. coli) is used to synthesize human insulin for people suffering from type I diabetes mellitus. In the following simplified reaction scheme,...
-
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...
-
Below figure find force between masses while system is being pushing by force of F=80.0N and makes the angle of 20 degrees. Friction coefficient between each mass and surface is 0.2. F=80N m,=5kg...
-
By looking at this image below, when is the particle speeding up? When is the particle slowing down? Please answer using interval notation. v = velocity a = acceleration s= position 30 30 20 20 10 10...
-
A horizontal meter stick with a scale that increases from left to right has a clamp at the 0.370 m mark (the 37.0 cm mark) from which a mass hanger with a weight is hung. The clamp has a mass of...
Study smarter with the SolutionInn App