Question: How to get more specific outputs within a data set on Excel? I am trying to figure out division and conference wins and ties using

How to get more specific outputs within a data set on Excel?

I am trying to figure out division and conference wins and ties using the data sets below?

How do I go about this? I've tried numerous ways, but I can't quite figure it out.

How to get more specific outputs within a data

24 DAL A B D E F 1 Date Visitor Vscore Home Hscore Winner 2 9/10/2020 HOU 20 KC 34 KC 3 9/13/2020 SEA 38 ATL 25 SEA 4 9/13/2020 IND 20 JAC 27 JAC 5 9/13/2020 PHI 17 WAS 27 WAS 6 9/13/2020 MIA 11 NE 21 NE 79/13/2020 GB 43 MIN 34 GB 8 9/13/2020 CLE 6 BAL 38 BAL 9 9/13/2020 NY) 17 BUF 27 BUF 10 9/13/2020 CHI 27 DET 23 CHI 11 9/13/2020 LVR 34 CAR 30 LVR 12 9/13/2020 LAC 16 CIN 13 LAC 13 9/13/2020 ARI SF 20 ARI 14 9/13/2020 TB 23 NO 34 NO 15 9/13/2020 17 LAR 20 LAR 16 9/14/2020 PIT 26 NYG 16 PIT 17 9/14/2020 TEN 16 DEN 14 TEN 18 9/17/2020 CIN 30 CLE 35 CLE 19 9/20/2020 JAC 30 TEN 33 TEN 20 9/20/2020 NYG CHI 17 CHI 21 9/20/2020 17 TB 31 TB 22 9/20/2020 DEN 21 PIT 26 PIT 23 9/20/2020 ATL 39 DAL 40 DAL 24 9/20/2020 MIN 11 IND 28 IND 25 9/20/2020 LAR 37 PHI 19 LAR 26 9/20/2020 DET 21 GB 42 GB 27 9/20/2020 BUF 31 MIA 28 BUF 28 9/20/2020 SF 31 NYJ 13 SF 29 9/20/2020 WAS 15 ARI 30 ARI 30 9/20/2020 KC 23 LAC 20 KC o/20/2020 H Tie Team Visitor TIE Team Home AFC Division Wins NFC Division Wins NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE NO TIE CAR 21 PAL 22 Oul 16 PA MO TIS NOTIC F G H E Wins TIE 7 0 0 Adjusted Wins Division Wins Division Ties Adjusted Division Wins 7 0 10 0 2 10 2 0 0 13 0 13 0 11 0 11 0 4 1 4.5 0 12 0 12 0 A B 1 Abbr. Team Name 2 NE New England Patriots 3 MIA Miami Dolphins 4 NYJ New York Jets 5 BUF Buffalo Bills 6 BAL Baltimore Ravens 7 CIN Cincinnati Bengals 8 PIT Pittsburgh Steelers 9 CLE Cleveland Browns 10 HOU Houston Texans IND Indianapolis Colts 12 TEN Tennessee Titans 13 JAC Jacksonville Jaguars 14 DEN Denver Broncos 15 LAC Los Angeles Chargers 16 LVR Las Vegas Raiders 17 KC Kansas City Chiefs D Division Conference AFC East AFC AFC East AFC AFC East AFC AFC East AFC AFC North AFC AFC North AFC AFC North AFC AFC North AFC AFC South AFC AFC South AFC AFC South AFC AFC South AFC AFC West AFC AFC West AFC AFC West AFC AFC West AFC K Rank Team Name 10 New England Patriots 6 Miami Dolphins 15 New York Jets 2 Buffalo Bills 4 Baltimore Ravens 13 Cincinnati Bengals 3 Pittsburgh Steelers 4 Cleveland Browns 14 Houston Texans 6 Indianapolis Colts 6 Tennessee Titans 16 Jacksonville Jaguars 12 Denver Broncos 11 Los Angeles Chargers 9 Las Vegas Raiders 1 Kansas City Chiefs 11 0 11 0 4 0 4 0 10 0 10 0 10 0 10 0 1 0 1 0 5 0 5 0 6 0 6 0 8 0 0 0 8 14 14 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

You are required to make a short summary of a proceeding paper below: A Tutorial on Simulation Conceptual Modeling by Stewart Robinson (2017) Using your creativity, write a 3 pages summary. Highlight...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

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...

please read chapter and answer the following questions. All answers must be typed. thank you, will give thumbs up. 1. What kind of structure, controls, and culture would you be likely to find in (a)...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

Criteria Exemplary 6 points Accomplishe d 4.8 points Developing 3.6 points Beginning Minimum Below Standards 2.4 points 1.2 points Formulated, wrote, interpreted, argued, and evaluated...

2. Data Analysis and Interpretation Strategies 12 Analysis . Analysis transforms data into findings. . No formula exists for that transformation. DATA DATA EVERYWHERE Guidance, yes. But no recipe....

Management 587 Case/Assignment/Summary Activity Name Texas A&M-Commerce In partial fulfillment of the requirements for MGT 587 Professor Lloyd M. Basham June 8, 2014 (The above [and the next 3 lines]...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

An industrial furnace is to be controlled as follows: The contacts of a bimetallic strip inside the furnace close if the temperature falls below the set point and open when the temperature is above...

To form a pendulum, a 0.092 kg ball is attached to one end of a rod of length 0.62 m and negligible mass, and the other end of the rod is mounted on a pivot. The rod is rotated until it is straight...

Are two financial statements, the statement of cash flow and statement of shareholder equity?

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...