MiniProject Table Processing - Part1 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 ALD Digital Systems SLD 10 18 68 74 6 18 8 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 Cont 1890 192 192 1938 199 199 4LD 1 UD SUD BUD 3 UD 2 UD 1 UD 4 GR 1 GR 4 Rashtian Ghiasi Knoesen, Yankelevich Kelner Al-Asaad Amirtharajah Amirtharjah Radulaski Homayoun Cheung Munday Martinez Lopez Akella Al-Asaad 1 1 28 206 200C Grad Res Gp Conf Research Research 2000 209 12.11,4,1 1,1,12, 8,4,3,4 1 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 MiniProject Table Processing - Part1 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 ALD Digital Systems SLD 10 18 68 74 6 18 8 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 Cont 1890 192 192 1938 199 199 4LD 1 UD SUD BUD 3 UD 2 UD 1 UD 4 GR 1 GR 4 Rashtian Ghiasi Knoesen, Yankelevich Kelner Al-Asaad Amirtharajah Amirtharjah Radulaski Homayoun Cheung Munday Martinez Lopez Akella Al-Asaad 1 1 28 206 200C Grad Res Gp Conf Research Research 2000 209 12.11,4,1 1,1,12, 8,4,3,4 1 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
