: Displays Raw Scores, K-corrected scores, and final T-scores.
Additionally, various supplementary scales and subscales (such as the Harris-Lingoes subscales) may be included for more nuanced interpretation.
Optimizing MMPI-2 Administration and Data Management Using Excel
For those not proficient in VBA, various workflow guides available online can help automate reporting from spreadsheets.
Unlike proprietary software that may require installation, activation keys, or specific operating systems, Excel spreadsheets can be shared among colleagues and opened on virtually any device.
Research use (de-identified):
Each scale consists of specific items answered in a specific direction (True or False). Use SUMPRODUCT to calculate the raw score for a scale based on an answer key array. =SUMPRODUCT((Input_Responses=Scale_Key_Responses)*1) Use code with caution. Step 2: Applying K-Correction
: Cells for Client ID, Age, Gender (critical for norm selection), and Test Date.
The most efficient way to process MMPI-2 data is to set up a . Do not manually add up items one by one on a calculator—that is prone to human error.
