MATLAB Answers

Pivot table using grpstats

3 views (last 30 days)
alpedhuez
alpedhuez on 13 Jan 2018
Edited: Prasanth Sunkara on 23 Jan 2018
Hello,
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)
>>openExample('stats/SummaryStatisticsforaDatasetArrayWithoutGroupingExample')

Tags

Products

Community Treasure Hunt

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

Start Hunting!