{"id":14194,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/coeficiente-asimetria\/"},"modified":"2021-02-26T08:57:42","modified_gmt":"2021-02-26T08:57:42","slug":"skew","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/skew\/","title":{"rendered":"COEFICIENTE.ASIMETRIA"},"content":{"rendered":"

La funci\u00f3n COEFICIENTE.ASIMETR\u00cdA en MS Excel y Google Sheets, denominada SKEW en ingl\u00e9s, se emplea para evaluar la asimetr\u00eda en la distribuci\u00f3n de un conjunto de datos. Esta medida es crucial para determinar si los datos se distribuyen m\u00e1s hacia la izquierda o la derecha de la media. A continuaci\u00f3n, se presentan ejemplos pr\u00e1cticos y aplicaciones relevantes de esta funci\u00f3n.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n COEFICIENTE.ASIMETR\u00cdA es la siguiente:<\/p>\n

=COEFICIENTE.ASIMETR\u00cdA(n\u00fam1; [n\u00fam2]; ...)<\/code><\/pre>\n
    \n
  • n\u00fam1, n\u00fam2, …<\/strong>: Argumentos que representan los valores del conjunto de datos. Estos argumentos pueden ser n\u00fameros directos, nombres, matrices o referencias que contengan n\u00fameros.<\/li>\n<\/ul>\n
    Por ejemplo, para un conjunto de n\u00fameros en las celdas A1:A10, la f\u00f3rmula ser\u00eda:<\/p>\n
    =COEFICIENTE.ASIMETR\u00cdA(A1:A10)<\/code><\/pre>\n
    Esta f\u00f3rmula calcula la asimetr\u00eda de los valores en el rango de A1 a A10.<\/p>\n
    Casos pr\u00e1cticos<\/h2>\n
    Exploraremos c\u00f3mo utilizar esta funci\u00f3n en varios escenarios frecuentes:<\/p>\n
    Analizando rendimientos de acciones<\/h2>\n
    Considera que tienes el retorno diario de una acci\u00f3n durante 30 d\u00edas y deseas analizar la asimetr\u00eda de estos rendimientos para comprender mejor la direcci\u00f3n del riesgo en la distribuci\u00f3n de los retornos.<\/p>\n\n\n\n\n\n
    D\u00eda<\/th>\nRendimiento (%)<\/th>\n<\/tr>\n
    1<\/td>\n0.5<\/td>\n<\/tr>\n
    2<\/td>\n0.7<\/td>\n<\/tr>\n
    3<\/td>\n-1.2<\/td>\n<\/tr>\n
      <\/table>\n
    Para calcular la asimetr\u00eda, se usar\u00eda la f\u00f3rmula:<\/p>\n
    =COEFICIENTE.ASIMETR\u00cdA(B1:B30)<\/code><\/pre>\n
    Una asimetr\u00eda significativamente distinta de cero puede sugerir una distribuci\u00f3n de rendimientos que se inclina hacia ganancias o p\u00e9rdidas.<\/p>\n
    Control de calidad en fabricaci\u00f3n<\/h2>\n
    Imaginemos que eres un administrador de calidad revisando el tama\u00f1o de piezas manufacturadas. Supongamos que tienes datos de tama\u00f1o de 50 piezas en mil\u00edmetros, registrados de A1 a A50:<\/p>\n
    =COEFICIENTE.ASIMETR\u00cdA(A1:A50)<\/code><\/pre>\n
    Un resultado negativo indicar\u00eda que hay una concentraci\u00f3n de datos hacia menores valores, lo que podr\u00eda significar un problema en la maquinaria que produce piezas menores a lo esperado.<\/p>\n
    La funci\u00f3n COEFICIENTE.ASIMETR\u00cdA permite a los profesionales de diversas \u00e1reas medir y comprender la direcci\u00f3n y naturaleza de la asimetr\u00eda, facilitando decisiones m\u00e1s informadas basadas en los datos estad\u00edsticos obtenidos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la asimetr\u00eda de una distribuci\u00f3n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-14194","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/skew\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/skew\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:57:42+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/skew\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/skew\/\",\"name\":\"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:57:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/skew\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/skew\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/skew\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"COEFICIENTE.ASIMETRIA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/skew\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/skew\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:57:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/skew\/","url":"https:\/\/functiontranslator.com\/es\/skew\/","name":"Funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:57:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n SKEW (COEFICIENTE.ASIMETRIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/skew\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/skew\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/skew\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"COEFICIENTE.ASIMETRIA"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14194"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14194\/revisions"}],"predecessor-version":[{"id":30284,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14194\/revisions\/30284"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}