Data Analytics & Reporting Flashcards
7 cards from real CMRT practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Analytics & Reporting flashcards as text
Which calculation correctly determines the percentage of occupancy for a hospital unit?
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.
A quality analyst uses a Pareto chart to prioritize coding error types. What principle does this chart visually represent?
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.
In SQL used for health data queries, which clause is used to filter results AFTER a GROUP BY aggregation?
Answer: HAVING
The HAVING clause filters grouped/aggregated results, while WHERE filters individual rows before grouping occurs.
A report shows that ICD-10-PCS procedure codes are frequently missing from inpatient records. Which downstream process is MOST directly harmed?
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.
Which method ensures that a random sample of medical records selected for a coding audit is representative of the entire population?
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.
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?
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.
Which type of analytic approach predicts future patient outcomes based on historical data patterns?
Answer: Predictive analytics
Predictive analytics uses statistical models and machine learning on historical data to forecast future events such as readmissions or deterioration.