How to convert char to num
Dear All,I have the data as follows and whatever I tried I can't make the new formula column a numeric one.Could someone help please?many thanks in advance

Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesDear All,I have the data as follows and whatever I tried I can't make the new formula column a numeric one.Could someone help please?many thanks in advance
I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
I can always add Legend to a Bivariate chart by using Report and FrameBox (see below), but how can i remove the added Legends? Report(biv_chart)[FrameBox(1)] << Row Legend( EntColumn, Color( 0 ), Color Theme( "" ), Marker( 0 ), Marker Theme( "" ), Continuous Scale( 0 ), ...
Good afternoon all; I'm pretty new to JMP and am most familiar with using it for multivariate (particularly canonical discriminant) analysis of geochemical data. I'm running into an obstacle to visualizing some data as a parallel plot. I have a dataset containing about 45 rock samples for each of which I measured the concentration of about 30 elements. The samples come from three different rock ...
My analysis produced the below p-value table. I have made some conclusions based upon the results, but am unsure whether I am on the right track given the multiple significant interactions and main effects, specifically if I have reached too far.Preliminary results of this study indicate that soluble solids content and specific gravity differed across years, cultivars, and locations, but for SSC t...
I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
I can always add Legend to a Bivariate chart by using Report and FrameBox (see below), but how can i remove the added Legends? Report(biv_chart)[FrameBox(1)] << Row Legend( EntColumn, Color( 0 ), Color Theme( "" ), Marker( 0 ), Marker Theme( "" ), Continuous Scale( 0 ), ...
Good afternoon all; I'm pretty new to JMP and am most familiar with using it for multivariate (particularly canonical discriminant) analysis of geochemical data. I'm running into an obstacle to visualizing some data as a parallel plot. I have a dataset containing about 45 rock samples for each of which I measured the concentration of about 30 elements. The samples come from three different rock ...
My analysis produced the below p-value table. I have made some conclusions based upon the results, but am unsure whether I am on the right track given the multiple significant interactions and main effects, specifically if I have reached too far.Preliminary results of this study indicate that soluble solids content and specific gravity differed across years, cultivars, and locations, but for SSC t...
// This code shows the bug. Concatenate with Append To First Table results in data corruption.dtA = new table("A");dtB = new table("B");dtA << Add Rows(3);dtB << Add Rows(1);colA = Column(dtA, 1);colB = Column(dtB, 1);colA[1]="A";colA[2]="A";colA[3]="C";colB[1]="B";dtA << Compress Selected Columns(dtA << Get Column Names());// This data has no List Check, but is not corrupted(dtA << Concatenate(d...
I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
A former classmate of mine from Graduate School has recently published a paper on Generalized Segmented Distributions. Utilizing this method, the distribution can approach any continuous density function of arbitrary form. The method is particularly effective in fitting data with sufficient observations that are skewed and/or multimodal. The paper can be found here:The General Segmented Distrib...
Hello everyone!I would like assistance in order to incorporate reference lines at certain numbers of the Y axis, horizontal lines, directly into the legend.This is my current script
Bivariate(
Y( :Cat),
X( :Dog),
Histogram Borders( 1 ),
Where(:Recipe == "B_XX" & (:Tool == "A_XX")),
Elements( Points( X, Legend( 1 ) ) ),
SendToReport(Dispatch(
{},
"2",
ScaleBox,
{Add Ref Line( 140, Solid, "...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...