This example demonstrates how to convert from income values measured as amounts into divisions like percentiles, deciles and quartiles. It also shows how to controle the outcome of the conversion.<\/p>\n\n\n
\/\/Connect to datastore\r\nrequire no.ssb.fdb:23 as db\r\n\r\n\/\/Create a dataset containing a wage variable\r\ncreate-dataset percentiletest\r\nimport db\/INNTEKT_WLONN 2021-01-01 as wage21\r\n\r\n\/\/Produce wage statistics measured in 2021 (all individuals with positive wage income this year)\r\nsummarize wage21\r\nhistogram wage21\r\n\r\n\/\/Convert into percentiles and test the division\r\ngenerate percentile21 = quantile(wage21, 100)\r\nhistogram percentile21, discrete\r\n\r\ntextblock\r\nNB! Note that the 1st percentile is fusioned with the 2nd due to the 1% bottom coding. This will sometimes happen if the 1st percentile is slightly below the 1% limit (0.99). In principle, this will also be the case for the last percentile (100th) due to the 1% top coding.\r\nendblock\r\n\r\n\/\/Convert into quartiles and test the division\r\ngenerate quartile21 = quantile(wage21, 4)\r\nhistogram quartile21, discrete\r\n\r\n\/\/Test the percentile and quartile divisions up against each other\r\ntabulate percentile21 quartile21\r\n\r\n\/\/Convert into deciles and show the frequencies and means within each decile\r\ngenerate decile21 = quantile(wage21, 10)\r\ntabulate decile21, missing\r\ntabulate decile21, summarize(wage21)<\/code><\/pre>\n<\/div>","protected":false},"parent":0,"menu_order":38,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":""},"class_list":["post-1273","eksempel","type-eksempel","status-publish","hentry"],"acf":[],"yoast_head":"\nHow to group income values into percentiles, deciles and quartiles - microdata.no<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to group income values into percentiles, deciles and quartiles - microdata.no\" \/>\n<meta property=\"og:description\" content=\"This example demonstrates how to convert from income values measured as amounts into divisions like percentiles, deciles and quartiles. It also shows how to controle the outcome of the conversion.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/\" \/>\n<meta property=\"og:site_name\" content=\"microdata.no\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T15:39:20+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\\\/\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\\\/\",\"name\":\"How to group income values into percentiles, deciles and quartiles - microdata.no\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\"},\"datePublished\":\"2022-02-11T15:12:22+00:00\",\"dateModified\":\"2023-10-27T15:39:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/eksempel\\\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\\\/\\\/www.microdata.no\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to group income values into percentiles, deciles and quartiles\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.microdata.no\\\/#website\",\"url\":\"https:\\\/\\\/www.microdata.no\\\/\",\"name\":\"microdata.no\",\"description\":\"Gj\u00f8r det enklere \u00e5 analysere registerdata\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.microdata.no\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to group income values into percentiles, deciles and quartiles - microdata.no","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/","og_locale":"en_US","og_type":"article","og_title":"How to group income values into percentiles, deciles and quartiles - microdata.no","og_description":"This example demonstrates how to convert from income values measured as amounts into divisions like percentiles, deciles and quartiles. It also shows how to controle the outcome of the conversion.","og_url":"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/","og_site_name":"microdata.no","article_modified_time":"2023-10-27T15:39:20+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/","url":"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/","name":"How to group income values into percentiles, deciles and quartiles - microdata.no","isPartOf":{"@id":"https:\/\/www.microdata.no\/#website"},"datePublished":"2022-02-11T15:12:22+00:00","dateModified":"2023-10-27T15:39:20+00:00","breadcrumb":{"@id":"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microdata.no\/eksempel\/gruppere-inntekter-i-prosentiler-desiler-og-kvartiler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.microdata.no\/en\/"},{"@type":"ListItem","position":2,"name":"How to group income values into percentiles, deciles and quartiles"}]},{"@type":"WebSite","@id":"https:\/\/www.microdata.no\/#website","url":"https:\/\/www.microdata.no\/","name":"microdata.no","description":"Gj\u00f8r det enklere \u00e5 analysere registerdata","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microdata.no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"taxonomy_info":[],"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/eksempel\/1273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/eksempel"}],"about":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/types\/eksempel"}],"wp:attachment":[{"href":"https:\/\/www.microdata.no\/en\/wp-json\/wp\/v2\/media?parent=1273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}