{"id":1579,"date":"2023-07-25T19:07:04","date_gmt":"2023-07-25T19:07:04","guid":{"rendered":"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/"},"modified":"2023-07-25T19:07:04","modified_gmt":"2023-07-25T19:07:04","slug":"teste-excel-durbin-watson","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/","title":{"rendered":"Como realizar um teste durbin-watson no excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Um dos <a href=\"https:\/\/statorials.org\/pt\/suposicoes-de-regressao-linear\/\" target=\"_blank\" rel=\"noopener\">principais pressupostos da regress\u00e3o linear<\/a> \u00e9 que n\u00e3o h\u00e1 correla\u00e7\u00e3o entre os res\u00edduos, ou seja, os res\u00edduos s\u00e3o independentes.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Uma forma de determinar se esta suposi\u00e7\u00e3o \u00e9 atendida \u00e9 realizar um <a href=\"https:\/\/statorials.org\/pt\/teste-de-durbin-watson\/\" target=\"_blank\" rel=\"noopener\">teste de Durbin-Watson<\/a> , que \u00e9 utilizado para detectar a presen\u00e7a de autocorrela\u00e7\u00e3o nos res\u00edduos de uma regress\u00e3o. Este teste usa as seguintes suposi\u00e7\u00f5es:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub> (hip\u00f3tese nula):<\/strong> N\u00e3o h\u00e1 correla\u00e7\u00e3o entre os res\u00edduos.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>H <sub>A<\/sub> (hip\u00f3tese alternativa):<\/strong> Os res\u00edduos s\u00e3o autocorrelacionados.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Este tutorial fornece um exemplo passo a passo de como realizar um teste Durbin-Watson no Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Passo 1: Insira os dados<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Primeiro, inseriremos valores de um conjunto de dados para o qual queremos construir um <a href=\"https:\/\/statorials.org\/pt\/regressao-linear-multipla\/\" target=\"_blank\" rel=\"noopener\">modelo de regress\u00e3o linear m\u00faltipla<\/a> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15708 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinexcel1.png\" alt=\"\" width=\"454\" height=\"411\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Etapa 2: ajustar um modelo de regress\u00e3o linear m\u00faltipla<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A seguir, ajustaremos um modelo de regress\u00e3o linear m\u00faltipla usando y como vari\u00e1vel de resposta e x1 e x2 como vari\u00e1veis preditoras.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Para fazer isso, clique na guia <strong>Dados<\/strong> na faixa superior. Em seguida, clique em <strong>An\u00e1lise de Dados<\/strong> no grupo <strong>Analisar<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-5292 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"\" width=\"485\" height=\"185\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Se voc\u00ea n\u00e3o vir isso como uma op\u00e7\u00e3o, primeiro dever\u00e1 <a href=\"https:\/\/statorials.org\/pt\/como-carregar-o-pacote-de-ferramentas-de-analise-no-excel\/\" target=\"_blank\" rel=\"noopener\">carregar o Analysis ToolPak<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Na janela que aparece, clique em <strong>Regress\u00e3o<\/strong> e depois clique em <strong>OK<\/strong> . Na nova janela que aparece, forne\u00e7a as seguintes informa\u00e7\u00f5es:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15709 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinexcel2.png\" alt=\"\" width=\"518\" height=\"354\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Depois de clicar em <strong>OK<\/strong> , o resultado da regress\u00e3o aparecer\u00e1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15710 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinexcel3.png\" alt=\"\" width=\"554\" height=\"616\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Passo 3: Realize o teste Durbin-Watson<\/span><\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A estat\u00edstica de teste para o teste Durbin-Watson, denotada <em>d<\/em> , \u00e9 calculada da seguinte forma:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13640 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinwatson1-1.png\" alt=\"Estat\u00edstica do teste Durbin Watson\" width=\"197\" height=\"66\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Ouro:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>T:<\/strong> O n\u00famero total de observa\u00e7\u00f5es<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>e <sub>t<\/sub> :<\/strong> O t- <sup>\u00e9simo<\/sup> res\u00edduo do modelo de regress\u00e3o<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Para calcular esta estat\u00edstica de teste no Excel, podemos usar a seguinte f\u00f3rmula:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15711 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinexcel4.png\" alt=\"Teste Durbin Watson no Excel\" width=\"615\" height=\"293\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A estat\u00edstica de teste acabou sendo <strong>1,3475<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Para determinar se uma estat\u00edstica do teste Durbin-Watson \u00e9 significativamente significativa em um determinado n\u00edvel alfa, pode-se consultar esta tabela de valores cr\u00edticos.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Para \u03b1 = 0,05, n = 13 observa\u00e7\u00f5es e k = 2 vari\u00e1veis independentes no modelo de regress\u00e3o, a tabela Durbin-Watson mostra os seguintes valores cr\u00edticos superiores e inferiores:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Valor cr\u00edtico inferior: <strong>0,86<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Valor cr\u00edtico superior: <strong>1,56<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Como a nossa estat\u00edstica de teste de <strong>1,3475<\/strong> n\u00e3o fica fora deste intervalo, n\u00e3o temos evid\u00eancias suficientes para rejeitar a hip\u00f3tese nula do teste de Durbin-Watson.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Em outras palavras, n\u00e3o h\u00e1 correla\u00e7\u00e3o entre os res\u00edduos.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>O que fazer se a autocorrela\u00e7\u00e3o for detectada<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Se voc\u00ea rejeitar a hip\u00f3tese nula e concluir que a autocorrela\u00e7\u00e3o est\u00e1 presente nos <a href=\"https:\/\/statorials.org\/pt\/residuo\/\" target=\"_blank\" rel=\"noopener\">res\u00edduos<\/a> , voc\u00ea ter\u00e1 v\u00e1rias op\u00e7\u00f5es para corrigir esse problema se ele for suficientemente grave:<\/span><\/p>\n<ul data-slot-rendered-dynamic=\"true\">\n<li> <span style=\"color: #000000;\">Para correla\u00e7\u00e3o serial positiva, considere adicionar defasagens da vari\u00e1vel dependente e\/ou independente ao modelo.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Para correla\u00e7\u00e3o serial negativa, certifique-se de que nenhuma de suas vari\u00e1veis esteja <em>atrasada demais<\/em> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Para correla\u00e7\u00e3o sazonal, considere adicionar <a href=\"https:\/\/statorials.org\/pt\/variaveis-ficticias-de-regressao\/\" target=\"_blank\" rel=\"noopener\">dummies<\/a> sazonais ao modelo.<\/span><\/li>\n<\/ul>\n<h3> <strong>Recursos adicionais<\/strong><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/pt\/como-criar-um-traco-residual-no-excel\/\" target=\"_blank\" rel=\"noopener\">Como criar um gr\u00e1fico residual no Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/residuos-normalizados-do-excel\/\" target=\"_blank\" rel=\"noopener\">Como calcular res\u00edduos padronizados no Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/soma-residual-de-quadrados-no-excel\/\" target=\"_blank\" rel=\"noopener\">Como calcular a soma residual dos quadrados no Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um dos principais pressupostos da regress\u00e3o linear \u00e9 que n\u00e3o h\u00e1 correla\u00e7\u00e3o entre os res\u00edduos, ou seja, os res\u00edduos s\u00e3o independentes. Uma forma de determinar se esta suposi\u00e7\u00e3o \u00e9 atendida \u00e9 realizar um teste de Durbin-Watson , que \u00e9 utilizado para detectar a presen\u00e7a de autocorrela\u00e7\u00e3o nos res\u00edduos de uma regress\u00e3o. Este teste usa as [&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-1579","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 realizar um teste Durbin-Watson no Excel \u2013 Estatologia<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como realizar um teste de Durbin-Watson 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\/teste-excel-durbin-watson\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como realizar um teste Durbin-Watson no Excel \u2013 Estatologia\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como realizar um teste de Durbin-Watson no Excel, com um exemplo passo a passo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T19:07:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinexcel1.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\/teste-excel-durbin-watson\/\",\"url\":\"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/\",\"name\":\"Como realizar um teste Durbin-Watson no Excel \u2013 Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-25T19:07:04+00:00\",\"dateModified\":\"2023-07-25T19:07:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como realizar um teste de Durbin-Watson no Excel, com um exemplo passo a passo.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como realizar um teste durbin-watson 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 realizar um teste Durbin-Watson no Excel \u2013 Estatologia","description":"Este tutorial explica como realizar um teste de Durbin-Watson 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\/teste-excel-durbin-watson\/","og_locale":"pt_PT","og_type":"article","og_title":"Como realizar um teste Durbin-Watson no Excel \u2013 Estatologia","og_description":"Este tutorial explica como realizar um teste de Durbin-Watson no Excel, com um exemplo passo a passo.","og_url":"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/","og_site_name":"Statorials","article_published_time":"2023-07-25T19:07:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/durbinexcel1.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\/teste-excel-durbin-watson\/","url":"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/","name":"Como realizar um teste Durbin-Watson no Excel \u2013 Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-25T19:07:04+00:00","dateModified":"2023-07-25T19:07:04+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como realizar um teste de Durbin-Watson no Excel, com um exemplo passo a passo.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/teste-excel-durbin-watson\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como realizar um teste durbin-watson 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\/1579","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=1579"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/1579\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=1579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=1579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=1579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}