Question: What do you need to do? Write a function with one input and two outputs called get_data. The function will read an excel file and
What do you need to do? Write a function with one input and two outputs called get_data. The function will read an excel file and return the relevant data. 1. The input will be the filename (a string) that we wish to read. b. a. The two outputs will be spreadsheet spreadsheet. i. num the matrix containing the numeric data in the ii. txt the cell array containing the text data in the 2. Write a function with two inputs and two outputs named scores a. The two inputs will be i. num, txt The variables returned from part 1. The two outputs will be b. i. mc The multiple choice scores for each student. ii ess - The essay scores for each student. 3. Write a function with two inputs and two outputs named calc_grades The two inputs will be i. mc, ess The multiple choice and essay scores from part2. a. b. The output will be i. grades - The final grades for each student. A student's final grade will be calculated using the following formula: grade-, (#correct answers for MC part) * 5 + (Essay score) 4. Using the above functions, create a script that calculates the students' final grades and plots a histogram of the data with bins of [10, 20, 90, 100)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
