Write a MATLAB program that will:

Load student data from the Excel file student$\_$data.xlsl$.$ The student$\_$data file contains each student$$s grades for four exams in a class as well as weight for each exam. Close the file. $[$num$,$ txt$,$ raw$]=$xlsread$(\text{'}$student$\_$data.xlsx$\text{'})$

Create an examWeight vector called examWeight, to hold the exam weights from the excel file. The numbers in the first row.

Create a Student structure array, called students, that will be populated with each student$$s information $($name$,$ grades$)$ available in the Excel file. A Student structure should have five fields extracted from the excel file. $($name$,$ exam$1,$ exam$2,$ exam$3,$ final, finalGrade, letterGrade$).$ After initialized the Student array, fill the structure array with data from the Excel file. the finalGrade and letterGrade to be filled in later.

Determine average for each of the four exams. Save your average grade in to a variable called avg$\_$grade$\_$of$\_$exams in order, it is a $1$x$4$ vector that holds the average for each exams.

Determine the final course grade for each student. The final course grade for each student is calculated by:

finalGrade$=($e$1*$e$1$Weight$+$e$2*$e$2$Weight$+$e$3*$e$3$Weight$+$final$*$finalWeight$)/100$

Save your findalGrade in the corresponding structure field of the strudent structure of each student.

$6.$ Determine how many students are above the class average, save it in a variable called num$\_$above$\_$average

$7.$ Determine the letter grade for each student, save it in the letterGrade field of each student.

finalGrade $>=90$ A

finalGrade $>=80$ B

finalGrade $>=70$ C

finalGrade $>=60$ D

otherwise F

Do the following on your own MATLAB installation to check your understanding yourself. No need to turn in the following parts:

Add two columns into the student$\_$data.xlsl file to the right of the Final column called Final Grade and Letter Grade. The Final Grade contains each student$$s final course grade, and the Letter Grade contains each student$$s letter grade for the class.

Create a new text file called student$\_$grade.txt that contains each student$$s name, final course grade, and letter grade for the course, one student at a line, separate fields with tab$/$spaces$.$

Element by element operation is allowed if that make it easier for a problem.

The program should work for student$\_$data.xlsl file in this format with any length.At the end, the first five students have info like the following:

Student id: $1,$ Name: Ashlyn, Exam$1$: $89\mathrm{.}00,$ Exam$2$: $76\mathrm{.}50,$ Exam$3$: $78\mathrm{.}00,$ Final: $55\mathrm{.}00,$ Final Grade: $70\mathrm{.}70,$ Letter Grade: C

Student id: $2,$ Name: Aston, Exam$1$: $90\mathrm{.}00,$ Exam$2$: $73\mathrm{.}00,$ Exam$3$: $95\mathrm{.}00,$ Final: $100\mathrm{.}00,$ Final Grade: $91\mathrm{.}60,$ Letter Grade: A

Student id: $3,$ Name: Austin, Exam$1$: $97\mathrm{.}00,$ Exam$2$: $97\mathrm{.}00,$ Exam$3$: $72\mathrm{.}00,$ Final: $76\mathrm{.}00,$ Final Grade: $83\mathrm{.}60,$ Letter Grade: B

Student id: $4,$ Name: Baer, Exam$1$: $74\mathrm{.}00,$ Exam$2$: $55\mathrm{.}00,$ Exam$3$: $87\mathrm{.}00,$ Final: $90\mathrm{.}00,$ Final Grade: $79\mathrm{.}20,$ Letter Grade: C

Student id: $5,$ Name: Battle, Exam$1$: $93\mathrm{.}00,$ Exam$2$: $94\mathrm{.}00,$ Exam$3$: $95\mathrm{.}00,$ Final: $100\mathrm{.}00,$ Final Grade: $96\mathrm{.}40,$ Letter Grade: A