필터 지우기
필터 지우기

How to calculate the mean value and standard deviation of 3 specific columns?

조회 수: 1 (최근 30일)
I have an excel file with a table 1442x31. I have extracted the 3 columns I want to calculate on a different table, named cols. Cols table size is 1439x3
And I want to calculate the mean and standard deviation of each of these columns.
I tried these:
mean_val = mean(cols);
stan_dev = std(cols);
But the result on both of mean and std was [NaN NaN NaN].
  댓글 수: 1
Sriram Tadavarty
Sriram Tadavarty 2020년 5월 14일
Implies the values have some NaN entries.
Try once
mean_val = mean(cols,'omitnan');
stan_dev = std(cols,'omitnan');
Hope this helps

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by