Raw scores must be converted to T-scores using normative data provided in the MMPI-2 manual. Excel’s VLOOKUP or XLOOKUP functions can automate this by referencing a lookup table containing normative means and standard deviations for different demographics.
[SCORE PROFILE] (after clicking "Calculate") Scale Raw K-corr T-score Interpretation L 4 4 48 Normal F 12 12 72 Elevated K 15 15 55 Normal Hs 8 12 68 Borderline ... mmpi-2 excel
Assuming your Raw Scale 1 score is in cell B2 and your K score is in cell C2: =B2 + (0.5 * C2) Raw scores must be converted to T-scores using