JMP User Community

Latest Discussions

Clean up a csv File

I have large quatity of csv files that need to be clean up. All of these files have same format which make the task a bit easy. My initial csv file has the following format: Item Recipe: (001) 48pt Stage Recipe: 48pt Batch ID: Prod1 Item ID: 42 Date/Time: 5/1/2017 4:28:56 PM PointMeasurementGainGFitXY112.399.70.9911212.299.90...
Artemio

Discussions |
May 16, 2017 8:10 AM

7659 views | 2 replies
How do I get the import file settings right before concatenating files by a script?

I have several files in a specific format and and with the *.asc extension (example: two files as attached to this post). I have tried to make changes in the script uploaded by Bryan can be found here: https://community.jmp.com/t5/JMP-Scripts/Combine-multiple-txt-or-csv-files/ta-p/24083 It works well if I rename all my files to *.txt before running the script but otherviese it will not. I have tri...
Nagraba

Discussions |
May 16, 2017 8:08 AM

6125 views | 1 replies
non parametric KS test of two samples

How to do non-parametric kolmogorov smirnov test with two sapmle using jmp? I have long time series data, so which format do I need to do for the input in jmp? I mean excel, or text file etc?
farida

Discussions |
May 16, 2017 2:39 AM

10018 views | 2 replies
Deleting columns that are not in a list

Hi Guys,

I have a set of columns that I want to keep and then delete all except this set.

The columns that I want to delete are large in number.

Is there any easy way to do this using a script?

Thanks.

Discussions |
May 15, 2017 6:21 PM

20206 views | 10 replies
Excel Import Date Format

Hello everyone,i want to import an Excel-File ( xls ) with the Open() function. Here is my code:dt = Open( "path\file.xls", Worksheets( "worksheet1" ), Use for all sheets( 0 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 5 ), Data Starts ...
vkessler

Discussions |
May 15, 2017 5:26 PM

13319 views | 3 replies

Previous
Next

Latest Discussions

What test do I use for two variables that are ordinal and seem to have a non monotonic relationship?

I'm trying to find the right test for association/relationship between two likert scale, ordinal variables from a questionnaire I did:Behavior"How often do you recycle" - (1) Almost Daily, (2)2-3 times a week, (3)Once a week, (4) Less than once a week, (5)I don't recycleAttitude"Recycling can conserve the environment" - Ranges from (1)Strongly agree to (5)Strongly disagree, with (3)Neutral in the...
slamer2000

Discussions |
May 14, 2017 10:38 PM

5510 views | 2 replies
Stand alone application.

Is there any way in JMP to build appications that can be run by folks without JMP? Something like a .exe. Gene
gene

Discussions |
May 10, 2017 11:58 AM

6973 views | 5 replies
How do I overlay box plots in JMP so they are aligned instead of next to each other?

Assuming you have a set of x values (numerical, continuous) and 3 sets of y values (numerical, continuous), is there any way to overlay the series together and have box plots that are overlayed? When I add box plots with graph builder, the box plots take up their own independent space along the x-axis, instead of being aligned along the same value of x, the box plots won't intersect eachother. The...
ambrose2

Discussions |
May 10, 2017 10:10 AM

5628 views | 2 replies
how to custamize the rangeof the

in the attcehd file there are 3 graphs in one box, but on the y-axis all the three graphs have the same range i.e is 0-500. But if i want to customize the three graphs with differetn ranges (like 0-200, 0-300, 0-500). So that all the graphs would fit in neatly. I tried changiin them but, all the values are changing at the same. or should i plot the three plots separatly. Plz share an answer, as i...
Drharsha

Discussions |
May 9, 2017 6:46 PM

3758 views | 1 replies
How to continue with no Analysis of Variance significance but Parameter Estimates significance

[interactive explanation] The analysis of responses with a DSD (Definitive Screening Design) resulted in no significance in the Analysis of Variance (p=0.0898) for the "Actual by Predicted Plot" report. But parameter estimates report showed significance (p=0.0321) for one factor. Similar findings are described in the example: http://www.jmp.com/support/help/Examples_of_Definitive_Screening_Designs...
den

Discussions |
May 4, 2017 4:41 AM

10786 views | 4 replies

Previous
Next

Latest Discussions

Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4247 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3305 views | 0 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3327 views | 0 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4385 views | 0 replies
How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
MIKE

Discussions |
Dec 14, 2016 8:48 AM

4711 views | 0 replies