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

La funci\u00f3n PRONOSTICO.ETS.ESTACIONALIDAD<\/strong> en Microsoft Excel y en Google Sheets es una herramienta avanzada dise\u00f1ada para identificar patrones c\u00edclicos en series de datos hist\u00f3ricos, siendo particularmente \u00fatil en el an\u00e1lisis de series temporales donde los patrones se repiten a intervalos regulares.<\/p>\n

Sintaxis y Ejemplos de Uso<\/h2>\n

La sintaxis de la funci\u00f3n se expresa de la siguiente manera:<\/p>\n

PRONOSTICO.ETS.ESTACIONALIDAD(valores_y, valores_x)<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • valores_y<\/strong>: Representa el rango de datos que contiene los valores hist\u00f3ricos.<\/li>\n
  • valores_x<\/strong>: Corresponde al rango de la l\u00ednea de tiempo asociada a valores_y<\/em>. Estos valores deben ser consistentes y estar en orden cronol\u00f3gico, frecuentemente fechas o per\u00edodos temporales.<\/li>\n<\/ul>\n
    A continuaci\u00f3n, se muestra un ejemplo pr\u00e1ctico de c\u00f3mo aplicar la funci\u00f3n:<\/p>\n
    =PRONOSTICO.ETS.ESTACIONALIDAD(B2:B25, A2:A25)<\/code><\/pre>\n
    En este caso, A2:A25<\/em> son las fechas o periodos (como meses o a\u00f1os), y B2:B25<\/em> son las cifras de ventas correspondientes. La funci\u00f3n eval\u00faa la estacionalidad de las ventas en el rango especificado.<\/p>\n
    Escenarios Pr\u00e1cticos de Aplicaci\u00f3n<\/h2>\n
    A continuaci\u00f3n, se describen dos escenarios donde la funci\u00f3n PRONOSTICO.ETS.ESTACIONALIDAD<\/strong> resulta sumamente valiosa:<\/p>\n
    An\u00e1lisis de Ventas Estacionales<\/h2>\n
    Consideremos una empresa que desea analizar el comportamiento estacional de sus ventas para optimizar la gesti\u00f3n de su inventario y sus promociones. La empresa cuenta con datos de ventas mensuales de los dos \u00faltimos a\u00f1os:<\/p>\n\n\n\n\n\n\n\n
    Mes<\/th>\nVentas<\/th>\n<\/tr>\n<\/thead>\n
    Enero 2022<\/td>\n150<\/td>\n<\/tr>\n
    Febrero 2022<\/td>\n180<\/td>\n<\/tr>\n
      <\/p>\n
    Diciembre 2023<\/td>\n220<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    =PRONOSTICO.ETS.ESTACIONALIDAD(B2:B25, A2:A25)<\/code><\/pre>\n
    Utilizando esta f\u00f3rmula, la empresa puede identificar patrones estacionales claros en sus ventas y determinar cu\u00e1les meses podr\u00edan ver aumentos o descensos.<\/p>\n
    Estimaci\u00f3n de Uso de Recursos<\/h2>\n
    Una empresa de servicios p\u00fablicos necesita prever el consumo de recursos energ\u00e9ticos, que fluct\u00faa durante el a\u00f1o seg\u00fan la temporada. Supongamos que dispone de registros del consumo mensual de energ\u00eda de los \u00faltimos cinco a\u00f1os:<\/p>\n
    =PRONOSTICO.ETS.ESTACIONALIDAD(C2:C60, B2:B60)<\/code><\/pre>\n
    Mediante esta funci\u00f3n, la empresa puede identificar per\u00edodos de alta demanda y adaptar su suministro y estrategias operativas de manera efectiva.<\/p>\n
    En resumen, PRONOSTICO.ETS.ESTACIONALIDAD<\/strong> es una herramienta indispensable para cualquier profesional que trabaje con series temporales, permitiendo una comprensi\u00f3n profunda de los patrones c\u00edclicos en sus datos y facilitando decisiones estrat\u00e9gicas basadas en comportamientos hist\u00f3ricos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la longitud del patr\u00f3n repetitivo que Excel detecta para la serie temporal especificada<\/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-13978","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) 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-ets-seasonality\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/\" \/>\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:36+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.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) 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-ets-seasonality\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/\",\"name\":\"Funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) 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:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/#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.ETS.ESTACIONALIDAD\"}]},{\"@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.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) 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-ets-seasonality\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) 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-ets-seasonality\/","url":"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/","name":"Funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) 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:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n FORECAST.ETS.SEASONALITY (PRONOSTICO.ETS.ESTACIONALIDAD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/forecast-ets-seasonality\/#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.ETS.ESTACIONALIDAD"}]},{"@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\/13978","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=13978"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13978\/revisions"}],"predecessor-version":[{"id":30037,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13978\/revisions\/30037"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}