{"id":11116,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/distorcao\/"},"modified":"2021-02-25T17:29:14","modified_gmt":"2021-02-25T17:29:14","slug":"skew","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/skew\/","title":{"rendered":"DISTOR\u00c7\u00c3O"},"content":{"rendered":"<h2>Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o de Distribui\u00e7\u00e3o Assim\u00e9trica<\/h2>\n<p>A fun\u00e7\u00e3o DISTOR\u00c7\u00c3O \u00e9 amplamente utilizada no Excel e no Google Planilhas para calcular a assimetria numa distribui\u00e7\u00e3o de probabilidade de um conjunto de dados. A assimetria, ou skewness, \u00e9 uma medida que reflete o quanto uma distribui\u00e7\u00e3o se desvia da simetria em torno da m\u00e9dia. Ela indica a dire\u00e7\u00e3o e a intensidade dessa distor\u00e7\u00e3o, apontando se a distribui\u00e7\u00e3o se estende mais por valores superiores ou inferiores.<\/p>\n<h2>Sintaxe e Exemplos<\/h2>\n<p><strong>Sintaxe:<\/strong><\/p>\n<pre><code>DISTOR\u00c7\u00c3O(numero1; [numero2]; ...)<\/code><\/pre>\n<p>Os argumentos <code>numero1<\/code>, <code>numero2<\/code>, &#8230; s\u00e3o os valores da amostra para os quais a assimetria ser\u00e1 calculada.<\/p>\n<p><strong>Exemplo B\u00e1sico:<\/strong><\/p>\n<pre><code>=DISTOR\u00c7\u00c3O(3; 4; 5; 2; 3; 6)<\/code><\/pre>\n<p>Este exemplo retorna a assimetria para os n\u00fameros 3, 4, 5, 2, 3 e 6. Um resultado positivo sugere uma assimetria \u00e0 direita, onde a cauda na extremidade direita \u00e9 mais longa ou pesada que a esquerda. Um resultado negativo indica o contr\u00e1rio.<\/p>\n<h2>Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n<p>A fun\u00e7\u00e3o DISTOR\u00c7\u00c3O \u00e9 \u00fatil em v\u00e1rios contextos anal\u00edticos:<\/p>\n<h3>An\u00e1lise de Investimento<\/h3>\n<p>Para um analista financeiro que precisa avaliar a assimetria nos retornos de diferentes a\u00e7\u00f5es para uma an\u00e1lise de risco mais apurada:<\/p>\n<pre><code>=DISTOR\u00c7\u00c3O(A2:A100)<\/code><\/pre>\n<p>Neste exemplo, A2:A100 pode conter os retornos di\u00e1rios de uma a\u00e7\u00e3o em particular, ajudando a identificar se os retornos tendem a ser extremamente altos ou baixos com mais frequ\u00eancia, uma informa\u00e7\u00e3o vital para decis\u00f5es de investimento.<\/p>\n<h3>Estudo Cient\u00edfico<\/h3>\n<p>Um pesquisador analisando dados ambientais, por exemplo, a assimetria nas temperaturas registradas durante um per\u00edodo espec\u00edfico:<\/p>\n<pre><code>=DISTOR\u00c7\u00c3O(B2:B365)<\/code><\/pre>\n<p>Aqui, presume-se que B2:B365 contenha dados di\u00e1rios de temperatura por um ano. Os resultados indicar\u00e3o se h\u00e1 uma tend\u00eancia de dias extremamente quentes ou frios, algo crucial em estudos sobre mudan\u00e7as clim\u00e1ticas.<\/p>\n<h2>Conclus\u00e3o<\/h2>\n<p>Compreender e usar a fun\u00e7\u00e3o DISTOR\u00c7\u00c3O no Excel e no Google Planilhas pode profundamente enriquecer a an\u00e1lise de dados em diversos campos, fornecendo insights valiosos sobre as caracter\u00edsticas dos dados analisados. Independentemente do setor \u2013 financeiro, cient\u00edfico ou qualquer outro \u2013, identificar padr\u00f5es de assimetria nos dados \u00e9 essencial para tomar decis\u00f5es estrat\u00e9gicas bem-informadas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devolve a distor\u00e7\u00e3o de uma distribui\u00e7\u00e3o<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[],"class_list":["post-11116","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pt-pt\/skew\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/skew\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:29:14+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/pt-pt\/skew\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/skew\/\",\"name\":\"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:29:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/skew\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/skew\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/skew\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estat\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DISTOR\u00c7\u00c3O\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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:\/\/functiontranslator.com\/pt-pt\/skew\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/skew\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:29:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/skew\/","url":"https:\/\/functiontranslator.com\/pt-pt\/skew\/","name":"Fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:29:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o SKEW (DISTOR\u00c7\u00c3O) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/skew\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/skew\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/skew\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Estat\u00edstica","item":"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/"},{"@type":"ListItem","position":3,"name":"DISTOR\u00c7\u00c3O"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11116"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11116\/revisions"}],"predecessor-version":[{"id":25945,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11116\/revisions\/25945"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}