Home » Topics » Service Provision Assessment (SPA) » Aggregating data from facility to Province level (Weighting )
Aggregating data from facility to Province level [message #22283] |
Tue, 23 February 2021 14:52 ![Go to next message Go to next message](/theme/default/images/down.png) |
spet2094
Messages: 3 Registered: February 2021
|
Member |
|
|
Hello,
My team is looking at several indicators for SPA and we have a question on how to aggregate data on facilities of different sizes up to province level. For example could you provide guidance on how to relatively weight the refrigeration capabilities of a clinic versus a hospital and then get to a province level estimate?
Looking forward to your response, -- also if I need to provide more detail do let me know.
|
|
|
|
|
|
Re: Aggregating data from facility to Province level [message #22467 is a reply to message #22351] |
Tue, 16 March 2021 19:39 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
spet2094
Messages: 3 Registered: February 2021
|
Member |
|
|
Dear Tom
Thank you very much for your response on refrigeration and for sharing the report.
I have a follow up question regarding the number of health care workers per 10,000 population.
I found two points of guidance on this:
1. (The number of health workers at a given time in a given country or region / Total population for the same geographical area)
The ratio can be adjusted to per 10,000 population by multiplying the numerator and denominator by the same factor required for the denominator to equal 10,000.
and
2. For the SARA indicator: N per 10,000 population/23 * 100 (max.100)
So I think this means that the first indicator can only be calculated at the admin level seeing as in most cases we do not know the population that the health facility itself serves. Therefore if we were to map health facility provision, for individual facilities, it would make most sense to map the raw numbers of total health care workers per facility. But for aggregation to health zone level, we would sum the health care workers across facilities and divide by the population of the health zone. So e.g. if there were a total of 20 healthcare workers over a health zone of 20,000 we would do 20*.5/20,000*.5 ie. 0.001 HCW for 10,000 population. Is that correct?
What if we were to want to know the average number of health care workers (HCW) per health zone. For that would we add any facility weighting?
Then finally, for the SARA indicator, on the understanding that 23 is the metric for the minimum number of HCW per 10,000 population according to WHO standards, is it correct to say that the indicator is telling us the percentage of the target number of HCW per 10,000 population that the health zone/admin area is acheiving?
Thanks again for your response
Regards
|
|
|
Re: Aggregating data from facility to Province level [message #22473 is a reply to message #22467] |
Wed, 17 March 2021 16:09 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Bridgette-DHS
Messages: 3151 Registered: February 2013
|
Senior Member |
|
|
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:
We do not normally produce estimates of healthcare workers per 100,000 population. To weight the numbers of health workers in the sampled facilities up to the population of all facilities, you would need to know the non-normalized sampling fraction for each facility. This may not be available. You would have to look at the sampling information in the SPA report. If the sampling fractions are not given explicitly in the report or in the data files, then they are not available. For SPA censuses, as in Malawi and Haiti, there is no problem. The total number of health workers would be divided by the total population and multiplied by 100,000. But in any case there may be health workers in some settings, such as private doctors' offices, who are not captured by a SPA.
We do not work with SARA data and we cannot answer questions about it.
|
|
|
Goto Forum:
Current Time: Sat Sep 7 01:23:48 Coordinated Universal Time 2024
|