{"id":907,"date":"2023-07-28T08:42:23","date_gmt":"2023-07-28T08:42:23","guid":{"rendered":"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/"},"modified":"2023-07-28T08:42:23","modified_gmt":"2023-07-28T08:42:23","slug":"desenhe-a-equacao-do-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/","title":{"rendered":"Como tra\u00e7ar uma equa\u00e7\u00e3o no excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Muitas vezes voc\u00ea pode querer tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel. Felizmente, isso \u00e9 f\u00e1cil de fazer gra\u00e7as \u00e0s f\u00f3rmulas integradas do Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Este tutorial fornece v\u00e1rios exemplos de como plotar equa\u00e7\u00f5es\/fun\u00e7\u00f5es no Excel.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Exemplo 1:<\/span> <span style=\"color: #000000;\">Desenhando uma Equa\u00e7\u00e3o Linear<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Suponha que voc\u00ea queira tra\u00e7ar a seguinte equa\u00e7\u00e3o:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>y = 2x + 5<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">A imagem a seguir mostra como criar os valores de y para esta equa\u00e7\u00e3o linear no Excel, usando o intervalo de 1 a 10 para os valores de x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9690\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel1.png\" alt=\"Trace uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel\" width=\"309\" height=\"394\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A seguir, destaque os valores no intervalo <strong>A2:B11<\/strong> . Em seguida, clique na guia <strong>Inserir<\/strong> . No grupo <strong>Gr\u00e1ficos<\/strong> , clique na op\u00e7\u00e3o de gr\u00e1fico chamada <strong>Dispers\u00e3o<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"433\" height=\"323\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">O seguinte gr\u00e1fico aparecer\u00e1 automaticamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9691 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel2.png\" alt=\"\" width=\"438\" height=\"403\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Podemos ver que o gr\u00e1fico segue uma linha reta, pois a equa\u00e7\u00e3o que usamos era de natureza linear.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Exemplo 2:<\/span> <span style=\"color: #000000;\">Desenhando uma Equa\u00e7\u00e3o Quadr\u00e1tica<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Suponha que voc\u00ea queira tra\u00e7ar a seguinte equa\u00e7\u00e3o:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>y = <sup>3&#215;2<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">A imagem a seguir mostra como criar os valores de y para esta equa\u00e7\u00e3o no Excel, utilizando o intervalo de 1 a 10 para os valores de x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9694 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel3.png\" alt=\"\" width=\"315\" height=\"446\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A seguir, destaque os valores no intervalo <strong>A2:B11<\/strong> . Em seguida, clique na guia <strong>Inserir<\/strong> . No grupo <strong>Gr\u00e1ficos<\/strong> , clique na op\u00e7\u00e3o de gr\u00e1fico chamada <strong>Dispers\u00e3o<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"433\" height=\"323\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">O seguinte gr\u00e1fico aparecer\u00e1 automaticamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9695 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel4.png\" alt=\"\" width=\"420\" height=\"382\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Podemos ver que o gr\u00e1fico segue uma linha curva j\u00e1 que a equa\u00e7\u00e3o que usamos era quadr\u00e1tica.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Exemplo 3:<\/span> <span style=\"color: #000000;\">Desenhando uma Equa\u00e7\u00e3o Rec\u00edproca<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Suponha que voc\u00ea queira tra\u00e7ar a seguinte equa\u00e7\u00e3o:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>y = 1\/x<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">A imagem a seguir mostra como criar os valores de y para esta equa\u00e7\u00e3o no Excel, utilizando o intervalo de 1 a 10 para os valores de x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9696 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel5.png\" alt=\"\" width=\"314\" height=\"404\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A seguir, destaque os valores no intervalo <strong>A2:B11<\/strong> . Em seguida, clique na guia <strong>Inserir<\/strong> . No grupo <strong>Gr\u00e1ficos<\/strong> , clique na op\u00e7\u00e3o de gr\u00e1fico chamada <strong>Dispers\u00e3o<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"433\" height=\"323\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">O seguinte gr\u00e1fico aparecer\u00e1 automaticamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9697 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel6.png\" alt=\"\" width=\"451\" height=\"418\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Podemos ver que o gr\u00e1fico segue uma linha curva descendente, pois representa a equa\u00e7\u00e3o y = 1\/x.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Exemplo 4:<\/span> <span style=\"color: #000000;\">Desenhando uma Equa\u00e7\u00e3o Senoidal<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Suponha que voc\u00ea queira tra\u00e7ar a seguinte equa\u00e7\u00e3o:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>y = pecado (x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">A imagem a seguir mostra como criar os valores de y para esta equa\u00e7\u00e3o no Excel, utilizando o intervalo de 1 a 10 para os valores de x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-9698 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel7.png\" alt=\"\" width=\"346\" height=\"376\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A seguir, destaque os valores no intervalo <strong>A2:B11<\/strong> . Em seguida, clique na guia <strong>Inserir<\/strong> . No grupo <strong>Gr\u00e1ficos<\/strong> , clique na op\u00e7\u00e3o de plotagem chamada <strong>Dispers\u00e3o com linhas suaves e marcadores<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">O seguinte gr\u00e1fico aparecer\u00e1 automaticamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9699 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel8.png\" alt=\"Trace uma fun\u00e7\u00e3o seno no Excel\" width=\"469\" height=\"361\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <strong>Conclus\u00e3o<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Voc\u00ea pode usar uma t\u00e9cnica semelhante para tra\u00e7ar qualquer fun\u00e7\u00e3o ou equa\u00e7\u00e3o no Excel. Basta escolher um intervalo de valores de x para usar em uma coluna e, em seguida, usar uma equa\u00e7\u00e3o em uma coluna separada para definir os valores de y com base nos valores de x.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Muitas vezes voc\u00ea pode querer tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel. Felizmente, isso \u00e9 f\u00e1cil de fazer gra\u00e7as \u00e0s f\u00f3rmulas integradas do Excel. Este tutorial fornece v\u00e1rios exemplos de como plotar equa\u00e7\u00f5es\/fun\u00e7\u00f5es no Excel. Exemplo 1: Desenhando uma Equa\u00e7\u00e3o Linear Suponha que voc\u00ea queira tra\u00e7ar a seguinte equa\u00e7\u00e3o: y = 2x + 5 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-907","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 tra\u00e7ar uma equa\u00e7\u00e3o no Excel - Estatologia<\/title>\n<meta name=\"description\" content=\"Uma explica\u00e7\u00e3o simples sobre como tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o 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\/desenhe-a-equacao-do-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como tra\u00e7ar uma equa\u00e7\u00e3o no Excel - Estatologia\" \/>\n<meta property=\"og:description\" content=\"Uma explica\u00e7\u00e3o simples sobre como tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T08:42:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel1.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\/desenhe-a-equacao-do-excel\/\",\"url\":\"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/\",\"name\":\"Como tra\u00e7ar uma equa\u00e7\u00e3o no Excel - Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-28T08:42:23+00:00\",\"dateModified\":\"2023-07-28T08:42:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Uma explica\u00e7\u00e3o simples sobre como tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como tra\u00e7ar uma equa\u00e7\u00e3o 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 tra\u00e7ar uma equa\u00e7\u00e3o no Excel - Estatologia","description":"Uma explica\u00e7\u00e3o simples sobre como tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o 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\/desenhe-a-equacao-do-excel\/","og_locale":"pt_PT","og_type":"article","og_title":"Como tra\u00e7ar uma equa\u00e7\u00e3o no Excel - Estatologia","og_description":"Uma explica\u00e7\u00e3o simples sobre como tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel.","og_url":"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T08:42:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel1.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\/desenhe-a-equacao-do-excel\/","url":"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/","name":"Como tra\u00e7ar uma equa\u00e7\u00e3o no Excel - Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-28T08:42:23+00:00","dateModified":"2023-07-28T08:42:23+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Uma explica\u00e7\u00e3o simples sobre como tra\u00e7ar uma equa\u00e7\u00e3o ou fun\u00e7\u00e3o no Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/desenhe-a-equacao-do-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como tra\u00e7ar uma equa\u00e7\u00e3o 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\/907","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=907"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/907\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}