World Statistics Day was yesterday, but we’re celebrating all week long! This celebration means acknowledging the impact statistics has on our world. Who is your favorite statistician? Share with us who they are and why they top your favorites list.
Choose Language Hide Translation Bar
Highlighted
almighty22
Level II

1E+05 to 100000

Hi guys,

 

Why the JSL didn't change the 1E+05 to 100000 when I tabulate the data? What can I do?

4 REPLIES 4
Highlighted
almighty22
Level II

Re: 1E+05 to 100000

And also the graph that I stimulate. Showing only the front number like 1.01E+05 from my raw data and it shown directly at the graph axis as 1.01E+05.
Highlighted
txnelson
Super User

Re: 1E+05 to 100000

You may have to provide your data table and/or script to allow the determination of your issue.  But I will guess that it may be because you are specifying a Scientific format for the data in your data table.

Jim
Highlighted
almighty22
Level II

Re: 1E+05 to 100000

Thanks nelson. You remind me, is the scientific format issues. I fixed it.

Highlighted
txnelson
Super User

Re: 1E+05 to 100000

The issue is that the data in scientific notation,  coming from the .txt files is being interpreted by JMP as character data, not numeric.  I am not aware of a method to change that during the reading in of the data, however, it is a simple matter to do that after the data are in the data table.  The following modification to your code will make the changes:

:Column 1 << Set Name( "Frequency" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 2 << Set Name( "S11 Data" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 3 << Set Name( "Result1" );
:Column 4 << Set Name( "S21 Data" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 5 << Set Name( "Result2" );
:Column 6 << Set Name( "S22 Data" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 7 << Set Name( "Result3" );

Please note the format setting.  You can change the format to any JMP numeric format, and it will that format the Graph windows will use.

scientific.PNG

Jim
Article Labels

    There are no labels assigned to this post.