{"id":3601,"date":"2023-07-16T14:50:05","date_gmt":"2023-07-16T14:50:05","guid":{"rendered":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/"},"modified":"2023-07-16T14:50:05","modified_gmt":"2023-07-16T14:50:05","slug":"covariancia-p-vs-covariancia-s-no-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/","title":{"rendered":"Covariance.p vs covariance.s no excel: qual a diferen\u00e7a?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Nas estat\u00edsticas, <strong>a covari\u00e2ncia<\/strong> \u00e9 uma forma de medir como as mudan\u00e7as em uma vari\u00e1vel est\u00e3o associadas \u00e0s mudan\u00e7as em outra vari\u00e1vel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Um valor de covari\u00e2ncia positivo indica que um aumento em uma vari\u00e1vel est\u00e1 associado a um aumento em outra vari\u00e1vel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Um valor negativo indica que um aumento em uma vari\u00e1vel est\u00e1 associado a uma diminui\u00e7\u00e3o em outra vari\u00e1vel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Existem duas fun\u00e7\u00f5es diferentes que voc\u00ea pode usar para calcular a covari\u00e2ncia no Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. COVARIANCE.P:<\/strong> Esta fun\u00e7\u00e3o calcula a covari\u00e2ncia populacional. Use esta fun\u00e7\u00e3o quando o intervalo de valores representar toda a popula\u00e7\u00e3o.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Esta fun\u00e7\u00e3o usa a seguinte f\u00f3rmula:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\">Covari\u00e2ncia populacional = \u03a3(x <sub>i<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> )(y <sub>i<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">y<\/span> ) \/ n<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ouro:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Um s\u00edmbolo grego que significa \u201csoma\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> O i- <sup>\u00e9simo<\/sup> valor da vari\u00e1vel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">x<\/span><\/strong> : O valor m\u00e9dio da vari\u00e1vel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>y <sub>i<\/sub> : o i-<\/strong> <sup>\u00e9simo<\/sup> valor da vari\u00e1vel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">y<\/span><\/strong> : O valor m\u00e9dio da vari\u00e1vel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> O n\u00famero total de observa\u00e7\u00f5es<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>2. COVARIANCE.S:<\/strong> Esta fun\u00e7\u00e3o calcula a covari\u00e2ncia da amostra. Use esta fun\u00e7\u00e3o quando o intervalo de valores representar uma amostra de valores em vez de uma popula\u00e7\u00e3o inteira.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Esta fun\u00e7\u00e3o usa a seguinte f\u00f3rmula:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\">Covari\u00e2ncia da amostra = \u03a3(x <sub>i<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> )(y <sub>i<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">y<\/span> ) \/ (n-1)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ouro:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Um s\u00edmbolo grego que significa \u201csoma\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> O i- <sup>\u00e9simo<\/sup> valor da vari\u00e1vel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">x<\/span><\/strong> : O valor m\u00e9dio da vari\u00e1vel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>y <sub>i<\/sub> : o i-<\/strong> <sup>\u00e9simo<\/sup> valor da vari\u00e1vel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">y<\/span><\/strong> : O valor m\u00e9dio da vari\u00e1vel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> O n\u00famero total de observa\u00e7\u00f5es<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Observe a diferen\u00e7a sutil entre as duas f\u00f3rmulas: <strong>COVARIANCE.P<\/strong> divide por <strong>n<\/strong> enquanto <strong>COVARIANCE.S<\/strong> divide por <strong>n-1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Por esse motivo, a f\u00f3rmula <strong>COVARIANCE.S<\/strong> sempre produzir\u00e1 um valor maior porque divide por um valor menor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">O exemplo a seguir mostra como usar cada f\u00f3rmula na pr\u00e1tica.<\/span><\/p>\n<h2> <strong>Exemplo: COVARIANCE.P vs COVARIANCE.S no Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Digamos que temos o seguinte conjunto de dados no Excel que mostra os pontos e assist\u00eancias de 15 jogadores de basquete diferentes:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29676 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar1.jpg\" alt=\"\" width=\"455\" height=\"459\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A captura de tela a seguir mostra como calcular a covari\u00e2ncia entre pontos e assist\u00eancias usando duas f\u00f3rmulas de covari\u00e2ncia diferentes:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29677 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar2.jpg\" alt=\"\" width=\"627\" height=\"483\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A covari\u00e2ncia da amostra \u00e9 <b>15,69<\/b> e a covari\u00e2ncia da popula\u00e7\u00e3o \u00e9 <strong>14,64<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Conforme mencionado anteriormente, a covari\u00e2ncia da amostra ser\u00e1 sempre maior que a covari\u00e2ncia da popula\u00e7\u00e3o.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Quando usar COVARIANCE.P ou COVARIANCE.S<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Na maioria dos casos n\u00e3o conseguimos recolher dados de uma popula\u00e7\u00e3o inteira. Portanto, coletamos dados apenas para uma <a href=\"https:\/\/statorials.org\/pt\/populacao-vs.-amostra\/\" target=\"_blank\" rel=\"noopener\">amostra<\/a> da popula\u00e7\u00e3o.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Portanto, quase sempre usamos <strong>COVARIANCE.S<\/strong> para calcular a covari\u00e2ncia de um conjunto de dados porque nosso conjunto de dados geralmente representa uma amostra.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Em casos raros em que seus dados representam uma popula\u00e7\u00e3o inteira, voc\u00ea pode usar a fun\u00e7\u00e3o <strong>COVARIANCE.P<\/strong> .<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam a diferen\u00e7a entre outras fun\u00e7\u00f5es do Excel comumente usadas:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pt\/stdevp-vs-stdevs-no-excel\/\" target=\"_blank\" rel=\"noopener\">STDEV.P vs STDEV.S no Excel: Qual \u00e9 a diferen\u00e7a?<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/percentil-exc-vs-percentil-inc-excel\/\" target=\"_blank\" rel=\"noopener\">PERCENTILE.EXC vs PERCENTILE.INC no Excel: Qual \u00e9 a diferen\u00e7a?<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/quartil-exc-vs-quartil-inc-excel\/\">QUARTILE.EXC vs QUARTILE.INC no Excel: Qual \u00e9 a diferen\u00e7a?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nas estat\u00edsticas, a covari\u00e2ncia \u00e9 uma forma de medir como as mudan\u00e7as em uma vari\u00e1vel est\u00e3o associadas \u00e0s mudan\u00e7as em outra vari\u00e1vel. Um valor de covari\u00e2ncia positivo indica que um aumento em uma vari\u00e1vel est\u00e1 associado a um aumento em outra vari\u00e1vel. Um valor negativo indica que um aumento em uma vari\u00e1vel est\u00e1 associado a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3601","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>COVARIANCE.P vs COVARIANCE.S no Excel: qual a diferen\u00e7a? - Statorials<\/title>\n<meta name=\"description\" content=\"Este tutorial explica a diferen\u00e7a entre COVARIANCE.P e COVARIANCE.S no Excel, com um exemplo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"COVARIANCE.P vs COVARIANCE.S no Excel: qual a diferen\u00e7a? - Statorials\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica a diferen\u00e7a entre COVARIANCE.P e COVARIANCE.S no Excel, com um exemplo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T14:50:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar1.jpg\" \/>\n<meta name=\"author\" content=\"Dr. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/\",\"url\":\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/\",\"name\":\"COVARIANCE.P vs COVARIANCE.S no Excel: qual a diferen\u00e7a? - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-16T14:50:05+00:00\",\"dateModified\":\"2023-07-16T14:50:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica a diferen\u00e7a entre COVARIANCE.P e COVARIANCE.S no Excel, com um exemplo.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Covariance.p vs covariance.s no excel: qual a diferen\u00e7a?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"COVARIANCE.P vs COVARIANCE.S no Excel: qual a diferen\u00e7a? - Statorials","description":"Este tutorial explica a diferen\u00e7a entre COVARIANCE.P e COVARIANCE.S no Excel, com um exemplo.","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:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/","og_locale":"pt_PT","og_type":"article","og_title":"COVARIANCE.P vs COVARIANCE.S no Excel: qual a diferen\u00e7a? - Statorials","og_description":"Este tutorial explica a diferen\u00e7a entre COVARIANCE.P e COVARIANCE.S no Excel, com um exemplo.","og_url":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-16T14:50:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar1.jpg"}],"author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/","url":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/","name":"COVARIANCE.P vs COVARIANCE.S no Excel: qual a diferen\u00e7a? - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-16T14:50:05+00:00","dateModified":"2023-07-16T14:50:05+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica a diferen\u00e7a entre COVARIANCE.P e COVARIANCE.S no Excel, com um exemplo.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/covariancia-p-vs-covariancia-s-no-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Covariance.p vs covariance.s no excel: qual a diferen\u00e7a?"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/3601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=3601"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/3601\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=3601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=3601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=3601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}