MATLAB Answers

Ms. Mat

Mean of every row in a double matrix without looping

Asked by Ms. Mat
on 27 Dec 2012
Accepted Answer by Matt J

Is it possible to find mean and std dev. of every row in a huge matrix with double data and a lot of NaN interspersed without looping through every row ?

A = [1 2 NaN; 4 NaN 6 ; 8 9 10]
output = 1.5
         5
         9

  0 Comments

Products

No products are associated with this question.

1 Answer

Matt J
Answer by Matt J
on 28 Dec 2012
Edited by Matt J
on 29 Dec 2012
 Accepted answer

If you have the Statistics toolbox, you can use nanmean(A,2) and nanstd(A,2).

If you don't have the toolbox, you can still avoid looping by doing

 B=A;
 map=~isnan(A);
 B(~map)=0;
 N=sum(map,2);
 rowmeans = sum(B,2)./N;
 rowstds = sqrt( sum(B.^2,2)./N -rowmeans.^2 );

If A is of type sparse, however, the above may need to be modified for efficiency's sake.

  1 Comment

Ms. Mat
on 29 Dec 2012

Thank You !!!


Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today