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
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 Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!