Digital Representation / BMEEPAGA205

Data Management⁺

Let us process the data of the settlements of Hungary Source: KSH new. The table is for educational purposes only.

The simplest format, which can be interpreted as a table, is a raw text file in which the rows of the table correspond to the lines of the text, and the values in different columns are separated by a special character (such as a tab or comma). Obviously, these files cannot store formulas, so you have to save them in e.g. xlsx format, which the program usually warns you about.

dowload Gazetteer   dowload Regions   dowload Solution

Tasks

  1. Format the table for convenient operation.
    Set column widths, lock header rows…
  2. Set up at least five population categories and classify the settlements into categories (e.g. 0, 500, 2000, 10 000, 50 000, 250 000).
    To avoid duplication, districts of the capital must be filtered out.
  3. Illustrate on a diagram how many people live in the settlements falling into each population category.
  4. In a new column, display the region of each settlement.
    Import and use the list of regions as an auxilary table.
  5. Summarize the number of people living in settlements of any given legal status in each region.
    It is advisable to merge similar categories (e.g. village-large village) using an auxilary table).
  6. Display the average population size of the settlements in each region.
  7. Display the average settlement population the inhabitants of each region live.
  8. Calculate the weighted average for the whole country based on the previous two breakdowns.