Your Excel IQ measures your ability at Excel relative to everyone who has taken our test. A score of 100 means you are of exactly average ability. We interpret your score in terms of the following classes of Excel proficiency (using Dreyfus and Dreyfus' (1986) 'Five Stages of Skill Acquisition' model). See the diagram below.
In addition to your Excel IQ™ score, the results of our test include scores for five important sub-categories of overall Excel ability. These scores are calculated in the same way as the Excel IQ™, but rely only on those test questions that assess that particular expertise.
This is a statistical measure of a particular value of a variable below which a certain percent of observations fall. For example, a percentile of 76.54 means that your score was higher than 76.54% of all scores. It helps give some context for your Excel IQ score.
Our Excel IQ™ score is calculated in the same way as an Intelligence Quotient (IQ) score is calculated. The average score of test-takers is 100, and the spread of scores is adjusted so that 95% of candidates score between 70 and 130. The scores of people taking our test are approximately normally distributed. That means the number of people with any given score follows the pattern of this graph:
One important advantage of this type of adjusted score – called a T-score – is that it can be compared meaningfully between different tests, because variations in the difficulty of questions are factored out. Crucially this means our tests reliably measure improvement in Excel, even though users answer a different set of questions before and after any training.
Besides an overall Excel IQ™ score, our test will rate your performance in five sub-categories: orientation & efficiency, data handling, data analysis and presentation. Each sub-score is calculated in the same way as the overall score.
In more detail...
The Excel IQ™ score is calculated from your ‘raw score’ (the number of questions you answer correctly) in two steps:
Where w is your weighted score, w is the average weighted score of test-takers, and σ is the standard deviation of weighted scores of test-takers.
IQ scores are used by psychologists to define categories of intelligence eg an IQ of between 130 and 144 is categorised as ‘moderately gifted’. We have categorised Excel IQ™ similarly, eg an Excel IQ™ of between 115 and 129 means we think you are ‘proficient’ at Excel.