Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Before creating any visuals, the first step is to clean the data. Clean the quarterback names so that they are displayed as LastName, FirstName.

2. Before creating any visuals, the first step is to clean the data. Clean the quarterback names so that they are displayed as "LastName, FirstName". For example: "Tannehill, Ryan" (no quotes). There should be no leading or trailing spaces. In the pass-2011 sheet, create the succession of columns needed to iteratively perform this cleansing. These cleansing formulas need to be filled down the entire row, meaning that the same formula is applied to all the names. This makes it future proof if more data was ever added. A viewer should be able to see how you cleaned this data by clicking on the cells and looking at your formulas. Note: You will need to do this in every sheet, but we will be removing the other sheets shortly. 3. You will need all the statistics in a single worksheet. For each sheet, create a column called "Year" and populate it with the year that the record is from. Create a new worksheet called "Quarterback Analysis". Remove the gridlines from this sheet (should appear as a white page with no lines). Move the data from the other sheets (pass-2011 through pass-2020) into this new sheet, starting in cell A1. Regarding the name, only copy over your newly formatted name, not the original data. Use grouping to hide/show this data. After moving the data to the new sheet, delete all other worksheets EXCEPT pass-2011 and Quarterback Analysis. 4. All the raw data that you are creating your visuals/controls from should not be seen - hide it with your choice of method(s). -I have pass worksheet from 2011 to 2020. A-Player. B Tim. C Cmp. D-Att. E-Comp%. F-Yds. G-TD. H-Int. I-Lng. J-Y/G. K-QBR. L-Sk. the player name is Drew Bree*\BreeDr00 Glossary: Player - Player (suffixes: * - Pro Bowl, + - All-pro) Tm - Team Cmp - No. of Pass completions Att - No. of Pass attempts Cmp% - Completion % Yds - Total Passing yards TD - No. of TDs Int - No. of Interceptions Lng - Longest completion (yds) Y/G - Yards/game QBR - ESPN's Total QB Rating Sk - No. of times sacked Y/A - Yards/pass attempts Y/C - Yards/completion TD% - TD % (No. of TDs/No. of attempts) Int% - Interceptions % (No. of Ints/No. of attempts. I need this in excel and formula please.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Contemporary Approach

Authors: David Haddock, John Price, Michael Farina

5th Edition

126078035X, 978-1260780352

More Books

Students also viewed these Accounting questions

Question

=+a) Is this an experiment or an observational study? Explain.

Answered: 1 week ago

Question

2. To store it and

Answered: 1 week ago