Math 123 Quiz 3 - Sec 8-9 Quantitative Reasoning 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 the thousandths place) 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 the tenths 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 Salary Percent of Employees Entry $30,000 60% Expert $40,000 38% CEO $125,000 2% Math 123 Quiz 3 - Sec 8-9 Quantitative Reasoning Descriptive Stats, Weighted Average 4. Find the GPA for the student: (round to the tenths 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 the hundredths place)