{"id":339,"date":"2023-11-03T02:39:17","date_gmt":"2023-11-03T02:39:17","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/"},"modified":"2023-12-25T10:23:44","modified_gmt":"2023-12-25T10:23:44","slug":"coeficiente-de-variacion","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/","title":{"rendered":"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1270784088\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Para calcular el coeficiente de variaci\u00f3n en Excel, debe utilizar una combinaci\u00f3n de funciones DESVEST.P y PROMEDIO.<\/p>\n<p> En esta f\u00f3rmula, STDEV.P te ayudar\u00e1 a obtener la desviaci\u00f3n est\u00e1ndar y la funci\u00f3n promedio te ayudar\u00e1 a obtener el promedio de los puntos de datos.<\/p>\n<p> En \u00faltima instancia, debes dividir la desviaci\u00f3n est\u00e1ndar por la media para obtener el coeficiente de variaci\u00f3n.<\/p>\n<p> La variaci\u00f3n del coeficiente es una medida de la dispersi\u00f3n (variabilidad) de los datos alrededor de su media. Cuanto mayor sea el coeficiente de variaci\u00f3n, mayor ser\u00e1 el nivel de dispersi\u00f3n de la media de los puntos de datos.<\/p>\n<p> Tambi\u00e9n puedes decir que es como dividir la desviaci\u00f3n est\u00e1ndar por la media de los datos.<\/p>\n<p> En el siguiente ejemplo, tiene los siguientes datos con 7 puntos de datos diferentes y ahora necesita calcular el CV (coeficiente de variaci\u00f3n) para estos puntos de datos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69525\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"datos-con-diferentes-puntos-de-datos\" width=\"462\" height=\"262\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para calcular el coeficiente de variaci\u00f3n en Excel <\/h2>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69526\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-calculer-la-variation-du-coefficient.png\" sizes=\"auto, \" srcset=\"\" alt=\"calculo-coeficiente-variacion\" width=\"581\" height=\"246\"><\/figure>\n<\/div>\n<ol type=\"1\">\n<li> Primero, ingrese STDEV.P en la celda F1 y consulte el rango A1 a E1 y cierre la funci\u00f3n.<\/li>\n<li> Despu\u00e9s de eso, ingrese el operador de divisi\u00f3n.<\/li>\n<li> Luego ingrese la funci\u00f3n promedio despu\u00e9s de este operador de divisi\u00f3n.<\/li>\n<li> Ahora consulte el rango A1 a E1.<\/li>\n<li> Al final, ingrese el par\u00e9ntesis de cierre y presione Enter para obtener el resultado.<\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=STDEV.P(A1:E1)\/AVERAGE(A1:E1)<\/code><\/pre>\n<p class=\"qt-tip\"> <strong>Nota:<\/strong> Debe cambiar el formato de celda a formato de porcentaje.<\/p>\n<p> Para entender esta f\u00f3rmula, necesitamos dividirla en dos partes, como dije antes. Entonces, en la primera parte tenemos la funci\u00f3n STDEV.P que calcula la desviaci\u00f3n est\u00e1ndar ignorando los valores l\u00f3gicos y las celdas vac\u00edas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69527\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-diviser-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"dividir la f\u00f3rmula\" width=\"603\" height=\"264\"><\/figure>\n<\/div>\n<p> Y en la segunda parte, tenemos la funci\u00f3n promedio que calcula el promedio de los puntos de datos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69528\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-moyenne-en-deuxieme-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-promedio-en-la-segunda-parte\" width=\"674\" height=\"246\"><\/figure>\n<\/div>\n<p> En \u00faltima instancia, cuando divides 2,82842712474619 entre 63, obtienes 0,04, y cuando lo conviertes a formato porcentual, obtienes 4%. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/variation-du-coefficient.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/maximo-si\/\">MAX SI en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/informe\/\">Calcule r\u00e1pidamente la proporci\u00f3n en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/\">Encuentre el valor m\u00e1s bajo de una lista de n\u00fameros (N)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/valor-mas-pequeno-2\/\">Encuentre el valor m\u00e1s peque\u00f1o en un rango de celdas (n\u00famero m\u00e1s peque\u00f1o)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/enesima-raiz-2\/\">Calcular la ra\u00edz en\u00e9sima<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para calcular el coeficiente de variaci\u00f3n en Excel, debe utilizar una combinaci\u00f3n de funciones DESVEST.P y PROMEDIO. En esta f\u00f3rmula, STDEV.P te ayudar\u00e1 a obtener la desviaci\u00f3n est\u00e1ndar y la funci\u00f3n promedio te ayudar\u00e1 a obtener el promedio de los puntos de datos. En \u00faltima instancia, debes dividir la desviaci\u00f3n est\u00e1ndar por la media para [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-339","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?<\/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:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?\" \/>\n<meta property=\"og:description\" content=\"Para calcular el coeficiente de variaci\u00f3n en Excel, debe utilizar una combinaci\u00f3n de funciones DESVEST.P y PROMEDIO. En esta f\u00f3rmula, STDEV.P te ayudar\u00e1 a obtener la desviaci\u00f3n est\u00e1ndar y la funci\u00f3n promedio te ayudar\u00e1 a obtener el promedio de los puntos de datos. En \u00faltima instancia, debes dividir la desviaci\u00f3n est\u00e1ndar por la media para [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/\",\"name\":\"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\",\"datePublished\":\"2023-11-03T02:39:17+00:00\",\"dateModified\":\"2023-12-25T10:23:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?","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:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?","og_description":"Para calcular el coeficiente de variaci\u00f3n en Excel, debe utilizar una combinaci\u00f3n de funciones DESVEST.P y PROMEDIO. En esta f\u00f3rmula, STDEV.P te ayudar\u00e1 a obtener la desviaci\u00f3n est\u00e1ndar y la funci\u00f3n promedio te ayudar\u00e1 a obtener el promedio de los puntos de datos. En \u00faltima instancia, debes dividir la desviaci\u00f3n est\u00e1ndar por la media para [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/","url":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/","name":"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png","datePublished":"2023-11-03T02:39:17+00:00","dateModified":"2023-12-25T10:23:44+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo calcular el coeficiente de variaci\u00f3n (cv)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=339"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/339\/revisions"}],"predecessor-version":[{"id":868,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/339\/revisions\/868"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}