Clear Filters
Clear Filters

Pivot table using grpstats

1 view (last 30 days)
alpedhuez on 13 Jan 2018
Edited: Prasanth Sunkara on 23 Jan 2018
Let us I want to calculate the sum and mean of wealth for men and women.
I set Type ={men, women} and have created a pivot table using
summarytable = grpstats(dsa,'Type',{'sum','mean'})
Now I want to have sum and mean for everyone in the sample (without grouping for men and women). Please advise the next step.

Answers (1)

Prasanth Sunkara
Prasanth Sunkara on 23 Jan 2018
Edited: Prasanth Sunkara on 23 Jan 2018
Hi, I understand that you want to compute the stats without using any grouping variable. It could be done as follows:
>>summarytable = grpstats(dsa, [],{'sum','mean'})
I would recommend trying out the below example first(execute this on MATLAB CMD prompt)



Community Treasure Hunt

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

Start Hunting!