清空筛选条件
清空筛选条件

Import Data from an Excel Spreadsheet, sum the data for one column

1 次查看（过去 30 天）
Lin Jun Lee
Lin Jun Lee 2019-1-9
回答： Steven Remington 2019-1-11
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)

请先登录，再回答此问题。

回答（1 个）

Steven Remington
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by