This is an old revision of the document!
Item Statistics and Results
Table: ceStatsExamQuestion
Aggregate of Candidate Items Stats for each Item on the Exam.
| Field | Description |
|---|---|
| StatsID | Unique Identifier for this set of Statistics |
| QtyQuestions | Count of all Items on the Exam |
| QtyCandidates | Count of all Candidates taking the Exam |
| QtyCompetencies | Count of distinct Competencies from all Items on the Exam |
| QtySections | Count of Sections on the Exam |
| ValueMax | Maximum achievable points for Exam, from sum of all Value Max of Items on the Exam |
| QtyCorrect | Total of all QtyCorrect for all Items on the Exam |
| QtySkipped | Total of all QtySkipped for all Items on the Exam |
| QtyIncorrect | Total of all QtyIncorrect for all Items on the Exam |
| RawPercent | x = Count of Correct Items on Exam n = Count of Candidates on Exam k = Count of Items on Exam  |
| ValueCorrect | Total of all ValueCorrect for all Items on the Exam |
| ValueSkipped | Total of all ValueSkipped for all Items on the Exam |
| ValueIncorrect | Total of all ValueIncorrect for all Items on the Exam |
| ValueTotal | (ValueCorrect + ValueSkipped + ValueIncorrect) |
| ValuePercent |  |
| Difficulty | x = Count of Correct Items on Exam n = Count of Candidates on Exam k = Count of Items on Exam  |
| RawHigh | Highest QtyCorrect achieved by a Candidate on the Exam |
| RawLow | Lowest QtyCorrect achieved by a Candidate on the Exam |
| RawMean | Mean (average) QtyCorrect achieved by a Candidate on the Exam |
| RawVariance | Variance of QtyCorrect for all Candidates on the Exam |
| RawStdev | Standard Deviation of QtyCorrect for all Candidates on the Exam |
| ValueHigh | Highest ValueTotal achieved by a Candidate on the Exam |
| ValueLow | Lowest ValueTotal achieved by a Candidate on the Exam |
| ValueMean | Mean (average) ValueTotal achieved by a Candidate on the Exam |
| ValueVariance | Variance of ValueTotal for all Candidates on the Exam |
| ValueStdev | Standard Deviation of ValueTotal for all Candidates on the Exam |
| ValueMedian | Median (middle) ValueTotal for all Candidates on the Exam |
| ValueMode | Mode (most frequent) ValueTotal for all Candidates on the Exam |
| PercentDistribution | Text field which holds a summary of the score distributions. Not a statistic, but used in reporting |
| QtyPassExam | Count of Candidates that passed Exam. See Candidate Statistics (PassExam)  link |
| SpearmanRank | n = Number of Candidates RankOdd = Candidates Ranking on Odd Items only compared to all other Candidates on Exam RankEven = Candidates Ranking on Odd Items only compared to all other Candidates on Exam  |
| SpearmanBrown |  |
| KuderRichardson20 | k = Count of Items on Exam Total Test Variance = Variance of Candidate Raw Scores Sum of p*q = sum of all items p (difficulty) * q (1-p) for all items in Exam  |
| KuderRichardson21 | qtyX = Count Items answered correctly on Exam x ̅ = Mean of QtyCorrect for each Candidate on Exam s = StDev of Raw Scores of all Candidates on Exam  |
| StandardError | s = StDev of QtyCorrect for Exam n = Count of Candidates  |
| AlphaCoefficient | k = Count of Items on Exam Total Test Variance = Variance of Candidate Raw Scores Sum of Item Variance = Sum of all item variances on Exam  |
| Skewness | n = Count of Candidates xi = QtyCorrect for each Candidate on Exam x ̅ = Mean of QtyCorrect on Exam s = StDev of QtyCorrect on Exam  Calculate Population Skewness using Sample Skewness  |
| Kurtosis | n = Count of Candidates xi = QtyCorrect for each Candidate on Exam x ̅ = Mean of QtyCorrect for Exam s = StDev of QtyCorrect for Exam Calculate Sample Kurtosis  Calculate Population Kurtosis using Sample Kurtosis  |
| AlternateSystem | Stores Alternate Value used for Calculation (True, Custom, ZScore, TScore,…) see Alternate Scores link |
| AlternateBase | Alternate used in Alternate Calculations see Alternate Scores link |
| AlternateMean | Alternate Mean used in Alternate Calculations see Alternate Scores link |
| AlternateStDev | Alternate Standard Deviation used in Alternate Calculations see Alternate Scores link |
| QuestionLogitSum | Future use |
| QuestionLogitMean | Future use |
| QuestionLogitVariance | Future use |
| QuestionLogitSquaredSum | Future use |
| QuestionSpreadExpansion | Future use |
| CandidateLogitSum | Future use |
| CandidateLogitMean | Future use |
| CandidateLogitVariance | Future use |
| CandidateLogitSquaredSum | Future use |
| CandidateSpreadExpansion | Future use |
Aggregate of Candidate Items Stats for each Item on the Exam. StatsID Unique Identifier for this set of Statistics QuestionID ID of Item in the Bank Sequence Sequence of Item on the Exam ValueMax Maximum achievable points for Item QtyCorrect Total of all QtyCorrect for Item for all Candidates QtySkipped Total of all QtySkipped for Item for all Candidates QtyIncorrect Total of all QtyIncorrect for Item for all Candidates RawPercent x = Count of Correct Items on Exam n = Count of Candidates on Exam x/(n*100) ValueCorrect Total of all ValueCorrect for Item for all Candidates ValueSkipped Total of all ValueSkipped for Item for all Candidates ValueIncorrect Total of all ValueIncorrect for Item for all Candidates ValueTotal (ValueCorrect + ValueSkipped + ValueIncorrect) ValuePercent ValueTotal/(ValueMax*100) Difficulty (p) x = Count of Correct Items on Exam n = Count of Candidates on Exam x/n ValueLow Lowest ValueTotal achieved by a Candidate for this Item ValueHigh Highest ValueTotal achieved by a Candidate for this Item ValueMean Mean (average) ValueTotal achieved by a Candidate for this Item ValueStdev Standard Deviation of ValueTotal for all Candidates for this Item ValueVariance Variance of ValueTotal for all Candidates for this Item ValueMedian Median (middle) ValueTotal for all Candidates for this Item ValueMode Mode (most frequent) ValueTotal for all Candidates for this Item QuestionDiscrimination Q1 is the Count of Candidates who responded correctly to Item whose Value total is in the top 27% of all Candidates taking the Exam. Q4 is the Count of Candidates who responded correctly to Item whose Value total is in the top 27% of all Candidates taking the Exam. A value between -1 and 1 n = Count of Candidates 1)/n Biserial Currently Uncalculated. Point Biserial m1 = Mean of correct on Exam for all Candidates that answered correctly. m0 = Mean of correct on Exam for all Candidates that answered incorrectly. n1 = Count of all Candidates that answered correctly. n0 = Count of all Candidates that answered incorrectly. s = Standard deviation of Candidate correct on Exam n = Total number of Candidates on Exam
2)/3)* √4)/5)) QtyCorrectTop50 Count of Candidates who responded correctly to Item whose Value total was in top 50% of all Candidates taking Exam QtyCorrectBottom50 Count of Candidates who responded incorrectly to Item whose Value total was in top 50% of all Candidates taking Exam TimeTotal Total Time for all Candidates on this Item. Used in Online testing Dichotomous True if Item has one correct response worth 1 point and all other responses are incorrect worth 0 points. PROXScore Future use PROXProportion Future use PROXLogit Future use PROXCalibration Future use PROXCalibrationFinal Future use PROXCalibrationError Future use IncludeStats True if Item is not experimental
Item Statistics by Competency Table: ceStatsExamCompetency Aggregate of Item stats, grouped by Competency. StatsID Unique Identifier for this set of Statistics CompetencyID ID of the Competency Items linked to IsRollup If true is a base Competency rollup (A, A-1, A-2) If false is the single Competency (A only) QtyQuestions Count of all Items on Exam in this Competency QtyCorrect Total of all QtyCorrect for all Items in this Competency QtySkipped Total of all QtySkipped for all Items in this Competency QtyIncorrect Total of all QtyIncorrect for all Items in this Competency RawPercent x = Count of Correct Items in Competency n = Count of Candidates on Exam k = Count of Items in Competency x/(n*k*100) ValueCorrect Total of all ValueCorrect for all Items in this Competency ValueSkipped Total of all ValueSkipped for all Items in this Competency ValueIncorrect Total of all ValueIncorrect for all Items in this Competency ValueTotal (ValueCorrect + ValueSkipped + ValueIncorrect) ValuePercent ValueTotal/(ValueMax*100) Difficulty x = Count of Correct Items in Competency n = Count of Candidates on Exam k = Count of Items in Competency x/(n*k) ValueMax Maximum achievable points for Competency from sum off all Value Max of Items in Competency ValueHigh Highest ValueTotal achieved by a Candidate for this Competency ValueLow Lowest ValueTotal achieved by a Candidate for this Competency ValueMean Mean (average) ValueTotal achieved by a Candidate for this Competency ValueStdev Standard Deviation of ValueTotal for all Candidates for this Competency ValueVariance Variance of ValueTotal for all Candidates for this Competency ValueMedian Median (middle) ValueTotal for all Candidates for this Competency ValueMode Mode (most frequent) ValueTotal for all Candidates for this Competency
