How do I get Z-scores in JMP?

[#1]

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.

[#2 · Accepted solution]

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

[#3]

Thank you very much! This worked.

[#4 · Accepted solution]

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,

[#5]

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