Plinius

Process

Public libraries data are generated as Excel spreadsheets from the KOSTRA database. Each row represents one municipality.

  • The rows are distributed among five sheets by population size: above fifty thousand, 20-50, 10-20, 5-10,  below five thousand.
  • Municipalities that no longer exist are removed. The rows that remain constitute our basic data.
  • Within each sheet the municipalities are also ordered by population size.
    • The two municipalities Tønsberg and Nøtterøy, which operate a joint library system, are treated as a single unit.

Each sheet with basic data is followed by an indicator sheet. Here indicator values are calculated interactively from the basic data. This means that changes to the basic data will automatically be reflected in the indicators. We do not replace missing indicator – or basic – values by imputed numbers.

  • When crucial indicator values are missing, the municipalities concerned are removed from the calculations.
  • We do this by moving them to the bottom of the indicator sheet, where they are marked in red.

The process is iterative. Often, missing values only become evident during the data processing.

  • In such cases, indicator values may have to be recalculated after the «offending» municipalities have been removed.
  • Since the indicator sheets are interactive, this is easily done – as long as we remember to do it.

Legg igjen en kommentar »

Ingen kommentarer så langt.

RSS feed for comments on this post. TrackBack URI

Legg igjen en kommentar

Fyll inn i feltene under, eller klikk på et ikon for å logge inn:

WordPress.com-logo

Du kommenterer med bruk av din WordPress.com konto. Logg ut / Endre )

Twitter picture

Du kommenterer med bruk av din Twitter konto. Logg ut / Endre )

Facebookbilde

Du kommenterer med bruk av din Facebook konto. Logg ut / Endre )

Google+ photo

Du kommenterer med bruk av din Google+ konto. Logg ut / Endre )

Kobler til %s

Blogg på WordPress.com.

%d bloggers like this: