how to import average specific data from excel file ?

HI all:

i want to import average of each day from above excel file but average of those values which is greather than 200.

this is my code but when i run this code it give me below error.

thanks

clc;

clear all;

close all;

[~,Num,Data]=xlsread('solar02.xlsx');

%Average values greater than zero

Average = mean(Data(2:end,3)>0);

Error

Undefined operator '>' for input arguments of type 'cell'.

Error in babab (line 7)

Average = mean(Data(2:end,3)>0);

>>

Answer 1

[drummer]

Your Data(2:end, 3) is cell type.

You can convert your Data column to array before.

arrayData = cell2mat(Data2:end, 3));

Then, you perform your average with your condition

average = mean(arrayData>0);

Cheers.

[Engineer Batoor khan mummand]

thanks problem solved but it gives me nan at the answr but i want average of each day which is given in excel file ...

thanks