CMRT Data Analytics & Reporting 4 — Questions and Answers
Question 1: Which calculation correctly determines the percentage of occupancy for a hospital unit?
- (Inpatient service days / Bed count × Days in period) × 100 (Correct answer)
- (Admissions / Bed count) × 100
- (Discharges / Total patient days) × 100
- (Available beds / Licensed beds) × 100
Correct answer: (Inpatient service days / Bed count × Days in period) × 100
Percentage of occupancy equals inpatient service days divided by the product of bed count and the number of days in the period, multiplied by 100.
Question 2: A quality analyst uses a Pareto chart to prioritize coding error types. What principle does this chart visually represent?
- The 80/20 rule — a few error types account for the majority of problems (Correct answer)
- Normal distribution of errors across all coder teams
- Sequential steps in the coding workflow
- Correlation between error rate and coder experience
Correct answer: The 80/20 rule — a few error types account for the majority of problems
A Pareto chart ranks categories by frequency and cumulates percentages, illustrating that roughly 80% of problems stem from 20% of causes.
Question 3: In SQL used for health data queries, which clause is used to filter results AFTER a GROUP BY aggregation?
- HAVING (Correct answer)
- WHERE
- ORDER BY
- JOIN
Correct answer: HAVING
The HAVING clause filters grouped/aggregated results, while WHERE filters individual rows before grouping occurs.
Question 4: A report shows that ICD-10-PCS procedure codes are frequently missing from inpatient records. Which downstream process is MOST directly harmed?
- MS-DRG assignment and hospital reimbursement (Correct answer)
- Outpatient E/M level selection
- Provider NPI verification
- Patient demographic updates
Correct answer: MS-DRG assignment and hospital reimbursement
MS-DRG grouping for inpatient claims depends on procedure codes; missing ICD-10-PCS codes can result in incorrect DRG assignment and underpayment.
Question 5: Which method ensures that a random sample of medical records selected for a coding audit is representative of the entire population?
- Simple random sampling using a random number generator (Correct answer)
- Selecting records from only the highest-volume coders
- Choosing records flagged by the billing department
- Auditing only records with denials in the past 90 days
Correct answer: Simple random sampling using a random number generator
Simple random sampling gives every record an equal chance of selection, producing a representative and unbiased sample for audit purposes.
Question 6: A hospital's data shows a sudden increase in Sepsis (A41.9) codes last quarter. Before reporting this as a clinical trend, what should the CMRT verify?
- Whether a new sepsis clinical documentation improvement initiative launched during that period (Correct answer)
- Whether the hospital's bed capacity changed
- Whether new physicians were hired in cardiology
- Whether the fiscal year reporting period changed
Correct answer: Whether a new sepsis clinical documentation improvement initiative launched during that period
A CDI initiative targeting sepsis documentation can cause apparent code-frequency increases that reflect improved documentation, not an actual disease trend.
Question 7: Which type of analytic approach predicts future patient outcomes based on historical data patterns?
- Predictive analytics (Correct answer)
- Descriptive analytics
- Prescriptive analytics
- Diagnostic analytics
Correct answer: Predictive analytics
Predictive analytics uses statistical models and machine learning on historical data to forecast future events such as readmissions or deterioration.
CMRT Data Analytics & Reporting 4
Which calculation correctly determines the percentage of occupancy for a hospital unit?