topic Re: Ratios in JMP in Discussions

Ratios in JMP

HelenaG — Sat, 10 Jun 2023 23:26:15 GMT

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

Re: Ratios in JMP

ih — Thu, 18 Feb 2021 17:38:55 GMT

Without knowing what platform or analyses you want to use the ratios it is hard to say, but it is pretty common to express those as a decimal, so 52:48 might be just 0.52.

Re: Ratios in JMP

Jeff_Perkinson — Thu, 18 Feb 2021 23:17:57 GMT

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.

Re: Ratios in JMP

Thierry_S — Fri, 19 Feb 2021 06:01:03 GMT

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

Re: Ratios in JMP

HelenaG — Fri, 19 Feb 2021 10:07:30 GMT

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).