Introduction - Ahmadabad

This report aims to provide a birds eye view of the district through the lens of village amenities data released by census in 2011. Before moving towards the descriptive insights from the census data, here is what pops up when a search is executed for Ahmadabad district Gujarat on wikipedia.

Summary Statistics

Total Number of Villages: 512

Total Number of Gram Panchayat: 486

Total Number of Sub Districts: 10

Total Population : 1.151178^{6}

Statistical Summaries at the subdistrict level

Sub District	Total Population	Total SC Population	Total ST Population	Total Area of Vilalges	Total Area Sown (Net)
Barwala	58035	3506	141	45436.41	36007.00
Bavla	115733	11081	9849	72830.25	52081.06
Daskroi	186782	13222	2236	41244.57	32343.32
Detroj-Rampura	83199	5869	73	35365.02	30087.12
Dhandhuka	112777	10043	217	170321.15	110765.85
Dholka	168907	25335	1394	99866.07	76523.82
Mandal	70346	8068	58	47525.70	40684.47
Ranpur	75982	5715	48	40713.44	30195.40
Sanand	141955	16871	235	62682.47	52112.79
Viramgam	137462	18792	2498	87157.89	72957.34

Population and Geographical Area

It is of interest to look into which are the most densely populated villages. We can do this by creating a simple scatter plot between population of village and the total geographical area of a village.

Irrigation for Agriculture

The census provides the net area sown (hectares) in a village along with area irrigated with water source in hectares. The area under irrigation may be affected by several factors.

Area Sown vs Area under Irrigation

A distribution for the percentage of area irrigated will be interesting to look at.

Understanding what drives area under irrigation

Much is heard about rain fed agriculture in India. There are several factors that can affect area under irrigation - ranging from government supports, demographics, distance from urban clusters and several known and unknown variables. With the given data we can check if the following variables have any relation with area under irrigation:

Percentage of Marginalised group population in village
Distance from Major government offices
Distance from urban center
Total population of a village

A simple Linear regression to see if the above explanation has any merit


	Dependent variable:

	perc_irrigated_over_net_sown

total_population_of_village	0.001
	(0.001)

perc_marginalised_pop	0.140
	(0.122)

district_head_quarter_distance_in_km	0.013
	(0.107)

sub_district_head_quarter_distance_in_km	-0.476^**
	(0.203)

nearest_statutory_town_distance_in_km	-0.096
	(0.201)

sub_district_nameBavla	32.030^***
	(11.064)

sub_district_nameDaskroi	39.333^***
	(13.950)

sub_district_nameDetroj-Rampura	12.555
	(9.166)

sub_district_nameDhandhuka	-18.629^***
	(6.783)

sub_district_nameDholka	42.498^***
	(10.326)

sub_district_nameMandal	-0.725
	(8.325)

sub_district_nameRanpur	16.065^**
	(6.847)

sub_district_nameSanand	48.851^***
	(12.084)

sub_district_nameViramgam	10.388
	(9.177)

Constant	32.150^**
	(14.273)


Observations	505
R²	0.456
Adjusted R²	0.441
Residual Std. Error	25.741 (df = 490)
F Statistic	29.373^*** (df = 14; 490)

Note:	p<0.1; p<0.05; p<0.01

Model Diagnostic plots

Note

This is to serve as a minimal example of creating parameterised reports with .rmd/.qmd files. This document is in no way analytically or statistically rigorous.