Competency Statistics and Results
Table: ceStatsExamCompetency
Aggregate of Item Stats, grouped by Competency.
| Field | Description |
|---|---|
| StatsID | Unique Identifier for this set of Statistics |
| IsRollup | If true is a base Competency rollup (A, A-1, A-2) If false is the single Competency (A only) |
| CompetencyID | ID of the Competency Items linked to |
| QtyQuestions | Count of all Items 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  |
| 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 |  |
| Difficulty | x = Count of Correct Items in Competency n = Count of Candidates on Exam k = Count of Items in Competency  |
| 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 |
