business homework 28

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.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.