how to import average and maximum data from excel sheet .
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Engineer Batoor khan mummand
le 20 Oct 2020
Commenté : Sudhakar Shinde
le 22 Oct 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 commentaires
Réponse acceptée
Sudhakar Shinde
le 20 Oct 2020
Modifié(e) : Sudhakar Shinde
le 20 Oct 2020
[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
%Maximum
max(Average);
12 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!