Calculate mean and standard deviation, the result is different from excel
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
bozheng
am 18 Apr. 2024
Beantwortet: Ayush Modi
am 18 Apr. 2024
this is me sample picture ![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1672526/image.jpeg)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1672526/image.jpeg)
and i got the Mean value: 1.1932 Standard deviation: 0.6329 by matlab
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1672531/image.jpeg)
but i output each data and paste on the google excel to calculate average ;1.12 and std :0.6005
outptu coding
data = adjusted_image(:);
fprintf('影像資料:\n');
disp(data);
which one is correct ? i have no idea
thanks your reading and answering
0 Kommentare
Akzeptierte Antwort
Ayush Modi
am 18 Apr. 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
I got the below answer:
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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!