{"id":11130,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/desvpadp\/"},"modified":"2021-02-25T17:29:53","modified_gmt":"2021-02-25T17:29:53","slug":"stdevp","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/","title":{"rendered":"DESVPADP"},"content":{"rendered":"

A fun\u00e7\u00e3o DESVPADP<\/strong> no Microsoft Excel e STDEVP<\/strong> no Google Sheets \u00e9 utilizada para calcular o desvio padr\u00e3o de uma popula\u00e7\u00e3o completa. Essa fun\u00e7\u00e3o assume que o conjunto de dados oferecido representa a totalidade da popula\u00e7\u00e3o em quest\u00e3o, ao contr\u00e1rio das fun\u00e7\u00f5es DESVPAD<\/strong> (ou STDEV<\/strong> no Excel), que s\u00e3o usadas para calcular o desvio padr\u00e3o de uma amostra representativa dessa popula\u00e7\u00e3o.<\/p>\n

Entendendo a Sintaxe da Fun\u00e7\u00e3o<\/h2>\n

A sintaxe para as fun\u00e7\u00f5es DESVPADP<\/strong> no Excel e STDEVP<\/strong> no Google Sheets \u00e9 a seguinte:<\/p>\n

 DESVPADP(valor1, [valor2], ...) STDEVP(valor1, [valor2], ...) <\/code> <\/pre>\n
    \n
  • valor1, valor2, …<\/strong>: S\u00e3o argumentos num\u00e9ricos ou intervalos de c\u00e9lulas contendo n\u00fameros. No Excel, voc\u00ea pode incluir at\u00e9 255 argumentos, enquanto no Google Sheets n\u00e3o h\u00e1 um limite estabelecido para a quantidade de dados. <\/li>\n<\/ul>\n
    Exemplos de Utiliza\u00e7\u00e3o da Fun\u00e7\u00e3o<\/h2>\n\n\n\n\n
    Exemplo<\/th>\nF\u00f3rmula<\/th>\nResultado<\/th>\n<\/tr>\n
    Calculando o desvio padr\u00e3o dos n\u00fameros 4, 7, 2, 5<\/td>\nDESVPADP(4, 7, 2, 5)<\/code>
    STDEVP(4, 7, 2, 5)<\/code><\/td>\n    		1,825741858<\/td>\n<\/tr>\n
    Desvio padr\u00e3o de uma coluna de valores<\/td>\nDESVPADP(A1:A10)<\/code>
    STDEVP(A1:A10)<\/code><\/td>\n    		Resultado varia conforme os valores em A1:A10<\/td>\n<\/tr>\n<\/table>\n
    Aplica\u00e7\u00e3o Pr\u00e1tica em An\u00e1lise de Dados<\/h2>\n
    1. Gerenciamento de Qualidade:<\/strong><\/p>\n
    Suponha que voc\u00ea \u00e9 respons\u00e1vel pelo controle de qualidade em uma ind\u00fastria. Todos os produtos finais de determinado dia s\u00e3o medidos para assegurar conformidade com os padr\u00f5es. Os valores medidos foram:<\/p>\n
      \n
    • 10.4, 10.5, 10.4, 10.3, 10.5, 10.4, 10.6, 10.3, 10.5, 10.5<\/li>\n<\/ul>\n
      Para calcular o desvio padr\u00e3o desses valores, utilize a f\u00f3rmula:<\/p>\n
      =DESVPADP(10.4, 10.5, 10.4, 10.3, 10.5, 10.4, 10.6, 10.3, 10.5, 10.5) ou =STDEVP(10.4, 10.5, 10.4, 10.3, 10.5, 10.4, 10.6, 10.3, 10.5, 10.5) <\/code><\/pre>\n
      O resultado indicar\u00e1 o desvio padr\u00e3o, refletindo a consist\u00eancia dos produtos fabricados.<\/p>\n
      2. An\u00e1lise Financeira:<\/strong><\/p>\n
      Considere a tarefa de avaliar a volatilidade dos retornos di\u00e1rios de um ativo financeiro. Digamos que os retornos dos \u00faltimos cinco dias foram:<\/p>\n
        \n
      • 0.95%, 1.20%, 1.10%, 1.15%, 0.98%<\/li>\n<\/ul>\n
        Utilize a seguinte f\u00f3rmula para calcular o desvio padr\u00e3o desses retornos:<\/p>\n
        =DESVPADP(0.95, 1.20, 1.10, 1.15, 0.98) ou =STDEVP(0.95, 1.20, 1.10, 1.15, 0.98) <\/code><\/pre>\n
        Um desvio padr\u00e3o mais elevado indica maior volatilidade, fornecendo dados essenciais para gestores de ativos ou investidores na tomada de decis\u00f5es.<\/p>\n
        Os exemplos apresentados demonstram como a fun\u00e7\u00e3o de desvio padr\u00e3o de uma popula\u00e7\u00e3o completa \u00e9 uma ferramenta valiosa em diversas situa\u00e7\u00f5es pr\u00e1ticas para fundamentar an\u00e1lises e decis\u00f5es baseadas em dados.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Calcula o desvio-padr\u00e3o com base na popula\u00e7\u00e3o total<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[444],"tags":[],"class_list":["post-11130","post","type-post","status-publish","format-standard","hentry","category-compatibilidade"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o STDEVP (DESVPADP) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o STDEVP (DESVPADP) 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\/stdevp\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o STDEVP (DESVPADP) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o STDEVP (DESVPADP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/\" \/>\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:53+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 STDEVP (DESVPADP) 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\/stdevp\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/\",\"name\":\"Fun\u00e7\u00e3o STDEVP (DESVPADP) 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:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o STDEVP (DESVPADP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilidade\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/compatibilidade\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DESVPADP\"}]},{\"@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 STDEVP (DESVPADP) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o STDEVP (DESVPADP) 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\/stdevp\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o STDEVP (DESVPADP) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o STDEVP (DESVPADP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:29:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o STDEVP (DESVPADP) 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\/stdevp\/","url":"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/","name":"Fun\u00e7\u00e3o STDEVP (DESVPADP) 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:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o STDEVP (DESVPADP) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/stdevp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/stdevp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Compatibilidade","item":"https:\/\/functiontranslator.com\/pt-pt\/compatibilidade\/"},{"@type":"ListItem","position":3,"name":"DESVPADP"}]},{"@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\/11130","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=11130"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11130\/revisions"}],"predecessor-version":[{"id":25959,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11130\/revisions\/25959"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}