how can I exclude NaN when I calculate average?

1 view (last 30 days)

Sun Wook Han on 2 May 2021

Edited: DGM on 2 May 2021

Accepted Answer: DGM

For example,

A = [1 3 5 NaN 9]

How can I calculate average of A? The answer should be (1+3+5+9)/4

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)))

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