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

3 次查看（过去 30 天）
bozheng
bozheng 2024-4-18
回答： Ayush Modi 2024-4-18
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
data = adjusted_image(:);
fprintf('影像資料：\n');
disp(data);
which one is correct ? i have no idea
thanks your reading and answering

请先登录，再回答此问题。

采纳的回答

Ayush Modi
Ayush Modi 2024-4-18
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by