python

Read the excel file "students 44.xls". The excel file contains the name, 2 quiz grades, 2 midterm grades and a final grade for each student as displayed below. Name AMAN JAISWAL SUNIL KUMAR AADITYA BHARAT ABHISHEK ANAND ABHISHEK TIWARI AMAN GUPTA Quiz 1 Quiz 2 Midterm 1 Midterm 2 Final 78 99 55 65 76 55 46 56 52 51 100 79 87 86 98 34 26 25 46 33 64 90 32 72 73 79 100 72 65 94 Create a data structure array named student with four fields: name, quiz, midterm, final and letter which keep records of the students listed in the excel file. 2 quiz grades, 2 midterm grades and 1 final grade for each student should be obtained from the excel file. Calculate the weighted average of each student based on the following formula: Grade = 0.25 x QuizAverage +0.35 x Midterm Average + 0.4 x FinalAverage Determine the letter grade for each student and assign the letter grade to the letter field of the related student based on the following table: 75