{"id":14133,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/pearson\/"},"modified":"2021-02-26T08:55:26","modified_gmt":"2021-02-26T08:55:26","slug":"pearson","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/pearson\/","title":{"rendered":"PEARSON"},"content":{"rendered":"

Descripci\u00f3n y uso general<\/h2>\n

La correlaci\u00f3n de Pearson es una medida de la relaci\u00f3n lineal entre dos variables cuantitativas. Comprender c\u00f3mo calcular y interpretar este coeficiente es fundamental en muchos campos, como la estad\u00edstica, la econom\u00eda y las ciencias sociales. Tanto Microsoft Excel como Google Sheets ofrecen una funci\u00f3n integrada para calcular la correlaci\u00f3n de Pearson, facilitando as\u00ed el an\u00e1lisis estad\u00edstico.<\/p>\n

Sintaxis y ejemplos<\/h2>\n

En Excel, la funci\u00f3n se escribe:<\/p>\n

=PEARSON(matriz1, matriz2)<\/code><\/pre>\n
D\u00f3nde matriz1<\/code> y matriz2<\/code> representan los rangos de datos de las dos variables cuya correlaci\u00f3n se desea calcular.<\/p>\n
Google Sheets utiliza una funci\u00f3n id\u00e9ntica para este prop\u00f3sito:<\/p>\n
=PEARSON(matriz1, matriz2)<\/code><\/pre>\n
Veamos un ejemplo pr\u00e1ctico. Supongamos que tenemos datos para dos variables X e Y:<\/p>\n\n\n\n\n\n
X<\/th>\nY<\/th>\n<\/tr>\n
1<\/td>\n2<\/td>\n<\/tr>\n
2<\/td>\n4<\/td>\n<\/tr>\n
3<\/td>\n5<\/td>\n<\/tr>\n<\/table>\n
Para calcular la correlaci\u00f3n de Pearson entre X e Y, aplicar\u00edamos la siguiente f\u00f3rmula en Excel o Google Sheets:<\/p>\n
=PEARSON(A2:A4, B2:B4)<\/code><\/pre>\n
Este c\u00e1lculo dar\u00e1 como resultado un coeficiente que var\u00eda entre -1 y 1, donde 1 indica una correlaci\u00f3n positiva perfecta, -1 indica una correlaci\u00f3n negativa perfecta, y 0 indica que no hay correlaci\u00f3n.<\/p>\n
Aplicaciones pr\u00e1cticas<\/h2>\n
    \n
  • \n
    Investigaci\u00f3n cient\u00edfica<\/h2>\n
    En la investigaci\u00f3n cient\u00edfica, comprender la relaci\u00f3n entre dos fen\u00f3menos es esencial. Por ejemplo, un investigador podr\u00eda estar interesado en la correlaci\u00f3n entre el n\u00famero de horas estudiadas y las notas obtenidas por los estudiantes. Utilizar esta funci\u00f3n facilita la evaluaci\u00f3n de la fuerza y direcci\u00f3n de la relaci\u00f3n.<\/p>\n
    =PEARSON(rango_horas_estudiadas, rango_calificaciones)<\/code><\/pre>\n<\/li>\n
  • \n
    En el mercado financiero<\/h2>\n
    Los analistas financieros a menudo analizan la correlaci\u00f3n entre distintas acciones, \u00edndices o instrumentos financieros para desarrollar estrategias de diversificaci\u00f3n. Supongamos que un analista quiere conocer la correlaci\u00f3n entre los rendimientos de dos acciones durante un per\u00edodo espec\u00edfico:<\/p>\n
    =PEARSON(rango_accion1, rango_accion2)<\/code><\/pre>\n
    Una correlaci\u00f3n cercana a 1 indica que las acciones tienden a moverse en la misma direcci\u00f3n, mientras que una correlaci\u00f3n cercana a -1 sugiere que se mueven en direcciones opuestas.<\/p>\n<\/li>\n<\/ul>\n
    Consideraciones finales<\/h2>\n
    Aunque la correlaci\u00f3n de Pearson es una herramienta poderosa para detectar relaciones lineales, es importante recordar que no identifica relaciones no lineales ni implica causalidad. Para un an\u00e1lisis m\u00e1s completo, podr\u00eda ser necesario explorar otros m\u00e9todos estad\u00edsticos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el coeficiente de momento de correlaci\u00f3n de producto Pearson<\/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-14133","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n PEARSON en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PEARSON 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\/pearson\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PEARSON en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PEARSON de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/pearson\/\" \/>\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:55:26+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 PEARSON 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\/pearson\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/pearson\/\",\"name\":\"Funci\u00f3n PEARSON 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:55:26+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PEARSON de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/pearson\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/pearson\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/pearson\/#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\":\"PEARSON\"}]},{\"@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 PEARSON en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PEARSON 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\/pearson\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PEARSON en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PEARSON de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/pearson\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:26+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PEARSON 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\/pearson\/","url":"https:\/\/functiontranslator.com\/es\/pearson\/","name":"Funci\u00f3n PEARSON 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:55:26+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PEARSON de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/pearson\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/pearson\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/pearson\/#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":"PEARSON"}]},{"@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\/14133","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=14133"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14133\/revisions"}],"predecessor-version":[{"id":30224,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14133\/revisions\/30224"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}