Create a second worksheet named Scoring Key . In this tab, list the 10 clinical scales (Hs, D, Hy, Pd, Mf, Pa, Pt, Sc, Ma, Si) plus validity scales (L, F, K, VRIN, TRIN). For each of the 567 items, indicate which scale it belongs to and whether True or False is the pathological response.
This turns Excel from a calculator into an interactive clinical assistant. mmpi2 excel better
Employ Excel’s VLOOKUP function to instantly match raw scores with T-scores from normative tables, as suggested by this AACN tutorial . Create a second worksheet named Scoring Key