{"id":13975,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/pronostico\/"},"modified":"2021-02-26T08:48:19","modified_gmt":"2021-02-26T08:48:19","slug":"forecast","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/forecast\/","title":{"rendered":"PRONOSTICO"},"content":{"rendered":"

Introducci\u00f3n a la funci\u00f3n PRONOSTICO<\/h2>\n

La funci\u00f3n PRONOSTICO en Excel y Google Sheets es \u00fatil para predecir un valor futuro bas\u00e1ndose en datos hist\u00f3ricos mediante la regresi\u00f3n lineal. Esta herramienta es extremadamente valiosa en \u00e1mbitos como el an\u00e1lisis financiero, la investigaci\u00f3n de mercado, y otros campos que requieren de predicciones fundamentadas en patrones existentes.<\/p>\n

Sintaxis y par\u00e1metros<\/h2>\n

La sintaxis de la funci\u00f3n PRONOSTICO es la siguiente:<\/p>\n

PRONOSTICO(x, datos_y, datos_x)<\/code><\/pre>\n
    \n
  • x<\/strong>: El valor en el que deseamos predecir un resultado.<\/li>\n
  • datos_y<\/strong>: Conjunto de datos dependientes, es decir, las variables que ya se conocen.<\/li>\n
  • datos_x<\/strong>: Conjunto de datos independientes, que sirven para predecir los valores de y.<\/li>\n<\/ul>\n
    Ejemplo de uso b\u00e1sico en una hoja de c\u00e1lculo:<\/p>\n
    =PRONOSTICO(B10, B2:B9, A2:A9)<\/code><\/pre>\n
    En este ejemplo, se usa la funci\u00f3n PRONOSTICO para predecir un valor para el punto B10<\/strong>, utilizando como referencia los pares de datos almacenados en los rangos A2:A9<\/strong> y B2:B9<\/strong>.<\/p>\n
    Aplicaciones pr\u00e1cticas de la funci\u00f3n<\/h2>\n
    Estimaci\u00f3n de ventas futuras<\/h2>\n
    Supongamos que eres un analista de ventas y necesitas estimar las ventas para el pr\u00f3ximo trimestre bas\u00e1ndote en los datos de ventas de trimestres anteriores.<\/p>\n\n\n\n\n\n\n
    Trimestre<\/th>\nVentas<\/th>\n<\/tr>\n
    1<\/td>\n12000<\/td>\n<\/tr>\n
    2<\/td>\n15000<\/td>\n<\/tr>\n
    3<\/td>\n18000<\/td>\n<\/tr>\n
    4<\/td>\n16000<\/td>\n<\/tr>\n<\/table>\n
    Utilizar\u00edamos la funci\u00f3n PRONOSTICO para prever las ventas del quinto trimestre de la siguiente manera:<\/p>\n
    =PRONOSTICO(5, B2:B5, A2:A5)<\/code><\/pre>\n
    En este caso, el n\u00famero de trimestre (5) se utiliza como x<\/strong>, mientras que los rangos A2:A5 y B2:B5 sirven como los conjuntos de datos hist\u00f3ricos de ventas. El resultado ser\u00eda una predicci\u00f3n de ventas, bas\u00e1ndose en la tendencia lineal observada en trimestres previos.<\/p>\n
    Prever calificaciones en un curso<\/h2>\n
    Imagine un profesor que desea predecir la calificaci\u00f3n final de un estudiante bas\u00e1ndose en sus calificaciones parciales.<\/p>\n\n\n\n\n\n\n
    Calificaci\u00f3n Parcial<\/th>\nCalificaci\u00f3n Final<\/th>\n<\/tr>\n
    70<\/td>\n75<\/td>\n<\/tr>\n
    80<\/td>\n83<\/td>\n<\/tr>\n
    90<\/td>\n92<\/td>\n<\/tr>\n
    85<\/td>\n88<\/td>\n<\/tr>\n<\/table>\n
    El profesor puede utilizar la funci\u00f3n PRONOSTICO para estimar la calificaci\u00f3n final de un estudiante que obtuvo 82 en su examen parcial de la siguiente forma:<\/p>\n
    =PRONOSTICO(82, B2:B5, A2:A5)<\/code><\/pre>\n
    Aqu\u00ed, el valor 82<\/strong> representa la calificaci\u00f3n parcial del estudiante, y se usa junto con los datos hist\u00f3ricos de las calificaciones contenidos en los rangos A2:A5 y B2:B5. El resultado esperado proporcionar\u00eda una calificaci\u00f3n final predicha basada en tendencias anteriores.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve un valor en una tendencia lineal<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-13975","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FORECAST (PRONOSTICO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/forecast\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FORECAST (PRONOSTICO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/forecast\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:48:19+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\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\/es\/forecast\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/forecast\/\",\"name\":\"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:48:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n FORECAST (PRONOSTICO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/forecast\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/forecast\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/forecast\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PRONOSTICO\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n FORECAST (PRONOSTICO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/forecast\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n FORECAST (PRONOSTICO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/forecast\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/forecast\/","url":"https:\/\/functiontranslator.com\/es\/forecast\/","name":"Funci\u00f3n FORECAST (PRONOSTICO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:48:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n FORECAST (PRONOSTICO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/forecast\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/forecast\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/forecast\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"PRONOSTICO"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13975"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13975\/revisions"}],"predecessor-version":[{"id":30034,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13975\/revisions\/30034"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}