{"id":1540,"date":"2023-07-25T23:18:10","date_gmt":"2023-07-25T23:18:10","guid":{"rendered":"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/"},"modified":"2023-07-25T23:18:10","modified_gmt":"2023-07-25T23:18:10","slug":"fade-altman-plot-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/","title":{"rendered":"Como criar um gr\u00e1fico de bland-altman no excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Um <a href=\"https:\/\/statorials.org\/pt\/rastrear-altman-fade\/\" target=\"_blank\" rel=\"noopener\">gr\u00e1fico de Bland-Altman<\/a> \u00e9 usado para visualizar diferen\u00e7as de medi\u00e7\u00e3o entre dois instrumentos diferentes ou duas t\u00e9cnicas de medi\u00e7\u00e3o diferentes.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00c9 \u00fatil para determinar qu\u00e3o semelhantes s\u00e3o dois instrumentos ou t\u00e9cnicas na medi\u00e7\u00e3o do mesmo conceito.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Este tutorial fornece um exemplo passo a passo de cria\u00e7\u00e3o de um gr\u00e1fico de Bland-Altman no Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 1: crie os dados<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Suponha que um bi\u00f3logo utilize dois instrumentos diferentes (A e B) para medir o peso do mesmo conjunto de 20 sapos diferentes, em gramas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">O peso dos sapos, medido por cada instrumento, \u00e9 mostrado abaixo:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15288 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel1.png\" alt=\"\" width=\"429\" height=\"478\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Passo 2: Calcule a diferen\u00e7a nas medidas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A seguir, usaremos as seguintes f\u00f3rmulas para calcular a medida m\u00e9dia e a diferen\u00e7a nas medidas de cada sapo:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15289 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel2.png\" alt=\"\" width=\"479\" height=\"463\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Podemos ent\u00e3o copiar e colar esta f\u00f3rmula em cada c\u00e9lula nas colunas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15290 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel3.png\" alt=\"\" width=\"463\" height=\"489\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 3: Calcule a diferen\u00e7a m\u00e9dia e o intervalo de confian\u00e7a<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ent\u00e3o podemos usar as seguintes f\u00f3rmulas para calcular a diferen\u00e7a m\u00e9dia entre os dois instrumentos, bem como os limites superior e inferior do intervalo de confian\u00e7a de 95% para a diferen\u00e7a m\u00e9dia:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15292 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel4.png\" alt=\"\" width=\"487\" height=\"525\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A diferen\u00e7a m\u00e9dia acaba sendo <strong>0,5<\/strong> e o intervalo de confian\u00e7a de 95% para a diferen\u00e7a m\u00e9dia \u00e9 <strong>[-1,921, 2,921]<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 4: crie o gr\u00e1fico Bland-Altman<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Para criar o gr\u00e1fico de Bland-Altman, destaque as c\u00e9lulas no intervalo <strong>C2:D21<\/strong> da seguinte forma:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15293 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel5.png\" alt=\"\" width=\"428\" height=\"528\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Na faixa superior, clique em <strong>Inserir<\/strong> e, em seguida, clique no primeiro gr\u00e1fico no grupo <strong>Inserir Dispers\u00e3o (X,Y) ou Gr\u00e1fico de Bolhas<\/strong> no grupo <strong>Gr\u00e1ficos<\/strong> . A seguinte nuvem de pontos aparecer\u00e1 automaticamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel6.png\" alt=\"\" width=\"461\" height=\"341\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">O eixo x mostra a medi\u00e7\u00e3o m\u00e9dia dos instrumentos e o eixo y mostra a diferen\u00e7a entre as medi\u00e7\u00f5es dos dois instrumentos.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Para adicionar uma linha horizontal que represente a diferen\u00e7a m\u00e9dia das medidas, precisamos criar uma s\u00e9rie de dados que mostre os valores m\u00ednimo e m\u00e1ximo ao longo do eixo x (0 e 30), bem como os valores que mostram o diferen\u00e7a m\u00e9dia:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel7.png\" alt=\"\" width=\"394\" height=\"417\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Em seguida, clique com o bot\u00e3o direito no gr\u00e1fico e clique em <strong>Selecionar dados<\/strong> . Na janela que aparece, clique em <strong>Adicionar<\/strong> na se\u00e7\u00e3o <strong>Entradas de legenda (s\u00e9rie)<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel8.png\" alt=\"\" width=\"544\" height=\"362\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Na nova janela que aparece, forne\u00e7a as seguintes informa\u00e7\u00f5es:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel9.png\" alt=\"\" width=\"478\" height=\"380\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Depois de clicar em <strong>OK<\/strong> , dois pontos laranja aparecer\u00e3o no gr\u00e1fico:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15300 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel12.png\" alt=\"\" width=\"474\" height=\"351\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Clique com o bot\u00e3o direito em um dos pontos laranja e clique em <strong>Formatar s\u00e9rie de dados\u2026<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Na janela que aparece \u00e0 direita da tela, clique em <strong>Linha s\u00f3lida<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15298 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel10.png\" alt=\"\" width=\"283\" height=\"436\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Isto transformar\u00e1 os dois pontos laranja em uma linha laranja s\u00f3lida que representa a diferen\u00e7a m\u00e9dia entre os dois instrumentos:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15299 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel11.png\" alt=\"\" width=\"464\" height=\"345\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Repita esse processo para as linhas superiores e inferiores do intervalo de confian\u00e7a.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sinta-se \u00e0 vontade para modificar os estilos de linha, os nomes dos eixos e o t\u00edtulo do gr\u00e1fico para produzir um gr\u00e1fico de Bland-Altman esteticamente agrad\u00e1vel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15280\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fade1.png\" alt=\"Gr\u00e1fico de Bland-Altman no Excel\" width=\"476\" height=\"470\" srcset=\"\" sizes=\"auto, \"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um gr\u00e1fico de Bland-Altman \u00e9 usado para visualizar diferen\u00e7as de medi\u00e7\u00e3o entre dois instrumentos diferentes ou duas t\u00e9cnicas de medi\u00e7\u00e3o diferentes. \u00c9 \u00fatil para determinar qu\u00e3o semelhantes s\u00e3o dois instrumentos ou t\u00e9cnicas na medi\u00e7\u00e3o do mesmo conceito. Este tutorial fornece um exemplo passo a passo de cria\u00e7\u00e3o de um gr\u00e1fico de Bland-Altman no Excel. Etapa [&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-1540","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 criar um gr\u00e1fico de Bland-Altman no Excel<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como criar um gr\u00e1fico de Bland-Altman no Excel, com um exemplo passo a passo.\" \/>\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\/fade-altman-plot-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como criar um gr\u00e1fico de Bland-Altman no Excel\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como criar um gr\u00e1fico de Bland-Altman no Excel, com um exemplo passo a passo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T23:18:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel1.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=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/\",\"url\":\"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/\",\"name\":\"Como criar um gr\u00e1fico de Bland-Altman no Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-25T23:18:10+00:00\",\"dateModified\":\"2023-07-25T23:18:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como criar um gr\u00e1fico de Bland-Altman no Excel, com um exemplo passo a passo.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como criar um gr\u00e1fico de bland-altman no excel\"}]},{\"@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 criar um gr\u00e1fico de Bland-Altman no Excel","description":"Este tutorial explica como criar um gr\u00e1fico de Bland-Altman no Excel, com um exemplo passo a passo.","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\/fade-altman-plot-excel\/","og_locale":"pt_PT","og_type":"article","og_title":"Como criar um gr\u00e1fico de Bland-Altman no Excel","og_description":"Este tutorial explica como criar um gr\u00e1fico de Bland-Altman no Excel, com um exemplo passo a passo.","og_url":"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T23:18:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel1.png"}],"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\/fade-altman-plot-excel\/","url":"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/","name":"Como criar um gr\u00e1fico de Bland-Altman no Excel","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-25T23:18:10+00:00","dateModified":"2023-07-25T23:18:10+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como criar um gr\u00e1fico de Bland-Altman no Excel, com um exemplo passo a passo.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/fade-altman-plot-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como criar um gr\u00e1fico de bland-altman no excel"}]},{"@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\/1540","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=1540"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/1540\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=1540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=1540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=1540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}