Update water sector performance database 2013 and 2014

3.2.3. Quartiles

• 
  First quartile (Q1) (Quartile 1/ lower quartile/ the 25th percentile); 
  
• 
  Second quartile (Q2) or median (Quartile 2 / Median/ the 50th percentile);
  
• 
  Third quartile (Q3) (Quartile 3/ upper quartile/ the 75th percentile)
  

For example, the ratio of capacity utilization of the utilities participated in database 2014 as shown in the Annex 3.10 of the Report. It included 70 utilities with ratio of capacity utilization ranged from 24.78% to 260%.

• 
  Arranged 79 values in order from small to large and divided into 4 parts with an equal number (each consists of 22 values ​​of 22 utilities). The value at the point of division is quartile value Q1 = 66.08; Q2 = 74.03% and Q3 = 90.42%;
  
• 
  As results, 25% of the utilities with smaller proportion (or equal to) 66%, 50% of the utilities with smaller proportion (or equal to) 74% and 75% of the utilities with smaller (or equal to) 90%;
  
• 
  Each utility can know their ratio of capacity utilization and need to be improved if belong the “risk” group. For improvements, the utility can review the experience of some utilities of the higher quartile group with similar conditions.
  

3.2.4. Quartiles for data 2013 and 2014

The value of quartile (low to high) of the Utilities indicators are summarized in Table 3.3. Quartiles of Utility Indicators. Each type of indicator has the following values:

• 
  Minimum value (Min);
  
• 
  First quartile (25th percentile), Q1;
  
• 
  Median value (50^th percentile), Q2;
  
• 
  Third quartile (75^th percentile), Q3 and;
  
• 
  Maximum value: Max.
  

Table 3.1 - List of Participating Utilities in Sector Database in 2011, 2012, 2013 and 2014

Province	No.	Name of Utilities	Code of Utility			Participation
			2011	2015	IBNET	2011	2012	2013	2014
		A. Northern Midland and Mountainous Region
1. Dien Bien	1)	Dien Bien Construction, Water Supply and Sewerage Company		A01.1.B		(1)	√	√	√
2. Lai Chau	2)	Lai Chau Construction and Water Supply Company	020LCI	A02.1.B	C2	√	√	√	√
3. Son La	3)	Son La Water Supply Joint Stock Company	022SLA	A03.1.B	C1	√	√	√	√
4. Hoa Binh	4)	Hoa Binh Water Supply Joint Stock Company	018HBI	A04.1.B	C6	√	√	√	√
5.   Lao Cai	5)	Lao Cai Water Supply One Limited Company	023LCA	A05.1.B	C3	√	√	√	√
6. Ha Giang	6)	Ha Giang Water Supply and Sewerage One Limited Company	019HGI	A06.1.B	C4	√	√	√	√
7. Cao Bang	7)	Cao Bang Water Supply One Member Limited Company	026CBA	A07.1.B	C5	√	√	√	√
8.Lang Son	8)	Lang Son Water Supply and Sewerage Joint Stock Company		A08.1.B		(1)	√	√	√
9. Quang Ninh	9)	Quang Ninh Water Supply Joint Stock Company	033QNH	A09.1.B	C23	√	√	√	√
10. Yen Bai	10)	1) Yen Bai Water Supply One Member Limited Company	029YBA	A10.1.B	C8	√	√	√	√
10. Yen Bai	11)	2) Nghia Lo Construction, Water Supply and Drainage Limited Company	029NLO	A10.2.B	C72	√	√	√	√
11. Phu Tho	12)	1) Phu Tho Water Supply Joint Stock Company	0210PTH	A11.1.B	C7	√	√	√	√
11. Phu Tho	13)	2) Phu Tho Water and Electricity Construction JSC		A11.2.B
12.Tuyen Quang	14)	Tuyen Quang Water Supply and Sewerage One Member Limited Company	027TQU	A12.1.B	C9	√	√	√	√
13. Bac Kan	15)	Bac Kan Water Supply and Sewerage One Member Limited Company	0281BKA	A13.1.B	C12	√	√	√	√
14. Thai Nguyen	16)	Thai Nguyen Water Supply Joint Stock Company	0280TNG	A14.1.B	C14	√	√	√	√
15. Bac Giang	17)	Bac Giang Water Supply and Sewerage One Member Limited Company	0240BGI	A15.1.B	C11	√	√	√	√
		Total A = 17 utilities (participating: 16; not participating: 01)
		B. Red River Delta Region
1. Ha noi	18)	1) Hanoi Clean Water Supply One Member Limited Company	04HNO	B01.1.B	C19	√	√	√	√
1. Ha noi	19)	2) Construction, Investment and Water Supply Joint Stock Company (VIWACO)	04VIW	B01.2.B	C20	√	√	√	√
1. Ha noi	20)	3) Ha Dong Water Supply One Member Limited Company	04HDO	B01.3.B	C18	√		√	√
1. Ha noi	21)	4) Son Tay Water Supply Joint Stock Company	04STA	B01.4.B	C17	√	√	√	√
2. Vinh Phuc	22)	1) Vinh Phuc No.1 Water Supply and Sewerage Joint Stock Company	0211SVP	B02.1.B	C15	√	√	√	√
2. Vinh Phuc	23)	2) Vinh Phuc Water Supply Joint Stock Company	0211WVP	B02.2.B	C16	√	√	√	√
3. Bac Ninh	24)	1) Bac Ninh Water Supply and Sewerage One Member Limited Company	0241BNI	B03.1.B	C10	√	√	√	√
3. Bac Ninh	25)	2) An Viet Development Investment JSC	0241AVT	B03.2.B	C81	√	√	√	√
3. Bac Ninh	26)	3) Thuan Thanh Water Limited Company		B03.3.B			√	√	√
4. Ha Nam	27)	Ha Nam Water Supply Joint Stock Company	0351HNA	B04.1.B	C28	√	√	√	√
5. Nam Dinh	28)	Nam Dinh Water Supply One Member Limited Company	0350NDH	B05.1.B	C26	√	√	√	√
6. Ninh Binh	29)	Ninh Binh Water Supply One Member Limited Company	030NBI	B06.1.B	C27	√	√	√	√
7. Hai Duong	30)	Hai Duong Water Supply One Member Limited Company	0320HDU	B07.1.B	C22	√	√	√	√
8. Hai Phong	31)	1) Hai Phong Water Supply One Member Limited Company	031HPG	B08.1.B	C24	√	√	√	√
8. Hai Phong	32)	2) Hai Phong Construction and Water Supply JSC		B08.2.B		√	√	√	√
8. Hai Phong	33)	3) Tien Lang Construction JSC	031TLG	B08.3.B	C73	√	√	√	√
8. Hai Phong	34)	4) Hai Phong No. 2 Clean Water Supply JSC	031VCH	B08.4.B	C85	√		√	√
9.  Hung Yen	35)	1) Hung Yen Water Supply One Member Limited Company	0321HYF	B09.1.B	C21	√	√	√	√
9.  Hung Yen	36)	2) Nam Long BITEXCO JSC		B09.2.B
10. Thai Binh	37)	1) Thai Binh Water Supply One Member Limited Company	036TBH	B10.1.B	C25	√	√	√	√
10. Thai Binh	38)	2) Nam Long Water Supply Co.		B10.2.B
		Sub-total B = 21 utilities (participating: 19; not participating: 02)
		C. Central Coast Region
1. Thanh Hoa	39)	1) Thanh Hoa Water Supply One Member Limited Company	037THA	C01.1.B	C29	√	√	√	√
1. Thanh Hoa	40)	2) Thach Thanh Transport and Public Works JSC		C01.2.B
2. Nghe An	41)	Nghe An Water Supply One Member Limited Company	038NAN	C02.1.B	C30	√	√	√	√
3. Ha Tinh	42)	Ha Tinh Water Supply and Construction One Member Limited Company	039HTI	C03.1.B	C31	√	√	√	√
4. Quang Binh	43)	Quang Binh Water Supply and Sewerage One Member Limited Company	052QBI	C04.1.B	C32	√	√	√	√
5. Quang tri	44)	Quang Tri Water Supply and Construction One Member Limited Company	053QTR	C05.1.B	C33	√	√	√	√
6. Thua Thien Hue	45)	Thua Thien Hue Construction and Water Supply One Member Limited Company	054TTH	C06.1.B	C34	√	√	√	√

Каталог: COMMONS -> FileDown.aspx?filecode=1 -> 2016
2016 -> Ministry of construction
COMMONS -> Ban quản lý DỰ Án phát triển hạ TẦng kỹ thuậT (mabutip)

tải về 2.61 Mb.

Chia sẻ với bạn bè của bạn: