solve it in matlab

An Excel spreadsheet contains course enrollment data. The data is given in Excel and in a format that requires preprocessing in Matlab before an analysis can be done. The data is given in the following format (the file can be much larger, and the option to directly modify the data in the Excel file is not desirable). Intro Dig & Analog Sys Digital Systems I 10 18 4LD 5LD 68 74 IRS 6 189U 192 8 1 1 Engineering Prob Solving Opto-Electronics Internship in ECE Internship in ECE Senior Design project Special Study for Adv UG Special Study for Adv UG Digital Image Processing Grad Res Gp Conf 192 193B 4LD 4UD SUD 3 UD BUD 2 UD JUD 4GR 1 GR Rashtian Ghiasi Knoesen Yankelevich Kolner Al-Asaad Amirtharajah Amirtharajah Radulaski Homayoun Cheung Munday Martinez Lopez Akella Al-Asaad 199 199 28 206 290C 1 Grad Res Gp Conf Research Research 290C 209 209 12,11,4,1 4,1,12, 8,1,3,4 I GR GR GR The objective is to estimate the student credit hours (SCH) from the data. SCH equals the units * students enrolled. Write a function readTheRawData to read the input excel file consiting of 14 records and produces an output table rawDataOut consisting of six strings columns. The table should consists of six strings arrays columns with column variables names: "CourseName", "CourseNumber", "Units", "Level", "Instructor" and "Enrollment". Use the data import tool to auto generate the code. (Refer to video: Importing Data as LiveScript) For example: clear; rawDataOut=readTheRawData("Spring 2020 TestData.xlsx"); summary(rawDataOut) Variables: CourseName: 14x1 string CourseNumber: 14x1 string Units: 14x1 string Level: 14x1 string Instructor: 14x1 string Enrollment: 14x1 string