Filter löschen
Filter löschen

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 Ansichten (letzte 30 Tage)
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 Kommentare
Rik
Rik am 28 Okt. 2023
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)?

Melden Sie sich an, um zu kommentieren.

Antworten (1)

SAI SRUJAN
SAI SRUJAN am 9 Nov. 2023
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.

Produkte


Version

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by