Question: Using excel data sheet containing TB data with variables, hospital name, your primary goal is to conduct a comprehensive analysis of the data and create
Using excel data sheet containing TB data with variables, "hospital name", your primary goal is to conduct a comprehensive analysis of the data and create a pivot table on a new worksheet using all inserted cells. Varibale name are "facilityname", "periodnamedate in month &yearPHC headcount years and older "Screen for TB years and older", "Client years and older eligible for TB test TB test years and older using GeneXpert", DSTB bacteriologically confirmed years and older", DSTB clinically diagnosed years and older DSTB treatment start years and older".
aEfficiently identify High Burden facilities based on Headcount using any method, including PIVOT Table or other suitable techniques.
b Generate a TB Cascade Graph representing the data for the identified high burden facilities.
c Identify issues related to data elements and assess the overall data quality based on the performance of the facilities.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
