Interpreting Excel Data in MATLAB

I am learning MATLAB as part of my engineering degree and am stuck on a relatively easy question. Given an excel sheet comprising 201 rows and 12 columns (represents 12 quiz grades amongst 201 students), I am being asked to determine the average grade for each student after dropping the two lowest grades. I also need to answer how many students scored higher than X.

Answer 1

[madhan ravi]

Read it using readmatrix() or readtable().

sort() it row wise , index from 3 to end.

mean() row wise.

Use > for threshold and nnz() to count no of students who were flamboyant.

And ofcourse I won’t do your homework.