USING SAS 1.(5 pts.) An Excel file named ‘students’ of the scores from the last
ID: 3747622 • Letter: U
Question
USING SAS
1.(5 pts.) An Excel file named ‘students’ of the scores from the last semester for a statistics course is given. The following is a guideline for the overall final grade and the final exam score is out of 150 points, which means it should be recalculated to out of 100 points first. For example, if a student got 120 points on final exam, the actual score should be (120/150)*100=80 points.
Exam #1 (out of 100 points)
20%
Exam #2 (out of 100 points)
20%
Final Exam (out of 150 points)
30%
Quiz #1- Quiz #5 (out of 10, respectively)
15%
HW #1 – HW #2 (out of 50, respectively)
15%
Total
100%
Note that the final grade is assigned as follows: A for 90-100%; B for 80-89%; C for 70-79%; D for 60-69%; F for 59% or under.
1. Calculate the overall final score for each student.
2. Create a new data set called ‘grade_A’ and print out the overall final score for A-Grade students only.
3. Print the student identification number, the overall final score, and the final grade only.
Exam #1 (out of 100 points)
20%
Exam #2 (out of 100 points)
20%
Final Exam (out of 150 points)
30%
Quiz #1- Quiz #5 (out of 10, respectively)
15%
HW #1 – HW #2 (out of 50, respectively)
15%
Total
100%
K-2 0 4 10 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 8 0 0 0 8 8 8 1 1 8 9 5 0 0 0 5 8 0 0 0 0 0 18 7597 6290739 08856589620047 45606366087099 4009993 7090877095000404 997682450908300 9 8698871 40095816776 1 7 8 00080507086 00088030808 0 1 0 0 8 187-13 0 0 85680002077 347 2 3. 2 3719 77947 8 2 2 12345 6 7 8 9 10 1 2 3 4 5 6 7 8 9 20 21 2 3 4 5 6 7 8 29 30 1 2 3 4 5 6 7 8 9 4 4 4 4 4 4 8Explanation / Answer
for the answer to this question I am doing the calculation for the first student '14001716', rest you can do it on your own.
= 20% exam_1 + 20% exam_2 + 30% final_exam + 15%(Quiz_1 + Quiz_2 + Quiz_3 + Quiz_4 + Quiz_5) + 15%(hw_1 + hw_2)
= 20%(82/100 *100) + 20%(86/100*100) + 30%(123/150 *100) + 15%(0+0+4/10*100 + 0 + 4/10*100) + 15%(42/50*100 + 39/50 *100)
= 16.4 + 17.2+ 24.6 + 12 + 24.3
= 94.5, this is the overall final score for the first student.
follow the same procedure for the rest of the students.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.