Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
stats_item_distribution [2017/02/13 11:08]
127.0.0.1 external edit
stats_item_distribution [2017/03/06 14:04] (current)
steveclarke
Line 1: Line 1:
-====== Item Statistics and Results ====== +====== Item Response Distribution ​Statistics and Results ====== 
-Table: **ceStatsExamQuestion**+Table: **ceStatsExamQuestionDistribution**
  
-Aggregate ​of [[stats_candidate_item|Candidate Item Stats]] ​for each Item on the Exam.+The response distributions are counts ​of Candidates in certain ranking thresholds that match a given response. ​ The rankings ​for the candidates is based on their Ranking of ValueTotal ​on the Exam compared to all other Candidates performance.
  
 ^Field^Description^ ^Field^Description^
 |StatsID|Unique Identifier for this set of Statistics| |StatsID|Unique Identifier for this set of Statistics|
 |QuestionID|ID of Item in the Bank| |QuestionID|ID of Item in the Bank|
 +|Response|Response for Multiple Choice: \\ -2(Not Reached) \\ -1 (Bubbling Error) \\ 0 (Skipped) \\ 1 (A) \\ 2 (B) \\ … \\ \\ Response for Essay = point value awarded|
 |Sequence|Sequence of Item on the Exam| |Sequence|Sequence of Item on the Exam|
-|ValueMax|Maximum achievable points for Item+|Decile1|Count of Candidates in Decile 1 (Exam) that match this response, see [[stats_concepts#​decile|Decile]]
-|QtyCorrect|Total of all QtyCorrect for Item for all Candidates| +|Decile2|Count of Candidates ​in Decile 2 (Exam) that match this response
-|QtySkipped|Total of all QtySkipped for Item for all Candidates| +|Decile3|Count of Candidates ​in Decile 3 (Exam) that match this response
-|QtyIncorrect|Total of all QtyIncorrect for Item for all Candidates| +|Decile4|Count of Candidates ​in Decile 4 (Exam) that match this response
-|RawPercent|x = Count of Correct Items on Exam \\ n = Count of Candidates ​on Exam \\ \\ {{:​stat_rawpercent_candidate.png|}}+|Decile5|Count of Candidates ​in Decile 5 (Exam) that match this response
-|ValueCorrect|Total of all ValueCorrect for Item for all Candidates| +|Decile6|Count of Candidates ​in Decile 6 (Exam) that match this response
-|ValueSkipped|Total of all ValueSkipped for Item for all Candidates| +|Decile7|Count of Candidates ​in Decile 7 (Exam) that match this response
-|ValueIncorrect|Total of all ValueIncorrect for Item for all Candidates| +|Decile8|Count of Candidates ​in Decile 8 (Exam) that match this response
-|ValueTotal|(ValueCorrect + ValueSkipped + ValueIncorrect)| +|Decile9|Count of Candidates in Decile 9 (Examthat match this response
-|ValuePercent|{{:​stat_valuepercent.png|}}| +|Decile10|Count of Candidates ​in Decile 10 (Exam) that match this response
-|Difficulty|x = Count of Correct Items on Exam \\ n = Count of Candidates ​on Exam \\ \\ {{:​stat_difficulty_candidate.png|}}+|Distribution1|Count of Candidates in top 20(Exam) that match this response| 
-|QuestionDiscrimination|A value between -1 and 1 \\ \\ Q1 is the Count of Candidates ​who responded correctly to Item whose Value total is in the top 27of all Candidates taking the Exam. \\ Q4 is the Count of Candidates ​who responded correctly to Item whose Value total is in the top 27of all Candidates taking the Exam. \\ n = Count of Candidates \\ \\ {{:​stat_questiondiscrimination.png|}}+|Distribution2|Count of Candidates in 20to 40% (Exam) that match this response
-|BiserialExam|FIXME biserials| +|Distribution3|Count of Candidates ​in 40% to 60% (Examthat match this response
-|PointBiserialExam|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 \\ \\ {{:​stat_pointbiserial.png|}}+|Distribution4|Count of Candidates ​in 60% to 80% (Examthat match this response
-|BiserialCorrectedExam|FIXME biserials| +|Distribution5|Count of Candidates ​in bottom 20% (Examthat match this response
-|PointBiserialCorrectedExam|FIXME biserials| +|Correct|True if the response is considered ​correct option ​for Multiple Choice Items or is passing value for Essay Items
-|BiserialSection|FIXME biserials| +|DistBottom50|Count of Candidates in bottom 50% (Examthat match this response
-|PointBiserialSection|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 \\ \\ {{:​stat_pointbiserial.png|}}+|DistTop50|Count of Candidates ​in top 50% (Exam) that match this response
-|BiserialCorrectedSection|FIXME biserials| +|Biserial|See [[stats_concepts#​biserial_calculations|Biserials]]
-|PointBiserialCorrectedSection|FIXME biserials| +|Quartile1|Count of Candidates in top 27% (Examthat match this response
-|BiserialCompetency|FIXME biserials| +|Quartile2|Count of Candidates in 27% to 50% (Examthat match this response
-|PointBiserialCompetency|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 \\ \\ {{:​stat_pointbiserial.png|}}+|Quartile3|Count of Candidates in 50% to 77% (Exam) that match this response
-|BiserialCorrectedCompetency|FIXME biserials| +|Quartile4|Count of Candidates in bottom 27(Exam) that match this response| 
-|PointBiserialCorrectedCompetency|FIXME biserials| + 
-|ValueLow|Lowest ValueTotal achieved by Candidate ​for this Item| + 
-|ValueHigh|Highest ValueTotal achieved by Candidate ​for this Item+ 
-|ValueMean|Mean (averageValueTotal 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 ​(middleValueTotal for all Candidates for this Item+
-|ValueMode|Mode (most frequentValueTotal for all Candidates for this Item+
-|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 50of all Candidates taking ​Exam+
-|TimeTotal|Total Time for all Candidates on this Item.  Used in Online testing FIXME link| +
-|Dichotomous|True if Item has one correct ​response ​worth 1 point and all other responses are incorrect worth 0 points.+
-|IncludeInStats|FIXME explain| +
-|PROXScore|Future use| +
-|PROXProportion|Future use| +
-|PROXLogit|Future use| +
-|PROXCalibration|Future use| +
-|PROXCalibrationFinal|Future use| +
-|PROXCalibrationError |Future use|+