StanScore is a simple but useful utility program that converts one or more sets of raw test scores into normalized-standardized z, stens, stanines, T-scores, and percentiles. The program accepts data in several convenient formats such as from Microsoft Excel .xls and .xlsx spreadsheets, Access 1997-2003 .mdb database tables, and standard comma-separated free text files. This means that data contained in such statistical packages as SPSS and STATISTICA etc. can be easily exported into say an Excel file, then read straight into Stanscore "as is" for processing. Missing Data are recognized for each variable separately by the program - recognizing a -9999 code, a null field (two commas together in a comma-separated "csv" or "txt" file), or the usual blank entries in SPSS, STATISTICA, Excel, or ACCESS.
StanScore calculates standardised scores in an on-screen, scrollable, detailed score distribution table (which can be can saved as an Excel spreadsheet).It also provides summary perecentile, stanine and sten look-up tables that are displayed on-screen, can be printed in tabular form, and can be saved to an Excel file for other uses or re-formatting for presentation-documentation purposes.
Stanscore version 3, in line with many authors, computed percentile ranks assuming continuous scores. This used a formula that assumes a score is actually a mid-point between two integer scores. The upshot of this is that the percentiles created using this formula are usually (but not always) interpreted as the values "BELOW WHICH" n% of individuals score. Another way of putting this is to say person X with percentile rank of say 80 scores higher than 80% of the group.
The problem is this is just plain wrong for integer-scored data where percentiles need to be computed for each integer score of a psychological test. There is no continuity; there are just the numbers 0 to some maximum-possible score, with the intervals between scores as an indivisible single number of 1.
The "continuous" assumption calculation only uses half the frequencies at an observed score. So for the maximum possible score, only half the observed frequencies are used to express the final percentile. This is crazy. It is factually incorrect to state the percentile for this score is the value below which n% of the norm-group score, because half the people scoring the maximum observed score are included in the cumulative proportion. I tried to make some sense of the competing definitions in one of my Technical Whitepapers entitled "Percentiles and Percentile Ranks - confused or what?" Technical whitepaper #3.
Stanscore now computes the cumulative frequency distribution from the observed frequencies at each integer score, assuming an integer score is a discrete entity (no continuity assumption). This distribution is what you find if you computed a standard frequency distribution for a set of scores in say SPSS, STATISTICA, or another stats package. The percentiles of this distribution range between a potential minimum value of 0 (if there are no observed frequencies at 0), and ALWAYS 100. Two frequency distributions for percentiles are now presented, one using the original Stanscore 3 continuous-score cumulative proportions (for legacy comparisons with "textbook solutions"), the other using the correct discrete score cumulative proportions. Both versions stanines and stens are also computed (in fact there is litle difference between these as the stanines and stens are based upon broad category-proportions of scores rather than the more numerous percentiles.
Stanscore 5 also computes and saves normed scores for each raw score for each scale (percentiles, stens, stanines, and T-scores). See the Introduction section of the help file manual.
The program accepts anywhere from 1 to 50 scale or test score variables. This means that using the "Print-All" facility, raw-score conversion lookup tables can be printed for up to 50 variables as one command. The maximum number of cases is now 1,048,570 (Excel .xlsx file)
(click on image to expand)
Stanscore 5 manual (~29Mb)
Download the .exe Setup file (zipped; ~13Mb)
Download the .msi Installation file (~14Mb)
If you elected to install Stanscore via the .exe setup file, you will see this error message when you first run Stanscore, while attempting to open an Excel input test file which is installed in the computer's "Documents" folder (this is created by default as "Stanscore Input-Data"):
This is because accessing files in this area requires that Stanscore is run with Administrator permissions. If you installed Stanscore using the .msi file, then the Administrator permission is set automatically and you can ignore the below steps.
It's very easy to assign these Administrator permissions - just follow the four steps below:
1. Right click on the program icon, which will then show:
2. Click on Properties (highlighted above by the red box). This will then show:
3. Click on the Tab "Compatability" (highlighted above by the red box). This will then show:
4. Click on the option "Run this program as an Administrator".(highlighted here by the red box). This will look like: