Question

Region	Percentage of malnourished children about to enter school	Government expenditure on education (% of total budget)
	Year 2016	Year 2016
A	29.3	4.70
B	19.2	4.17
C	3.4	7.10
D	12.8	5.40
E	31.7	4.09
F	27	4.45
G	3.1	3.82
H	5.9	5.95

Draw a conclusion on the basis of the data given in table. Use Spearman's Rank Correlation, find the correlation between the two variables. What can you comment about the development in this region?

Answer 1

Region	Malnourished Children (%)	Rank X	Education Expenditure (%)	Rank Y	d = X − Y	d2
A	29.3	2	4.70	4	−2	4
B	19.2	4	4.17	6	−2	4
C	3.4	7	7.10	1	6	36
D	12.8	5	5.40	3	2	4
E	31.7	1	4.09	7	−6	36
F	27.0	3	4.45	5	−2	4
G	3.1	8	3.82	8	0	0
H	5.9	6	5.95	2	4	16
Total						104

`R = 1 - (6sumd^2)/(n(n^2 - 1))`

`R = 1 - (6(104))/(8 (8^2 - 1))`

`R = 1 - 624/504`

R = −0.24 approximately

There is a weak negative correlation between the percentage of malnourished children and government expenditure on education.

This means that, in general, regions spending more on education tend to have lower malnutrition, but the relationship is not very strong. Therefore, the development of a region depends not only on education expenditure but also on factors such as healthcare, income, nutrition, employment and other social facilities.