how can I exclude NaN when I calculate average?

1 view (last 30 days)
Sun Wook Han
Sun Wook Han on 2 May 2021
Edited: DGM on 2 May 2021
how can I exclude NaN when I calculate average?
For example,
A = [1 3 5 NaN 9]
How can I calculate average of A? The answer should be (1+3+5+9)/4

Sign in to answer this question.

Accepted Answer

DGM
DGM on 2 May 2021
Edited: DGM on 2 May 2021
If you're using a reasonably new version:
A = [1 3 5 NaN 9]
B = mean(A(:),'omitnan')
If you need it to work in older versions:
B = mean(A(~isnan(A)))

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!