{"id":2091,"date":"2023-07-23T17:54:52","date_gmt":"2023-07-23T17:54:52","guid":{"rendered":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/"},"modified":"2023-07-23T17:54:52","modified_gmt":"2023-07-23T17:54:52","slug":"barras-de-erro-do-planilhas-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/","title":{"rendered":"Como adicionar barras de erro a gr\u00e1ficos no planilhas google"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Muitas vezes voc\u00ea pode querer adicionar <strong>barras de erro<\/strong> aos gr\u00e1ficos do Planilhas Google para capturar incertezas em torno de medi\u00e7\u00f5es ou valores calculados.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Felizmente, isso \u00e9 f\u00e1cil de fazer gra\u00e7as aos recursos de gr\u00e1ficos integrados do Planilhas Google.<\/span><\/p>\n<p> <span style=\"color: #000000;\">O exemplo passo a passo a seguir mostra como adicionar barras de erro a um histograma no Planilhas Google.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Passo 1: Insira os dados<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Vamos come\u00e7ar inserindo alguns valores de dados no Planilhas Google:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19458 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles1.png\" alt=\"\" width=\"519\" height=\"438\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 2: crie um histograma<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A seguir, vamos inserir um histograma. Destaque as c\u00e9lulas <strong>A1:B6<\/strong> , clique na guia <strong>Inserir<\/strong> e clique em <strong>Gr\u00e1fico<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19459 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles2.png\" alt=\"\" width=\"454\" height=\"464\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Na janela <strong>do Editor de Gr\u00e1fico<\/strong> no lado direito da tela, clique em <strong>Tipo de Gr\u00e1fico<\/strong> e depois clique em <strong>Histograma<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19460 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles3.png\" alt=\"\" width=\"350\" height=\"555\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">O seguinte gr\u00e1fico de colunas aparecer\u00e1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19465 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles0.png\" alt=\"\" width=\"513\" height=\"324\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 3: inserir barras de erro<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Para inserir barras de erro, clique na guia <strong>Personalizar<\/strong> na janela do Editor de Gr\u00e1fico. Role para baixo e clique em <strong>S\u00e9rie<\/strong> e marque a caixa ao lado de <strong>Barras de erro<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19461 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles4.png\" alt=\"\" width=\"355\" height=\"727\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Por padr\u00e3o, barras de erro representando 10% do tamanho de cada coluna ser\u00e3o exibidas no gr\u00e1fico:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19462 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-derreur5.png\" alt=\"\" width=\"517\" height=\"329\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 4: personalizar barras de erro<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Existem tr\u00eas tipos de barras de erro que voc\u00ea pode usar nos histogramas do Planilhas Google:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Porcentagem (padr\u00e3o)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Constante<\/span><\/li>\n<li> <span style=\"color: #000000;\">Desvio padr\u00e3o<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Por exemplo, podemos optar por exibir uma barra de erro constante de comprimento 5 para cada coluna:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19463 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles6.png\" alt=\"\" width=\"367\" height=\"295\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Uma barra de erro com comprimento 5 seria adicionada a cada coluna do gr\u00e1fico:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19464 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles7.png\" alt=\"\" width=\"522\" height=\"342\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sinta-se \u00e0 vontade para escolher um dos tr\u00eas tipos de barras de erro para exibir, dependendo de como deseja que o gr\u00e1fico apare\u00e7a.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam como criar outras visualiza\u00e7\u00f5es comuns no Planilhas Google:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pt\/boxplot-planilhas-do-google\/\" target=\"_blank\" rel=\"noopener\">Como criar um box plot no Planilhas Google<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/grafico-de-pareto-planilhas-do-google\/\" target=\"_blank\" rel=\"noopener\">Como criar um gr\u00e1fico de Pareto no Planilhas Google<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/grafico-de-bolhas-do-planilhas-google\/\" target=\"_blank\" rel=\"noopener\">Como criar um gr\u00e1fico de bolhas no Planilhas Google<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Muitas vezes voc\u00ea pode querer adicionar barras de erro aos gr\u00e1ficos do Planilhas Google para capturar incertezas em torno de medi\u00e7\u00f5es ou valores calculados. Felizmente, isso \u00e9 f\u00e1cil de fazer gra\u00e7as aos recursos de gr\u00e1ficos integrados do Planilhas Google. O exemplo passo a passo a seguir mostra como adicionar barras de erro a um histograma [&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-2091","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>Como adicionar barras de erro a gr\u00e1ficos no Planilhas Google \u2013 Estatologia<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como adicionar barras de erro a gr\u00e1ficos no Planilhas Google, com v\u00e1rios exemplos.\" \/>\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\/barras-de-erro-do-planilhas-google\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como adicionar barras de erro a gr\u00e1ficos no Planilhas Google \u2013 Estatologia\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como adicionar barras de erro a gr\u00e1ficos no Planilhas Google, com v\u00e1rios exemplos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T17:54:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles1.png\" \/>\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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/\",\"url\":\"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/\",\"name\":\"Como adicionar barras de erro a gr\u00e1ficos no Planilhas Google \u2013 Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-23T17:54:52+00:00\",\"dateModified\":\"2023-07-23T17:54:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como adicionar barras de erro a gr\u00e1ficos no Planilhas Google, com v\u00e1rios exemplos.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como adicionar barras de erro a gr\u00e1ficos no planilhas google\"}]},{\"@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":"Como adicionar barras de erro a gr\u00e1ficos no Planilhas Google \u2013 Estatologia","description":"Este tutorial explica como adicionar barras de erro a gr\u00e1ficos no Planilhas Google, com v\u00e1rios exemplos.","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\/barras-de-erro-do-planilhas-google\/","og_locale":"pt_PT","og_type":"article","og_title":"Como adicionar barras de erro a gr\u00e1ficos no Planilhas Google \u2013 Estatologia","og_description":"Este tutorial explica como adicionar barras de erro a gr\u00e1ficos no Planilhas Google, com v\u00e1rios exemplos.","og_url":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/","og_site_name":"Statorials","article_published_time":"2023-07-23T17:54:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles1.png"}],"author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/","url":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/","name":"Como adicionar barras de erro a gr\u00e1ficos no Planilhas Google \u2013 Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-23T17:54:52+00:00","dateModified":"2023-07-23T17:54:52+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como adicionar barras de erro a gr\u00e1ficos no Planilhas Google, com v\u00e1rios exemplos.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/barras-de-erro-do-planilhas-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como adicionar barras de erro a gr\u00e1ficos no planilhas google"}]},{"@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\/2091","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=2091"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/2091\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=2091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=2091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=2091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}