清空筛选条件
清空筛选条件

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

6 次查看（过去 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 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by