====== Item Statistics and Results ====== Table: **ceStatsExamSection** Aggregate of [[Stats_Item|Item Stats]], grouped by Section. Also derives some values by aggregating from Candidate performance by Section from [[Stats_Registration_Section|Registration Section Stats]]. ^Field^Description^ |StatsID|Unique Identifier for this set of Statistics| |SectionID|ID of Section all Items are a member of| |QtyQuestions|Count of all Items in this Section| |QtyCorrect|Total of all QtyCorrect for all Items in this Section| |QtySkipped|Total of all QtySkipped for all Items in this Section| |QtyIncorrect|Total of all QtyIncorrect for all Items in this Section| |RawPercent|x = Count of Correct Items in Section \\ n = Count of Candidates on Exam \\ k = Count of Items in Section \\ \\ {{:stat_rawpercent.png|}}| |ValueCorrect|Total of all ValueCorrect for all Items in this Section| |ValueSkipped|Total of all ValueSkipped for all Items in this Section| |ValueIncorrect|Total of all ValueIncorrect for all Items in this Section| |ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)| |ValuePercent|{{:stat_valuepercent.png|}}| |Difficulty|x = Count of Correct Items in Section \\ n = Count of Candidates on Exam \\ k = Count of Items in Section \\ \\ {{:stat_difficulty.png|}}| |RawHigh|Highest QtyCorrect achieved by a Candidate for this Section| |RawLow|Lowest QtyCorrect achieved by a Candidate for this Section| |RawMean|Mean (average) QtyCorrect achieved by a Candidate for this Section| |RawVariance|Variance of QtyCorrect for all Candidates for this Section| |RawStdev|Standard Deviation of QtyCorrect for all Candidates for this Section| |ValueMax|Maximum achievable points for Group from sum off all Value Max of Items in Section| |ValueHigh|Highest ValueTotal achieved by a Candidate for this Section| |ValueLow|Lowest ValueTotal achieved by a Candidate for this Section| |ValueMean|Mean (average) ValueTotal achieved by a Candidate for this Section| |ValueStdev|Standard Deviation of ValueTotal for all Candidates for this Section| |ValueVariance|Variance of ValueTotal for all Candidates for this Section| |ValueMedian|Median (middle) ValueTotal for all Candidates for this Section| |ValueMode|Mode (most frequent) ValueTotal for all Candidates for this Section| |KuderRichardson20|k = Count of Items in Section \\ Total Section Variance = Variance of Candidate Raw Scores for Section \\ Sum of p*q = sum of all items p (difficulty) * q (1-p) for all items in Section \\ \\ {{:stat_kr20.png|}}| |StandardErrorMean|s = StDev of QtyCorrect for Section \\ n = Count of Candidates \\ {{:stat_stderr.png|}}| |StandardErrorMeasurement|s = StDev of QtyCorrect for Section \\ n = Count of Candidates \\ kr20 = Kuder Richardson 20 \\ {{:stat_stderrmeasurement.png|}}| |Skewness|n = Count of Candidates \\ xi = QtyCorrect for each Candidate in Section \\ x = Mean of QtyCorrect in Section \\ s = StDev of QtyCorrect in Section \\ \\ {{:stat_skewness_1.png|}} \\ \\ Calculate Population Skewness using Sample Skewness \\ \\ {{:stat_skewness_2.png|}}| |Kurtosis|n = Count of Candidates \\ xi = QtyCorrect for each Candidate in Section \\ x = Mean of QtyCorrect for Section \\ s = StDev of QtyCorrect for Section \\ \\ Calculate Sample Kurtosis {{:stat_kurtosis_1.png|}} \\ \\ Calculate Population Kurtosis using Sample Kurtosis \\ \\ {{:stat_kurtosis_2.png|}}|