Math 123 Quantitative Reasoning Quiz 3 - Sec 8-9 Descriptive Stats, Weighted Average 1. The Ivy Tech Basketball team had the following scores for their season: 72 88 57 88 91 67 42 92 Mean = _______________ (round to three decimal places) Median = ______________ Mode = ________________ (enter N/A if the mode does not exist) 25th Percentile = ____________ 75th Percentile = ____________ Maximum = _____________ Minimum = _____________ Range = ________________ 2. Many students work part-time. This past week, a group of students reported their hours worked as 20, 12, 8, 6 and 12. Mean = _______________ (round to one decimal place) Median = ______________ Mode = ________________ (enter N/A if the mode does not exist) 25th Percentile = ____________ 75th Percentile = ____________ Maximum = _____________ Minimum = _____________ Range = ________________ 3. A company has the pay scales below, with the percent of employees receiving that pay listed. Find the best value to represent an average salary at this company. (round to the nearest dollar) Job Entry Expert CEO Salary $30,000 $40,000 $125,000 Percent of Employees 60% 38% 2% Math 123 Quantitative Reasoning Quiz 3 - Sec 8-9 Descriptive Stats, Weighted Average 4. Find the GPA for the student: (round to one decimal place) Course Credits Grade Points English 4 C 2.0 Philosophy 4 A 4.0 Science 3 D 1.0 Success seminar 1 B 3.0 Questions 5-6. Use the Excel screenshot to answer the questions. 5. What formula would need to be typed into Excel in order to have Excel calculate the student's weighted average grade? 6. Use Excel to calculate the weighted grade. (enter as a percentage rounded to two decimal places)