i need a code to find the mean of a specific column from an excel sheet and find the variation of the mean and actual value and then display 'yes' if the the variation is 0.5.

2 次查看（过去 30 天）
Aditi
Aditi 2023-10-27
回答： SAI SRUJAN 2023-11-9
i used a switch statement but i have a problem in finding the variation. there are almost 2000 iterations.
data=readtable("DATA.xlsx");
n = mean(data(1676-50:end,26),'omitnan');
switch n
case 0.5
disp('yes')
otherwise
disp('no')
end
how can i solve this
  5 个评论
显示 3更早的评论
Rik
Rik 2023-10-28
How are you defining variation? You're not using standard statiscal terminology I'm familiar with.
And do you know how to write a for loop? And are you aware that your current code requires an exact match with 0.5 (so there isn't room for rounding errors)?

请先登录，再进行评论。

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

回答（1 个）

SAI SRUJAN
SAI SRUJAN 2023-11-9
Hi Aditi,
I understand that you are trying to find the variation of the mean and the actual value of a specific column.
To find the mean of a vector in MATLAB, you may utilize the 'mean' function. Following this, you can employ a 'for' loop to calculate the variation relative to each data point.
You can follow the given example to proceed further,
data=readtable("DATA.xlsx");
n = mean(data(1626:end,26),'omitnan');
v= data(1626:end,26);
for i=1:numel(v)
if isnan(v(i))==0
if abs(v(i)-n)==0.5:
disp('yes')
else
disp('no')
end
end
end
I hope this helps.

类别

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

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by