business homework 28

Get perfect grades by consistently using www.college-experts.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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.

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper