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)
Ältere Kommentare anzeigen
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
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)?
Antworten (1)
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.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Multirate Signal Processing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!