# How to use grpstats to sum several variables

Hi,

I have a table of historic stock returns that I’m trying to perform some analysis on. The first variable is Stock, the second variable is Industry and 3:374 are the monthly returns.

I am looking to sum the monthly return by industry, i.e. for Materials to have the sum of the Materials stocks, which will result in a matrix/table of industries as variable 1 and the respective monthly summed returns for the other columns.

NOTE:-

Matlabsolutions.com provide latest MatLab Homework Help,MatLab Assignment Help for students, engineers and researchers in Multiple Branches like ECE, EEE, CSE, Mechanical, Civil with 100% output.Matlab Code for B.E, B.Tech,M.E,M.Tech, Ph.D. Scholars with 100% privacy guaranteed. Get MATLAB projects with source code for your learning and research.

Given the following table, ‘TStock’, which is arranged as specified in your question:

`TStock =  6×5 table    Stock     Industry      R1    R2     R3     _____    ___________    __    ___    ___    'S1'     'Materials'    71    176    128    'S2'     'Materials'    69    163    200    'S3'     'Oil'          64    131    100    'S4'     'Oil'          64    131    156    'S5'     'Oil'          67    133    145    'S6'     'Auto'         64    119    140`

Now, when you use the ‘grpstats’ function, you will want to specify that you would like to group by the ‘Industry’ column. You can also specify that you would like to ‘sum’ the other columns. In order for this to work, you will need to omit the ‘Stock’ column in the calculation, as a sum cannot be performed on non-numeric data.

`GStock = grpstats(TStock(:,2:end),'Industry','sum')`

Which will deliver the following output, in which the first column is the name of each industry, and the remaining columns are the sums of the monthly returns for each industry:

--

--

## More from Technical Source

Simple! That is me, a simple person. I am passionate about knowledge and reading. That’s why I have decided to write and share a bit of my life and thoughts to.

## Get the Medium app

Simple! That is me, a simple person. I am passionate about knowledge and reading. That’s why I have decided to write and share a bit of my life and thoughts to.