Problem with statistical function(s) when it's input is matrix containing some NaN

Hi, I've imported a table from MS Excel to matlab using import wizard. There were some #DIV/0 in excel table, represented as NaN in matlab, which is correct. But, when i use function median and it's input is matrix with NaNs, median returns NaN. Is there any option how to make matlab to skip NaNs when calculating such task without writing any loop or thg like that?

Thanks!!!

Answer 1

[Walter Roberson]

http://www.mathworks.com/help/toolbox/stats/nanmedian.html

http://www.mathworks.com/help/toolbox/stats/nanmean.html