Clear Filters
Clear Filters

Cell array: How can I calculate the mean of it?

1 view (last 30 days)
Hello,
I got an cell array. You can find it attached.
time1, etc. are the times of the different testing. And values are the meassured values according to the times. So values 1 is connected with time1 and values2 is connected with time2
I would like to get the mean of the "values1" if the conditions "time1>0 & time<=3" is fulfilled.
So the solution would be (4+6+3)/3=4.33333
How can I do this?
Thanks.
  3 Comments
Image Analyst
Image Analyst on 30 Jun 2019
Make it easy for people to help you, not hard, by attaching your cell array in a .mat file. In the meantime, check out cellfun(), cell2mat(), and mean().
Max Behr
Max Behr on 30 Jun 2019
I attached the file. Can you please help me?

Sign in to comment.

Accepted Answer

KALYAN ACHARJYA
KALYAN ACHARJYA on 30 Jun 2019
Edited: KALYAN ACHARJYA on 30 Jun 2019
load test_file.mat
idx=find(time1>0 & time1<=4);
result=sum(values1(idx))/length(idx);
Do the same for others.
  7 Comments
Max Behr
Max Behr on 30 Jun 2019
Creating two cells. 1 cell for the times and 1 cell for the values.
And can u show me a cell based solution for my problem?
Thanks.
KALYAN ACHARJYA
KALYAN ACHARJYA on 30 Jun 2019
Edited: KALYAN ACHARJYA on 30 Jun 2019
I dont know, why you are interested to creating two cells?
Read here cell the differences.
Good Night!

Sign in to comment.

More Answers (1)

Dave
Dave on 30 Jun 2019
Edited: Dave on 30 Jun 2019
Hi Max,
Since it looks like you have the time1 and values1 data in a 1 x 7 numeric array I would create a single 2 x 7 array an then transpose it. It reads better, atleast for me.
A = [time1;values1]';
Take a look at then using find() with the conditions you specified to identify those rows of A that meet the conditions. Apply this index to the 2nd column and then use the mean() function on the output.

Categories

Find more on Programming in Help Center and File Exchange

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!