or this assignment you will once again take on Mark's role as the Lead Data Analyst for Royal Health Partners (RHP). As you've learned from your manager, the committee has elected to utilize your recommendation in a pilot form! You will be working with data provided by the care management company below.

• Excel Data Download Excel Data

Your Task!

Your taskis to review and analyze the data set from the care management company above that provides an update of the data used to calculate the diabetes and hypertension quality metrics.

• For your last project you were to describe the status of the population, for this project you are apply the appropriate epidemiological tools to determine the effect that care management has had on the sample. You will provide your results in the PowerPoint template provided below and present your results to the class.

\fV fx K102 X =COUNTIF(K2:K101,"