Consider the following table containing the marks for so we tests and an Exami 69 Srident ID 93801 93810 93815 93945 92837 93820 93835 93838 93839 93840 93855 93857 93870 93871 Test 68 09 82 65 55 92 49 74 81 40 85 65 Test 2 71 66 81 72 49 89 58 86 65 39 70 88 153 48 91 81 63 95 54 89 62 47 55 91 68 The above data are stored in an Excel file umed student terin marks.xls, which can be downloaded from the Downloads Spreadsheet files section of eClass All marks are out of 100. The "final" mark of a student is computed as a weighted sum of the student's tests and the exam. The weights of Test 1. Test 2, and Exam are 25%, 35%, and 40%, respectively. Write a MATLAB program that does the following in the specified order (a) Read the student IDs, Test 1 Test 2 and Exam marks in the student_term_marks.xls file into a matrix Min MATLAB Note that you are not allowed to type the values into a matrix b) Compute the final mark for each student sang the wesghted sum of the student's tests and exam marka deseribed above. Then, display all the marks in the command window as follows: TD Test Test EN 2001 71 LO EP 22 2015 1 53 sas 45 73 92037 55 40 2030 23 5 GS 335 40 53 74 86 M D 40 MANN 70 49 55 co 35 The students test markes, and excam mark are displayed as integer The final markdisplayed above AL XXIX - sbould appear as the computed final mark with 1 decimal place. Do not type the total marks into your program. The values must be computed This also applies to the following steps (c) Compute the average of the final marks scores over all the students. Display the computed average in the command window as follows: Average of the final marks: XXXX Note that the average is displayed with 1 decimal place and on the same line as the string "Average of the final marks:". (d) Compute the number of students whose exam mark was higher than their final mark. Display the result in the command window as follows, where xxxx is the number of students: Number of students whose exam mark was highert XXXX e) Compute the number of students whose exam mark was lower than their final mark. Display the result in the command window as follows, where xXxx is the number of students: Bumber of students whose exam mazk was lower: xxxx (1) Compute the number of students whose final mark was above the average final mark calculated i Step e). Display the result in the command window as follows, where xxxx is the number of students: Number of students above average: xxxx (g) Examine the final marks and compute the number of students in each letter grade category. The letter grades and their corresponding numeric marks are as follows: F (0.40) E D [40, 50) (50.60) c (60.70) B A+ (70, 80) (80.90) 190, 100) The results should appear as follows, where xxxx is the number of students in each category. Number of A students xxx Number of students: xxxx Number of B students i xxx Number of students xxxx Number of students: XXXX Number of students: XXXX Number of students XXX
