Question
Take the percentile formula from the formula Below and make NEW EXCEL FORMULA to: PERCENTILE.INC(Table1[NUM_CLAIMS_OP],0.75) Classify patients into 4 tiers based on a number of
Take the percentile formula from the formula Below and make NEW EXCEL FORMULA to:
PERCENTILE.INC(Table1[NUM_CLAIMS_OP],0.75)
Classify patients into 4 tiers based on a number of claims.
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)
Step by Step Solution
3.38 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
Alright we are going to create a new column that will classify patients based on ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Government and Not for Profit Accounting Concepts and Practices
Authors: Michael H. Granof, Saleha B. Khumawala
6th edition
978-1-119-4958, 9781118473047, 1118155971, 1118473043, 978-1118155974
