I want to find the average of a matrix from excel in MATLAB
5 次查看(过去 30 天)
显示 更早的评论
Hi,
I would like to find the average of the matrix found in the spreadsheet attached in MATLAB. I calculated my results manually, but would like to find it through MATLAB. I wrote the following code, but was returned an incorrect value:
sheet = 1;
xlRange = 'A1:E7449';
Data = xlsread('data.xlsx', sheet, xlRange);
AvgData= mean(Data);
I received the following output:
NaN 0.0874718684775714 NaN NaN NaN
However, the output should be:
0.094422821
I would also like to know if there's a way to find data that is repeated in each column and record it.
0 个评论
采纳的回答
the cyclist
2017-3-6
编辑:the cyclist
2017-3-6
nanmean(Data(:))
will do what you want.
You need nanmean rather than mean, because Data has NaN values in it, due to the columns being different lengths.
You need Data(:) rather than Data, because you want the mean of all the values as one vector, rather than the means of each column.
0 个评论
更多回答(1 个)
Image Analyst
2017-3-6
You can use mean() with the 'omitnan' option, and the : (colon) operator (otherwise you get column means instead of the mean of the whole thing), like this
theMean = mean(Data(:), 'omitnan');
Regarding repeats, if a data value is in both row 2 and row 7, is it "repeated" or does it need to be in the adjacent row to be repeated?
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!