{"id":612,"date":"2019-03-20T12:08:03","date_gmt":"2019-03-20T12:08:03","guid":{"rendered":"https:\/\/hlrnet.com\/sites\/bet\/?p=612"},"modified":"2021-10-30T18:06:18","modified_gmt":"2021-10-30T18:06:18","slug":"agrupar-por-intervalos-irregulares-y-tablas-dinamicas","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/sites\/bet\/?p=612","title":{"rendered":"Agrupar por intervalos irregulares y tablas din\u00e1micas"},"content":{"rendered":"<p>P. S\u00e9 c\u00f3mo agrupar datos en una tabla din\u00e1mica, y s\u00e9 que en tablas din\u00e1micas se pueden combinar varios par\u00e1metros. Tambi\u00e9n s\u00e9 que con la funci\u00f3n FRECUENCIA puedo agrupar con intervalos irregulares.<\/p>\n<p>Pero \u00bfhay manera de tener los dos? \u00bfIntervalos irregulares\u00a0 combinados con otros par\u00e1metros?<\/p>\n<p>R. S\u00ed. Un par de cosas:<\/p>\n<ul>\n<li>FRECUENCIA tiene un par de inconvenientes: es algo t\u00e9cnico (ctrl+may+enter, pero tambi\u00e9n y sobre todo: da cifras del n\u00famero <em>hasta<\/em> el intervalo, no <em>desde<\/em> el intervalo (=de la categor\u00eda del intervalo).<br \/>\n<a href=\"https:\/\/support.office.com\/es-es\/article\/frecuencia-funci%C3%B3n-frecuencia-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9\" class=\"autohyperlink\">support.office.com\/es-es\/article\/frecuencia-funci%C3%B3n-frecuencia-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9<\/a><\/li>\n<li>La soluci\u00f3n es calcular con BUSCARV a qu\u00e9 categor\u00eda pertenece un valor, y luego crear la tabla din\u00e1mica.<br \/>\n<a href=\"https:\/\/support.office.com\/es-es\/article\/funci%C3%B3n-buscarv-0bbc8083-26fe-4963-8ab8-93a18ad188a1\" class=\"autohyperlink\">support.office.com\/es-es\/article\/funci%C3%B3n-buscarv-0bbc8083-26fe-4963-8ab8-93a18ad188a1<\/a><\/li>\n<li>En este ejemplo calculo la provincia y la autonom\u00eda desde el c\u00f3digo postal, valores que despu\u00e9s se puede combinar con otros (edad, sexo, estado de salud)<br \/>\n<a href=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2019\/03\/codigos-postales.xlsx\">codigos postales<\/a>: Excel<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>P. S\u00e9 c\u00f3mo agrupar datos en una tabla din\u00e1mica, y s\u00e9 que en tablas din\u00e1micas se pueden combinar varios par\u00e1metros. Tambi\u00e9n s\u00e9 que con la funci\u00f3n FRECUENCIA puedo agrupar con intervalos irregulares. Pero \u00bfhay manera de tener los dos? \u00bfIntervalos irregulares\u00a0 combinados con otros par\u00e1metros? R. S\u00ed. Un par de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[6,5],"tags":[12,10],"class_list":["post-612","post","type-post","status-publish","format-standard","hentry","category-herramientas","category-investigacion","tag-excel","tag-tic"],"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/posts\/612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=612"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/posts\/612\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}