how to import average and maximum data from excel sheet .

1 view (last 30 days)
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

Accepted Answer

Sudhakar Shinde
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

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!