how to import average and maximum data from excel sheet .
1 view (last 30 days)
Show older comments
Engineer Batoor khan mummand
on 20 Oct 2020
Commented: Sudhakar Shinde
on 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 Comments
Accepted Answer
Sudhakar Shinde
on 20 Oct 2020
Edited: Sudhakar Shinde
on 20 Oct 2020
[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
%Maximum
max(Average);
12 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!