The data on the scores obtained by students in 5 different entrance exams have been collected from 50 colleges and they are provided below. Create a PivotTable in Excel to display the number of students who had taken up each exam and the average score for students in each exam.
a. Which exam did most students attempt?
b. Which exam has the highest average score?
c. Use the PivotTable to determine the exam attempted by the student with the highest score. What is the exam attempted by the student with the lowest score?
Definitions:
Freight Costs
Expenses incurred by a company for transporting goods, which may include shipping, handling, and insurance fees.
Asset Retirement Costs
Costs associated with removing equipment or property from service and disposing of it in accordance with legal and regulatory guidelines.
Depreciable Asset
A tangible or intangible asset subject to depreciation, reflecting the decline in the asset's value over its useful life.
Delivery Truck
A vehicle used by companies to transport goods from one location to another.
Q2: The profit function for two types
Q3: Given below is a sample list of
Q6: Arterial hypertension of Cushing syndrome is associated
Q8: The most common form of congenital coagulopathy,
Q32: Reference - 10.3. Which of the following
Q41: If all the squared terms in a
Q41: The study of how changes in the
Q48: Jim is trying to solve a problem
Q53: A chart that is recommended as an
Q58: _ is the process of estimating the