cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

calculate grouped percentages

Hi,

I used TABLES>SUMMARY to group a table by year and position to get N rows. I want to calculate % by year (COL 3) in below table. But when I select % Total statistic it gives me % of all observations(I get COL 4). I don't see a % Total statistic on the group variable. Can anyone tell how I can calculate COL 3 of below table?

     

YEARPOSITIONN ROWS % by year% Total
2002Catcher708.244.18
2002Designated Hitter60.710.36
2002First Baseman465.422.75
2002Outfielder16018.859.55
2002Pitcher41148.4124.54
2002Second Baseman566.603.34
2002Shortstop465.422.75
2002Third Baseman546.363.22
2003Catcher738.844.36
2003First Baseman556.663.28
2003Outfielder14517.558.66
2003Pitcher39447.7023.52
2003Second Baseman445.332.63
2003Shortstop637.633.76
2003Third Baseman526.303.10
1 REPLY 1

Re: calculate grouped percentages

Did you select (check box) the Include marginal statistics option that appears under the list of data columns?

Recommended Articles