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 2023-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2039636-i-need-a-code-to-find-the-mean-of-a-specific-column-from-an-excel-sheet-and-find-the-variation-of-th

回答： 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更早的评论隐藏 3更早的评论

Aditi 2023-10-27

I need help to find the variation in one loop and then display the message

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 2023-11-9

在 MATLAB Online 中打开

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