{"id":13583,"date":"2023-05-25T15:30:45","date_gmt":"2023-05-25T15:30:45","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13583"},"modified":"2023-05-27T10:44:59","modified_gmt":"2023-05-27T10:44:59","slug":"la-funcion-pronostico-ets","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/","title":{"rendered":"LA FUNCI\u00d3N PRONOSTICO.ETS"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #0a6e42;\"><strong><u>DOMINA EL ARTE DE LA PREDICCI\u00d3N CON LA FUNCI\u00d3N PRONOSTICO.ETS: \u00a1TU AS BAJO LA MANGA EN EXCEL!<\/u><\/strong><\/span><\/p><div id=\"excel-4096068656\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>En el fascinante mundo de Excel, hay una gran variedad de funciones que pueden facilitar nuestro trabajo y ayudarnos a tomar decisiones informadas. Una de estas funciones es <strong>PRONOSTICO.ETS<\/strong>, una herramienta poderosa para realizar pron\u00f3sticos basados en datos hist\u00f3ricos. En este blog, exploraremos en qu\u00e9 consiste esta funci\u00f3n, para qu\u00e9 sirve y c\u00f3mo utilizarla para obtener predicciones precisas. \u00a1Prep\u00e1rate para dar un paso adelante en tus an\u00e1lisis y tomar decisiones m\u00e1s inteligentes!<\/p>\n<h6>\u00bfQU\u00c9 ES LA FUNCI\u00d3N PRONOSTICO.ETS?<\/h6>\n<p>La funci\u00f3n PRONOSTICO.ETS es una funci\u00f3n estad\u00edstica y es parte de las funciones de <a href=\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\" target=\"_blank\" rel=\"noopener\"><strong>pron\u00f3stico<\/strong><\/a> de Excel y se basa en el m\u00e9todo de suavizado exponencial triple (ETS, por sus siglas en ingl\u00e9s). Esta funci\u00f3n utiliza datos hist\u00f3ricos para generar una proyecci\u00f3n futura.<\/p>\n<h6>\u00bfPARA QU\u00c9 SIRVE?<\/h6>\n<p>Su principal objetivo es predecir valores en series de tiempo, teniendo en cuenta las tendencias y patrones presentes en los datos.\u00a0Es especialmente \u00fatil cuando se trata de pronosticar valores en series de tiempo, como ventas mensuales, ingresos trimestrales o cualquier otro tipo de datos secuenciales.<\/p>\n<p><strong>Algunos de los usos comunes de la funci\u00f3n PRONOSTICO.ETS incluyen:<\/strong><\/p>\n<ul>\n<li><strong>Pron\u00f3stico de ventas:<\/strong> Puedes utilizar esta funci\u00f3n para estimar las ventas futuras de tu negocio en funci\u00f3n de los datos hist\u00f3ricos de ventas. Esto te ayudar\u00e1 a planificar la producci\u00f3n, el inventario y las estrategias de marketing.<\/li>\n<li><strong>Previsi\u00f3n financiera:<\/strong> Si est\u00e1s realizando an\u00e1lisis financiero o proyecciones de ingresos y gastos, la funci\u00f3n PRONOSTICO.ETS puede ayudarte a pronosticar los valores futuros y evaluar el desempe\u00f1o financiero esperado.<\/li>\n<li><strong>Planificaci\u00f3n de recursos:<\/strong> Si necesitas anticipar la demanda de recursos, como personal, materiales o capacidad de producci\u00f3n, la funci\u00f3n PRONOSTICO.ETS te permitir\u00e1 realizar estimaciones futuras para una mejor planificaci\u00f3n y asignaci\u00f3n de recursos.<\/li>\n<li><strong>An\u00e1lisis de tendencias:<\/strong> La funci\u00f3n PRONOSTICO.ETS puede ayudarte a identificar y evaluar tendencias en tus datos hist\u00f3ricos. Esto es especialmente \u00fatil en campos como el an\u00e1lisis de mercado, donde puedes pronosticar el comportamiento de los consumidores y la demanda en el futuro.<\/li>\n<\/ul>\n<h6 style=\"text-align: center;\">SINTAXIS DE LA FUNCI\u00d3N PRONOSTICO.ETS<\/h6>\n<pre><strong>=PRONOSTICO.ETS(fecha_objetivo; valores; escala de tiempo;[estacionalidad];[finalizaci\u00f3n_datos];[agregaci\u00f3n])<\/strong><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13584\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/pronostico.ets_.png\" alt=\"\" width=\"584\" height=\"329\" \/><\/p>\n<ul>\n<li><strong>Fecha_objetivo (obligatorio):<\/strong> Es el punto de datos para el que Microsoft Excel predice un valor. Se debe llevar a cabo en el patr\u00f3n de valores de la escala de tiempo.<\/li>\n<li><strong>Valores (obligatorio):<\/strong> Es la matriz o el rango de datos num\u00e9ricos que est\u00e1 prediciendo.<\/li>\n<li><strong>Escaladetiempo (obligatorio):<\/strong> Es la matriz o el rango de datos num\u00e9ricos independiente. Las fechas de la escala de tiempo debe tener un paso coherente entre ellas, que no puede ser cero.<\/li>\n<li><strong>Estacionalidad (opcional):<\/strong> Es un valor num\u00e9rico opcional que indica la longitud del patr\u00f3n estacional. El valor predeterminado de 1 indica que la estacionalidad se detecta autom\u00e1ticamente.<\/li>\n<li><strong>Finalizacion_datos (opcional):<\/strong> Es un valor opcional para el tratamiento de valores que faltan. El valor predeterminado de 1 reemplaza valores que faltan por interpolaci\u00f3n y 0 los reemplaza con ceros.<\/li>\n<li><strong>Agregacion (opcional):<\/strong> Es un valor num\u00e9rico opcional para agregar varios valores con la misma marca de tiempo. Si est\u00e1 en blanco, Microsoft Excel calcula la media de los valores.<\/li>\n<\/ul>\n<h6>C\u00d3MO UTILIZAR LA FUNCI\u00d3N PRONOSTICO.ETS<\/h6>\n<p>Para utilizar la funci\u00f3n PRONOSTICO.ETS, simplemente debes tener una columna con tus datos hist\u00f3ricos en Excel. Aseg\u00farate de que los datos est\u00e9n organizados en orden cronol\u00f3gico para obtener resultados precisos. Una vez que tengas tus datos listos, sigue estos pasos:<\/p>\n<p><strong>1.<\/strong> Selecciona una celda donde deseas que aparezca el resultado de tu pron\u00f3stico.<\/p>\n<p><strong>2.<\/strong> Escribe <strong>=PRONOSTICO.ETS( <\/strong>y Excel te mostrar\u00e1 la sintaxis completa de la funci\u00f3n.<\/p>\n<p><strong>3.<\/strong> Dentro de los par\u00e9ntesis, especifica el rango de tus datos hist\u00f3ricos. Por ejemplo, si tus datos est\u00e1n en las celdas A1 a A10, debes escribir \u00abA1:A10\u00bb.<\/p>\n<p><strong>4.<\/strong> A continuaci\u00f3n, puedes agregar un par\u00e1metro opcional llamado \u00abestacionalidad\u00bb para indicar cu\u00e1ntos puntos en el futuro deseas pronosticar. Por defecto, Excel pronosticar\u00e1 un \u00fanico punto.<\/p>\n<p><strong>5.<\/strong> Presiona <em>Enter<\/em> y Excel calcular\u00e1 autom\u00e1ticamente el pron\u00f3stico basado en tus datos.<\/p>\n<p>Es importante destacar que la funci\u00f3n PRONOSTICO.ETS puede ajustar su pron\u00f3stico a diferentes tipos de tendencias y patrones presentes en los datos hist\u00f3ricos. Puede reconocer y adaptarse a tendencias lineales, exponenciales y estacionales, lo que le permite generar pron\u00f3sticos m\u00e1s precisos y realistas.<\/p>\n<p>Una vez que obtengas el pron\u00f3stico, es posible utilizarlo para tomar decisiones informadas y estrat\u00e9gicas. Puedes utilizarlo para estimar ventas futuras, planificar el inventario, evaluar la demanda de productos o cualquier otro escenario en el que se requiera anticipar valores futuros.<\/p>\n<h6>EJEMPLO DE LA FUNCI\u00d3N PRON\u00d3STICO.ETS<\/h6>\n<p><iframe loading=\"lazy\" title=\"20- La nueva funci&amp;oacute;n PRONOSTICO.ETS de Excel 2016\" src=\"https:\/\/player.vimeo.com\/video\/417785128?h=f608e79052&amp;dnt=1&amp;app_id=122963\" width=\"960\" height=\"540\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<h6>CONCLUSI\u00d3N<\/h6>\n<p>La funci\u00f3n <strong>PRONOSTICO.ETS<\/strong> de Excel es una herramienta valiosa para predecir valores futuros en series de tiempo. Con su capacidad de reconocer y adaptarse a diferentes patrones, te permite obtener pron\u00f3sticos precisos y confiables. Solo necesitas tus datos hist\u00f3ricos y unos pocos pasos simples para comenzar a aprovechar esta poderosa funci\u00f3n.<\/p>\n<p>\u00a1No te limites a mirar hacia atr\u00e1s en tus datos! Ya sea que est\u00e9s estimando ventas, evaluando la demanda o planificando el futuro, esta funci\u00f3n te proporciona una visi\u00f3n clara y confiable de lo que est\u00e1 por venir.<\/p>\n<hr \/>\n<p><strong><span style=\"color: #0a6e42;\">\u00bb<\/span> <\/strong>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p><strong><span style=\"color: #0a6e42;\">\u00bb<\/span><\/strong> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p><strong><span style=\"color: #0a6e42;\">\u00bb<\/span> <\/strong>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; DOMINA EL ARTE DE &#8230; <a title=\"LA FUNCI\u00d3N PRONOSTICO.ETS\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N PRONOSTICO.ETS\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13594,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[565,328,549],"tags":[675,575,676,677],"class_list":["post-13583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-estadisticas","category-excel","category-excel-intermedio","tag-estadisticas","tag-funciones","tag-pronostico","tag-tendencia","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LA FUNCI\u00d3N PRONOSTICO.ETS - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n PRONOSTICO.ETS utiliza datos hist\u00f3ricos teniendo en cuenta tendencias y patrones para generar una proyecci\u00f3n futura.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LA FUNCI\u00d3N PRONOSTICO.ETS - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n PRONOSTICO.ETS utiliza datos hist\u00f3ricos teniendo en cuenta tendencias y patrones para generar una proyecci\u00f3n futura.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-25T15:30:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-27T10:44:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N PRONOSTICO.ETS\",\"datePublished\":\"2023-05-25T15:30:45+00:00\",\"dateModified\":\"2023-05-27T10:44:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\"},\"wordCount\":964,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png\",\"keywords\":[\"estadisticas\",\"funciones\",\"pronostico\",\"tendencia\"],\"articleSection\":[\"Estad\u00edsticas\",\"Excel\",\"Excel Intermedio\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\",\"name\":\"LA FUNCI\u00d3N PRONOSTICO.ETS - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png\",\"datePublished\":\"2023-05-25T15:30:45+00:00\",\"dateModified\":\"2023-05-27T10:44:59+00:00\",\"description\":\"La funci\u00f3n PRONOSTICO.ETS utiliza datos hist\u00f3ricos teniendo en cuenta tendencias y patrones para generar una proyecci\u00f3n futura.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png\",\"width\":1280,\"height\":720,\"caption\":\"LA FUNCI\u00d3N PRONOSTICO.ETS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LA FUNCI\u00d3N PRONOSTICO.ETS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LA FUNCI\u00d3N PRONOSTICO.ETS - EXCELFULL.COM","description":"La funci\u00f3n PRONOSTICO.ETS utiliza datos hist\u00f3ricos teniendo en cuenta tendencias y patrones para generar una proyecci\u00f3n futura.","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:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N PRONOSTICO.ETS - EXCELFULL.COM","og_description":"La funci\u00f3n PRONOSTICO.ETS utiliza datos hist\u00f3ricos teniendo en cuenta tendencias y patrones para generar una proyecci\u00f3n futura.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-05-25T15:30:45+00:00","article_modified_time":"2023-05-27T10:44:59+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N PRONOSTICO.ETS","datePublished":"2023-05-25T15:30:45+00:00","dateModified":"2023-05-27T10:44:59+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/"},"wordCount":964,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png","keywords":["estadisticas","funciones","pronostico","tendencia"],"articleSection":["Estad\u00edsticas","Excel","Excel Intermedio"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/","name":"LA FUNCI\u00d3N PRONOSTICO.ETS - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png","datePublished":"2023-05-25T15:30:45+00:00","dateModified":"2023-05-27T10:44:59+00:00","description":"La funci\u00f3n PRONOSTICO.ETS utiliza datos hist\u00f3ricos teniendo en cuenta tendencias y patrones para generar una proyecci\u00f3n futura.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-PRONOSTICO.ETS_.png","width":1280,"height":720,"caption":"LA FUNCI\u00d3N PRONOSTICO.ETS"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-pronostico-ets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LA FUNCI\u00d3N PRONOSTICO.ETS"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=13583"}],"version-history":[{"count":11,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13583\/revisions"}],"predecessor-version":[{"id":13605,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13583\/revisions\/13605"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13594"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}