{"id":13541,"date":"2023-05-22T10:53:03","date_gmt":"2023-05-22T10:53:03","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13541"},"modified":"2023-05-25T18:01:05","modified_gmt":"2023-05-25T18:01:05","slug":"las-funciones-pronostico-y-tendencia","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/","title":{"rendered":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong>POTENCIA TUS AN\u00c1LISIS CON EXCEL: DESCUBRIENDO LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA<\/strong><\/span><\/p><div id=\"excel-2032499875\" 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 este art\u00edculo, vamos a sumergirnos en el fascinante mundo de las estad\u00edsticas y explorar dos funciones de Excel claves que te ayudar\u00e1n a realizar an\u00e1lisis y proyecciones: la funci\u00f3n<em><strong> Pron\u00f3stico<\/strong><\/em> y la funci\u00f3n <em><strong>Tendencia<\/strong><\/em>. Ambas pertenecen al grupo de funciones estad\u00edsticas y nos permiten obtener informaci\u00f3n valiosa a partir de conjuntos de datos. \u00a1Prep\u00e1rate para descubrir todo su potencial de una manera sencilla y efectiva!<\/p>\n<h6>PRON\u00d3STICO: PREDICCIONES PRECISAS CON EXCEL<\/h6>\n<p>La funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em> es una herramienta poderosa que te permite realizar estimaciones futuras basadas en datos hist\u00f3ricos. Su principal objetivo es predecir un valor para un punto futuro en funci\u00f3n de los datos existentes. \u00bfTienes una serie de ventas mensuales y deseas prever c\u00f3mo se comportar\u00e1n en el pr\u00f3ximo a\u00f1o? \u00a1La funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em> es tu aliada!<\/p>\n<p>Para utilizar esta funci\u00f3n, necesitas tener una serie de datos hist\u00f3ricos organizados en columnas en Excel. Luego, puedes aplicar la funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em> para obtener una predicci\u00f3n precisa. Puedes ajustar par\u00e1metros adicionales seg\u00fan tus necesidades, como el nivel de confianza deseado. Esta funci\u00f3n es especialmente \u00fatil en la planificaci\u00f3n financiera, la proyecci\u00f3n de ventas y cualquier escenario en el que se requiera prever valores futuros basados en datos hist\u00f3ricos.<\/p>\n<h6 style=\"text-align: center;\"><strong>SINTAXIS DE LA FUNCI\u00d3N <em>PRONOSTICO<\/em><\/strong><\/h6>\n<pre style=\"text-align: center;\"><span style=\"color: #000000;\"><strong>=PRONOSTICO(x, conocido_y, conocido_x)<\/strong><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13542\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/pronostico.png\" alt=\"\" width=\"582\" height=\"300\" \/><\/p>\n<p>La sintaxis de la funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em> tiene los siguientes argumentos:<\/p>\n<ul>\n<li><strong>x (obligatorio):<\/strong> El punto para el cual se desea predecir un valor.<\/li>\n<li><strong>conocido_y (obligatorio):<\/strong> Matriz o rango de datos dependientes.<\/li>\n<li><strong>conocido_x (obligatorio):<\/strong> Matriz o rango de datos independientes.<\/li>\n<\/ul>\n<p style=\"text-align: left;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11974 alignnone\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/ATENCION.png\" alt=\"\" width=\"22\" height=\"20\" \/>\u00a0 Es importante tener en cuenta que las funciones en Excel suelen recibir actualizaciones y mejoras\u00a0con el tiempo, por lo que es posible que encuentres variantes o versiones mejoradas de la funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em>. Sin embargo, la funci\u00f3n b\u00e1sica para realizar pron\u00f3sticos y proyecciones sigue estando presente en las versiones m\u00e1s recientes de Excel, incluyendo Excel 2019, Excel 365 y Excel Online.<\/p>\n<h6>TENDENCIA: IDENTIFICA PATRONES Y EXTRAPOLACIONES<\/h6>\n<p>La funci\u00f3n <em><strong>Tendencia<\/strong><\/em> tambi\u00e9n es una funci\u00f3n estad\u00edstica poderosa en Excel que te permite identificar patrones y realizar extrapolaciones en tus datos. Su objetivo principal es encontrar la relaci\u00f3n lineal entre dos conjuntos de valores y, a partir de ah\u00ed, estimar valores adicionales.<\/p>\n<p>A diferencia de la funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em>, que se enfoca en proporcionar estimaciones espec\u00edficas, la funci\u00f3n <em><strong>Tendencia<\/strong><\/em> te da una visi\u00f3n general de la tendencia general de los datos y c\u00f3mo se espera que se comporte en el futuro. Esta funci\u00f3n es \u00fatil cuando deseas identificar tendencias a largo plazo y proyectar c\u00f3mo podr\u00edan evolucionar los datos en el tiempo. Imagina que tienes datos de ventas y deseas saber cu\u00e1l podr\u00eda ser la tendencia futura en funci\u00f3n de esos datos. \u00a1La funci\u00f3n <em><strong>Tendencia<\/strong><\/em> te ayudar\u00e1 a obtener esa informaci\u00f3n!<\/p>\n<p>Para utilizar esta funci\u00f3n, tambi\u00e9n necesitas tener tus datos organizados en columnas. La funci\u00f3n <em><strong>Tendencia<\/strong><\/em> se encargar\u00e1 de encontrar la l\u00ednea de tendencia que mejor se ajuste a esos datos y te proporcionar\u00e1 informaci\u00f3n valiosa, como el valor de intercepci\u00f3n y la pendiente de la l\u00ednea. Con esta informaci\u00f3n, podr\u00e1s realizar proyecciones y entender mejor c\u00f3mo se comportar\u00e1n tus datos en el futuro.<\/p>\n<h6 style=\"text-align: center;\"><strong>SINTAXIS DE LA FUNCI\u00d3N <\/strong><strong><em>TENDENCIA<\/em><\/strong><\/h6>\n<pre style=\"text-align: center;\"><span style=\"color: #000000;\"><strong>=TENDENCIA(conocido_y, [conocido_x], [nueva_matriz_x], [constante])<\/strong><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13543\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/tendencia.png\" alt=\"\" width=\"584\" height=\"324\" \/><\/p>\n<p>La sintaxis de la funci\u00f3n <em><strong>Tendencia<\/strong><\/em>\u00a0tiene los siguientes argumentos:<\/p>\n<ul>\n<li><strong>conocido_y (obligatorio):<\/strong> Valores y, conocidos en la ecuaci\u00f3n y = mx + b.<\/li>\n<li><strong>conocido_x (opcional): <\/strong>Valores x, conocidos en la ecuaci\u00f3n y = mx + b.<\/li>\n<li><strong>nueva_matriz_x (opcional):<\/strong> Nuevos valores x para los que se desea obtener los valores de y.<\/li>\n<li><strong>constante (opcional):<\/strong> Valor de la constante b en la ecuaci\u00f3n y = mx + b.<\/li>\n<\/ul>\n<h6>EJEMPLO DE LAS FUNCIONES PRONOSTICO Y TENDENCIA<\/h6>\n<p><iframe loading=\"lazy\" title=\"19- Aplicaci&amp;oacute;n de las funciones PRONOSTICO Y TENDENCIA\" src=\"https:\/\/player.vimeo.com\/video\/417785200?h=02efc6d85c&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>Las funciones <em><strong>Pron\u00f3stico<\/strong><\/em> y <em><strong>Tendencia<\/strong><\/em> son herramientas valiosas para realizar an\u00e1lisis predictivos y obtener informaci\u00f3n significativa a partir de tus datos en Excel. Mientras que la funci\u00f3n <em><strong>Pron\u00f3stico<\/strong><\/em> se enfoca en proporcionar estimaciones precisas de valores futuros basadas en datos hist\u00f3ricos, la funci\u00f3n <em><strong>Tendencia<\/strong><\/em> se centra en identificar patrones y relaciones lineales entre conjuntos de datos para proyectar tendencias generales en el tiempo.<\/p>\n<p>Ya sea que necesites realizar proyecciones financieras o identificar tendencias en tus datos, estas funciones te ayudar\u00e1n a obtener resultados precisos y tomar decisiones informadas.<span style=\"color: #136e42;\"><strong> \u00a1Exprime al m\u00e1ximo Excel y potencia tus an\u00e1lisis con estas dos funciones!<\/strong><\/span><\/p>\n<hr \/>\n<p>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>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>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; POTENCIA TUS AN\u00c1LISIS CON &#8230; <a title=\"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\" aria-label=\"Leer m\u00e1s sobre LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13553,"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,556],"tags":[675,575,676,677],"class_list":["post-13541","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-estadisticas","category-excel","category-excel-intermedio","category-funciones-especiales","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>LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA<\/title>\n<meta name=\"description\" content=\"Las funciones Pron\u00f3stico y Tendencia nos permiten realizar an\u00e1lisis predictivos y proyectar tendencias a partir de conjuntos de datos.\" \/>\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\/las-funciones-pronostico-y-tendencia\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\" \/>\n<meta property=\"og:description\" content=\"Las funciones Pron\u00f3stico y Tendencia nos permiten realizar an\u00e1lisis predictivos y proyectar tendencias a partir de conjuntos de datos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\" \/>\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-22T10:53:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-25T18:01:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.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=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\",\"datePublished\":\"2023-05-22T10:53:03+00:00\",\"dateModified\":\"2023-05-25T18:01:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\"},\"wordCount\":830,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png\",\"keywords\":[\"estadisticas\",\"funciones\",\"pronostico\",\"tendencia\"],\"articleSection\":[\"Estad\u00edsticas\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\",\"url\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\",\"name\":\"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png\",\"datePublished\":\"2023-05-22T10:53:03+00:00\",\"dateModified\":\"2023-05-25T18:01:05+00:00\",\"description\":\"Las funciones Pron\u00f3stico y Tendencia nos permiten realizar an\u00e1lisis predictivos y proyectar tendencias a partir de conjuntos de datos.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png\",\"width\":1280,\"height\":720,\"caption\":\"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#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\":\"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA\"}]},{\"@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":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA","description":"Las funciones Pron\u00f3stico y Tendencia nos permiten realizar an\u00e1lisis predictivos y proyectar tendencias a partir de conjuntos de datos.","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\/las-funciones-pronostico-y-tendencia\/","og_locale":"es_ES","og_type":"article","og_title":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA","og_description":"Las funciones Pron\u00f3stico y Tendencia nos permiten realizar an\u00e1lisis predictivos y proyectar tendencias a partir de conjuntos de datos.","og_url":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-05-22T10:53:03+00:00","article_modified_time":"2023-05-25T18:01:05+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA","datePublished":"2023-05-22T10:53:03+00:00","dateModified":"2023-05-25T18:01:05+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/"},"wordCount":830,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png","keywords":["estadisticas","funciones","pronostico","tendencia"],"articleSection":["Estad\u00edsticas","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/","url":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/","name":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png","datePublished":"2023-05-22T10:53:03+00:00","dateModified":"2023-05-25T18:01:05+00:00","description":"Las funciones Pron\u00f3stico y Tendencia nos permiten realizar an\u00e1lisis predictivos y proyectar tendencias a partir de conjuntos de datos.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LAS-FUNCIONES-PRONOSTICO-Y-TENDENCIA.png","width":1280,"height":720,"caption":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/las-funciones-pronostico-y-tendencia\/#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":"LAS FUNCIONES PRON\u00d3STICO Y TENDENCIA"}]},{"@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\/13541","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=13541"}],"version-history":[{"count":9,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13541\/revisions"}],"predecessor-version":[{"id":13598,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13541\/revisions\/13598"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13553"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}