I want to find the average of a matrix from excel in MATLAB

17 visualizaciones (últimos 30 días)
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.

Respuesta aceptada

the cyclist
the cyclist el 6 de Mzo. de 2017
Editada: the cyclist el 6 de Mzo. de 2017
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.
You should be able to use the unique command to find the repeated data elements.

Más respuestas (1)

Image Analyst
Image Analyst el 6 de Mzo. de 2017
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?
  1 comentario
Alexandra Brian
Alexandra Brian el 6 de Mzo. de 2017
If a data value is in both row 2 and row 7, it is "repeated." It does not need to be in the adjacent row to be repeated.

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by