How do I get Z-scores in JMP?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.
Basic Data Analysis and ModelingRe: How do I get Z-scores in JMP?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?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?Yes, this is very helpful. Thank you so much!
Re: How do I get Z-scores in JMP?Thank you very much! This worked.
