Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MiniProject Table Processing - Part1 An Excel spreadsheet contains course enrollment data. The data is given in Excel and in a format that requires preprocessing

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David Kroenke

11th Edition

0132302675, 9780132302678

More Books

Students also viewed these Databases questions