Question
2. Write a script to apply this function to the provided spreadsheet data. For each student, do the following: a. Each students data is stored
2. Write a script to apply this function to the provided spreadsheet data. For each student, do the following:
a. Each students data is stored in a separate sheet. To simplify things, prompt the user for the number of students using input( )(there are 5 students provided in the excel sheet) (theoretically), and use a for loop to sequence through the students. (Some guidance is given in the template.)
b. Read in the data using xlsread(). The spreadsheet file has multiple sheets, and you need both the text and the numerical data, so use this form: [numericalData, textData] = xlsread(filename, sheet) Matlab will load the numerical data into a matrix, and the text data into a cell array.
(Note: this is just to illustrate the form of the function call; you dont have to use the
same variable names as in the example!)
c. Extract the data from the arrays that were created in part b, and put them into a struct, which will be one element of a struct array called students
d. Call the GPA function, passing the struct as an argument.
e. Print out a message like the one shown in the example of problem 1 (John Does overall GPA is...
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started