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

1 view (last 30 days)
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!!!

Accepted Answer

Walter Roberson
Walter Roberson on 24 Jan 2012

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!