{"id":13878,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/coef-de-correl\/"},"modified":"2021-02-26T08:43:58","modified_gmt":"2021-02-26T08:43:58","slug":"correl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/correl\/","title":{"rendered":"COEF.DE.CORREL"},"content":{"rendered":"

Descripci\u00f3n general de la funci\u00f3n de correlaci\u00f3n<\/h2>\n

La funci\u00f3n CORREL en Microsoft Excel y el equivalente COEF.DE.CORREL en Google Sheets, se utilizan para calcular el coeficiente de correlaci\u00f3n de Pearson entre dos conjuntos de datos. Este coeficiente mide el grado de relaci\u00f3n lineal entre dos variables, siendo +1 una correlaci\u00f3n positiva perfecta, -1 una correlaci\u00f3n negativa perfecta y 0 ninguna correlaci\u00f3n.<\/p>\n

Sintaxis y ejemplos de uso<\/h2>\n

La sintaxis de la funci\u00f3n es:<\/p>\n

CORREL(matriz1, matriz2)<\/code><\/pre>\n
Donde matriz1<\/i> y matriz2<\/i> son los rangos de datos que deseamos comparar.<\/p>\n
Ejemplo de aplicaci\u00f3n en Excel y Google Sheets:<\/p>\n
=COEF.DE.CORREL(A1:A10, B1:B10)<\/code><\/pre>\n
Supongamos que en el rango A1:A10 tenemos las edades de un grupo de personas y en B1:B10 sus respectivos salarios. Este c\u00e1lculo nos dir\u00e1 cu\u00e1n relacionada est\u00e1 la edad con el salario en este grupo espec\u00edfico.<\/p>\n
Aplicaciones pr\u00e1cticas de la correlaci\u00f3n<\/h2>\n
Estudio de variables econ\u00f3micas<\/h3>\n
Supongamos que un economista desea investigar la relaci\u00f3n entre el nivel de educaci\u00f3n (a\u00f1os de estudio) y el salario en una regi\u00f3n determinada. Para esto, recopila datos de 100 personas:<\/p>\n
    \n
  • Columna A (A1:A100): A\u00f1os de educaci\u00f3n.<\/li>\n
  • Columna B (B1:B100): Salario mensual.<\/li>\n<\/ul>\n
    Para calcular la correlaci\u00f3n entre estas dos variables, el economista utilizar\u00eda:<\/p>\n
    =COEF.DE.CORREL(A1:A100, B1:B100)<\/code><\/pre>\n
    Un resultado cercano a +1 indicar\u00eda una fuerte correlaci\u00f3n positiva, sugiriendo que a mayor educaci\u00f3n corresponde un mayor salario.<\/p>\n
    An\u00e1lisis en el campo de la salud<\/h3>\n
    Un investigador de salud p\u00fablica podr\u00eda estar interesado en explorar la relaci\u00f3n entre el ejercicio f\u00edsico y el nivel de estr\u00e9s. Recoge datos de 50 participantes:<\/p>\n
      \n
    • Columna C (C1:C50): Horas de ejercicio por semana.<\/li>\n
    • Columna D (D1:D50): \u00cdndice de estr\u00e9s.<\/li>\n<\/ul>\n
      El investigador calcular\u00eda la correlaci\u00f3n de la siguiente manera:<\/p>\n
      =COEF.DE.CORREL(C1:C50, D1:D50)<\/code><\/pre>\n
      Una correlaci\u00f3n negativa cerca de -1 indicar\u00eda que a mayor cantidad de ejercicio, menor es el nivel de estr\u00e9s reportado, beneficiando as\u00ed su propuesta de programas de ejercicio para reducir el estr\u00e9s.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el coeficiente de correlaci\u00f3n entre dos conjuntos de datos<\/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-13878","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n CORREL (COEF.DE.CORREL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CORREL (COEF.DE.CORREL) 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\/correl\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n CORREL (COEF.DE.CORREL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CORREL (COEF.DE.CORREL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/correl\/\" \/>\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:43:58+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 CORREL (COEF.DE.CORREL) 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\/correl\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/correl\/\",\"name\":\"Funci\u00f3n CORREL (COEF.DE.CORREL) 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:43:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n CORREL (COEF.DE.CORREL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/correl\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/correl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/correl\/#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\":\"COEF.DE.CORREL\"}]},{\"@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 CORREL (COEF.DE.CORREL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n CORREL (COEF.DE.CORREL) 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\/correl\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n CORREL (COEF.DE.CORREL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n CORREL (COEF.DE.CORREL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/correl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:43:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n CORREL (COEF.DE.CORREL) 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\/correl\/","url":"https:\/\/functiontranslator.com\/es\/correl\/","name":"Funci\u00f3n CORREL (COEF.DE.CORREL) 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:43:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n CORREL (COEF.DE.CORREL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/correl\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/correl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/correl\/#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":"COEF.DE.CORREL"}]},{"@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\/13878","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=13878"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13878\/revisions"}],"predecessor-version":[{"id":29941,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13878\/revisions\/29941"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}