Hi,
NOTE:-
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:
Comments
Post a Comment