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.
回答（1 个）
madhan ravi
2020-9-16
0 个投票
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.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2020-9-16
2020-9-16
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
