2. Analyze the given claims dataset and calculate the following measures (2 points) a. The 25 percentile, mean, median, 75 and 100th percentile values for number of outpatient claims b. The 25 percentile, mean, median, 75 and 100th percentile values for amount of Medicare outpatient reimbursement 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)(25-50%) Tier 4 (Low Risk) (0-25%) b. Add a new column to the Beneficiary table that indicates the tier of the patient 2. Analyze the given claims dataset and calculate the following measures (2 points) a. The 25 percentile, mean, median, 75 and 100th percentile values for number of outpatient claims b. The 25 percentile, mean, median, 75 and 100th percentile values for amount of Medicare outpatient reimbursement 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)(25-50%) Tier 4 (Low Risk) (0-25%) b. Add a new column to the Beneficiary table that indicates the tier of the patient