{"id":10990,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/proj-lin\/"},"modified":"2021-02-25T17:23:31","modified_gmt":"2021-02-25T17:23:31","slug":"linest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/linest\/","title":{"rendered":"PROJ.LIN"},"content":{"rendered":"

A fun\u00e7\u00e3o PROJ.LIN (LINEST em ingl\u00eas) \u00e9 uma ferramenta essencial tanto no Excel quanto no Google Planilhas, utilizada para realizar regress\u00f5es lineares entre conjuntos de dados. Esta fun\u00e7\u00e3o calcula os coeficientes de uma linha reta que melhor se ajusta aos dados fornecidos atrav\u00e9s do m\u00e9todo dos m\u00ednimos quadrados. A seguir, apresentaremos detalhes sobre como utilizar essa fun\u00e7\u00e3o, abordando sua sintaxe e fornecendo exemplos pr\u00e1ticos.<\/p>\n

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

A sintaxe b\u00e1sica da fun\u00e7\u00e3o PROJ.LIN \u00e9:<\/p>\n

=PROJ.LIN(y; x; constante; estat\u00edsticas)<\/code><\/pre>\n
    \n
  • y:<\/strong> Refere-se ao intervalo de c\u00e9lulas que cont\u00e9m a vari\u00e1vel dependente.<\/li>\n
  • x:<\/strong> Refere-se ao intervalo de c\u00e9lulas que cont\u00e9m a(s) vari\u00e1vel(eis) independente(s).<\/li>\n
  • constante:<\/strong> Um valor l\u00f3gico que indica se a constante b (intercepto) deve ser zero. Se verdadeiro (ou omitido), b n\u00e3o \u00e9 zero. Se falso, b \u00e9 configurado como zero.<\/li>\n
  • estat\u00edsticas:<\/strong> Um valor l\u00f3gico que, se verdadeiro, retorna estat\u00edsticas adicionais al\u00e9m dos coeficientes da regress\u00e3o.<\/li>\n<\/ul>\n
    Exemplo de Aplica\u00e7\u00e3o<\/h2>\n
    Considere um conjunto de dados que cont\u00e9m as horas de estudo de alguns alunos (x) e suas respectivas notas (y). Nosso objetivo \u00e9 utilizar a fun\u00e7\u00e3o PROJ.LIN para prever as notas com base nas horas de estudo.<\/p>\n\n\n\n\n\n\n\n
    Horas de Estudo (x)<\/th>\nNota (y)<\/th>\n<\/tr>\n
    5<\/td>\n70<\/td>\n<\/tr>\n
    6<\/td>\n76<\/td>\n<\/tr>\n
    7<\/td>\n78<\/td>\n<\/tr>\n
    8<\/td>\n85<\/td>\n<\/tr>\n
    9<\/td>\n90<\/td>\n<\/tr>\n<\/table>\n
    =PROJ.LIN(B2:B6; A2:A6; VERDADEIRO; FALSO)<\/code><\/pre>\n
    O resultado da fun\u00e7\u00e3o \u00e9 um array com dois elementos: o coeficiente angular (a inclina\u00e7\u00e3o) e o intercepto y (o ponto onde a linha cruza o eixo y). Com estes valores, podemos elaborar a equa\u00e7\u00e3o da linha de melhor ajuste.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Estimativa de Vendas:<\/strong> Suponha que voc\u00ea \u00e9 analista de vendas e deseja projetar vendas futuras com base nos gastos com publicidade. Utilizando a fun\u00e7\u00e3o PROJ.LIN, voc\u00ea pode inserir os dados de gastos hist\u00f3ricos e vendas para criar uma linha de tend\u00eancia que auxiliar\u00e1 na previs\u00e3o de vendas futuras.<\/p>\n
    An\u00e1lise de Tend\u00eancias Econ\u00f4micas:<\/strong> Economistas podem usar a PROJ.LIN para explorar a rela\u00e7\u00e3o entre vari\u00e1veis econ\u00f4micas, como PIB e taxa de desemprego, ajudando a compreender como uma vari\u00e1vel influencia outra.<\/p>\n
    Resumo<\/h2>\n
    A fun\u00e7\u00e3o PROJ.LIN \u00e9 extremamente valiosa para a an\u00e1lise e previs\u00e3o de dados lineares, permitindo aos usu\u00e1rios descobrir padr\u00f5es entre vari\u00e1veis e fazer proje\u00e7\u00f5es confi\u00e1veis baseadas em informa\u00e7\u00f5es hist\u00f3ricas. Sua utilidade se estende por diversos campos, incluindo economia e educa\u00e7\u00e3o.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve os par\u00e2metros de uma tend\u00eancia linear<\/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-10990","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o LINEST (PROJ.LIN) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LINEST (PROJ.LIN) 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\/linest\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o LINEST (PROJ.LIN) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LINEST (PROJ.LIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/linest\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:23:31+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 LINEST (PROJ.LIN) 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\/linest\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/linest\/\",\"name\":\"Fun\u00e7\u00e3o LINEST (PROJ.LIN) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:23:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LINEST (PROJ.LIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/linest\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/linest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/linest\/#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\":\"PROJ.LIN\"}]},{\"@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 LINEST (PROJ.LIN) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LINEST (PROJ.LIN) 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\/linest\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o LINEST (PROJ.LIN) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LINEST (PROJ.LIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/linest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:23:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o LINEST (PROJ.LIN) 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\/linest\/","url":"https:\/\/functiontranslator.com\/pt-pt\/linest\/","name":"Fun\u00e7\u00e3o LINEST (PROJ.LIN) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:23:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o LINEST (PROJ.LIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/linest\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/linest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/linest\/#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":"PROJ.LIN"}]},{"@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\/10990","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=10990"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10990\/revisions"}],"predecessor-version":[{"id":25819,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10990\/revisions\/25819"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}