Interpreting Excel Data in MATLAB

2 次查看（过去 30 天）
Mark Bamburak
Mark Bamburak 2020-9-16
回答： madhan ravi 2020-9-16
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.

请先登录，再回答此问题。

回答（1 个）

madhan ravi
madhan ravi 2020-9-16
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by