Editing Excel (Spreadsheets) using Matlab
显示 更早的评论
Hello, I'm wondering how I could write the mean of all grades and apply a individual letter grade onto a spreadsheet... if given a simple list for example of what I'm given and then what I'm trying to do:
What would I need to do to make this happen using only Matlab (xlsread, xlswrite). Hope what I'm trying to ask makes sense, thanks!
2 个评论
Ish
2017-3-29
Is this what you need to do?: Read data from excel, calculate the mean,grade and write back to it.
James Larsen
2017-3-29
Yes here is what I have so far
With an output of: (Conversion % to decimal issues...)
回答（1 个）
Walter Roberson
2017-3-30
0 个投票
Your code is not calculating the letter for each row.
mean(num) is taking the mean of each column of num. You would need mean(num,2) to take the mean of each row . The result would be a column vector, and you need to find the letter for each entry in the column vector.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2017-3-29
2017-3-30
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
