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

3 次查看（过去 30 天）

显示更早的评论

Max Behr 2019-6-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/469561-cell-array-how-can-i-calculate-the-mean-of-it

编辑： KALYAN ACHARJYA 2019-6-30

采纳的回答： KALYAN ACHARJYA

matlab.mat

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 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2019-6-30

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 2019-6-30

matlab.mat

I attached the file. Can you please help me?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

KALYAN ACHARJYA 2019-6-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/469561-cell-array-how-can-i-calculate-the-mean-of-it#answer_381397

编辑：KALYAN ACHARJYA 2019-6-30

在 MATLAB Online 中打开

load test_file.mat
idx=find(time1>0 & time1<=4);
result=sum(values1(idx))/length(idx);

Do the same for others.

7 个评论
显示 5更早的评论隐藏 5更早的评论

Max Behr 2019-6-30

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 2019-6-30

编辑：KALYAN ACHARJYA 2019-6-30

I dont know, why you are interested to creating two cells?

Read here cell the differences.

Good Night!

请先登录，再进行评论。

更多回答（1 个）

Dave 2019-6-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/469561-cell-array-how-can-i-calculate-the-mean-of-it#answer_381399

编辑：Dave 2019-6-30

在 MATLAB Online 中打开

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.