I keep getting NaN values when computing the mean and standard deviation of an array

38 次查看（过去 30 天）
Cai Chin
Cai Chin 2021-1-6
评论： Walter Roberson 2021-1-8
Hi, I am attempting to calculate the mean of all the rows in a cell array called 'XTrain2_all' comprised of 4x30 doubles, however I keep getting NaN values instead of 4 mean values. The same happens when computing the standard deviation. How do I stop this from happening? Thanks in advance.
XV = [XTrain2_all{:}];
mu = mean(XV,2);
sg = std(XV,[],2);

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

采纳的回答

Walter Roberson
Walter Roberson 2021-1-6
Each of your rows has 30 NaN values.
In rows 1 and 2, they are in columns 95221 to 95250.
In rows 3 and 4, they are in columns 94951 to 94980 .
mean() of a value that includes nan is going to be nan, because anything added to nan gives nan as a result.
You can use
XV = [XTrain2_all{:}];
mu = mean(XV, 2, 'omitnan');
sg = std(XV, [], 2, 'omitnan');
  8 个评论
显示 6更早的评论
Cai Chin
Cai Chin 2021-1-7
Hi Steven, in my situation, the NaN values all follow eachother across 30 values. Therefore, instead of replacing by the previous number, is it possible to replace these 30 values with the 30 values prior to these missing ones rather than just replacing with the last non-missing value?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Descriptive Statistics 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by