{"id":598,"date":"2023-07-29T09:16:51","date_gmt":"2023-07-29T09:16:51","guid":{"rendered":"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/"},"modified":"2023-07-29T09:16:51","modified_gmt":"2023-07-29T09:16:51","slug":"suavizacao-exponencial-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/","title":{"rendered":"Como realizar suaviza\u00e7\u00e3o exponencial no excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>A suaviza\u00e7\u00e3o exponencial<\/strong> \u00e9 uma t\u00e9cnica para \u201csuavizar\u201d dados de s\u00e9ries temporais e \u00e9 frequentemente usada para previs\u00f5es de curto prazo.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A ideia b\u00e1sica \u00e9 que os dados de s\u00e9ries temporais s\u00e3o frequentemente associados a &#8220;ru\u00eddos aleat\u00f3rios&#8221;, resultando em picos e vales nos dados, mas aplicando suaviza\u00e7\u00e3o exponencial podemos suavizar esses picos e vales para ver a verdadeira tend\u00eancia subjacente nos dados. .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5547 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth2.png\" alt=\"Suaviza\u00e7\u00e3o Exponencial no Excel\" width=\"448\" height=\"270\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A f\u00f3rmula b\u00e1sica para aplicar suaviza\u00e7\u00e3o exponencial \u00e9:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">F <sub>t<\/sub> = \u03b1y <sub>t-1<\/sub> + (1 \u2013 \u03b1) F <sub>t-1<\/sub><\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Ouro:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>F <sub>t<\/sub><\/strong> = valor previsto para o per\u00edodo atual <em>t<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>\u03b1<\/strong> = O valor da constante de suaviza\u00e7\u00e3o, entre 0 e 1<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>y<\/strong> <sub><strong>t-1<\/strong><\/sub> = O valor real dos dados do per\u00edodo anterior<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>F <sub>t-1<\/sub><\/strong> = valor previsto para o per\u00edodo anterior <em>t-1<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Quanto menor o valor alfa, mais suaves s\u00e3o os dados da s\u00e9rie temporal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Neste tutorial, mostramos como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9rie temporal usando uma fun\u00e7\u00e3o integrada no Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Exemplo: suaviza\u00e7\u00e3o exponencial no Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Suponha que temos o seguinte conjunto de dados que mostra as vendas de uma determinada empresa durante 10 per\u00edodos de vendas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5546 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth1.png\" alt=\"Exemplo de suaviza\u00e7\u00e3o exponencial no Excel\" width=\"524\" height=\"533\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Conclua as etapas a seguir para aplicar suaviza\u00e7\u00e3o exponencial a esses dados de s\u00e9rie temporal.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Passo 1: Clique no bot\u00e3o \u201cAn\u00e1lise de Dados\u201d.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">V\u00e1 para a guia \u201cDados\u201d na faixa superior e clique no bot\u00e3o \u201cAn\u00e1lise de Dados\u201d. Se voc\u00ea n\u00e3o vir esse bot\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 Excel Analysis ToolPak<\/a> , que \u00e9 totalmente gratuito.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5292 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"Kit de ferramentas de an\u00e1lise de dados no Excel\" width=\"532\" height=\"203\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Passo 2: Escolha a op\u00e7\u00e3o \u201cSuaviza\u00e7\u00e3o Exponencial\u201d e clique em OK.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5550 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth3.png\" alt=\"Exemplo de suaviza\u00e7\u00e3o exponencial no Excel\" width=\"499\" height=\"342\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Etapa 3: Preencha os valores necess\u00e1rios.<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Preencha os valores dos dados para <strong>o intervalo de entrada<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selecione o valor que deseja usar para <strong>Damping Factor<\/strong> , que \u00e9 1-\u03b1. Se voc\u00ea quiser usar \u03b1 = 0,2, ent\u00e3o seu fator de amortecimento ser\u00e1 1-0,2 = 0,8.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selecione o <strong>intervalo de sa\u00edda<\/strong> no qual deseja que os valores previstos apare\u00e7am. \u00c9 uma boa ideia escolher esse intervalo de sa\u00edda ao lado dos valores reais dos dados para que voc\u00ea possa comparar facilmente os valores reais e os valores previstos lado a lado.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Se desejar ver um gr\u00e1fico exibido com valores reais e previstos, marque a caixa que diz <strong>Sa\u00edda do gr\u00e1fico<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Em seguida, clique em OK.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5553 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth4-2.png\" alt=\"Exemplo de suaviza\u00e7\u00e3o exponencial\" width=\"533\" height=\"370\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Uma lista de valores previstos e um gr\u00e1fico aparecer\u00e3o automaticamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5554 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth5.png\" alt=\"Suaviza\u00e7\u00e3o Exponencial no Excel\" width=\"573\" height=\"331\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Observe que o primeiro per\u00edodo est\u00e1 definido como #N\/A porque n\u00e3o h\u00e1 per\u00edodo anterior a ser usado para calcular o valor da previs\u00e3o.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Experimente fatores de suaviza\u00e7\u00e3o<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Voc\u00ea pode experimentar diferentes valores para o fator de suaviza\u00e7\u00e3o \u03b1 e ver seu impacto nos valores previstos. Voc\u00ea notar\u00e1 que quanto menor o valor de \u03b1 (maior valor do fator de amortecimento), mais suaves ser\u00e3o os valores previstos:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5556 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth6.png\" alt=\"Exemplos de suaviza\u00e7\u00e3o exponencial no Excel\" width=\"579\" height=\"558\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><em>Para mais tutoriais do Excel, verifique nossa <a href=\"https:\/\/statorials.org\/pt\/estatologia-explica-conceitos-de-forma-simples-e-direta-facilitamos-o-aprendizado-de-estatistica\/\" target=\"_blank\" rel=\"noopener\">lista completa de guias do Excel<\/a> .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A suaviza\u00e7\u00e3o exponencial \u00e9 uma t\u00e9cnica para \u201csuavizar\u201d dados de s\u00e9ries temporais e \u00e9 frequentemente usada para previs\u00f5es de curto prazo. A ideia b\u00e1sica \u00e9 que os dados de s\u00e9ries temporais s\u00e3o frequentemente associados a &#8220;ru\u00eddos aleat\u00f3rios&#8221;, resultando em picos e vales nos dados, mas aplicando suaviza\u00e7\u00e3o exponencial podemos suavizar esses picos e vales para [&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-598","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 suaviza\u00e7\u00e3o exponencial no Excel \u2013 Estatologia<\/title>\n<meta name=\"description\" content=\"Uma explica\u00e7\u00e3o simples sobre como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9ries temporais no Excel.\" \/>\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\/suavizacao-exponencial-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como realizar suaviza\u00e7\u00e3o exponencial no Excel \u2013 Estatologia\" \/>\n<meta property=\"og:description\" content=\"Uma explica\u00e7\u00e3o simples sobre como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9ries temporais no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T09:16:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth2.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\/suavizacao-exponencial-excel\/\",\"url\":\"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/\",\"name\":\"Como realizar suaviza\u00e7\u00e3o exponencial no Excel \u2013 Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-29T09:16:51+00:00\",\"dateModified\":\"2023-07-29T09:16:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Uma explica\u00e7\u00e3o simples sobre como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9ries temporais no Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como realizar suaviza\u00e7\u00e3o exponencial 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 suaviza\u00e7\u00e3o exponencial no Excel \u2013 Estatologia","description":"Uma explica\u00e7\u00e3o simples sobre como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9ries temporais no Excel.","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\/suavizacao-exponencial-excel\/","og_locale":"pt_PT","og_type":"article","og_title":"Como realizar suaviza\u00e7\u00e3o exponencial no Excel \u2013 Estatologia","og_description":"Uma explica\u00e7\u00e3o simples sobre como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9ries temporais no Excel.","og_url":"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T09:16:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expsmooth2.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\/suavizacao-exponencial-excel\/","url":"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/","name":"Como realizar suaviza\u00e7\u00e3o exponencial no Excel \u2013 Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-29T09:16:51+00:00","dateModified":"2023-07-29T09:16:51+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Uma explica\u00e7\u00e3o simples sobre como realizar suaviza\u00e7\u00e3o exponencial para dados de s\u00e9ries temporais no Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/suavizacao-exponencial-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como realizar suaviza\u00e7\u00e3o exponencial 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\/598","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=598"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/598\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}