how to import average and maximum data from excel sheet .
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Engineer Batoor khan mummand
am 20 Okt. 2020
Kommentiert: Sudhakar Shinde
am 22 Okt. 2020
hi all:
i want to import avarege data of each day from above excel file but avarege of that values which is greater than 0.
second i want find greatest average value day in that excel file .
thanks
0 Kommentare
Akzeptierte Antwort
Sudhakar Shinde
am 20 Okt. 2020
Bearbeitet: Sudhakar Shinde
am 20 Okt. 2020
[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
%Maximum
max(Average);
12 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets 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!