cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
joechicago
Level I

changing how many decimal points are displayed

I am working in JMP 8 for Mac, Fit X by Y, doing a contingency analysis, and am most interested in the contingency table.

How do I fix the display of percentaghes so that there are no decimal points, only whole numbers?

Where can i find this sort of informastion in the user manuals?

Thank you for your help!!

- Michael D.

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: changing how many decimal points are displayed

The contingency table does not appear to be editable (I work in JMP 9 for Mac) but you can export it into a data table by selecting "make into data table" from under the red triangle. The nr of decimals can then be set for the columns. This can also be scripted as in the example below (the first part borrrowed from the example found in Help/Displaybox Scripting/CrossTabBox).

Open( "$ENGLISH_SAMPLE_DATA/Alcohol.jmp" );

c = Contingency(

          Y( :Relapsed ),

          X( :Alcohol Consumption ),

          Freq( :Count ),

          Contingency Table(

                    Count( 1 ),

                    Total %( 1 ),

                    Col %( 1 ),

                    Row %( 1 ),

                    Expected( 0 ),

                    Deviation( 0 ),

                    Cell Chi Square( 0 ),

                    Col Cum( 0 ),

                    Col Cum %( 0 ),

                    Row Cum( 0 ),

                    Row Cum %( 0 )

          )

);

cr = c << report;

ctb = cr[CrosstabBox( 1 )];

Print( ctb << Get As Matrix );


dt=ctb << make into datatable;

for(i=1, i<= ncol(dt), i++, if ((column(dt,i)<<get data type)=="Numeric",column(dt,i)<< format("fixed dec",0)));

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: changing how many decimal points are displayed

The contingency table does not appear to be editable (I work in JMP 9 for Mac) but you can export it into a data table by selecting "make into data table" from under the red triangle. The nr of decimals can then be set for the columns. This can also be scripted as in the example below (the first part borrrowed from the example found in Help/Displaybox Scripting/CrossTabBox).

Open( "$ENGLISH_SAMPLE_DATA/Alcohol.jmp" );

c = Contingency(

          Y( :Relapsed ),

          X( :Alcohol Consumption ),

          Freq( :Count ),

          Contingency Table(

                    Count( 1 ),

                    Total %( 1 ),

                    Col %( 1 ),

                    Row %( 1 ),

                    Expected( 0 ),

                    Deviation( 0 ),

                    Cell Chi Square( 0 ),

                    Col Cum( 0 ),

                    Col Cum %( 0 ),

                    Row Cum( 0 ),

                    Row Cum %( 0 )

          )

);

cr = c << report;

ctb = cr[CrosstabBox( 1 )];

Print( ctb << Get As Matrix );


dt=ctb << make into datatable;

for(i=1, i<= ncol(dt), i++, if ((column(dt,i)<<get data type)=="Numeric",column(dt,i)<< format("fixed dec",0)));

joechicago
Level I

changing how many decimal points are displayed

Thank you for your prompt and helpful reply!! 

- Michael D.