MATLAB Answers

Pivot table using grpstats

6 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.

  0 Comments

Sign in to comment.

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')

  0 Comments

Sign in to comment.

Tags

Products

Community Treasure Hunt

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

Start Hunting!

Translated by