how to import average and maximum data from excel sheet .

6 visualizaciones (últimos 30 días)
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

Respuesta aceptada

Sudhakar Shinde
Sudhakar Shinde el 20 de Oct. de 2020
Editada: Sudhakar Shinde el 20 de Oct. de 2020
[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
%Maximum
max(Average);
  12 comentarios
Engineer Batoor khan mummand
Engineer Batoor khan mummand el 22 de Oct. de 2020
Done thank u so much dear from your helping and support.
Sudhakar Shinde
Sudhakar Shinde el 22 de Oct. de 2020
Welcome. glad to help.

Iniciar sesión para comentar.

Más respuestas (0)

Productos


Versión

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by