Separate number and character in cell
Hello,I have a column in given format, Is it possible to remove the “hr.” from the cells and just leave the numbers?1.2 hrs1.6 hrs4.5 hrs7.6 hrs8.2 hrs1.0 hrs0.9 hrsThe output I desire is:1.21.64.57.68.21.00.9
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHello,I have a column in given format, Is it possible to remove the “hr.” from the cells and just leave the numbers?1.2 hrs1.6 hrs4.5 hrs7.6 hrs8.2 hrs1.0 hrs0.9 hrsThe output I desire is:1.21.64.57.68.21.00.9
This is probably super easy but I'm stumped. I could just query the database again and filter out what I need and build my data table with that but I'd rather save bandwidth and query my table or filter it somehow.Basically I have a table like soitemreturn_qtyvaluefailurestool145.00Productbook532.99Cust issuelaptop1439.99Productdinner112.99Cust issueclock324.00Broken by shippingI want to create a ...
loysius
Hi,I am interested in testing and comparing the correlation of many (hundreds) of Y variables individually to a single X variable. The "fit Y by X" function seems appropriate.How do I generate the statistics for each Y variable in a batch, and export them to a data table? Can I apply the saved script to the data table and add the values to the table for instance?
andreas_scherer
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, "...
saswatmishra50
Hello,sorry for that trival question but I can't find a solution for that by myself I have created an overlay plot with two axis (retention time and masses). The response (intensity) is displayed as different colors. So far so good everything works fine, but unfortunately the ranges for each color are already given and I'd like to change them.For example 1-2 is red and 2-3 is green and so on, I'd...
marcokunzelmann
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, "...
saswatmishra50
Hi, I see a discrepancy in the plotted Y variables when plotting similar columns in the Oneway vs Bivariate plots. Bivariate plots the Y values correctly (left side below). Oneway seems to jitter the points on the Y-axis, which seems strange to me. I realize that my horizontal axis here is a numeric, and that bivariate makes more sense* but I'm just looking for a simple x-y scatter and I like the ...
How could I identify pixels groups with quite similar colors (grey for instance) on a picture .jpeg?
I had run separate analysis on the same excel file at different times , thus I have two separate session script files. How can I merge them into one single file- which will enable me to run both the analysis via single script file?I am using JMP trial version
abhinavpiplani
Hello. First post to the forum for me... I am a research ecologist with a wildlife conservation emphasis. Not the typical JMP user, I'm guessing. I have developed and tested a complex individual-based simulation model of bird population dynamics. I am currently at the point in model analysis, where a global, variance-based sensitivity analysis would be appropriate. I am wondering if JMP has the to...
clott
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, "...
saswatmishra50
Hi, I see a discrepancy in the plotted Y variables when plotting similar columns in the Oneway vs Bivariate plots. Bivariate plots the Y values correctly (left side below). Oneway seems to jitter the points on the Y-axis, which seems strange to me. I realize that my horizontal axis here is a numeric, and that bivariate makes more sense* but I'm just looking for a simple x-y scatter and I like the ...
Hi all,Till now I was using "Panel Box" and "Close" local data filter command for the invisible but functioning local data filter. Something like below closes the data filter it is visible by jmp graph but invisible by the HTML5 output (magical).nw[Panel Box( 1 )][Outline Box( "Local Data Filter" )] << Close( 1 );nw[Panel Box( 2 )][Outline Box( "Local Data Filter" )] << Close( 1 );
This time I use ...
saitcopuroglu
I don't know if anybody using the Interactive HTML output as intensive as me but Fit Y by X platform needs an upgrade about converting the jmp language to HTML5 language. Here is an example comparing the outputs of both. Almost none of the axis and font and colour settings seem to be carried over.
saitcopuroglu
Is there a way to control the formatting of the exported PowerPoint deck? The exported file needs so much clean up I am not sure if it saves any time over cutting and pasting. I made a simple journal from the big class data table and a 1 page journal turns into a 5 page PowerPoint. The resulting PowerPoint is attached.
JMP Student Edition is a professional statistics environment rather than a simplified teaching tool....
JMP imports and analyzes the important data you collect or store in a variety of databases and forma...
Este seminario web se presenta en español. Tanto si acaba de descargar la prueba gratuita de 30 días...
Date: Friday, February 20Time: 1:00–2:00 p.m. ETRegistration: FREE Whether you've jus...