Exam Statistics and Results
Table: ceStatsExam
Aggregation of all Item Stats for 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 Registrant Statistics |
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 |
StandardErrorMeasurement | s = StDev of QtyCorrect for Exam n = Count of Candidates kr20 = Kuder Richardson 20 |
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 |
AlternateBase | Alternate used in Alternate Calculations see Alternate Scores |
AlternateMean | Alternate Mean used in Alternate Calculations see Alternate Scores |
AlternateStDev | Alternate Standard Deviation used in Alternate Calculations see Alternate Scores |
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 |