{"id":13896,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/covarianza-m\/"},"modified":"2021-02-26T08:44:34","modified_gmt":"2021-02-26T08:44:34","slug":"covariance-s","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/covariance-s\/","title":{"rendered":"COVARIANZA.M"},"content":{"rendered":"

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

La funci\u00f3n COVARIANZA.M en Microsoft Excel y Google Sheets se emplea para calcular la covarianza de una muestra, esto es, mide el grado al que dos variables cambian conjuntamente. Esta funci\u00f3n es esencial en el an\u00e1lisis de la relaci\u00f3n entre variables y se utiliza ampliamente en campos como estad\u00edstica y econom\u00eda.<\/p>\n

Sintaxis en Excel:<\/strong><\/p>\n

=COVARIANZA.M(matriz1, matriz2)<\/code><\/pre>\n
Sintaxis en Google Sheets:<\/strong><\/p>\n
=COVARIANZA.M(rango1, rango2)<\/code><\/pre>\n
En estas f\u00f3rmulas, matriz1<\/em> y matriz2<\/em> (o rango1<\/em> y rango2<\/em>) representan los dos conjuntos de datos entre los que se desea calcular la covarianza muestral.<\/p>\n
Ejemplos pr\u00e1cticos<\/h2>\n
Exploraremos distintos escenarios donde esta funci\u00f3n resulta de gran utilidad.<\/p>\n
Escenario 1: An\u00e1lisis financiero<\/h2>\n
Imagine un analista financiero que necesita evaluar la relaci\u00f3n entre los rendimientos de dos acciones para decidir si incluirlas en un portafolio diversificado.<\/p>\n\n\n\n\n\n
Mes<\/th>\nRetorno Acci\u00f3n A (%)<\/th>\nRetorno Acci\u00f3n B (%)<\/th>\n<\/tr>\n
Enero<\/td>\n5<\/td>\n7<\/td>\n<\/tr>\n
Febrero<\/td>\n3<\/td>\n4<\/td>\n<\/tr>\n
Marzo<\/td>\n6<\/td>\n8<\/td>\n<\/tr>\n<\/table>\n
Para calcular la covarianza entre los retornos de las acciones A y B en Excel o Google Sheets, se usar\u00eda la f\u00f3rmula:<\/p>\n
=COVARIANZA.M(A2:A4, B2:B4)<\/code><\/pre>\n
Un resultado positivo alto indica una tendencia de moverse conjuntamente: cuando el valor de una acci\u00f3n sube, el de la otra tambi\u00e9n tiende a hacerlo.<\/p>\n
Escenario 2: Investigaci\u00f3n en el comportamiento humano<\/h2>\n
Un psic\u00f3logo, por ejemplo, podr\u00eda estar interesado en analizar la relaci\u00f3n entre las horas de sue\u00f1o y el nivel de estr\u00e9s en individuos durante un per\u00edodo de ex\u00e1menes.<\/p>\n\n\n\n\n\n
Persona<\/th>\nHoras de Sue\u00f1o<\/th>\nNivel de Estr\u00e9s<\/th>\n<\/tr>\n
Juan<\/td>\n4<\/td>\n9<\/td>\n<\/tr>\n
Ana<\/td>\n6<\/td>\n7<\/td>\n<\/tr>\n
Pedro<\/td>\n5<\/td>\n8<\/td>\n<\/tr>\n<\/table>\n
El an\u00e1lisis se realizar\u00eda con la f\u00f3rmula:<\/p>\n
=COVARIANZA.M(B2:B4, C2:C4)<\/code><\/pre>\n
Un valor negativo en este caso sugerir\u00eda que menos horas de sue\u00f1o est\u00e1n asociadas con un mayor nivel de estr\u00e9s, revelando una relaci\u00f3n inversa entre estas variables.<\/p>\n
Estos ejemplos demuestran la utilidad de la funci\u00f3n COVARIANZA.M para investigar relaciones entre diferentes conjuntos de datos y para comprender mejor las din\u00e1micas entre variables en diversos contextos.<\/p>\n","protected":false},"excerpt":{"rendered":"
Devuelve la covarianza de ejemplo, que es el promedio de los productos de las desviaciones para cada pareja de puntos de datos en 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-13896","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n COVARIANCE.S (COVARIANZA.M) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COVARIANCE.S (COVARIANZA.M) 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\/covariance-s\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n COVARIANCE.S (COVARIANZA.M) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COVARIANCE.S (COVARIANZA.M) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/covariance-s\/\" \/>\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:44:34+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 COVARIANCE.S (COVARIANZA.M) 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\/covariance-s\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/covariance-s\/\",\"name\":\"Funci\u00f3n COVARIANCE.S (COVARIANZA.M) 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:44:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n COVARIANCE.S (COVARIANZA.M) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/covariance-s\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/covariance-s\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/covariance-s\/#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\":\"COVARIANZA.M\"}]},{\"@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 COVARIANCE.S (COVARIANZA.M) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n COVARIANCE.S (COVARIANZA.M) 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\/covariance-s\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n COVARIANCE.S (COVARIANZA.M) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n COVARIANCE.S (COVARIANZA.M) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/covariance-s\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:44:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n COVARIANCE.S (COVARIANZA.M) 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\/covariance-s\/","url":"https:\/\/functiontranslator.com\/es\/covariance-s\/","name":"Funci\u00f3n COVARIANCE.S (COVARIANZA.M) 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:44:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n COVARIANCE.S (COVARIANZA.M) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/covariance-s\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/covariance-s\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/covariance-s\/#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":"COVARIANZA.M"}]},{"@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\/13896","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=13896"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13896\/revisions"}],"predecessor-version":[{"id":29959,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13896\/revisions\/29959"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}