MATLAB: How to import average and maximum data from excel sheet .

Question

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

Answer 1

[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
%Maximum
max(Average);