{"id":14978,"date":"2024-10-20T20:34:00","date_gmt":"2024-10-21T01:34:00","guid":{"rendered":"https:\/\/www.perucontable.com\/excelcontable\/?p=14978"},"modified":"2024-10-21T12:47:19","modified_gmt":"2024-10-21T17:47:19","slug":"funcion-pronostico-lineal-en-excel","status":"publish","type":"post","link":"https:\/\/www.perucontable.com\/excelcontable\/funcion-pronostico-lineal-en-excel\/","title":{"rendered":"Funci\u00f3n Pronostico Lineal en Excel"},"content":{"rendered":"\n<p>La funci\u00f3n <strong>PRONOSTICO.LINEAL<\/strong> en <a href=\"https:\/\/aulacontable.com\/url\/cvmiofexbg\" target=\"_blank\" rel=\"noreferrer noopener\">Excel<\/a> es una herramienta estad\u00edstica que anticipa valores futuros bas\u00e1ndose en datos previos.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Infografia-de-Salud-Proceso-Minimalista-Azul-410x1024.jpg\" alt=\"Ejemplo de la funci\u00f3n Pronostico lineal en Excel\" class=\"wp-image-18027\" width=\"650\" height=\"1636\"\/><\/figure><\/div>\n\n\n<p>La regresi\u00f3n lineal, al utilizar valores existentes (valores conocidos &#8216;x&#8217; e &#8216;y&#8217;), proyecta el futuro de &#8216;y&#8217; para un valor &#8216;x&#8217; espec\u00edfico. Esta t\u00e9cnica resulta valiosa para anticipar ventas o gestionar el inventario en un contexto empresarial.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/walink.co\/353bac\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/10\/image-40-1024x1024.png\" alt=\"\" class=\"wp-image-18940\" width=\"512\" height=\"512\"\/><\/a><\/figure><\/div>\n\n\n<div class=\"is-layout-flex wp-block-buttons\">\n<div class=\"wp-block-button aligncenter is-style-shadow td_btn_large\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/walink.co\/353bac\" style=\"background-color:#118d60\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Especial\u00edzate con el Curso Virtual del SOFTWARE CONTABLE SISCONT (CLICK AQU\u00cd)<\/strong><\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3><strong>Sintaxis de la Funci\u00f3n PRONOSTICO.LINEAL en Excel : <\/strong><\/h3>\n\n\n\n<h3 class=\"has-text-align-center\"><strong>=PRONOSTICO.LINEAL(X;CONOCIDO_Y;CONOCIDO_X)<\/strong><\/h3>\n\n\n\n<ul>\n<li>x (<em>obligatorio<\/em>): Es el punto de datos cuyo valor se desea predecir.<\/li>\n\n\n\n<li>conocido_y (<em>obligatorio<\/em>): Es la matriz o rango de datos dependientes.<\/li>\n\n\n\n<li>conocido_x (<em>obligatorio<\/em>): Es la matriz o rango de datos independientes.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2021\/03\/image-16.png\" alt=\"\" class=\"wp-image-14979\" width=\"722\" height=\"357\"\/><\/figure>\n\n\n\n<pre class=\"wp-block-verse has-text-align-center\"><strong><a href=\"https:\/\/aulacontable.com\/url\/cvmiofexbg\" target=\"_blank\" rel=\"noreferrer noopener\">S\u00e9 un experto en EXCEL, llevando el curso de: MICROSOFT OFFICE EXCEL<\/a><\/strong><\/pre>\n\n\n\n<h3>Ejemplo de la funci\u00f3n PRONOSTICO.LINEAL<\/h3>\n\n\n\n<p>Anticipemos las ventas de los pr\u00f3ximos meses a partir de los datos de los primeros nueve meses.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"974\" height=\"446\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Captura-de-pantalla-2023-12-01-200123.png\" alt=\"Paso1 para usar la funci\u00f3n pronostico.lineal\" class=\"wp-image-18028\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Captura-de-pantalla-2023-12-01-200123.png 974w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Captura-de-pantalla-2023-12-01-200123-300x137.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Captura-de-pantalla-2023-12-01-200123-768x352.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Captura-de-pantalla-2023-12-01-200123-696x319.png 696w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/Captura-de-pantalla-2023-12-01-200123-917x420.png 917w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/figure>\n\n\n\n<p>Para hacerlo, col\u00f3cate sobre la celda del mes 10 y escribe esta f\u00f3rmula:<\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong>=PRONOSTICO.LINEAL(A13;B4:B12;A4:A12)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"975\" height=\"499\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/2.png\" alt=\"\" class=\"wp-image-18029\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/2.png 975w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/2-300x154.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/2-768x393.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/2-696x356.png 696w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/2-821x420.png 821w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p>Repite este proceso para los meses 11 y 12, obteniendo las ventas estimadas para todo el a\u00f1o, destacadas en amarillo en el gr\u00e1fico.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"973\" height=\"450\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-1.png\" alt=\"\" class=\"wp-image-18030\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-1.png 973w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-1-300x139.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-1-768x355.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-1-696x322.png 696w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-1-908x420.png 908w\" sizes=\"(max-width: 973px) 100vw, 973px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-verse has-text-align-center\"><strong><a href=\"https:\/\/www.cursos.perucontable.com\/planillas-construccion-civil-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">Te recomendamos el siguiente curso: PLANILLAS DE CONSTRUCCI\u00d3N CIVIL EN EXCEL<\/a><\/strong><\/pre>\n\n\n\n<p>Despu\u00e9s le a\u00f1adimos los nuevos valores al gr\u00e1fico.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"974\" height=\"452\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-2.png\" alt=\"\" class=\"wp-image-18032\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-2.png 974w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-2-300x139.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-2-768x356.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-2-696x323.png 696w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/image-2-905x420.png 905w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/figure>\n\n\n\n<p>Y su l\u00ednea de tendencia.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"975\" height=\"451\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/4.png\" alt=\"\" class=\"wp-image-18031\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/4.png 975w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/4-300x139.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/4-768x355.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/4-696x322.png 696w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/12\/4-908x420.png 908w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p>Lo que veremos es que los valores estimados coinciden para los meses que se han estimado.<\/p>\n\n\n\n<p><strong>Art\u00edculos que te recomendamos leer:<\/strong><\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/www.perucontable.com\/excelcontable\/como-crear-un-grafico-de-maximos-y-minimos-en-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u00bfC\u00d3MO CREAR UN GR\u00c1FICO DE M\u00c1XIMOS Y M\u00cdNIMOS EN EXCEL?<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.perucontable.com\/excelcontable\/funcion-contar-realizacion-de-calculos-rapidos-y-precisos\/\" target=\"_blank\">FUNCI\u00d3N CONTAR: REALIZACI\u00d3N DE C\u00c1LCULOS R\u00c1PIDOS Y PRECISOS.<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.perucontable.com\/excelcontable\/hojas-de-calculo-tips-para-el-manejo-de-microsoft-excel\/\" target=\"_blank\">HOJAS DE CALCULO: TIPS PARA EL MANEJO DE MICROSOFT EXCEL.<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.perucontable.com\/excelcontable\/aprenda-estos-atajos-de-teclado-excel-muy-utiles-para-ser-mas-productivo-en-la-oficina\/\" target=\"_blank\">APRENDA ESTOS ATAJOS DE TECLADO EXCEL MUY \u00daTILES PARA SER MAS PRODUCTIVO EN LA OFICINA.<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.perucontable.com\/excelcontable\/estado-flujo-efectivo-excel\/\" target=\"_blank\">ELABORACION DEL ESTADO DE FLUJOS DE EFECTIVO EN EXCEL.<\/a><\/li>\n<\/ul>\n\n\n\n<p><strong>Conoce m\u00e1s en este video:<\/strong> \u00bfC\u00f3mo realizar una barra de progreso para las notas de tus estudiantes?<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-tiktok wp-block-embed-tiktok\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"tiktok-embed\" cite=\"https:\/\/www.tiktok.com\/@aprendexcelfacil\/video\/7004874202163514629\" data-video-id=\"7004874202163514629\" data-embed-from=\"oembed\" style=\"max-width: 605px;min-width: 325px;\" > <section> <a target=\"_blank\" title=\"@aprendexcelfacil\" href=\"https:\/\/www.tiktok.com\/@aprendexcelfacil?refer=embed\">@aprendexcelfacil<\/a> <p>\ud83e\udd14\ud83d\udcbb\u00bfC\u00f3mo realizar una barra de progreso para las notas de tus estudiantes?<a title=\"tipexcel\" target=\"_blank\" href=\"https:\/\/www.tiktok.com\/tag\/tipexcel?refer=embed\">#tipexcel<\/a> <a title=\"excel\" target=\"_blank\" href=\"https:\/\/www.tiktok.com\/tag\/excel?refer=embed\">#excel<\/a> <a title=\"perucontable\" target=\"_blank\" href=\"https:\/\/www.tiktok.com\/tag\/perucontable?refer=embed\">#perucontable<\/a> <a title=\"graficoenexcel\" target=\"_blank\" href=\"https:\/\/www.tiktok.com\/tag\/graficoenexcel?refer=embed\">#graficoenexcel<\/a><\/p> <a target=\"_blank\" title=\"\u266c marketing - TimTaj\" href=\"https:\/\/www.tiktok.com\/music\/marketing-6817449782101936130?refer=embed\">\u266c marketing &#8211; TimTaj<\/a> <\/section> <\/blockquote> <script async src=\"https:\/\/www.tiktok.com\/embed.js\"><\/script>\n<\/div><\/figure>\n\n\n\n<p><strong>\u00bfTe ha resultado \u00fatil este art\u00edculo? \u00a1Nos encantar\u00eda conocer tu opini\u00f3n!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n PRONOSTICO.LINEAL en Excel es una herramienta estad\u00edstica que anticipa valores futuros bas\u00e1ndose en datos previos. La regresi\u00f3n lineal, al utilizar valores existentes (valores conocidos &#8216;x&#8217; e &#8216;y&#8217;), proyecta el futuro de &#8216;y&#8217; para un valor &#8216;x&#8217; espec\u00edfico. Esta t\u00e9cnica resulta valiosa para anticipar ventas o gestionar el inventario en un contexto empresarial. Sintaxis [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17603,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[45,67,25],"tags":[],"yst_prominent_words":[275,133,122,424,320,379,339,343],"_links":{"self":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14978"}],"collection":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/comments?post=14978"}],"version-history":[{"count":21,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14978\/revisions"}],"predecessor-version":[{"id":18949,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14978\/revisions\/18949"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media\/17603"}],"wp:attachment":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media?parent=14978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/categories?post=14978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/tags?post=14978"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/yst_prominent_words?post=14978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}