Import Data from an Excel Spreadsheet, sum the data for one column
조회 수: 1 (최근 30일)
이전 댓글 표시
Use importdata() to import the population data of each country from the data file called World Population.xlsx.
Calculate the total population of each year for each of the six major areas. - I am not sure what to use for this? sumof? sum?
This is what I've written so far.
%% Import population data
filename = 'World Population.xlsx';
[A]=importdata(filename)
댓글 수: 2
Akira Agata
2019년 1월 9일
I think possible solution will depends on data structure in your Excel file. If possible, could you upload your file?
답변 (1개)
Steven Remington
2019년 1월 11일
In order to get the sum of an array, You can use the "sum" function that I have linked below.
https://www.mathworks.com/help/matlab/ref/sum.html
If you are trying to get a subset of the actual original array, you'll have to index into the array to select the data before performing the sum. A good resource for array indexing is the following link:
https://www.mathworks.com/help/matlab/math/array-indexing.html
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!