1. Classify patients into 4 tiers based on number of claims. (6 p
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →1. Classify patients into 4 tiers based on number of claims. (6 points)a. Tier 1 (High-Risk) (75-100 percentile); Tier 2 (Rising Risk) (50-75percentile), Tier 3 (Med Risk)(25-50%) Tier 4 (Low Risk) (0-25%) b. Add a new column to the Beneficiary table that indicates the tier of the patientc. Add a new column to the beneficiary table that calculates patient age in 2019 (2019 – Year of birth) a. For each tier identifyi. Average and Median Claim count and claim amountii. Percentage of the population with each type of chronic conditioniii. Percentage of population in different age ranges (65 -74, 75-85, 85+)
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds