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!

[Ish]

Is this what you need to do?: Read data from excel, calculate the mean,grade and write back to it.

[James Larsen]

Yes here is what I have so far

With an output of: (Conversion % to decimal issues...)

Answer 1

[Walter Roberson]

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.

I recommend you look at logical indexing