Welcome to the JMP User Community!

Latest Discussions

• How Can I get a list of sheets in an Excel workbook ?

  I have a situation where I am opening Excel sheets using Open Database().This has been a good way to do it since I want specific columns from specific sheets, so using an SQL SELECT statement is ideal.I am now discovering there is no standardization on the sheet names. So what I want to do is query the Excel workbook and get a list of sheets in it. I can then use some logic in my code to decide wh...

  tsl

  Discussions |

  Dec 23, 2024 7:07 PM

  7156 views | 7 replies

• DOE with covariate

  I have done some basic searching already, but can't find an example matching this scenario. Suppose I wanted to run a typical full or fractional 2-level factorial DOE but there was a covariate I wanted to account for. I was expecting that I could just go to custom design and add the factors and specify one of those as a covariate. It would make the table and fill in the +1 -1 as appropriate for th...

  awelsh

  Discussions |

  Dec 23, 2024 2:08 PM

  1233 views | 4 replies

• Create duplicate heat-maps with different summary statistics in Graph Builder

  Given Big Class and this plot: Graph Builder( Size( 574, 613 ), Graph Spacing( 20 ), Variables( X( :sex ), X( :sex ), Y( :age ), Color( :height, Summary Statistic( "Min" ) ) ), Elements( Position( 1, 1 ), Heatmap( X, Y, Legend( 4 ) ) ), Elements( Position( 2, 1 ), Heatmap( X, Y, Legend( 5 ) ) ) )Is there a way to make the left plot use the "Mean" summary statistic and the right plot ...

  BHarris

  Discussions |

  Dec 23, 2024 9:16 AM

  1552 views | 5 replies

• DASHBOARDING for Process Parameters

  Hi, I have many continuous data for 360 individual units. I would like to make a dashboard for some critical KPI which represent a single unit with respect to the whole population (all units). This will help me to identify the exceptional or out layer in my process. I have daily data for each unit for n number of variables. 

  swapnil_sohar

  Discussions |

  Dec 23, 2024 6:15 AM

  707 views | 2 replies

• What is the Difference Between "Remove" and "Exclude" Effects in the Effects Summary Table?

  I have the following question: I am working with a fractional factorial design 2^(5−1), evaluating a single response, and adding a central point and a replicate to the effects. The goal is to determine if there are indications of curvature and if there is a difference between replicates, respectively. In the effect summary table, if I exclude the replicate effect and exclude curvature, the model d...

  leodu

  Discussions |

  Dec 23, 2024 1:37 AM

  687 views | 1 replies