Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

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 Security

Authors: Alfred Basta, Melissa Zgola

1st Edition

1435453905, 978-1435453906

Students also viewed these Databases questions

Question

a score of 70 or higher on the test?

Answered: 1 week ago