Upload the file and the answers to the two questions above.Create a table in Excel and solve for the following:
What proportion of students had an overall grade above 80%? (Round the calculations to the nearest whole number.)
How many students had a grade of B+ or higher?
In the table in Excel, you must use the SumProduct formula initially to calculate each studentâ€™s grade, and then use VLookup to enter the letter grade.
Next create a pivot table showing only the major, status (freshman or sophomore) and letter grade.
You have to submit an excel file â€“ not a pdf of the file – I need to be able to click on the cells and see the formula. The file will have two sheets, the first sheet is all the data you enter (and shows use of the SumProduct and VLookup formulas), and the second sheet is the pivot table.