{"id":10868,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/funcerro\/"},"modified":"2021-02-25T17:18:35","modified_gmt":"2021-02-25T17:18:35","slug":"erf","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/erf\/","title":{"rendered":"FUNCERRO"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o de Erro<\/h2>\n

A fun\u00e7\u00e3o ERF, chamada de FUNCERRO em portugu\u00eas, \u00e9 empregada para calcular o erro integral de fun\u00e7\u00e3o dentro de limites especificados. Essencial em estat\u00edsticas e probabilidade, a FUNCERRO \u00e9 \u00fatil para analisar vari\u00e1veis que obedecem a uma distribui\u00e7\u00e3o normal, sendo frequentemente usada em \u00e1reas como f\u00edsica, engenharia e pesquisa operacional.<\/p>\n

Sintaxe e Exemplos de Uso<\/h2>\n

A sintaxe da fun\u00e7\u00e3o FUNCERRO no Excel e no Google Planilhas \u00e9:<\/p>\n

=FUNCERRO(limite_inferior, limite_superior)<\/code><\/pre>\n
Onde:<\/p>\n
    \n
  • limite_inferior<\/strong> corresponde ao limite inferior na integral da fun\u00e7\u00e3o de erro.<\/li>\n
  • limite_superior<\/strong> (opcional) \u2013 Caso n\u00e3o seja fornecido, assume-se automaticamente zero para este par\u00e2metro.<\/li>\n<\/ul>\n
    Exemplo:<\/p>\n
    =FUNCERRO(0, 1)<\/code><\/pre>\n
    Este comando calcula o erro integral da fun\u00e7\u00e3o de distribui\u00e7\u00e3o normal padr\u00e3o de 0 a 1.<\/p>\n
    Aplica\u00e7\u00f5es pr\u00e1ticas da fun\u00e7\u00e3o<\/h2>\n
    Exemplo 1: An\u00e1lise de Desempenho de Alunos<\/h2>\n
    Suponha uma escola que quer investigar a distribui\u00e7\u00e3o do desempenho dos estudantes em um teste nacional, onde se presume que estes desempenhos seguem uma distribui\u00e7\u00e3o normal. A institui\u00e7\u00e3o quer determinar a porcentagem de alunos que alcan\u00e7am um desempenho acima de um certo valor \u2018X\u2019 at\u00e9 um m\u00e1ximo ‘Y’.<\/p>\n
    Solu\u00e7\u00e3o:<\/p>\n
    =1 - FUNCERRO(X, Y)<\/code><\/pre>\n
    Aqui, a FUNCERRO \u00e9 usada para calcular a \u00e1rea sob a curva de distribui\u00e7\u00e3o normal do valor \u2018X\u2019 ao \u2018Y\u2019. Subtraindo esse resultado de 1, obt\u00e9m-se a propor\u00e7\u00e3o de estudantes com desempenho superior a \u2018X\u2019.<\/p>\n
    Exemplo 2: Aplica\u00e7\u00f5es em Engenharia<\/h2>\n
    Engenheiros recorrem \u00e0 fun\u00e7\u00e3o de erro para avaliar probabilidades de falhas em componentes durante opera\u00e7\u00f5es normais, dadas as pequenas varia\u00e7\u00f5es inerentes ao processo de fabrica\u00e7\u00e3o, que resultam em uma distribui\u00e7\u00e3o normal.<\/p>\n
    Solu\u00e7\u00e3o:<\/p>\n
    =FUNCERRO(limite_inferior_da_falha, limite_superior_da_falha)<\/code><\/pre>\n
    Esta aplica\u00e7\u00e3o da fun\u00e7\u00e3o FUNCERRO permite calcular a probabilidade de falha dos componentes dentro dos limites de toler\u00e2ncia estabelecidos, determinando a \u00e1rea sob a curva de distribui\u00e7\u00e3o normal entre esses pontos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve a fun\u00e7\u00e3o de erro<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[],"class_list":["post-10868","post","type-post","status-publish","format-standard","hentry","category-engenharia"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o ERF (FUNCERRO) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ERF (FUNCERRO) 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\/erf\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o ERF (FUNCERRO) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ERF (FUNCERRO) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/erf\/\" \/>\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:18:35+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 ERF (FUNCERRO) 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\/erf\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/erf\/\",\"name\":\"Fun\u00e7\u00e3o ERF (FUNCERRO) 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:18:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ERF (FUNCERRO) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/erf\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/erf\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/erf\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Engenharia\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/engenharia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"FUNCERRO\"}]},{\"@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 ERF (FUNCERRO) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ERF (FUNCERRO) 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\/erf\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o ERF (FUNCERRO) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ERF (FUNCERRO) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/erf\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:18:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o ERF (FUNCERRO) 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\/erf\/","url":"https:\/\/functiontranslator.com\/pt-pt\/erf\/","name":"Fun\u00e7\u00e3o ERF (FUNCERRO) 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:18:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o ERF (FUNCERRO) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/erf\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/erf\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/erf\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Engenharia","item":"https:\/\/functiontranslator.com\/pt-pt\/engenharia\/"},{"@type":"ListItem","position":3,"name":"FUNCERRO"}]},{"@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\/10868","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=10868"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10868\/revisions"}],"predecessor-version":[{"id":25697,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10868\/revisions\/25697"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}