I have to calculate the percentage of students that have been approved in a subject but haven't done the group work.

It has been given to us a table with every students' results in excel but I have been having some doubts on how to read the values I need. Can you help me? Thank you!

Answer 1

[Walter Roberson]

[num, str, raw] = xlsread('TheNameOfYourFileGoesHere.xls');

[Pedro Capitão]

So, in the file I have been given, the students' grades are in the final column (column 17) I need to determine the amount of students who have passed (students' grade >= 10) how do i know how many have passed and then calculate the percentage of those who have passed? Thank you!

[Walter Roberson]

size() can be used to determine how many rows there are.

When you test a vector >= some value then the result is a logical array of 0 (false) and 1 (true). You should be able to come up with some ways to convert that vector that has 1 for each person who passed into a count of how many people passed.

[Pedro Capitão]

Thank you! I'm going to try that.