cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
SimonFuchs
Level III

Problem to paste continuuos numbers from JMP to Excel

Dear JMP-Experts,

 

I have measured continuous datasets and when I export them from excel to JMP (either by the JMP macro or by copy paste) they appear only as ordinal or nominal but not as continuous. How do I fix this problem. I uploaded the excel sheet as well as the JMP sheet below.

 

Thanks a lot for your help!!!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Problem to paste continuuos numbers from JMP to Excel

They appear nominal because you have character values in the columns ("--"). You should be able to change data type to Numeric and modeling type to Continuous. "--" values will then be replaced with missing values

jthi_0-1666627507167.png

jthi_2-1666627568433.png

 

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Problem to paste continuuos numbers from JMP to Excel

They appear nominal because you have character values in the columns ("--"). You should be able to change data type to Numeric and modeling type to Continuous. "--" values will then be replaced with missing values

jthi_0-1666627507167.png

jthi_2-1666627568433.png

 

-Jarmo