OuarterBacks

Module 6 Assignment:
NFL Quarterback Comparison (MO-6.1 & 6.2)

 

The National Football League is the premier outlet for America’s sport: football. On a football team, the premier position is that of the quarterback. You are tasked with creating several interesting, interactive, dynamic visuals, including a dashboard, for analyzing quarterback statistics. The starting file contains quarterback statistics for a period of ten years. The descriptions of the column headers are on the last page of this document.

Complete the following requirements using the Quarterbacks.xlsx file:

  1. Save the file as QuarterbacksDashboard(your last name).xlsx.
  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-2009 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-2009 through pass-2018) 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-2009 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).
  5. With the data in place, you are ready to create your visuals. On this worksheet, you are tasked to create visuals. The decision on what size to make them, where to place them, colors, and other formatting choices are up to you. Ensure that your design choices aid in the ease of interpreting and understanding how to use the worksheet and how to make sense of the visuals themselves. Label all interactive features. All lists (dropdown, spin buttons, etc.) should be in alphabetical order. Use appropriate references (absolute vs. relative) where appropriate. The visuals you are tasked to create (in no particular order) are:
  • An area chart to “animate” changes between teams. The chart should show total passing yards per year for two selected teams. The overlap between the areas should be seen. Use two lists to allow the user to select the teams they wish to compare.
  • A combo chart that will display overall touchdowns as a clustered column and overall interception percentage as a line, per year. Use the scroll and zoom functionality to allow the user to dynamically shift the chart to see the years desired. Do not allow the chart to move beyond 2018.
  • A dynamic dashboard. The dashboard should include an area that displays the statistics for a selected player for all the years. Columns for the statistics should be displayed in the following order:
    • Cmp, Att, Cmp%, Yds, Y/A, Y/C, TD, TD%, Int, Int%, Lng, Y/G
      You will have to calculate Y/A, Y/C, TD%, and Int%

If a player does not have statistics for a given year, display a dash “-“ instead of a zero or error message. Above the statistics display area, allow for a user to select a player from a list of all players sorted alphabetically by last name. The statistics should be updated to reflect the player chosen from the list. Add appropriate conditional formatting to the Yds, TD, and INT% columns.

Create two more combo charts. One chart should compare two statistics of your choice for the player selected in the statistics display area. The other should be a chart that allows the user to pick the two statistics that are being compared. Use spin buttons to allow users to cycle through the statistics. Use different colors on the two charts. On both, add data labels and markers on the first and last data point. Ensure that your formatting stays consistent when changing statistics on the second chart.

  1. On the pass-2009 sheet, in column A, two rows down from the bottom of the data, type the following: “The quarterback with the most overall passing yards during this ten-year span is:” and the answer to this question.
  2. Save and close the QuarterbacksDashboard.xlsx file.

 

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)

 

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Essay USA, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Essay USA has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Essay Writing Services

At Essay USA, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.

Admissions

Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.

Editing

Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.

Coursework

Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.