topic How do I get Z-scores in JMP? in Discussions

How do I get Z-scores in JMP?

CompositeLemur6 — Wed, 22 Oct 2025 17:43:53 GMT

Hello,

I am looking to figure out how to find Z-scores for my data in JMP, which is not a simple matched pairs. This is what some of my data looks like:

I'm looking at protein concentrations (JS values) for different proteins at 3 time points (day 0, day 30, day 90) for multiple subjects (only subject 1 and 2 are here). Is there a way I can format this data to obtain Z-scores for each protein type using JMP? I do not completely understand JMP or how to manipulate this sort of data, so any help would be appreciated.

Thank you so much.

Re: How do I get Z-scores in JMP?

statman — Wed, 22 Oct 2025 18:32:28 GMT

You can always add columns with formulae. Z-score = mean - (data point of interest) divided by standard deviation.

Re: How do I get Z-scores in JMP?

Victor_G — Wed, 22 Oct 2025 22:11:34 GMT

Hi @CompositeLemur6,

Following the advice from @statman, JMP has some "built-in" functions that can be used easily.
One of them is "Standardize", which directly does the calculation you want. Simply right-click on the column you want to standardize, then go to "Distributional" menu and then choose "Standardize" : https://www.jmp.com/support/help/en/18.2/#page/jmp/transform-columns-in-a-jmp-platform.shtml

If you want to standardize the values by protein, simply right-click on "protein name" column and choose "Group By" before standardizing the values.

Hope this answer will help you,

Re: How do I get Z-scores in JMP?

CompositeLemur6 — Thu, 23 Oct 2025 01:37:06 GMT

Yes, this is very helpful. Thank you so much!

Re: How do I get Z-scores in JMP?

CompositeLemur6 — Thu, 23 Oct 2025 01:37:22 GMT

Thank you very much! This worked.