Ratios in JMP

Question

Hello, I would like to question what is the best way to insert ratios in JMP. It seems to me that 52:48 and 53:47 and so on doesn't quite work for conclusive data analysis... The purpose is to use them for correlation coefficient calculations.

Thank you in advance!

Helena

HelenaG · Answer

Thank you all @Thierry_S @Jeff_Perkinson @ih for these helpful insights. My goal is to use the ratios as X and correlate them (using Pearson and Spearman coefficients) with a Y (yield).

Thierry_S · Answer

Hi,
As my peers have indicated, it is a bit difficult to tell what is your end goal but I'm guessing that you want to capture the weight of the ratio as well as the ratios themselves. Hence, I would suggest that you calculate the ratios as @ih mentioned and create a new column as the sum of the numerator and denominator as Weight. Then you can analyze these data using the ratios as your Ys and the Weight as weight. Is that a good guess or am I going on a tangent?
Best,
TS

Jeff_Perkinson · Answer

As @ih says, ratios are usually entered as a decimal but perhaps we're not understanding exactly what you want to do.

Can you tell us more about what you mean by ratios and how you want to use them? What do the 52 and the 48 represent in your example, 52:48? They might be better represented as separate columns in your data table.