3. 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)(1 claim to 50percentile) Tier 4 (Low Risk) (0 claims) b. Add a new column to the Beneficiary table that indicates the tier of the patient c. Add a new column to the beneficiary table that calculates patient age in 2022 (2022 - Year of birth) d. For each tier identify i. Average and claim count and claim amount 25.72418 116352 ii. Percentage of the population with each type of chronic condition iii. Percentage of population in different age ranges (65 -74, 75-85, 85+) e. Write a narrative description of each tier and Health IT recommendations for providing services that can reduce costs and improving quality of care (about 150 words). For understanding role of Health IT see i. Slides 4-7 Population Health and Application of Health IT ii. Accountable care and Health IT Submit 1. Excel File that includes Patient Risk Tier and Age for each patient 2. Well formatted report that includes responses to all questions above with appropriate headings/subheadings