Welcome to the JMP User Community!

Latest Discussions

• How do you interpret Welch's Test results?

  Since the tests for Unequal Variances indicates that the variances ARE unequal, how do I interpret the Welch's Test results?  My take, based on the JMP Help is that since the Prob > F is greater than 0.05, the means of my two sample groups are NOT significantly different.

  jeff_kolton1

  Discussions |

  Sep 30, 2015 11:45 AM

  33581 views | 3 replies

• How can I set a cell value to "missing" through a script?

  I have a script that I use to remove out of family data points from large numeric data sets.  When a value was found that was outside a defined distribution then that value was set to missing by using the code "columnReference[specificCell] = ."I used to work great but now it seems the script does not like me setting the cell value to "."  Any suggestions on how I can set a cell value to "missing"...

  wblack0

  Discussions |

  Sep 29, 2015 1:16 AM

  20156 views | 9 replies

• DOE - Fit Model and Profiler

  I am using Fit Model and Profiler to help me identify which factors are important and predict the response.After Fit Model -> Stepwise analysis, only 2 out of 5 factors are important. I try and put all 5 factors into Fit Model -> Standard Least Squares & Effect Screening, the Profiler gave me different prediction. That make sense to me because now JMP fit a different model. But I know the first mo...

  dtsang

  Discussions |

  Sep 28, 2015 5:09 PM

  5902 views | 2 replies

• Excel VBA - Subset data by column

  Hello, I'm looking at a sample program included with JMP 11:  C:\Program Files\SAS\JMP\11\Samples\Automation\Visual Basic Samples\Data Table .NET\datatab.vbSince I don't have Visual Studio (just Excel), I opened "datatab.vb" with Notepad and attempted to translate the "Subset_Click" procedure from Visual Basic (VB) to Visual Basic for Applications (VBA). Please see the code example below.I have a ...

  jb

  Discussions |

  Sep 28, 2015 3:57 PM

  11693 views | 2 replies

• VBA - Save Excel workbook as JMP data table

  Hello, I'm familiar with Excel VBA but new to JMP scripting. I'm currently using JMP 11.I'd like to open an Excel workbook (with a single worksheet) and save it as a JMP data table, so I can run a JMP analysis on it.How do I reference the unsaved JMP data table created by this VBA code?Dim app As JMP.Application
  Dim doc As JMP.Document
  Dim dt  As JMP.DataTable'Start JMP
  Set app = CreateObject("JMP.Ap...

  jb

  Discussions |

  Sep 28, 2015 8:38 AM

  11835 views | 4 replies