# Calculate mean and standard deviation, the result is different from excel

7 visualizaciones (últimos 30 días)
bozheng el 18 de Abr. de 2024
Respondida: Ayush Modi el 18 de Abr. de 2024
this is me sample picture
and i got the Mean value: 1.1932 Standard deviation: 0.6329 by matlab
but i output each data and paste on the google excel to calculate average ;1.12 and std :0.6005
outptu coding
fprintf('影像資料：\n');
disp(data);
which one is correct ? i have no idea
##### 0 comentariosMostrar -2 comentarios más antiguosOcultar -2 comentarios más antiguos

Iniciar sesión para comentar.

Ayush Modi el 18 de Abr. de 2024
Hi,
I copy pasted the values of adjusted_image variable in the excel, and used the below formulas to calculate the value.
=AVERAGE(A1:JW45) % For Mean
=STDEV(A1:JW45) % For Standard deviation
Mean = 1.193168433
std = 0.6329027251
I would suggest you to check the calculations for the mean and standard deviation in your Excel spreadsheet to ensure that the formula correctly includes all the values.
##### 0 comentariosMostrar -2 comentarios más antiguosOcultar -2 comentarios más antiguos

Iniciar sesión para comentar.

### Categorías

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

R2020a

### Community Treasure Hunt

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

Start Hunting!

Translated by