data in Range N$6$: Y$43$ describes NFL quarterback $($QB$)$ statistics for the $2013$ season. Write different formulas for the following questions. Name Team G QBRat Comp Att Pct Yds Y$/$G Y$/$A TD Int

Nick Foles PHI $13119\mathrm{.}2203317642891222\mathrm{.}49\mathrm{.}1272$

$1)$ Using Lookup functions Peyton ManningDEN $16115\mathrm{.}145065968\mathrm{.}35477342\mathrm{.}38\mathrm{.}35510$

QBRat Formulatext of column C Josh McCownCHI $810914922466\mathrm{.}51829228\mathrm{.}68\mathrm{.}2131$

Ben Roethlisberger Philip RiversSDG $16105\mathrm{.}537854469\mathrm{.}54478279\mathrm{.}98\mathrm{.}23211$

Colin Kaepernick Aaron RodgersGNB $9104\mathrm{.}919329066\mathrm{.}62536281\mathrm{.}88\mathrm{.}7176$

Sam Bradford Drew BreesNOR $16104\mathrm{.}744665068\mathrm{.}65162322\mathrm{.}67\mathrm{.}93912$

Matt Ryan Russell WilsonSEA $16101\mathrm{.}225740763\mathrm{.}13357209\mathrm{.}88\mathrm{.}2269$

Jay Cutler Tony RomoDAL $1596\mathrm{.}734253563\mathrm{.}93828255\mathrm{.}27\mathrm{.}23110$

Alex Smith Ben RoethlisbergerPIT $169237558464\mathrm{.}24261266\mathrm{.}37\mathrm{.}32814$

Andy Dalton Colin KaepernickSFO $1691\mathrm{.}624341658\mathrm{.}43197199\mathrm{.}87\mathrm{.}7218$

Cam Newton Sam BradfordSTL $790\mathrm{.}915926260\mathrm{.}716872416\mathrm{.}4144$

Matt Ryan ATL $1689\mathrm{.}643965167\mathrm{.}44515282\mathrm{.}26\mathrm{.}92617$

$2)$ Using Match Function to return the row and column of the selected Jay Cutler CHI $1189\mathrm{.}222435563\mathrm{.}12621238\mathrm{.}37\mathrm{.}41912$

Alex Smith KAN $1589\mathrm{.}130850860\mathrm{.}63313220\mathrm{.}96\mathrm{.}5237$

row number Formulatext of column C column number Formulatext of column F Andy DaltonCIN $1688\mathrm{.}836358661\mathrm{.}94293268\mathrm{.}37\mathrm{.}33320$

Robert Griffin III QBRat Cam NewtonCAR $1688\mathrm{.}829247361\mathrm{.}73379211\mathrm{.}27\mathrm{.}12413$

Christian Ponder Pct Tom Brady NWE $1687\mathrm{.}338062860\mathrm{.}54343271\mathrm{.}46\mathrm{.}92511$

Jason Campbell Y$/$G Andrew LuckIND $168734357060\mathrm{.}23822238\mathrm{.}96\mathrm{.}7239$

Chad Henne Y$/$A Matthew StaffordDET $1684\mathrm{.}237163458\mathrm{.}54650290\mathrm{.}67\mathrm{.}32919$

Tony Romo TD Mike GlennonTAM $1383\mathrm{.}924741659\mathrm{.}42608200\mathrm{.}66\mathrm{.}3199$

Russell Wilson Comp Carson PalmerARI $1683\mathrm{.}936257263\mathrm{.}34274267\mathrm{.}17\mathrm{.}52422$

Robert Griffin IIIWAS $1382\mathrm{.}227445660\mathrm{.}13203246\mathrm{.}471612$

Ryan FitzpatrickTEN $1182217350622454223\mathrm{.}171412$

$3)$ Using combined Index and Match function to return results Ryan TannehillMIA $1681\mathrm{.}735558860\mathrm{.}43913244\mathrm{.}66\mathrm{.}72417$

Formulatext of column D Matt CasselMIN $981\mathrm{.}615325460\mathrm{.}21807200\mathrm{.}87\mathrm{.}1119$

Robert Griffin III QBRat Kellen ClemensSTL $1078\mathrm{.}814224258\mathrm{.}71673167\mathrm{.}36\mathrm{.}987$

Christian Ponder Pct Case KeenumHOU $878\mathrm{.}213725354\mathrm{.}21760220796$

Jason Campbell Y$/$G Christian PonderMIN $977\mathrm{.}915223963\mathrm{.}61648183\mathrm{.}16\mathrm{.}979$

Chad Henne Y$/$A EJ Manuel BUF $1077\mathrm{.}718030658\mathrm{.}81972197\mathrm{.}26\mathrm{.}4119$

Tony Romo TD Jason CampbellCLE $976\mathrm{.}918031756\mathrm{.}82015223\mathrm{.}96\mathrm{.}4118$

Russell Wilson Comp Chad HenneJAC $1576\mathrm{.}530550360\mathrm{.}63241216\mathrm{.}16\mathrm{.}41314$

Joe Flacco BAL $1673\mathrm{.}1362614593912244\mathrm{.}56\mathrm{.}41922$

Matt SchaubHOU $107321935861\mathrm{.}223102316\mathrm{.}51014$

Q$3$ Using the data in "Data" Worksheet and return following information Brandon WeedenCLE $870\mathrm{.}314126752\mathrm{.}81731216\mathrm{.}46\mathrm{.}599$

Results Formula Eli ManningNYG $1669\mathrm{.}431755157\mathrm{.}53818238\mathrm{.}66\mathrm{.}91827$

$1)$ What is the average cost price of "small business" customer type? Terrelle PryorOAK $1169\mathrm{.}115627257\mathrm{.}41798163\mathrm{.}56\mathrm{.}6711$

$2)$ What is the total sales of "high" priority order? Geno SmithNYJ $1666\mathrm{.}524744355\mathrm{.}83046190\mathrm{.}46\mathrm{.}91221$

$3)$ What is the average sales when order date is after $1/1/2015?$

$4)$ What is the number of orders when order date is before $1/1/2015?$

$5)$ What is the average retail price sold by "Yvette Biti"?

$6)$ What is the total sales to customer located in Sydney?

$7)$ What is the number of orders to customer located in Sydney?

Q$4$ Using Pivot Table and Pivot charts to create an interactive dashboard for the following three information.

$1)$ The sales of each account manager by different customer type, using year as the slicer

$2)$ The to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 Accounting Questions!

Q:

data in Range N 6 : Y 4 3 describes NFL quarterback ( QB ) statistics for the 2 0 1 3 season. Write different formulas for the following questions. Name Team G QBRat Comp Att Pct Yds Y / G Y / A TD...

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Q:

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

Q:

STAT 2263 - UNB Online College of Extended Learning, University of New Brunswick Assignment #2: Probability Instructions: Students are advised to submit this assignment within 2 months of their...

Q:

An MBA program was experiencing problems scheduling its courses. Demand for the program's optional courses and specializations varied yearly. Within a year, students seem to want marketing courses;...

Q:

I had copied and pasted my lab, I don't understand how to do the histogram and statistical portion of this lab. Item 5: In-Lab Exercises (15 points) Exercise 1: Canine Variability In this part of the...

Q:

An Investigation into obesity rates Researchers have been interested in studying the obesity trends worldwide over the past 25 years. In 2014 the World Health Organization (WHO) declared there were....

Q:

Western Region Original Price Sale Price Days to Sell 82 60 20 140 123 26 80 70 16 89 50 72 135 120 18 146 143 109 80 80 79 125 100 130 70 60 100 81 52 96 103 95 14 118 100 33 136 100 101 101 50 55...

Q:

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Q:

The coefficient of static friction between block B and the horizontal surface and between the rope and support C is 0.40. Knowing that WA = 30 lb, determine the smallest weight of block B for which...

Q:

Many manufacturing organisations hold raw material stocks. Required: (a) (b) (c) (d) List three examples of holding costs. List two examples of stockout costs. List two examples of ordering costs....

Q:

in Alberta real estate transaction calculate a statement of adjustments for the sale of a condominium. The closing date is November 7, and the common expenses are $810 per month. Calculate the...

Q:

Which of the following is the best definition of ethics? Ethics are the values, which have developed throughout our lives and influence our moral behavior. Ethics are the standards for conduct that...

Q:

Explain recruiting technology.

Q:

Define and operationalize types of employment discrimination.

Q:

Describe sexual harassment in the global environment.

Previous Question Next Question