EXAMPLE 13 Data for students in a statistics class Figure 12

EXAMPLE 1.3 Data for students in a statistics class.
Figure 1.2 below shows part of a data set for students enrolled in an introductory statistics class. Each row gives the data for one student. The values for the different variables are in the columns. This data set has eight variables. ID is a label for each student. Exam1, Exam2, Homework, Final, and Project give the points earned, out of a possible total of 100, for each of these course requirements. Final grades are based on a possible 200 points for each exam and the final, 300 points for Homework, and 100 points for Project.TotalPoints is the variable that gives the composite score. It is computed by adding 2 times Exam1, Exam2, and Final plus 3 times Homework plus 1 times Project. Grade is the grade earned in the course. This instructor used cutoffs of 900, 800, 700, etc. for the letter grades.

A student whose data do not appear on the spreadsheet scored 86 on Exam1, 82 on Exam2, 77 for Homework, 90 on the Final, and 80 on the Project. Find TotalPoints for this student and give the grade earned.

(Fill in the blanks below.)

TotalPoints = _____ (Give your answer as a whole number.)

Grade =______ (Give your answer as A, B or C.)

Solution

TOTAL POINTS = 2 (86 +82+90) + 3(77) +80 = 827

GRADE = B