I am quite new in QGIS and I really need your help.
I have a map of Kenya divided into 68 districts and I have coordinates of 30.000 schools. The points have one variable besides the latitude and longitude data called "distance to nearest school".
First I imported the map. Then I imported the spreedsheet and transformed it to a SHP file like the map. So now I have two SHP files.
The points have three variables: "Latitude", "Longitude" and "Distance to nearest school". I want to have a fourth variable called "District" and take the mean of the "Distance to nearest school" for each district.