JMP User Community

Latest Discussions

How to append data from one table to another?

I have a JMP file that I wish to update from an Excel file every month. When I run the Source script from the original data table, I get a new table with the new data attached. HOWEVER, all the scripts I want to run to do the analysis on the updated table are in the orignial table. Can I move the scripts to the new table? Actually, I don't even want a new table. Can't JMP just append data to ...
Steven_Moore

Discussions |
Oct 9, 2014 8:48 AM

17303 views | 4 replies
How to properly censor data

Hello everyone.I want to use the jmp software for analysing biological data. I observed how many eggs some worms laid over 40 days after birth. Some did not start to lay eggs. I want to use the survival analysis of jmp to have a look at the timing of the first eggs different groups of worms produced (instead of dying they start laying eggs). My question is how I can censor those who did not lay eg...
daniel

Discussions |
Oct 9, 2014 6:25 AM

12477 views | 2 replies
calculate grouped percentages

Hi,I used TABLES>SUMMARY to group a table by year and position to get N rows. I want to calculate % by year (COL 3) in below table. But when I select % Total statistic it gives me % of all observations(I get COL 4). I don't see a % Total statistic on the group variable. Can anyone tell how I can calculate COL 3 of below table? YEARPOSITIONN ROWS % by year% Total2002Catcher708.244.182002Design...
noone_santosh

Discussions |
Oct 8, 2014 8:20 AM

3226 views | 1 replies
Hiding "No" or Zero Arguments from Data Table

I am dealing with a data set that has several user groups that I will be cross tabbing. Whenever I drop a user group into a banner or stub, I am also shown those not in the group ("No", 0 in data column) along side those in the group ("Yes", 1 in data column). Seeing those not in the group in this way is not particularly relevant to my needs. Is there a way that I can prevent the "No's" from showi...
mcstagger

Discussions |
Oct 8, 2014 5:45 AM

8946 views | 2 replies
export rotating 3d scatter plot

Hi all. I was wondering if it is possible to export a rotating 3d scatter plot to a power point presentation.Cheers
mathieu_leclerc

Discussions |
Oct 8, 2014 5:16 AM

8575 views | 1 replies

Previous
Next

Latest Discussions

calculate grouped percentages

Hi,I used TABLES>SUMMARY to group a table by year and position to get N rows. I want to calculate % by year (COL 3) in below table. But when I select % Total statistic it gives me % of all observations(I get COL 4). I don't see a % Total statistic on the group variable. Can anyone tell how I can calculate COL 3 of below table? YEARPOSITIONN ROWS % by year% Total2002Catcher708.244.182002Design...
noone_santosh

Discussions |
Oct 8, 2014 8:20 AM

3226 views | 1 replies
how to make a subset of a table and append data from loop

Hi, I have a set of data, (see attached). i want to check every row on a column (against a certain criteria) and then isolate rows that do not meet that criteria and subset them into a new data table. i want to be able to repeat this for multiple columns (where each has its own criteria) and continue adding to this subset table that i originally created. i'm having some trouble with this and was...
bk

Discussions |
Oct 3, 2014 7:35 AM

6049 views | 2 replies
Copying the legend box from one graph to the other

I wanted to overlay a line graph over a box plot so I used the 'copy frame contents' function to copy the frame contents of a line graph and place it over a box plot. Is there a way to also copy the legend box of the line graph to the new destination?Thank you in advance
vidushan_jeyane

Discussions |
Sep 20, 2014 12:10 AM

7313 views | 7 replies
Import from Excel yields random missing fields (dots) in JMP

Hi,

All my source data is in Excel and when importing into JMP, either by Opening the file directly or by doing a scripted Open Database(), I have some columns of numbers that show up with missing fields(dots). The data in Excel is a formula which provides a number. I can't find a pattern that would hint to why this is happening (some fields are ok).

Any suggestions or known errors?

I'm using JMP8 ...
alex

Discussions |
Sep 15, 2014 4:58 PM

6248 views | 3 replies
EMS vs REML - why do the standard errors differ?

Hi,I've just set up a series of mixed models using the Fit Model platform using one of the JMP demo data sets ("Blood Pressure", in which I've set Doses as a fixed effect and Subjects as a random effect). To analyse those models I have a choice of methodologies: EMS or REML (recommended), so I tried them both, added a pairwise comparison of the doses (the "LS Means Student's t" option on the "Eff...

Discussions |
Sep 12, 2014 12:20 PM

5910 views | 2 replies

Previous
Next

Latest Discussions

What robust methods are common for Process Capability Indices for Non-Nornal distributions?

In Europe, we found it common to use Cpkn as a non-normal Cpk metric, where mean was replaced with median, and stdev was replaced with IQR/1.35. For some "regulatory" or "customer" reports, this seems to be accepted rather than the usual "torture the data until it says its normal" approach with transformations. Does anyone have similar experience or better ideas? (Note: any use of capabilit...
mclayton200

Discussions |
Jun 19, 2014 2:05 PM

4532 views | 0 replies
Graph Builder Remove Variable

Hello,I am trying to use jsl to remove the x-axis variable and replace it with a different one. It looks like I should use the GraphBuilderBox <- Remove Variable() tool, but since I change the x-axis variable multiple times, I do not know its name and would like to use the Remove Variable(Role("X"), Position(1)) method, but this does not work. Any assistance would be appreciated.Thank you,Martin
Martin

Discussions |
Apr 15, 2014 6:44 AM

2601 views | 0 replies
How to calculate average (median) of a group of variables to get the eudlidean centre

How would I calculate the shape of the average (using the median) of a variable from a group within a data set? I need a certain function for calculating the centre of gravity (centroid) or Euclidian centre of this group of variable.
Many thanks!!
alexsheehy1992

Discussions |
Apr 2, 2014 12:17 PM

3986 views | 0 replies
How to establish a DOE related to multivariate analysis

I have encountered a DOE aspect issue as below:Background:1. A new plastic mold with 20-cavity, that means each shot/trial will yield 20 parts2. each part has two critical dimensions.3. there are 11 factors/variables (injection molding machine parameters) which will have impact on these 2 critical dimensionPurpose of DOE1. By DOE, custom design, to detect which factors/parameters are RED factor or...
mujahida

Discussions |
Mar 23, 2014 6:43 AM

2931 views | 0 replies
LD50 and LT50 calculation

Hi everybody,I would want to calculate LD50 and LT50 from a dataset organized in 6 columns:- Name of the compound (I just got 1 compound named A)- Concentration of the compound (2 dilutions per compound)- Individual number (a fixed number of 10 individuals is used per assay)- State of the individual at the end of the experiment (1 = alive, 0 = dead)- Day death (experiment last 15 days)- Experiment...
cecilia

Discussions |
Mar 5, 2014 8:13 AM

4770 views | 0 replies