Calculating with missing values?

Hello,

I got a matrix and one value is missing. I still wan to calculate the standard error of it

>> test=rand(3,3)

test =

    0.0975    0.9575    0.9706
    0.2785    0.9649    0.9572
    0.5469    0.1576    0.4854

>> test(3,1)=missing

test =

    0.0975    0.9575    0.9706
    0.2785    0.9649    0.9572
       NaN    0.1576    0.4854

>> test_SE=std(test)/sqrt(length(test))

test_SE =

       NaN    0.2679    0.1595

Why doesn't it work?

And can I let Matlab ignore the missing value?

Thanks.

Answer 1

[KSSV]

doc nanstd

Or fill NaN values using fillmissing and use std.

Or have a look here:

https://in.mathworks.com/matlabcentral/fileexchange/67270-standard-error-of-the-mean-ignores-nans

[Max Behr]

nanstd works perfect! Thanks :)