Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
stats_section [2017/02/13 11:33] 127.0.0.1 external edit |
stats_section [2017/06/07 09:52] (current) 72.38.112.148 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Item Statistics and Results ====== | ====== Item Statistics and Results ====== | ||
| - | Table: **ceStatsExamQuestionGroup** | + | 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]]. | ||
| - | Aggregate of [[Stats_Item|Item Stats]], grouped by Item Group. | ||
| ^Field^Description^ | ^Field^Description^ | ||
| |StatsID|Unique Identifier for this set of Statistics| | |StatsID|Unique Identifier for this set of Statistics| | ||
| - | |GroupID|ID of Item Group Items are linked to| | + | |SectionID|ID of Section all Items are a member of| |
| - | |QtyQuestions|Count of all Items on Exam in this Group| | + | |QtyQuestions|Count of all Items in this Section| |
| - | |QtyCorrect|Total of all QtyCorrect for all Items in this Group| | + | |QtyCorrect|Total of all QtyCorrect for all Items in this Section| |
| - | |QtySkipped|Total of all QtySkipped for all Items in this Group| | + | |QtySkipped|Total of all QtySkipped for all Items in this Section| |
| - | |QtyIncorrect|Total of all QtyIncorrect for all Items in this Group| | + | |QtyIncorrect|Total of all QtyIncorrect for all Items in this Section| |
| - | |RawPercent|x = Count of Correct Items in Group \\ n = Count of Candidates on Exam \\ k = Count of Items in Group \\ \\ {{:stat_rawpercent.png|}}| | + | |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 Group| | + | |ValueCorrect|Total of all ValueCorrect for all Items in this Section| |
| - | |ValueSkipped|Total of all ValueSkipped for all Items in this Group| | + | |ValueSkipped|Total of all ValueSkipped for all Items in this Section| |
| - | |ValueIncorrect|Total of all ValueIncorrect for all Items in this Group| | + | |ValueIncorrect|Total of all ValueIncorrect for all Items in this Section| |
| |ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)| | |ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)| | ||
| |ValuePercent|{{:stat_valuepercent.png|}}| | |ValuePercent|{{:stat_valuepercent.png|}}| | ||
| - | |Difficulty|x = Count of Correct Items in Group \\ n = Count of Candidates on Exam \\ k = Count of Items in Group \\ \\ {{:stat_difficulty.png|}}| | + | |Difficulty|x = Count of Correct Items in Section \\ n = Count of Candidates on Exam \\ k = Count of Items in Section \\ \\ {{:stat_difficulty.png|}}| |
| - | |ValueMax|Maximum achievable points for Group from sum off all Value Max of Items in Group| | + | |RawHigh|Highest QtyCorrect achieved by a Candidate for this Section| |
| - | |ValueHigh|Highest ValueTotal achieved by a Candidate for this Group| | + | |RawLow|Lowest QtyCorrect achieved by a Candidate for this Section| |
| - | |ValueLow|Lowest ValueTotal achieved by a Candidate for this Group| | + | |RawMean|Mean (average) QtyCorrect achieved by a Candidate for this Section| |
| - | |ValueMean|Mean (average) ValueTotal achieved by a Candidate for this Group| | + | |RawVariance|Variance of QtyCorrect for all Candidates for this Section| |
| - | |ValueStdev|Standard Deviation of ValueTotal for all Candidates for this Group| | + | |RawStdev|Standard Deviation of QtyCorrect for all Candidates for this Section| |
| - | |ValueVariance|Variance of ValueTotal for all Candidates for this Group| | + | |ValueMax|Maximum achievable points for Group from sum off all Value Max of Items in Section| |
| - | |ValueMedian|Median (middle) ValueTotal for all Candidates for this Group| | + | |ValueHigh|Highest ValueTotal achieved by a Candidate for this Section| |
| - | |ValueMode|Mode (most frequent) ValueTotal for all Candidates for this Group| | + | |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|}}| | ||
