WPC 300 Latest Update Already Graded A+

WPC 300 Latest Update Already Graded A+ Section A Instructions: Use the following data file for this section Section A-Data [Dataset # 1]Preview the document Remember the honor code. This section is worth a total of 37.5 points. In addition to responding to multiple-choice questions, you need to submit an updated data file with your name appended to the front of the filename (e.g. firstname_lastname_filename). Create 2 new columns as follows: The first new column shows the outcome when you calculate the total score for a school as a combination of 'critical reading mean' + 'mathematics mean' + 'writing mean'. The second column will use a vlookup() function to segment the performance of a school according to the data outlined in the Table. Make sure you correctly implement this table on your excel file first before using them on a vlookup(). Total score Performance 0-1099 D C B 1400+ A Upload Create a pivot table on a new sheet to calculate how many schools were in each performance category. Show the outcome in both a table and a pie chart. Screenshot of the 2 new columns (1 screenful is enough), pivot table output, and pie chart output (3 x 6 points). Create a word document (that you will upload here) and paste those screenshot in sequence as follows: 1. Two-column output. 2. Pivot Table output 3. pie chart output 1221 - Not 100% that it's the correct answer What is the average (with 0 decimal places) across all schools for the total score? 1221 1215 1229 1287 C Which performance category has the greatest number of schools? A B C D A Which performance category has the least number