cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

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