{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Introducción","1.Obteniendo los datos","2. Análisis de Datos","3.Presentación Final"],"not_rendered":{"charts":7,"images":11,"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Introducción","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[5,7,6,8],[7,7,8,8],[9,7,9,8]]}
["Este libro es una guía para que los alumnos sepan cómo realizar el ejercicio del Tema 6"]
[]
["El libro de excel está estructurado en distintas hojas. En cada hoja se explica cada uno de los pasos que aparecen en el siguiente esquema, que se corresponden con los que el alumno debe dar para realizar el ejercicio:"]
[]
["Pasos",{"$nulls":6},"Explicado en Hoja"]
["Paso 1","Buscar la información necesaria en una base de datos de internet",{"$nulls":5},"1. Obteniendo los datos"]
["Paso 2","Descargar los datos buscados a una hoja de excel"]
["Paso 3","Dar formato a los datos para su análisis y presentación",{"$nulls":5},"2. Análisis de datos"]
["Paso 4","Análisis de los datos (gráficos y cálculos)"]
["Paso 5","Pasando los resultados a word",{"$nulls":5},"3. Presentación final"]
[]
["Este libro contiene, además el análisis de la serie del PIB trimestral español y sus componentes desde 1970 hasta 1998."]
["En esta primera hoja se repasan los conceptos teóricos básicos que debe el alumno debe aplicar para realizar este ejercicio."]
[]
["El enunciado de la tarea pide que los alumnos"]
["1. Analicen la serie del PIB de un país cualquiera (datos trimestrales),para lo cual deben:"]
[" ","a. Distinguir entre las distintas estados en los que se puede econtrar una economía: expansión, desaceleración, recesión;"]
[null,"b. Detectar los ciclos económicos, encontrando los picos de las fases expansivas y los fondos de las recesiones,"]
[null,"c. Identificar la tendencia a largo plazo del PIB de la economía estudiada."]
["2. Realicen una de las dos siguientes tareas:"]
[null,"a. Analizar el comportamiento de cada uno de los componentes del PIB por la demanda en las distintas fases del ciclo,"]
[null,"b. Poner en relación el comportamiento del PIB por la demanda con la tasa de desempleo del país estudiado."]
[]
["NOTA IMPORTANTE: si los alumnos escogen una base que contenga datos de más de 20 años de la serie del PIB del país analizado, pueden dividirse entre distintos grupos el análisis del PIB de dicho país. Eso sí, cada grupo debe analizar un periodo  MÍNIMO"]
["de 20 años."]
[]
["Teniendo en cuenta lo que se pide en el problema, el alumno debe utilizar los siguientes conceptos explicados en teoría:"]
{"$rows_empty":14}
["Además, debe conocer los siguientes conceptos relacionados con el estudio del ciclo económico:"]
[" "]

{"sheet":"1.Obteniendo los datos","index":1,"n_rows":271,"n_cols":19,"rows_kept":271}
["Para obtener los datos que necesita para realizar el ejercicio, el alumno debe seguir los siguientes pasos:"]
[]
["1. Búsqueda de una base de datos"]
["El primer paso es seleccionar el país del que se va a analizar la serie del PIB. El consejo es que elijan, en primer lugar, países desarrollados. Una vez decidido el país, deberán buscar los datos correspondientes a su economía."]
["En internet existen las siguientes bases de datos en los que los alumnos pueden encontrar los datos deseados:"]
[]
["Nacionales","Vínculo "]
["Ine","El alumno debe buscar esta base de datos (Si la utiliza DEBE descargarse los datos básicos)"]
["Banco de España","El alumno debe buscar esta base de datos"]
["Internacionales"]
["Federal Reserve of St. Louis Database (FRED)","https://fred.stlouisfed.org/"]
["The Maddison Project","http://www.ggdc.net/maddison/maddison-project/home.htm"]
["Eurostat","El alumno debe buscar esta base de datos"]
[]
["El ejemplo que utilizaremos en este libro está obtenido de la base de datos del INE."]
[]
["2. Búsqueda de los datos necesarios en la base de datos seleccionada"]
["Una vez en la página web de la base de datos seleccionada, tenemos que buscar la serie de datos que es relevante para el análisis que pide el ejercicio. En general, los alumnos deben buscar las serie del PIB trimestral del país seleccionado, que esté"]
["expresada en unidades monetarias constantes (o en índices de volumen) y,  a ser posible, que estén desestacionalizadas."]
[]
["1er. Paso: En el caso de nuestro ejemplo, buscamos en la base del INE la serie trimestral del PIB español de 1970 a 1998 en pesetas constantes de 1986."]
{"$rows_empty":26}
["2o. Paso: Una vez pinchado el vínculo obtenemos la serie de datos deseados, que en nuestro caso aparecen en el siguiente formato:"]
[]
["Cuarto Trimestre de 1998"]
[]
["Demanda. Precios constantes de 1986"]
["unidad: miles de millones de pesetas"]
[]
[null,null,"Producto Interior","Consumo privado","Consumo privado","Consumo","Formación bruta","FBCF en bienes","FBCF en","Variación de","Demanda","Exportación de","Exportación de","Exportación de","Consumo en el TE","Importación de","Importación de","Importación de","Consumo en el RM"]
["año","trim","Bruto p.m.","nacional","interior","público","de capital fijo","de equipo","construcción","existencias","interna","bienes y servicios","bienes","servicios","de no residentes","bienes y servicios","bienes","servicios","de residentes"]
[1970,1,{"v":5098.7,"d":"5,098.700"},{"v":3317.3,"d":"3,317.300"},{"v":3547.8,"d":"3,547.800"},{"v":536.4,"d":"536.400"},{"v":1306.9,"d":"1,306.900"},{"v":438.1,"d":"438.100"},{"v":868.8,"d":"868.800"},{"v":65.18700000000027,"d":"65.187"},{"v":5225.787,"d":"5,225.787"},528.259,{"v":219.9,"d":"219.900"},59.459,{"v":248.9,"d":"248.900"},655.346,{"v":609.6,"d":"609.600"},27.346,{"v":18.4,"d":"18.400"}]
[null,2,{"v":5106.8,"d":"5,106.800"},{"v":3328.3,"d":"3,328.300"},{"v":3561.9,"d":"3,561.900"},{"v":536.7,"d":"536.700"},{"v":1288.3,"d":"1,288.300"},{"v":423,"d":"423.000"},{"v":865.3,"d":"865.300"},{"v":51.31299999999974,"d":"51.313"},{"v":5204.613,"d":"5,204.613"},543.775,{"v":231.6,"d":"231.600"},60.075,{"v":252.1,"d":"252.100"},641.588,{"v":595.4,"d":"595.400"},27.688,{"v":18.5,"d":"18.500"}]
[null,3,{"v":5132.9,"d":"5,132.900"},{"v":3350.3,"d":"3,350.300"},{"v":3589.9,"d":"3,589.900"},{"v":538.5,"d":"538.500"},{"v":1267.3,"d":"1,267.300"},{"v":408.9,"d":"408.900"},{"v":858.4,"d":"858.400"},{"v":42.66299999999992,"d":"42.663"},{"v":5198.763,"d":"5,198.763"},566.308,{"v":246.7,"d":"246.700"},61.308,{"v":258.3,"d":"258.300"},632.171,{"v":585.1,"d":"585.100"},28.371,{"v":18.7,"d":"18.700"}]
[null,4,{"v":5173.4,"d":"5,173.400"},{"v":3383.5,"d":"3,383.500"},{"v":3632.1,"d":"3,632.100"},{"v":543.3,"d":"543.300"},{"v":1245.8,"d":"1,245.800"},{"v":397.9,"d":"397.900"},{"v":847.9,"d":"847.900"},{"v":40.13799999999937,"d":"40.138"},{"v":5212.738,"d":"5,212.738"},586.758,{"v":256,"d":"256.000"},63.158,{"v":267.6,"d":"267.600"},626.096,{"v":577.7,"d":"577.700"},29.396,{"v":19,"d":"19.000"}]
[1971,1,{"v":5213.8,"d":"5,213.800"},{"v":3427.6,"d":"3,427.600"},{"v":3688.3,"d":"3,688.300"},{"v":547.7,"d":"547.700"},{"v":1221.6,"d":"1,221.600"},{"v":387.6,"d":"387.600"},{"v":834,"d":"834.000"},{"v":40.9380000000001,"d":"40.938"},{"v":5237.838,"d":"5,237.838"},599.124,{"v":253.4,"d":"253.400"},65.624,{"v":280.1,"d":"280.100"},623.162,{"v":573,"d":"573.000"},30.762,{"v":19.4,"d":"19.400"}]
[null,2,{"v":5315.5,"d":"5,315.500"},{"v":3480.4,"d":"3,480.400"},{"v":3749.6,"d":"3,749.600"},{"v":558.5,"d":"558.500"},{"v":1224.6,"d":"1,224.600"},{"v":392.7,"d":"392.700"},{"v":831.9,"d":"831.900"},{"v":55.98299999999963,"d":"55.983"},{"v":5319.483,"d":"5,319.483"},623.411,{"v":264.8,"d":"264.800"},69.411,{"v":289.2,"d":"289.200"},627.394,{"v":575.3,"d":"575.300"},32.094,{"v":20,"d":"20.000"}]
[null,3,{"v":5413.3,"d":"5,413.300"},{"v":3541.8,"d":"3,541.800"},{"v":3816,"d":"3,816.000"},{"v":566.6,"d":"566.600"},{"v":1236.2,"d":"1,236.200"},{"v":394.7,"d":"394.700"},{"v":841.5,"d":"841.500"},{"v":65.17299999999996,"d":"65.173"},{"v":5409.773,"d":"5,409.773"},648.518,{"v":278.9,"d":"278.900"},74.518,{"v":295.1,"d":"295.100"},644.991,{"v":590.7,"d":"590.700"},33.391,{"v":20.9,"d":"20.900"}]
[null,4,{"v":5522.3,"d":"5,522.300"},{"v":3611.9,"d":"3,611.900"},{"v":3887.5,"d":"3,887.500"},{"v":574.9,"d":"574.900"},{"v":1272.6,"d":"1,272.600"},{"v":409.7,"d":"409.700"},{"v":862.9,"d":"862.900"},{"v":70.60600000000031,"d":"70.606"},{"v":5530.006,"d":"5,530.006"},670.047,{"v":291.5,"d":"291.500"},80.947,{"v":297.6,"d":"297.600"},677.753,{"v":621.1,"d":"621.100"},34.653,{"v":22,"d":"22.000"}]
[1972,1,{"v":5611.9,"d":"5,611.900"},{"v":3690.5,"d":"3,690.500"},{"v":3964.1,"d":"3,964.100"},{"v":576.8,"d":"576.800"},{"v":1329.8,"d":"1,329.800"},{"v":433.8,"d":"433.800"},{"v":896,"d":"896.000"},{"v":62.98599999999951,"d":"62.986"},{"v":5660.086,"d":"5,660.086"},683.995,{"v":298.4,"d":"298.400"},88.695,{"v":296.9,"d":"296.900"},732.181,{"v":673,"d":"673.000"},35.881,{"v":23.3,"d":"23.300"}]
[null,2,{"v":5744.5,"d":"5,744.500"},{"v":3768.7,"d":"3,768.700"},{"v":4044,"d":"4,044.000"},{"v":586.9,"d":"586.900"},{"v":1395.9,"d":"1,395.900"},{"v":468.6,"d":"468.600"},{"v":927.3,"d":"927.300"},{"v":69.09200000000037,"d":"69.092"},{"v":5820.592,"d":"5,820.592"},704.357,{"v":309.6,"d":"309.600"},94.557,{"v":300.2,"d":"300.200"},780.449,{"v":718.4,"d":"718.400"},37.149,{"v":24.9,"d":"24.900"}]
[null,3,{"v":5870.7,"d":"5,870.700"},{"v":3846.3,"d":"3,846.300"},{"v":4127.3,"d":"4,127.300"},{"v":596,"d":"596.000"},{"v":1443.8,"d":"1,443.800"},{"v":486.9,"d":"486.900"},{"v":956.9,"d":"956.900"},{"v":74.9279999999997,"d":"74.928"},{"v":5961.028,"d":"5,961.028"},733.431,{"v":327.2,"d":"327.200"},98.531,{"v":307.7,"d":"307.700"},823.759,{"v":758.6,"d":"758.600"},38.459,{"v":26.7,"d":"26.700"}]
[null,4,{"v":5987,"d":"5,987.000"},{"v":3923.3,"d":"3,923.300"},{"v":4213.9,"d":"4,213.900"},{"v":604.8,"d":"604.800"},{"v":1489.2,"d":"1,489.200"},{"v":504.4,"d":"504.400"},{"v":984.8,"d":"984.800"},{"v":72.09400000000042,"d":"72.094"},{"v":6089.394,"d":"6,089.394"},759.817,{"v":339.9,"d":"339.900"},100.617,{"v":319.3,"d":"319.300"},862.211,{"v":793.7,"d":"793.700"},39.811,{"v":28.7,"d":"28.700"}]
[1973,1,{"v":6097.2,"d":"6,097.200"},{"v":3999.8,"d":"3,999.800"},{"v":4303.8,"d":"4,303.800"},{"v":613.7,"d":"613.700"},{"v":1543.4,"d":"1,543.400"},{"v":532.5,"d":"532.500"},{"v":1010.9,"d":"1,010.900"},{"v":58.38700000000008,"d":"58.387"},{"v":6215.287,"d":"6,215.287"},779.116,{"v":343.3,"d":"343.300"},100.816,{"v":335,"d":"335.000"},897.203,{"v":825,"d":"825.000"},41.203,{"v":31,"d":"31.000"}]
[null,2,{"v":6205.9,"d":"6,205.900"},{"v":4072.1,"d":"4,072.100"},{"v":4381.5,"d":"4,381.500"},{"v":623.5,"d":"623.500"},{"v":1586.3,"d":"1,586.300"},{"v":552.1,"d":"552.100"},{"v":1034.2,"d":"1,034.200"},{"v":56.99999999999964,"d":"57.000"},{"v":6338.9,"d":"6,338.900"},792.939,{"v":350.4,"d":"350.400"},101.339,{"v":341.2,"d":"341.200"},925.939,{"v":851.1,"d":"851.100"},43.039,{"v":31.8,"d":"31.800"}]
[null,3,{"v":6308.4,"d":"6,308.400"},{"v":4140.4,"d":"4,140.400"},{"v":4447.2,"d":"4,447.200"},{"v":633.1,"d":"633.100"},{"v":1613.2,"d":"1,613.200"},{"v":558.6,"d":"558.600"},{"v":1054.6,"d":"1,054.600"},{"v":65.3309999999994,"d":"65.331"},{"v":6452.031,"d":"6,452.031"},802.587,{"v":362.4,"d":"362.400"},102.187,{"v":338,"d":"338.000"},946.218,{"v":869.7,"d":"869.700"},45.318,{"v":31.2,"d":"31.200"}]
[null,4,{"v":6412.2,"d":"6,412.200"},{"v":4204.5,"d":"4,204.500"},{"v":4500.7,"d":"4,500.700"},{"v":645.7,"d":"645.700"},{"v":1651.4,"d":"1,651.400"},{"v":579.1,"d":"579.100"},{"v":1072.3,"d":"1,072.300"},{"v":78.88199999999998,"d":"78.882"},{"v":6580.482,"d":"6,580.482"},795.058,{"v":366.4,"d":"366.400"},103.358,{"v":325.3,"d":"325.300"},{"v":963.34,"d":"963.340"},{"v":886.2,"d":"886.200"},{"v":48.04,"d":"48.040"},{"v":29.1,"d":"29.100"}]
[1974,1,{"v":6521.1,"d":"6,521.100"},{"v":4264.6,"d":"4,264.600"},{"v":4542.1,"d":"4,542.100"},{"v":664.7,"d":"664.700"},{"v":1690.7,"d":"1,690.700"},{"v":603.6,"d":"603.600"},{"v":1087.1,"d":"1,087.100"},{"v":106.75100000000002,"d":"106.751"},{"v":6726.751,"d":"6,726.751"},781.455,{"v":373.5,"d":"373.500"},104.855,{"v":303.1,"d":"303.100"},987.106,{"v":910.3,"d":"910.300"},51.206,{"v":25.6,"d":"25.600"}]
[null,2,{"v":6603.5,"d":"6,603.500"},{"v":4308.1,"d":"4,308.100"},{"v":4571.6,"d":"4,571.600"},{"v":684.4,"d":"684.400"},{"v":1708.5,"d":"1,708.500"},{"v":615.8,"d":"615.800"},{"v":1092.7,"d":"1,092.700"},{"v":134.61899999999986,"d":"134.619"},{"v":6835.619,"d":"6,835.619"},779.171,{"v":385.2,"d":"385.200"},107.271,{"v":286.7,"d":"286.700"},{"v":1011.29,"d":"1,011.290"},{"v":935.1,"d":"935.100"},{"v":52.99,"d":"52.990"},{"v":23.2,"d":"23.200"}]
[null,3,{"v":6650.1,"d":"6,650.100"},{"v":4335.1,"d":"4,335.100"},{"v":4589.2,"d":"4,589.200"},{"v":696,"d":"696.000"},{"v":1706.3,"d":"1,706.300"},{"v":617.1,"d":"617.100"},{"v":1089.2,"d":"1,089.200"},145.984,{"v":6883.384,"d":"6,883.384"},787.308,{"v":400.6,"d":"400.600"},110.608,{"v":276.1,"d":"276.100"},{"v":1020.592,"d":"1,020.592"},{"v":945.2,"d":"945.200"},53.392,{"v":22,"d":"22.000"}]
[null,4,{"v":6654.5,"d":"6,654.500"},{"v":4345.8,"d":"4,345.800"},{"v":4594.9,"d":"4,594.900"},{"v":704.7,"d":"704.700"},{"v":1685.4,"d":"1,685.400"},{"v":608.8,"d":"608.800"},{"v":1076.6,"d":"1,076.600"},{"v":140.5460000000001,"d":"140.546"},{"v":6876.446,"d":"6,876.446"},790.166,{"v":404.1,"d":"404.100"},114.866,{"v":271.2,"d":"271.200"},{"v":1012.112,"d":"1,012.112"},{"v":937.6,"d":"937.600"},52.412,{"v":22.1,"d":"22.100"}]
[1975,1,{"v":6621.1,"d":"6,621.100"},{"v":4339.9,"d":"4,339.900"},{"v":4588.7,"d":"4,588.700"},{"v":713,"d":"713.000"},{"v":1650.3,"d":"1,650.300"},{"v":595.4,"d":"595.400"},{"v":1054.9,"d":"1,054.900"},{"v":129.60700000000014,"d":"129.607"},{"v":6832.807,"d":"6,832.807"},782.444,{"v":390.3,"d":"390.300"},120.044,{"v":272.1,"d":"272.100"},994.151,{"v":920.8,"d":"920.800"},50.051,{"v":23.3,"d":"23.300"}]
[null,2,{"v":6615.6,"d":"6,615.600"},{"v":4358,"d":"4,358.000"},{"v":4604.5,"d":"4,604.500"},{"v":720.1,"d":"720.100"},{"v":1620.3,"d":"1,620.300"},{"v":580.9,"d":"580.900"},{"v":1039.4,"d":"1,039.400"},{"v":126.12800000000043,"d":"126.128"},{"v":6824.528,"d":"6,824.528"},778.238,{"v":386.5,"d":"386.500"},121.238,{"v":270.5,"d":"270.500"},987.166,{"v":913.1,"d":"913.100"},50.066,{"v":24,"d":"24.000"}]
[null,3,{"v":6644.5,"d":"6,644.500"},{"v":4400.1,"d":"4,400.100"},{"v":4642.3,"d":"4,642.300"},{"v":724.1,"d":"724.100"},{"v":1613.5,"d":"1,613.500"},{"v":583.3,"d":"583.300"},{"v":1030.2,"d":"1,030.200"},{"v":122.5109999999997,"d":"122.511"},{"v":6860.211,"d":"6,860.211"},779.247,{"v":394.4,"d":"394.400"},118.447,{"v":266.4,"d":"266.400"},994.958,{"v":918.3,"d":"918.300"},52.458,{"v":24.2,"d":"24.200"}]
[null,4,{"v":6691.2,"d":"6,691.200"},{"v":4466.3,"d":"4,466.300"},{"v":4702.1,"d":"4,702.100"},{"v":735.7,"d":"735.700"},{"v":1601.2,"d":"1,601.200"},{"v":573.9,"d":"573.900"},{"v":1027.3,"d":"1,027.300"},{"v":120.85299999999953,"d":"120.853"},{"v":6924.053,"d":"6,924.053"},785.672,{"v":414.3,"d":"414.300"},111.672,{"v":259.7,"d":"259.700"},{"v":1018.525,"d":"1,018.525"},{"v":937.4,"d":"937.400"},57.225,{"v":23.9,"d":"23.900"}]
[1976,1,{"v":6757.7,"d":"6,757.700"},{"v":4556.6,"d":"4,556.600"},{"v":4783.9,"d":"4,783.900"},{"v":752.3,"d":"752.300"},{"v":1603.2,"d":"1,603.200"},{"v":572.5,"d":"572.500"},{"v":1030.7,"d":"1,030.700"},{"v":115.65799999999982,"d":"115.658"},{"v":7027.758,"d":"7,027.758"},791.412,{"v":440,"d":"440.000"},100.912,{"v":250.5,"d":"250.500"},{"v":1061.47,"d":"1,061.470"},{"v":973.9,"d":"973.900"},{"v":64.37,"d":"64.370"},{"v":23.2,"d":"23.200"}]
[null,2,{"v":6835.7,"d":"6,835.700"},{"v":4624.8,"d":"4,624.800"},{"v":4848.4,"d":"4,848.400"},{"v":768.8,"d":"768.800"},{"v":1608.7,"d":"1,608.700"},{"v":576.8,"d":"576.800"},{"v":1031.9,"d":"1,031.900"},{"v":125.40699999999997,"d":"125.407"},{"v":7127.707,"d":"7,127.707"},807.173,{"v":465.6,"d":"465.600"},94.673,{"v":246.9,"d":"246.900"},{"v":1099.18,"d":"1,099.180"},{"v":1007.3,"d":"1,007.300"},{"v":68.58,"d":"68.580"},{"v":23.3,"d":"23.300"}]
[null,3,{"v":6902,"d":"6,902.000"},{"v":4671.1,"d":"4,671.100"},{"v":4895.5,"d":"4,895.500"},{"v":781.5,"d":"781.500"},{"v":1610.6,"d":"1,610.600"},{"v":579.7,"d":"579.700"},{"v":1030.9,"d":"1,030.900"},{"v":127.09900000000016,"d":"127.099"},{"v":7190.299,"d":"7,190.299"},829.756,{"v":488,"d":"488.000"},92.956,{"v":248.8,"d":"248.800"},{"v":1118.055,"d":"1,118.055"},{"v":1023.8,"d":"1,023.800"},69.855,{"v":24.4,"d":"24.400"}]
[null,4,{"v":6955,"d":"6,955.000"},{"v":4695.4,"d":"4,695.400"},{"v":4925.3,"d":"4,925.300"},{"v":789.9,"d":"789.900"},{"v":1610.8,"d":"1,610.800"},{"v":583,"d":"583.000"},{"v":1027.8,"d":"1,027.800"},{"v":113.43700000000027,"d":"113.437"},{"v":7209.537,"d":"7,209.537"},853.259,{"v":501.2,"d":"501.200"},95.759,{"v":256.3,"d":"256.300"},{"v":1107.796,"d":"1,107.796"},{"v":1013.2,"d":"1,013.200"},68.196,{"v":26.4,"d":"26.400"}]
[1977,1,{"v":7010.1,"d":"7,010.100"},{"v":4697.7,"d":"4,697.700"},{"v":4937.8,"d":"4,937.800"},{"v":794.1,"d":"794.100"},{"v":1609.8,"d":"1,609.800"},{"v":587.4,"d":"587.400"},{"v":1022.4,"d":"1,022.400"},{"v":99.91900000000041,"d":"99.919"},{"v":7201.519,"d":"7,201.519"},878.183,{"v":505.7,"d":"505.700"},103.083,{"v":269.4,"d":"269.400"},{"v":1069.602,"d":"1,069.602"},{"v":976.7,"d":"976.700"},63.602,{"v":29.3,"d":"29.300"}]
[null,2,{"v":7041.9,"d":"7,041.900"},{"v":4702,"d":"4,702.000"},{"v":4953.4,"d":"4,953.400"},{"v":799.1,"d":"799.100"},{"v":1594.2,"d":"1,594.200"},{"v":577.1,"d":"577.100"},{"v":1017.1,"d":"1,017.100"},{"v":78.25399999999972,"d":"78.254"},{"v":7173.554,"d":"7,173.554"},{"v":908.03,"d":"908.030"},{"v":516.9,"d":"516.900"},{"v":108.63,"d":"108.630"},{"v":282.5,"d":"282.500"},{"v":1039.684,"d":"1,039.684"},{"v":947.7,"d":"947.700"},60.884,{"v":31.1,"d":"31.100"}]
[null,3,{"v":7065.3,"d":"7,065.300"},{"v":4708.7,"d":"4,708.700"},{"v":4972.2,"d":"4,972.200"},{"v":803.7,"d":"803.700"},{"v":1585.3,"d":"1,585.300"},{"v":573.5,"d":"573.500"},{"v":1011.8,"d":"1,011.800"},{"v":55.943000000000396,"d":"55.943"},{"v":7153.643,"d":"7,153.643"},932.698,{"v":524.8,"d":"524.800"},112.398,{"v":295.5,"d":"295.500"},{"v":1021.041,"d":"1,021.041"},{"v":929,"d":"929.000"},60.041,{"v":32,"d":"32.000"}]
[null,4,{"v":7112.5,"d":"7,112.500"},{"v":4717.6,"d":"4,717.600"},{"v":4994.3,"d":"4,994.300"},{"v":816.2,"d":"816.200"},{"v":1586.2,"d":"1,586.200"},{"v":579.7,"d":"579.700"},{"v":1006.5,"d":"1,006.500"},{"v":47.68599999999988,"d":"47.686"},{"v":7167.686,"d":"7,167.686"},959.788,{"v":536.9,"d":"536.900"},114.388,{"v":308.5,"d":"308.500"},{"v":1014.974,"d":"1,014.974"},{"v":922.1,"d":"922.100"},61.074,{"v":31.8,"d":"31.800"}]
[null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
["El problema es que no siempre los datos van a estar presentados de esta forma tan legible. Por ejemplo, cualquiera las series de datos del Banco de España no aparecen igual de bien presentadas."]
[]
["Cuando esto ocurre, para darle un formato intelegible a los datos tenéis que seguir los pasos del siguiente "]
[]
["̶  Supongamos que queremos los datos de los índices de los precios industriales. Buscando esta serie en la base de datos del Banco de España llegamos a la siguiente página:"]
{"$rows_empty":34}
["̶  Si le damos al enlace con la imagen del archivo excel y abrimos el archivo descargado, veremos la siguiente pantalla:"]
{"$rows_empty":37}
["̶  Obviamente, los datos así presentados no son legibles. Para hacer que sean legibles hay que dar los siguientes pasos."]
[]
["● En el menú \"Datos\", seleccionar la opción \"Texto en columnas\". Se lanzará el assitente de configuración de datos"]
{"$rows_empty":37}
["● Dejar seleccionada la opción \"Delimitados\" que viene por defecto y hacer click en \"siguiente\""]
[]
["● En el siguiente paso del asistente, en el menú \"separadores\", deseleccionar \"Tabulación\" y seleccionar \"Coma\". Hacer click en \"siguiente\"."]
{"$rows_empty":28}
["● En el siguiente paso seleccionar la opción \"Avanzadas\". Se abre un nuevo menú en el que aparecen los separadores de millares y decimales. Cambiar el separador decimal a punto (\".\") y el separado de miles a coma (\",\"). Deseleccionar la Opción"]
["\"signo menos detrás de los números negativos"]
{"$rows_empty":31}
["̶  Haciendo click en \"Aceptar\" en primer lugar, y luego en \"Finalizar\", los datos se presentan correctamente:"]

{"sheet":"2. Análisis de Datos","index":2,"n_rows":1231,"n_cols":17,"rows_kept":1231}
["En esta hoja se realizan los mismos análisis que pide la tarea del campus virtual, pero para la serie del PIB español a pesetas constantes de 1986."]
[]
[]
["Este primer ejercicio no es opcional: el alumno debe analizar la serie trimestral del PIB de algún país seleccionado. En nuestro caso, partiendo de los datos que nos hemos descargado, la serie del PIB a precios constantes."]
["del 86 aparece en la primera columna de los datos, damos los siguientes pasos."]
[]
[]
["Lo primero que haremos es seleccionar la columna de datos del PIb y copiarlas dándole un formato adecuado para su análisis y presentación posterior en el documento de word. La nueva serie está copiada en dos columnas: una en la que aparece el periodo y otra en la que aparece el PIB. El alumno tiene dos posibilidades de denominar el periodo:"]
[null,"a- El año correspondiente más Q seguido por el trimestre en el que el dato es recogido. Así 1970Q1 es la forma de denotar el dato correspondiente al primer trimestre de 1970,"]
[null,"b- Utilizar la fecha del día en el que termina el periodo del dato recogido. Así, el mismo dato que antes se denotaría por 31/03/1970 porque este es el último día del primer trimestre de 1970."]
["La diferencia entre ambos modos de denotar las fechas radica en que, como para excel las fechas son números (con el 1/1/1900=1), con el segundo formato  se pueden hacer cálculos (se pueden restar fechas, por ejemplo).  Además, el formato del gráfico"]
[" de la serie del PIB variará según el formato de fecha escogido."]
[]
[]
[{"$nulls":3},"DATOS ORIGINALES",null,null,"PRESENTACIÓN 1",null,null,"PRESENTACIÓN 2"]
[{"$nulls":4},"Producto Interior"]
[null,null,"año","trim","Bruto p.m.",null,"Periodo","PIB pm ",null,"Periodo","PIB pm"]
[null,null,1970,1,{"v":5098.7,"d":"5,098.700"},null,"1970Q1",{"$f":"E18","v":{"v":5098.7,"d":"5,098.700"}},null,"1970-03-31",{"$f":"E18","v":{"v":5098.7,"d":"5,098.700"}}]
[{"$nulls":3},2,{"v":5106.8,"d":"5,106.800"},null,"1970Q2",{"v":5106.8,"d":"5,106.800"},null,"1970-06-30",{"v":5106.8,"d":"5,106.800"}]
[{"$nulls":3},3,{"v":5132.9,"d":"5,132.900"},null,"1970Q3",{"v":5132.9,"d":"5,132.900"},null,"31/09/1970",{"v":5132.9,"d":"5,132.900"}]
[{"$nulls":3},4,{"v":5173.4,"d":"5,173.400"},null,"1970Q4",{"v":5173.4,"d":"5,173.400"},null,"1970-12-31",{"v":5173.4,"d":"5,173.400"}]
[null,null,1971,1,{"v":5213.8,"d":"5,213.800"},null,"1971Q1",{"v":5213.8,"d":"5,213.800"},null,"1971-03-31",{"v":5213.8,"d":"5,213.800"}]
[{"$nulls":3},2,{"v":5315.5,"d":"5,315.500"},null,"1971Q2",{"v":5315.5,"d":"5,315.500"},null,"1971-06-30",{"v":5315.5,"d":"5,315.500"}]
[{"$nulls":3},3,{"v":5413.3,"d":"5,413.300"},null,"1971Q3",{"v":5413.3,"d":"5,413.300"},null,"31/09/1971",{"v":5413.3,"d":"5,413.300"}]
[{"$nulls":3},4,{"v":5522.3,"d":"5,522.300"},null,"1971Q4",{"v":5522.3,"d":"5,522.300"},null,"1971-12-31",{"v":5522.3,"d":"5,522.300"}]
[null,null,1972,1,{"v":5611.9,"d":"5,611.900"},null,"1972Q1",{"v":5611.9,"d":"5,611.900"},null,{"$f":"J25+91","v":"1972-03-31"},{"v":5611.9,"d":"5,611.900"}]
[{"$nulls":3},2,{"v":5744.5,"d":"5,744.500"},null,"1972Q2",{"v":5744.5,"d":"5,744.500"},null,{"$f":"J26+91","v":"1972-06-30"},{"v":5744.5,"d":"5,744.500"}]
[{"$nulls":3},3,{"v":5870.7,"d":"5,870.700"},null,"1972Q3",{"v":5870.7,"d":"5,870.700"},null,{"$f":"J27+92","v":"1972-09-30"},{"v":5870.7,"d":"5,870.700"}]
[{"$nulls":3},4,{"v":5987,"d":"5,987.000"},null,"1972Q4",{"v":5987,"d":"5,987.000"},null,{"$f":"J28+92","v":"1972-12-31"},{"v":5987,"d":"5,987.000"}]
[null,null,1973,1,{"v":6097.2,"d":"6,097.200"},null,"1973Q1",{"v":6097.2,"d":"6,097.200"},null,{"$f":"J29+90","v":"1973-03-31"},{"v":6097.2,"d":"6,097.200"}]
[{"$nulls":3},2,{"v":6205.9,"d":"6,205.900"},null,"1973Q2",{"v":6205.9,"d":"6,205.900"},null,{"$f":"J30+91","v":"1973-06-30"},{"v":6205.9,"d":"6,205.900"}]
[{"$nulls":3},3,{"v":6308.4,"d":"6,308.400"},null,"1973Q3",{"v":6308.4,"d":"6,308.400"},null,{"$f":"J31+92","v":"1973-09-30"},{"v":6308.4,"d":"6,308.400"}]
[{"$nulls":3},4,{"v":6412.2,"d":"6,412.200"},null,"1973Q4",{"v":6412.2,"d":"6,412.200"},null,{"$f":"J32+92","v":"1973-12-31"},{"v":6412.2,"d":"6,412.200"}]
[null,null,1974,1,{"v":6521.1,"d":"6,521.100"},null,"1974Q1",{"v":6521.1,"d":"6,521.100"},null,{"$f":"J33+90","v":"1974-03-31"},{"v":6521.1,"d":"6,521.100"}]
[{"$nulls":3},2,{"v":6603.5,"d":"6,603.500"},null,"1974Q2",{"v":6603.5,"d":"6,603.500"},null,{"$f":"J34+91","v":"1974-06-30"},{"v":6603.5,"d":"6,603.500"}]
[{"$nulls":3},3,{"v":6650.1,"d":"6,650.100"},null,"1974Q3",{"v":6650.1,"d":"6,650.100"},null,{"$f":"J35+92","v":"1974-09-30"},{"v":6650.1,"d":"6,650.100"}]
[{"$nulls":3},4,{"v":6654.5,"d":"6,654.500"},null,"1974Q4",{"v":6654.5,"d":"6,654.500"},null,{"$f":"J36+92","v":"1974-12-31"},{"v":6654.5,"d":"6,654.500"}]
[null,null,1975,1,{"v":6621.1,"d":"6,621.100"},null,"1975Q1",{"v":6621.1,"d":"6,621.100"},null,{"$f":"J37+90","v":"1975-03-31"},{"v":6621.1,"d":"6,621.100"}]
[{"$nulls":3},2,{"v":6615.6,"d":"6,615.600"},null,"1975Q2",{"v":6615.6,"d":"6,615.600"},null,{"$f":"J38+91","v":"1975-06-30"},{"v":6615.6,"d":"6,615.600"}]
[{"$nulls":3},3,{"v":6644.5,"d":"6,644.500"},null,"1975Q3",{"v":6644.5,"d":"6,644.500"},null,{"$f":"J39+92","v":"1975-09-30"},{"v":6644.5,"d":"6,644.500"}]
[{"$nulls":3},4,{"v":6691.2,"d":"6,691.200"},null,"1975Q4",{"v":6691.2,"d":"6,691.200"},null,{"$f":"J40+92","v":"1975-12-31"},{"v":6691.2,"d":"6,691.200"}]
[null,null,1976,1,{"v":6757.7,"d":"6,757.700"},null,"1976Q1",{"v":6757.7,"d":"6,757.700"},null,{"$f":"J41+91","v":"1976-03-31"},{"v":6757.7,"d":"6,757.700"}]
[{"$nulls":3},2,{"v":6835.7,"d":"6,835.700"},null,"1976Q2",{"v":6835.7,"d":"6,835.700"},null,{"$f":"J42+91","v":"1976-06-30"},{"v":6835.7,"d":"6,835.700"}]
[{"$nulls":3},3,{"v":6902,"d":"6,902.000"},null,"1976Q3",{"v":6902,"d":"6,902.000"},null,{"$f":"J43+92","v":"1976-09-30"},{"v":6902,"d":"6,902.000"}]
[{"$nulls":3},4,{"v":6955,"d":"6,955.000"},null,"1976Q4",{"v":6955,"d":"6,955.000"},null,{"$f":"J44+92","v":"1976-12-31"},{"v":6955,"d":"6,955.000"}]
[null,null,1977,1,{"v":7010.1,"d":"7,010.100"},null,"1977Q1",{"v":7010.1,"d":"7,010.100"},null,{"$f":"J45+90","v":"1977-03-31"},{"v":7010.1,"d":"7,010.100"}]
[{"$nulls":3},2,{"v":7041.9,"d":"7,041.900"},null,"1977Q2",{"v":7041.9,"d":"7,041.900"},null,{"$f":"J46+91","v":"1977-06-30"},{"v":7041.9,"d":"7,041.900"}]
[{"$nulls":3},3,{"v":7065.3,"d":"7,065.300"},null,"1977Q3",{"v":7065.3,"d":"7,065.300"},null,{"$f":"J47+92","v":"1977-09-30"},{"v":7065.3,"d":"7,065.300"}]
[{"$nulls":3},4,{"v":7112.5,"d":"7,112.500"},null,"1977Q4",{"v":7112.5,"d":"7,112.500"},null,{"$f":"J48+92","v":"1977-12-31"},{"v":7112.5,"d":"7,112.500"}]
[null,null,1978,1,{"v":7156.9,"d":"7,156.900"},null,"1978Q1",{"$f":"E50","v":{"v":7156.9,"d":"7,156.900"}},null,{"$f":"J49+90","v":"1978-03-31"},{"$f":"E50","v":{"v":7156.9,"d":"7,156.900"}}]
[{"$nulls":3},2,{"v":7171.4,"d":"7,171.400"},null,"1978Q2",{"v":7171.4,"d":"7,171.400"},null,{"$f":"J50+91","v":"1978-06-30"},{"v":7171.4,"d":"7,171.400"}]
[{"$nulls":3},3,{"v":7162.6,"d":"7,162.600"},null,"1978Q3",{"v":7162.6,"d":"7,162.600"},null,{"$f":"J51+92","v":"1978-09-30"},{"v":7162.6,"d":"7,162.600"}]
[{"$nulls":3},4,{"v":7152,"d":"7,152.000"},null,"1978Q4",{"v":7152,"d":"7,152.000"},null,{"$f":"J52+92","v":"1978-12-31"},{"v":7152,"d":"7,152.000"}]
[null,null,1979,1,{"v":7140.6,"d":"7,140.600"},null,"1979Q1",{"v":7140.6,"d":"7,140.600"},null,{"$f":"J53+90","v":"1979-03-31"},{"v":7140.6,"d":"7,140.600"}]
[{"$nulls":3},2,{"v":7151.7,"d":"7,151.700"},null,"1979Q2",{"v":7151.7,"d":"7,151.700"},null,{"$f":"J54+91","v":"1979-06-30"},{"v":7151.7,"d":"7,151.700"}]
[{"$nulls":3},3,{"v":7168.9,"d":"7,168.900"},null,"1979Q3",{"v":7168.9,"d":"7,168.900"},null,{"$f":"J55+92","v":"1979-09-30"},{"v":7168.9,"d":"7,168.900"}]
[{"$nulls":3},4,{"v":7194.1,"d":"7,194.100"},null,"1979Q4",{"v":7194.1,"d":"7,194.100"},null,{"$f":"J56+92","v":"1979-12-31"},{"v":7194.1,"d":"7,194.100"}]
[null,null,1980,1,{"v":7225.6,"d":"7,225.600"},null,"1980Q1",{"v":7225.6,"d":"7,225.600"},null,{"$f":"J57+91","v":"1980-03-31"},{"v":7225.6,"d":"7,225.600"}]
[{"$nulls":3},2,{"v":7270.8,"d":"7,270.800"},null,"1980Q2",{"v":7270.8,"d":"7,270.800"},null,{"$f":"J58+91","v":"1980-06-30"},{"v":7270.8,"d":"7,270.800"}]
[{"$nulls":3},3,{"v":7280.5,"d":"7,280.500"},null,"1980Q3",{"v":7280.5,"d":"7,280.500"},null,{"$f":"J59+92","v":"1980-09-30"},{"v":7280.5,"d":"7,280.500"}]
[{"$nulls":3},4,{"v":7250.4,"d":"7,250.400"},null,"1980Q4",{"v":7250.4,"d":"7,250.400"},null,{"$f":"J60+92","v":"1980-12-31"},{"v":7250.4,"d":"7,250.400"}]
[null,null,1981,1,{"v":7188.7,"d":"7,188.700"},null,"1981Q1",{"v":7188.7,"d":"7,188.700"},null,{"$f":"J61+90","v":"1981-03-31"},{"v":7188.7,"d":"7,188.700"}]
[{"$nulls":3},2,{"v":7219.7,"d":"7,219.700"},null,"1981Q2",{"v":7219.7,"d":"7,219.700"},null,{"$f":"J62+91","v":"1981-06-30"},{"v":7219.7,"d":"7,219.700"}]
[{"$nulls":3},3,{"v":7281.8,"d":"7,281.800"},null,"1981Q3",{"v":7281.8,"d":"7,281.800"},null,{"$f":"J63+92","v":"1981-09-30"},{"v":7281.8,"d":"7,281.800"}]
[{"$nulls":3},4,{"v":7286.6,"d":"7,286.600"},null,"1981Q4",{"v":7286.6,"d":"7,286.600"},null,{"$f":"J64+92","v":"1981-12-31"},{"v":7286.6,"d":"7,286.600"}]
[null,null,1982,1,{"v":7291.1,"d":"7,291.100"},null,"1982Q1",{"v":7291.1,"d":"7,291.100"},null,{"$f":"J65+90","v":"1982-03-31"},{"v":7291.1,"d":"7,291.100"}]
[{"$nulls":3},2,{"v":7331.5,"d":"7,331.500"},null,"1982Q2",{"v":7331.5,"d":"7,331.500"},null,{"$f":"J66+91","v":"1982-06-30"},{"v":7331.5,"d":"7,331.500"}]
[{"$nulls":3},3,{"v":7393.6,"d":"7,393.600"},null,"1982Q3",{"v":7393.6,"d":"7,393.600"},null,{"$f":"J67+92","v":"1982-09-30"},{"v":7393.6,"d":"7,393.600"}]
[{"$nulls":3},4,{"v":7413.2,"d":"7,413.200"},null,"1982Q4",{"v":7413.2,"d":"7,413.200"},null,{"$f":"J68+92","v":"1982-12-31"},{"v":7413.2,"d":"7,413.200"}]
[null,null,1983,1,{"v":7443.3,"d":"7,443.300"},null,"1983Q1",{"v":7443.3,"d":"7,443.300"},null,{"$f":"J69+90","v":"1983-03-31"},{"v":7443.3,"d":"7,443.300"}]
[{"$nulls":3},2,{"v":7501.9,"d":"7,501.900"},null,"1983Q2",{"v":7501.9,"d":"7,501.900"},null,{"$f":"J70+91","v":"1983-06-30"},{"v":7501.9,"d":"7,501.900"}]
[{"$nulls":3},3,{"v":7560.1,"d":"7,560.100"},null,"1983Q3",{"v":7560.1,"d":"7,560.100"},null,{"$f":"J71+92","v":"1983-09-30"},{"v":7560.1,"d":"7,560.100"}]
[{"$nulls":3},4,{"v":7578.1,"d":"7,578.100"},null,"1983Q4",{"v":7578.1,"d":"7,578.100"},null,{"$f":"J72+92","v":"1983-12-31"},{"v":7578.1,"d":"7,578.100"}]
[null,null,1984,1,{"v":7576.5,"d":"7,576.500"},null,"1984Q1",{"v":7576.5,"d":"7,576.500"},null,{"$f":"J73+91","v":"1984-03-31"},{"v":7576.5,"d":"7,576.500"}]
[{"$nulls":3},2,{"v":7609.1,"d":"7,609.100"},null,"1984Q2",{"v":7609.1,"d":"7,609.100"},null,{"$f":"J74+91","v":"1984-06-30"},{"v":7609.1,"d":"7,609.100"}]
[{"$nulls":3},3,{"v":7652.7,"d":"7,652.700"},null,"1984Q3",{"v":7652.7,"d":"7,652.700"},null,{"$f":"J75+92","v":"1984-09-30"},{"v":7652.7,"d":"7,652.700"}]
[{"$nulls":3},4,{"v":7686.1,"d":"7,686.100"},null,"1984Q4",{"v":7686.1,"d":"7,686.100"},null,{"$f":"J76+92","v":"1984-12-31"},{"v":7686.1,"d":"7,686.100"}]
[null,null,1985,1,{"v":7739.9,"d":"7,739.900"},null,"1985Q1",{"v":7739.9,"d":"7,739.900"},null,{"$f":"J77+90","v":"1985-03-31"},{"v":7739.9,"d":"7,739.900"}]
[{"$nulls":3},2,{"v":7802.1,"d":"7,802.100"},null,"1985Q2",{"v":7802.1,"d":"7,802.100"},null,{"$f":"J78+91","v":"1985-06-30"},{"v":7802.1,"d":"7,802.100"}]
[{"$nulls":3},3,{"v":7872.5,"d":"7,872.500"},null,"1985Q3",{"v":7872.5,"d":"7,872.500"},null,{"$f":"J79+92","v":"1985-09-30"},{"v":7872.5,"d":"7,872.500"}]
[{"$nulls":3},4,{"v":7907.3,"d":"7,907.300"},null,"1985Q4",{"v":7907.3,"d":"7,907.300"},null,{"$f":"J80+92","v":"1985-12-31"},{"v":7907.3,"d":"7,907.300"}]
[null,null,1986,1,{"v":7958.597,"d":"7,958.597"},null,"1986Q1",{"v":7958.597,"d":"7,958.597"},null,{"$f":"J81+90","v":"1986-03-31"},{"v":7958.597,"d":"7,958.597"}]
[{"$nulls":3},2,{"v":8031.7,"d":"8,031.700"},null,"1986Q2",{"$f":"E83","v":{"v":8031.7,"d":"8,031.700"}},null,{"$f":"J82+91","v":"1986-06-30"},{"$f":"E83","v":{"v":8031.7,"d":"8,031.700"}}]
[{"$nulls":3},3,{"v":8118.6,"d":"8,118.600"},null,"1986Q3",{"v":8118.6,"d":"8,118.600"},null,{"$f":"J83+92","v":"1986-09-30"},{"v":8118.6,"d":"8,118.600"}]
[{"$nulls":3},4,{"v":8215.095,"d":"8,215.095"},null,"1986Q4",{"v":8215.095,"d":"8,215.095"},null,{"$f":"J84+92","v":"1986-12-31"},{"v":8215.095,"d":"8,215.095"}]
[null,null,1987,1,{"v":8341.175,"d":"8,341.175"},null,"1987Q1",{"v":8341.175,"d":"8,341.175"},null,{"$f":"J85+90","v":"1987-03-31"},{"v":8341.175,"d":"8,341.175"}]
[{"$nulls":3},2,{"v":8478.003,"d":"8,478.003"},null,"1987Q2",{"v":8478.003,"d":"8,478.003"},null,{"$f":"J86+91","v":"1987-06-30"},{"v":8478.003,"d":"8,478.003"}]
[{"$nulls":3},3,{"v":8611.098,"d":"8,611.098"},null,"1987Q3",{"v":8611.098,"d":"8,611.098"},null,{"$f":"J87+92","v":"1987-09-30"},{"v":8611.098,"d":"8,611.098"}]
[{"$nulls":3},4,{"v":8717.239,"d":"8,717.239"},null,"1987Q4",{"v":8717.239,"d":"8,717.239"},null,{"$f":"J88+92","v":"1987-12-31"},{"v":8717.239,"d":"8,717.239"}]
[null,null,1988,1,{"v":8814.089,"d":"8,814.089"},null,"1988Q1",{"v":8814.089,"d":"8,814.089"},null,{"$f":"J89+91","v":"1988-03-31"},{"v":8814.089,"d":"8,814.089"}]
[{"$nulls":3},2,{"v":8931.979,"d":"8,931.979"},null,"1988Q2",{"v":8931.979,"d":"8,931.979"},null,{"$f":"J90+91","v":"1988-06-30"},{"v":8931.979,"d":"8,931.979"}]
[{"$nulls":3},3,{"v":9031.254,"d":"9,031.254"},null,"1988Q3",{"v":9031.254,"d":"9,031.254"},null,{"$f":"J91+92","v":"1988-09-30"},{"v":9031.254,"d":"9,031.254"}]
[{"$nulls":3},4,{"v":9132.705,"d":"9,132.705"},null,"1988Q4",{"v":9132.705,"d":"9,132.705"},null,{"$f":"J92+92","v":"1988-12-31"},{"v":9132.705,"d":"9,132.705"}]
[null,null,1989,1,{"v":9244.954,"d":"9,244.954"},null,"1989Q1",{"v":9244.954,"d":"9,244.954"},null,{"$f":"J93+90","v":"1989-03-31"},{"v":9244.954,"d":"9,244.954"}]
[{"$nulls":3},2,{"v":9355.919,"d":"9,355.919"},null,"1989Q2",{"v":9355.919,"d":"9,355.919"},null,{"$f":"J94+91","v":"1989-06-30"},{"v":9355.919,"d":"9,355.919"}]
[{"$nulls":3},3,{"v":9457.422,"d":"9,457.422"},null,"1989Q3",{"v":9457.422,"d":"9,457.422"},null,{"$f":"J95+92","v":"1989-09-30"},{"v":9457.422,"d":"9,457.422"}]
[{"$nulls":3},4,{"v":9553.114,"d":"9,553.114"},null,"1989Q4",{"v":9553.114,"d":"9,553.114"},null,{"$f":"J96+92","v":"1989-12-31"},{"v":9553.114,"d":"9,553.114"}]
[null,null,1990,1,{"v":9642.296,"d":"9,642.296"},null,"1990Q1",{"v":9642.296,"d":"9,642.296"},null,{"$f":"J97+90","v":"1990-03-31"},{"v":9642.296,"d":"9,642.296"}]
[{"$nulls":3},2,{"v":9722.119,"d":"9,722.119"},null,"1990Q2",{"v":9722.119,"d":"9,722.119"},null,{"$f":"J98+91","v":"1990-06-30"},{"v":9722.119,"d":"9,722.119"}]
[{"$nulls":3},3,{"v":9802.427,"d":"9,802.427"},null,"1990Q3",{"v":9802.427,"d":"9,802.427"},null,{"$f":"J99+92","v":"1990-09-30"},{"v":9802.427,"d":"9,802.427"}]
[{"$nulls":3},4,{"v":9851.455,"d":"9,851.455"},null,"1990Q4",{"v":9851.455,"d":"9,851.455"},null,{"$f":"J100+92","v":"1990-12-31"},{"v":9851.455,"d":"9,851.455"}]
[null,null,1991,1,{"v":9888.737,"d":"9,888.737"},null,"1991Q1",{"v":9888.737,"d":"9,888.737"},null,{"$f":"J101+90","v":"1991-03-31"},{"v":9888.737,"d":"9,888.737"}]
[{"$nulls":3},2,{"v":9947.364,"d":"9,947.364"},null,"1991Q2",{"v":9947.364,"d":"9,947.364"},null,{"$f":"J102+91","v":"1991-06-30"},{"v":9947.364,"d":"9,947.364"}]
[{"$nulls":3},3,{"v":10016.847,"d":"10,016.847"},null,"1991Q3",{"v":10016.847,"d":"10,016.847"},null,{"$f":"J103+92","v":"1991-09-30"},{"v":10016.847,"d":"10,016.847"}]
[{"$nulls":3},4,{"v":10050.227,"d":"10,050.227"},null,"1991Q4",{"v":10050.227,"d":"10,050.227"},null,{"$f":"J104+92","v":"1991-12-31"},{"v":10050.227,"d":"10,050.227"}]
[null,null,1992,1,{"v":10070.344,"d":"10,070.344"},null,"1992Q1",{"v":10070.344,"d":"10,070.344"},null,{"$f":"J105+91","v":"1992-03-31"},{"v":10070.344,"d":"10,070.344"}]
[{"$nulls":3},2,{"v":10075.613,"d":"10,075.613"},null,"1992Q2",{"v":10075.613,"d":"10,075.613"},null,{"$f":"J106+91","v":"1992-06-30"},{"v":10075.613,"d":"10,075.613"}]
[{"$nulls":3},3,{"v":10044.635,"d":"10,044.635"},null,"1992Q3",{"v":10044.635,"d":"10,044.635"},null,{"$f":"J107+92","v":"1992-09-30"},{"v":10044.635,"d":"10,044.635"}]
[{"$nulls":3},4,{"v":9986.851,"d":"9,986.851"},null,"1992Q4",{"v":9986.851,"d":"9,986.851"},null,{"$f":"J108+92","v":"1992-12-31"},{"v":9986.851,"d":"9,986.851"}]
[null,null,1993,1,{"v":9937.692,"d":"9,937.692"},null,"1993Q1",{"v":9937.692,"d":"9,937.692"},null,{"$f":"J109+90","v":"1993-03-31"},{"v":9937.692,"d":"9,937.692"}]
[{"$nulls":3},2,{"v":9907.366,"d":"9,907.366"},null,"1993Q2",{"v":9907.366,"d":"9,907.366"},null,{"$f":"J110+91","v":"1993-06-30"},{"v":9907.366,"d":"9,907.366"}]
[{"$nulls":3},3,{"v":9906.048,"d":"9,906.048"},null,"1993Q3",{"v":9906.048,"d":"9,906.048"},null,{"$f":"J111+92","v":"1993-09-30"},{"v":9906.048,"d":"9,906.048"}]
[{"$nulls":3},4,{"v":9958.927,"d":"9,958.927"},null,"1993Q4",{"v":9958.927,"d":"9,958.927"},null,{"$f":"J112+92","v":"1993-12-31"},{"v":9958.927,"d":"9,958.927"}]
[null,null,1994,1,{"v":10037.915,"d":"10,037.915"},null,"1994Q1",{"v":10037.915,"d":"10,037.915"},null,{"$f":"J113+90","v":"1994-03-31"},{"v":10037.915,"d":"10,037.915"}]
[{"$nulls":3},2,{"v":10115.36,"d":"10,115.360"},null,"1994Q2",{"v":10115.36,"d":"10,115.360"},null,{"$f":"J114+91","v":"1994-06-30"},{"v":10115.36,"d":"10,115.360"}]
[{"$nulls":3},3,{"v":10187.088,"d":"10,187.088"},null,"1994Q3",{"v":10187.088,"d":"10,187.088"},null,{"$f":"J115+92","v":"1994-09-30"},{"v":10187.088,"d":"10,187.088"}]
[{"$nulls":3},4,{"v":10263.644,"d":"10,263.644"},null,"1994Q4",{"v":10263.644,"d":"10,263.644"},null,{"$f":"J116+92","v":"1994-12-31"},{"v":10263.644,"d":"10,263.644"}]
[null,null,1995,1,{"v":10340.936,"d":"10,340.936"},null,"1995Q1",{"v":10340.936,"d":"10,340.936"},null,{"$f":"J117+90","v":"1995-03-31"},{"v":10340.936,"d":"10,340.936"}]
[{"$nulls":3},2,{"v":10410.88,"d":"10,410.880"},null,"1995Q2",{"v":10410.88,"d":"10,410.880"},null,{"$f":"J118+91","v":"1995-06-30"},{"v":10410.88,"d":"10,410.880"}]
[{"$nulls":3},3,{"v":10457.463,"d":"10,457.463"},null,"1995Q3",{"v":10457.463,"d":"10,457.463"},null,{"$f":"J119+92","v":"1995-09-30"},{"v":10457.463,"d":"10,457.463"}]
[{"$nulls":3},4,{"v":10497.647,"d":"10,497.647"},null,"1995Q4",{"v":10497.647,"d":"10,497.647"},null,{"$f":"J120+92","v":"1995-12-31"},{"v":10497.647,"d":"10,497.647"}]
[null,null,1996,1,{"v":10559.095,"d":"10,559.095"},null,"1996Q1",{"v":10559.095,"d":"10,559.095"},null,{"$f":"J121+91","v":"1996-03-31"},{"v":10559.095,"d":"10,559.095"}]
[{"$nulls":3},2,{"v":10635.522,"d":"10,635.522"},null,"1996Q2",{"v":10635.522,"d":"10,635.522"},null,{"$f":"J122+91","v":"1996-06-30"},{"v":10635.522,"d":"10,635.522"}]
[{"$nulls":3},3,{"v":10717.783,"d":"10,717.783"},null,"1996Q3",{"v":10717.783,"d":"10,717.783"},null,{"$f":"J123+92","v":"1996-09-30"},{"v":10717.783,"d":"10,717.783"}]
[{"$nulls":3},4,{"v":10802.949,"d":"10,802.949"},null,"1996Q4",{"v":10802.949,"d":"10,802.949"},null,{"$f":"J124+92","v":"1996-12-31"},{"v":10802.949,"d":"10,802.949"}]
[null,null,1997,1,{"v":10896.711,"d":"10,896.711"},null,"1997Q1",{"v":10896.711,"d":"10,896.711"},null,{"$f":"J125+90","v":"1997-03-31"},{"v":10896.711,"d":"10,896.711"}]
[{"$nulls":3},2,{"v":10998.575,"d":"10,998.575"},null,"1997Q2",{"v":10998.575,"d":"10,998.575"},null,{"$f":"J126+91","v":"1997-06-30"},{"v":10998.575,"d":"10,998.575"}]
[{"$nulls":3},3,{"v":11111.611,"d":"11,111.611"},null,"1997Q3",{"v":11111.611,"d":"11,111.611"},null,{"$f":"J127+92","v":"1997-09-30"},{"v":11111.611,"d":"11,111.611"}]
[{"$nulls":3},4,{"v":11217.216,"d":"11,217.216"},null,"1997Q4",{"v":11217.216,"d":"11,217.216"},null,{"$f":"J128+92","v":"1997-12-31"},{"v":11217.216,"d":"11,217.216"}]
[null,null,1998,1,{"v":11320.396,"d":"11,320.396"},null,"1998Q1",{"v":11320.396,"d":"11,320.396"},null,{"$f":"J129+90","v":"1998-03-31"},{"v":11320.396,"d":"11,320.396"}]
[{"$nulls":3},2,{"v":11428.749,"d":"11,428.749"},null,"1998Q2",{"v":11428.749,"d":"11,428.749"},null,{"$f":"J130+91","v":"1998-06-30"},{"v":11428.749,"d":"11,428.749"}]
[{"$nulls":3},3,{"v":11532.808,"d":"11,532.808"},null,"1998Q3",{"v":11532.808,"d":"11,532.808"},null,{"$f":"J131+92","v":"1998-09-30"},{"v":11532.808,"d":"11,532.808"}]
[{"$nulls":3},4,{"v":11618.697,"d":"11,618.697"},null,"1998Q4",{"v":11618.697,"d":"11,618.697"},null,{"$f":"J132+92","v":"1998-12-31"},{"v":11618.697,"d":"11,618.697"}]
[]
[]
[]
["En este paso añadiremos dos columnas más a nuestra serie: una en la que calcularemos el logaritmo neperiano de los datos originales y otra en la que calcularemos la diferencia trimestral del PIB."]
[null,"Paso 1: Cálculo del LN del PIB. Las series temporales se suelen transformar de esta manera para estabilizar la variabilidad de los datos. Para ello, utilizamos la función de excel LN() "]
[null,"Paso 2: Cálculo de la variación trimestral del PIB. Calculamos la serie diferencia del PIB (ΔPIB) restando al dato de un periodo el dato del periodo anterior y multiplicando el resultado por 100."]
["Una vez dados estos dos pasos, nuestros datos quedan como siguen:"]
[]
[null,null,"PRESENTACIÓN 1",{"$nulls":4},"PRESENTACIÓN 2"]
[]
[null,null,"Periodo","PIB pm ","LN(PIB)","ΔPIB",null,"Periodo","PIB pm","LN(PIB)","ΔPIB"]
[null,null,"1970Q1",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(D145)","v":8.536740884258606},null,null,"1970-03-31",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(I145)","v":8.536740884258606}]
[null,null,"1970Q2",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(D146)","v":8.538328263946196},{"$f":"(E146-E145)*100","v":0.15873796875904844},null,"1970-06-30",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(I146)","v":8.538328263946196},{"$f":"(J146-J145)*100","v":0.15873796875904844}]
[null,null,"1970Q3",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(E147-E146)*100","v":0.5097816639802133},null,"31/09/1970",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(J147-J146)*100","v":0.5097816639802133}]
[null,null,"1970Q4",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629,null,"1970-12-31",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629]
[null,null,"1971Q1",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691,null,"1971-03-31",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691]
[null,null,"1971Q2",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763,null,"1971-06-30",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763]
[null,null,"1971Q3",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723,null,"31/09/1971",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723]
[null,null,"1971Q4",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813,null,"1971-12-31",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813]
[null,null,"1972Q1",{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977,null,{"$f":"H152+91","v":"1972-03-31"},{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977]
[null,null,"1972Q2",{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555,null,{"$f":"H153+91","v":"1972-06-30"},{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555]
[null,null,"1972Q3",{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044,null,{"$f":"H154+92","v":"1972-09-30"},{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044]
[null,null,"1972Q4",{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897,null,{"$f":"H155+92","v":"1972-12-31"},{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897]
[null,null,"1973Q1",{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934,null,{"$f":"H156+90","v":"1973-03-31"},{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934]
[null,null,"1973Q2",{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583,null,{"$f":"H157+91","v":"1973-06-30"},{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583]
[null,null,"1973Q3",{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803,null,{"$f":"H158+92","v":"1973-09-30"},{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803]
[null,null,"1973Q4",{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789,null,{"$f":"H159+92","v":"1973-12-31"},{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789]
[null,null,"1974Q1",{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282,null,{"$f":"H160+90","v":"1974-03-31"},{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282]
[null,null,"1974Q2",{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368,null,{"$f":"H161+91","v":"1974-06-30"},{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368]
[null,null,"1974Q3",{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703,null,{"$f":"H162+92","v":"1974-09-30"},{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703]
[null,null,"1974Q4",{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158,null,{"$f":"H163+92","v":"1974-12-31"},{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158]
[null,null,"1975Q1",{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404,null,{"$f":"H164+90","v":"1975-03-31"},{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404]
[null,null,"1975Q2",{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585,null,{"$f":"H165+91","v":"1975-06-30"},{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585]
[null,null,"1975Q3",{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723,null,{"$f":"H166+92","v":"1975-09-30"},{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723]
[null,null,"1975Q4",{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598,null,{"$f":"H167+92","v":"1975-12-31"},{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598]
[null,null,"1976Q1",{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032,null,{"$f":"H168+91","v":"1976-03-31"},{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032]
[null,null,"1976Q2",{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884,null,{"$f":"H169+91","v":"1976-06-30"},{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884]
[null,null,"1976Q3",{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595,null,{"$f":"H170+92","v":"1976-09-30"},{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595]
[null,null,"1976Q4",{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861,null,{"$f":"H171+92","v":"1976-12-31"},{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861]
[null,null,"1977Q1",{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943,null,{"$f":"H172+90","v":"1977-03-31"},{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943]
[null,null,"1977Q2",{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364,null,{"$f":"H173+91","v":"1977-06-30"},{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364]
[null,null,"1977Q3",{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603,null,{"$f":"H174+92","v":"1977-09-30"},{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603]
[null,null,"1977Q4",{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023,null,{"$f":"H175+92","v":"1977-12-31"},{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023]
[null,null,"1978Q1",{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076,null,{"$f":"H176+90","v":"1978-03-31"},{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076]
[null,null,"1978Q2",{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176,null,{"$f":"H177+91","v":"1978-06-30"},{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176]
[null,null,"1978Q3",{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975,null,{"$f":"H178+92","v":"1978-09-30"},{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975]
[null,null,"1978Q4",{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787,null,{"$f":"H179+92","v":"1978-12-31"},{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787]
[null,null,"1979Q1",{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563,null,{"$f":"H180+90","v":"1979-03-31"},{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563]
[null,null,"1979Q2",{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175,null,{"$f":"H181+91","v":"1979-06-30"},{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175]
[null,null,"1979Q3",{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773,null,{"$f":"H182+92","v":"1979-09-30"},{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773]
[null,null,"1979Q4",{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054,null,{"$f":"H183+92","v":"1979-12-31"},{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054]
[null,null,"1980Q1",{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793,null,{"$f":"H184+91","v":"1980-03-31"},{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793]
[null,null,"1980Q2",{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892,null,{"$f":"H185+91","v":"1980-06-30"},{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892]
[null,null,"1980Q3",{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484,null,{"$f":"H186+92","v":"1980-09-30"},{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484]
[null,null,"1980Q4",{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978,null,{"$f":"H187+92","v":"1980-12-31"},{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978]
[null,null,"1981Q1",{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577,null,{"$f":"H188+90","v":"1981-03-31"},{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577]
[null,null,"1981Q2",{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049,null,{"$f":"H189+91","v":"1981-06-30"},{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049]
[null,null,"1981Q3",{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752,null,{"$f":"H190+92","v":"1981-09-30"},{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752]
[null,null,"1981Q4",{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758,null,{"$f":"H191+92","v":"1981-12-31"},{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758]
[null,null,"1982Q1",{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365,null,{"$f":"H192+90","v":"1982-03-31"},{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365]
[null,null,"1982Q2",{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072,null,{"$f":"H193+91","v":"1982-06-30"},{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072]
[null,null,"1982Q3",{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269,null,{"$f":"H194+92","v":"1982-09-30"},{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269]
[null,null,"1982Q4",{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516,null,{"$f":"H195+92","v":"1982-12-31"},{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516]
[null,null,"1983Q1",{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944,null,{"$f":"H196+90","v":"1983-03-31"},{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944]
[null,null,"1983Q2",{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303,null,{"$f":"H197+91","v":"1983-06-30"},{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303]
[null,null,"1983Q3",{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829,null,{"$f":"H198+92","v":"1983-09-30"},{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829]
[null,null,"1983Q4",{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303,null,{"$f":"H199+92","v":"1983-12-31"},{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303]
[null,null,"1984Q1",{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464,null,{"$f":"H200+91","v":"1984-03-31"},{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464]
[null,null,"1984Q2",{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617,null,{"$f":"H201+91","v":"1984-06-30"},{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617]
[null,null,"1984Q3",{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272,null,{"$f":"H202+92","v":"1984-09-30"},{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272]
[null,null,"1984Q4",{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835,null,{"$f":"H203+92","v":"1984-12-31"},{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835]
[null,null,"1985Q1",{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985,null,{"$f":"H204+90","v":"1985-03-31"},{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985]
[null,null,"1985Q2",{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039,null,{"$f":"H205+91","v":"1985-06-30"},{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039]
[null,null,"1985Q3",{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418,null,{"$f":"H206+92","v":"1985-09-30"},{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418]
[null,null,"1985Q4",{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954,null,{"$f":"H207+92","v":"1985-12-31"},{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954]
[null,null,"1986Q1",{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934,null,{"$f":"H208+90","v":"1986-03-31"},{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934]
[null,null,"1986Q2",{"v":8031.7,"d":"8,031.700"},{"$f":"LN(D210)","v":8.99115149063635},0.9143483614291625,null,{"$f":"H209+91","v":"1986-06-30"},{"v":8031.7,"d":"8,031.700"},{"$f":"LN(I210)","v":8.99115149063635},0.9143483614291625]
[null,null,"1986Q3",{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(E211-E210)*100","v":1.0761513861304195},null,{"$f":"H210+92","v":"1986-09-30"},{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(J211-J210)*100","v":1.0761513861304195}]
[null,null,"1986Q4",{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516,null,{"$f":"H211+92","v":"1986-12-31"},{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516]
[null,null,"1987Q1",{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769,null,{"$f":"H212+90","v":"1987-03-31"},{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769]
[null,null,"1987Q2",{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429,null,{"$f":"H213+91","v":"1987-06-30"},{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429]
[null,null,"1987Q3",{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832,null,{"$f":"H214+92","v":"1987-09-30"},{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832]
[null,null,"1987Q4",{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122,null,{"$f":"H215+92","v":"1987-12-31"},{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122]
[null,null,"1988Q1",{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058,null,{"$f":"H216+91","v":"1988-03-31"},{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058]
[null,null,"1988Q2",{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193,null,{"$f":"H217+91","v":"1988-06-30"},{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193]
[null,null,"1988Q3",{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435,null,{"$f":"H218+92","v":"1988-09-30"},{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435]
[null,null,"1988Q4",{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376,null,{"$f":"H219+92","v":"1988-12-31"},{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376]
[null,null,"1989Q1",{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368,null,{"$f":"H220+90","v":"1989-03-31"},{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368]
[null,null,"1989Q2",{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473,null,{"$f":"H221+91","v":"1989-06-30"},{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473]
[null,null,"1989Q3",{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208,null,{"$f":"H222+92","v":"1989-09-30"},{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208]
[null,null,"1989Q4",{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242,null,{"$f":"H223+92","v":"1989-12-31"},{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242]
[null,null,"1990Q1",{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859,null,{"$f":"H224+90","v":"1990-03-31"},{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859]
[null,null,"1990Q2",{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117,null,{"$f":"H225+91","v":"1990-06-30"},{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117]
[null,null,"1990Q3",{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913,null,{"$f":"H226+92","v":"1990-09-30"},{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913]
[null,null,"1990Q4",{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678,null,{"$f":"H227+92","v":"1990-12-31"},{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678]
[null,null,"1991Q1",{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637,null,{"$f":"H228+90","v":"1991-03-31"},{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637]
[null,null,"1991Q2",{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469,null,{"$f":"H229+91","v":"1991-06-30"},{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469]
[null,null,"1991Q3",{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081,null,{"$f":"H230+92","v":"1991-09-30"},{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081]
[null,null,"1991Q4",{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752,null,{"$f":"H231+92","v":"1991-12-31"},{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752]
[null,null,"1992Q1",{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655,null,{"$f":"H232+91","v":"1992-03-31"},{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655]
[null,null,"1992Q2",{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152,null,{"$f":"H233+91","v":"1992-06-30"},{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152]
[null,null,"1992Q3",{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002,null,{"$f":"H234+92","v":"1992-09-30"},{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002]
[null,null,"1992Q4",{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834,null,{"$f":"H235+92","v":"1992-12-31"},{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834]
[null,null,"1993Q1",{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656,null,{"$f":"H236+90","v":"1993-03-31"},{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656]
[null,null,"1993Q2",{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506,null,{"$f":"H237+91","v":"1993-06-30"},{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506]
[null,null,"1993Q3",{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561,null,{"$f":"H238+92","v":"1993-09-30"},{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561]
[null,null,"1993Q4",{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101,null,{"$f":"H239+92","v":"1993-12-31"},{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101]
[null,null,"1994Q1",{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413,null,{"$f":"H240+90","v":"1994-03-31"},{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413]
[null,null,"1994Q2",{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256,null,{"$f":"H241+91","v":"1994-06-30"},{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256]
[null,null,"1994Q3",{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894,null,{"$f":"H242+92","v":"1994-09-30"},{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894]
[null,null,"1994Q4",{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251,null,{"$f":"H243+92","v":"1994-12-31"},{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251]
[null,null,"1995Q1",{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298,null,{"$f":"H244+90","v":"1995-03-31"},{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298]
[null,null,"1995Q2",{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444,null,{"$f":"H245+91","v":"1995-06-30"},{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444]
[null,null,"1995Q3",{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747,null,{"$f":"H246+92","v":"1995-09-30"},{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747]
[null,null,"1995Q4",{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494,null,{"$f":"H247+92","v":"1995-12-31"},{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494]
[null,null,"1996Q1",{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116,null,{"$f":"H248+91","v":"1996-03-31"},{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116]
[null,null,"1996Q2",{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627,null,{"$f":"H249+91","v":"1996-06-30"},{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627]
[null,null,"1996Q3",{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521,null,{"$f":"H250+92","v":"1996-09-30"},{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521]
[null,null,"1996Q4",{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168,null,{"$f":"H251+92","v":"1996-12-31"},{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168]
[null,null,"1997Q1",{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192,null,{"$f":"H252+90","v":"1997-03-31"},{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192]
[null,null,"1997Q2",{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234,null,{"$f":"H253+91","v":"1997-06-30"},{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234]
[null,null,"1997Q3",{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345,null,{"$f":"H254+92","v":"1997-09-30"},{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345]
[null,null,"1997Q4",{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602,null,{"$f":"H255+92","v":"1997-12-31"},{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602]
[null,null,"1998Q1",{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454,null,{"$f":"H256+90","v":"1998-03-31"},{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454]
[null,null,"1998Q2",{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841,null,{"$f":"H257+91","v":"1998-06-30"},{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841]
[null,null,"1998Q3",{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293,null,{"$f":"H258+92","v":"1998-09-30"},{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293]
[null,null,"1998Q4",{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846,null,{"$f":"H259+92","v":"1998-12-31"},{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846]
[]
[]
[]
[]
["El siguiente paso del análisis consiste en clasificar las distintas fases del ciclo en las que se puede encontrar el PIB. Para ello tenemos que detectar en la serie anterior cuándo crece o decrece el PIB."]
["Lo más fácil es localizar en la serie de datos los periodos en los que el PIB decrece. Para ello aplicamos un formato condicional a las celdas de la serie ΔPIB y haremos que los números negativos aparezcan en rojo. "]
["Una vez hecho esto, aparecen claramente señalados los periodos en los que el PIB decrece."]
[]
[]
[null,null,"PRESENTACIÓN 1",{"$nulls":4},"PRESENTACIÓN 2"]
[]
[null,null,"Periodo","PIB pm ","LN(PIB)","ΔPIB",null,"Periodo","PIB pm","LN(PIB)","ΔPIB"]
[null,null,"1970Q1",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(D273)","v":8.536740884258606},null,null,"1970-03-31",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(I273)","v":8.536740884258606}]
[null,null,"1970Q2",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(D274)","v":8.538328263946196},{"$f":"(E274-E273)*100","v":0.15873796875904844},null,"1970-06-30",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(I274)","v":8.538328263946196},{"$f":"(J274-J273)*100","v":0.15873796875904844}]
[null,null,"1970Q3",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(E275-E274)*100","v":0.5097816639802133},null,"31/09/1970",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(J275-J274)*100","v":0.5097816639802133}]
[null,null,"1970Q4",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629,null,"1970-12-31",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629]
[null,null,"1971Q1",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691,null,"1971-03-31",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691]
[null,null,"1971Q2",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763,null,"1971-06-30",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763]
[null,null,"1971Q3",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723,null,"31/09/1971",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723]
[null,null,"1971Q4",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813,null,"1971-12-31",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813]
[null,null,"1972Q1",{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977,null,{"$f":"H280+91","v":"1972-03-31"},{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977]
[null,null,"1972Q2",{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555,null,{"$f":"H281+91","v":"1972-06-30"},{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555]
[null,null,"1972Q3",{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044,null,{"$f":"H282+92","v":"1972-09-30"},{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044]
[null,null,"1972Q4",{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897,null,{"$f":"H283+92","v":"1972-12-31"},{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897]
[null,null,"1973Q1",{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934,null,{"$f":"H284+90","v":"1973-03-31"},{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934]
[null,null,"1973Q2",{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583,null,{"$f":"H285+91","v":"1973-06-30"},{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583]
[null,null,"1973Q3",{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803,null,{"$f":"H286+92","v":"1973-09-30"},{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803]
[null,null,"1973Q4",{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789,null,{"$f":"H287+92","v":"1973-12-31"},{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789]
[null,null,"1974Q1",{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282,null,{"$f":"H288+90","v":"1974-03-31"},{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282]
[null,null,"1974Q2",{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368,null,{"$f":"H289+91","v":"1974-06-30"},{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368]
[null,null,"1974Q3",{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703,null,{"$f":"H290+92","v":"1974-09-30"},{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703]
[null,null,"1974Q4",{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158,null,{"$f":"H291+92","v":"1974-12-31"},{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158]
[null,null,"1975Q1",{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404,null,{"$f":"H292+90","v":"1975-03-31"},{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404]
[null,null,"1975Q2",{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585,null,{"$f":"H293+91","v":"1975-06-30"},{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585]
[null,null,"1975Q3",{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723,null,{"$f":"H294+92","v":"1975-09-30"},{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723]
[null,null,"1975Q4",{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598,null,{"$f":"H295+92","v":"1975-12-31"},{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598]
[null,null,"1976Q1",{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032,null,{"$f":"H296+91","v":"1976-03-31"},{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032]
[null,null,"1976Q2",{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884,null,{"$f":"H297+91","v":"1976-06-30"},{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884]
[null,null,"1976Q3",{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595,null,{"$f":"H298+92","v":"1976-09-30"},{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595]
[null,null,"1976Q4",{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861,null,{"$f":"H299+92","v":"1976-12-31"},{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861]
[null,null,"1977Q1",{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943,null,{"$f":"H300+90","v":"1977-03-31"},{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943]
[null,null,"1977Q2",{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364,null,{"$f":"H301+91","v":"1977-06-30"},{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364]
[null,null,"1977Q3",{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603,null,{"$f":"H302+92","v":"1977-09-30"},{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603]
[null,null,"1977Q4",{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023,null,{"$f":"H303+92","v":"1977-12-31"},{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023]
[null,null,"1978Q1",{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076,null,{"$f":"H304+90","v":"1978-03-31"},{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076]
[null,null,"1978Q2",{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176,null,{"$f":"H305+91","v":"1978-06-30"},{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176]
[null,null,"1978Q3",{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975,null,{"$f":"H306+92","v":"1978-09-30"},{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975]
[null,null,"1978Q4",{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787,null,{"$f":"H307+92","v":"1978-12-31"},{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787]
[null,null,"1979Q1",{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563,null,{"$f":"H308+90","v":"1979-03-31"},{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563]
[null,null,"1979Q2",{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175,null,{"$f":"H309+91","v":"1979-06-30"},{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175]
[null,null,"1979Q3",{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773,null,{"$f":"H310+92","v":"1979-09-30"},{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773]
[null,null,"1979Q4",{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054,null,{"$f":"H311+92","v":"1979-12-31"},{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054]
[null,null,"1980Q1",{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793,null,{"$f":"H312+91","v":"1980-03-31"},{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793]
[null,null,"1980Q2",{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892,null,{"$f":"H313+91","v":"1980-06-30"},{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892]
[null,null,"1980Q3",{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484,null,{"$f":"H314+92","v":"1980-09-30"},{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484]
[null,null,"1980Q4",{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978,null,{"$f":"H315+92","v":"1980-12-31"},{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978]
[null,null,"1981Q1",{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577,null,{"$f":"H316+90","v":"1981-03-31"},{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577]
[null,null,"1981Q2",{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049,null,{"$f":"H317+91","v":"1981-06-30"},{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049]
[null,null,"1981Q3",{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752,null,{"$f":"H318+92","v":"1981-09-30"},{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752]
[null,null,"1981Q4",{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758,null,{"$f":"H319+92","v":"1981-12-31"},{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758]
[null,null,"1982Q1",{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365,null,{"$f":"H320+90","v":"1982-03-31"},{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365]
[null,null,"1982Q2",{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072,null,{"$f":"H321+91","v":"1982-06-30"},{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072]
[null,null,"1982Q3",{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269,null,{"$f":"H322+92","v":"1982-09-30"},{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269]
[null,null,"1982Q4",{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516,null,{"$f":"H323+92","v":"1982-12-31"},{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516]
[null,null,"1983Q1",{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944,null,{"$f":"H324+90","v":"1983-03-31"},{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944]
[null,null,"1983Q2",{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303,null,{"$f":"H325+91","v":"1983-06-30"},{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303]
[null,null,"1983Q3",{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829,null,{"$f":"H326+92","v":"1983-09-30"},{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829]
[null,null,"1983Q4",{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303,null,{"$f":"H327+92","v":"1983-12-31"},{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303]
[null,null,"1984Q1",{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464,null,{"$f":"H328+91","v":"1984-03-31"},{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464]
[null,null,"1984Q2",{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617,null,{"$f":"H329+91","v":"1984-06-30"},{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617]
[null,null,"1984Q3",{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272,null,{"$f":"H330+92","v":"1984-09-30"},{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272]
[null,null,"1984Q4",{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835,null,{"$f":"H331+92","v":"1984-12-31"},{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835]
[null,null,"1985Q1",{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985,null,{"$f":"H332+90","v":"1985-03-31"},{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985]
[null,null,"1985Q2",{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039,null,{"$f":"H333+91","v":"1985-06-30"},{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039]
[null,null,"1985Q3",{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418,null,{"$f":"H334+92","v":"1985-09-30"},{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418]
[null,null,"1985Q4",{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954,null,{"$f":"H335+92","v":"1985-12-31"},{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954]
[null,null,"1986Q1",{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934,null,{"$f":"H336+90","v":"1986-03-31"},{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934]
[null,null,"1986Q2",{"v":8031.7,"d":"8,031.700"},{"$f":"LN(D338)","v":8.99115149063635},0.9143483614291625,null,{"$f":"H337+91","v":"1986-06-30"},{"v":8031.7,"d":"8,031.700"},{"$f":"LN(I338)","v":8.99115149063635},0.9143483614291625]
[null,null,"1986Q3",{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(E339-E338)*100","v":1.0761513861304195},null,{"$f":"H338+92","v":"1986-09-30"},{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(J339-J338)*100","v":1.0761513861304195}]
[null,null,"1986Q4",{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516,null,{"$f":"H339+92","v":"1986-12-31"},{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516]
[null,null,"1987Q1",{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769,null,{"$f":"H340+90","v":"1987-03-31"},{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769]
[null,null,"1987Q2",{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429,null,{"$f":"H341+91","v":"1987-06-30"},{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429]
[null,null,"1987Q3",{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832,null,{"$f":"H342+92","v":"1987-09-30"},{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832]
[null,null,"1987Q4",{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122,null,{"$f":"H343+92","v":"1987-12-31"},{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122]
[null,null,"1988Q1",{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058,null,{"$f":"H344+91","v":"1988-03-31"},{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058]
[null,null,"1988Q2",{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193,null,{"$f":"H345+91","v":"1988-06-30"},{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193]
[null,null,"1988Q3",{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435,null,{"$f":"H346+92","v":"1988-09-30"},{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435]
[null,null,"1988Q4",{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376,null,{"$f":"H347+92","v":"1988-12-31"},{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376]
[null,null,"1989Q1",{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368,null,{"$f":"H348+90","v":"1989-03-31"},{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368]
[null,null,"1989Q2",{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473,null,{"$f":"H349+91","v":"1989-06-30"},{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473]
[null,null,"1989Q3",{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208,null,{"$f":"H350+92","v":"1989-09-30"},{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208]
[null,null,"1989Q4",{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242,null,{"$f":"H351+92","v":"1989-12-31"},{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242]
[null,null,"1990Q1",{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859,null,{"$f":"H352+90","v":"1990-03-31"},{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859]
[null,null,"1990Q2",{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117,null,{"$f":"H353+91","v":"1990-06-30"},{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117]
[null,null,"1990Q3",{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913,null,{"$f":"H354+92","v":"1990-09-30"},{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913]
[null,null,"1990Q4",{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678,null,{"$f":"H355+92","v":"1990-12-31"},{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678]
[null,null,"1991Q1",{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637,null,{"$f":"H356+90","v":"1991-03-31"},{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637]
[null,null,"1991Q2",{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469,null,{"$f":"H357+91","v":"1991-06-30"},{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469]
[null,null,"1991Q3",{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081,null,{"$f":"H358+92","v":"1991-09-30"},{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081]
[null,null,"1991Q4",{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752,null,{"$f":"H359+92","v":"1991-12-31"},{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752]
[null,null,"1992Q1",{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655,null,{"$f":"H360+91","v":"1992-03-31"},{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655]
[null,null,"1992Q2",{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152,null,{"$f":"H361+91","v":"1992-06-30"},{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152]
[null,null,"1992Q3",{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002,null,{"$f":"H362+92","v":"1992-09-30"},{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002]
[null,null,"1992Q4",{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834,null,{"$f":"H363+92","v":"1992-12-31"},{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834]
[null,null,"1993Q1",{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656,null,{"$f":"H364+90","v":"1993-03-31"},{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656]
[null,null,"1993Q2",{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506,null,{"$f":"H365+91","v":"1993-06-30"},{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506]
[null,null,"1993Q3",{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561,null,{"$f":"H366+92","v":"1993-09-30"},{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561]
[null,null,"1993Q4",{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101,null,{"$f":"H367+92","v":"1993-12-31"},{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101]
[null,null,"1994Q1",{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413,null,{"$f":"H368+90","v":"1994-03-31"},{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413]
[null,null,"1994Q2",{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256,null,{"$f":"H369+91","v":"1994-06-30"},{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256]
[null,null,"1994Q3",{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894,null,{"$f":"H370+92","v":"1994-09-30"},{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894]
[null,null,"1994Q4",{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251,null,{"$f":"H371+92","v":"1994-12-31"},{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251]
[null,null,"1995Q1",{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298,null,{"$f":"H372+90","v":"1995-03-31"},{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298]
[null,null,"1995Q2",{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444,null,{"$f":"H373+91","v":"1995-06-30"},{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444]
[null,null,"1995Q3",{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747,null,{"$f":"H374+92","v":"1995-09-30"},{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747]
[null,null,"1995Q4",{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494,null,{"$f":"H375+92","v":"1995-12-31"},{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494]
[null,null,"1996Q1",{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116,null,{"$f":"H376+91","v":"1996-03-31"},{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116]
[null,null,"1996Q2",{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627,null,{"$f":"H377+91","v":"1996-06-30"},{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627]
[null,null,"1996Q3",{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521,null,{"$f":"H378+92","v":"1996-09-30"},{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521]
[null,null,"1996Q4",{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168,null,{"$f":"H379+92","v":"1996-12-31"},{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168]
[null,null,"1997Q1",{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192,null,{"$f":"H380+90","v":"1997-03-31"},{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192]
[null,null,"1997Q2",{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234,null,{"$f":"H381+91","v":"1997-06-30"},{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234]
[null,null,"1997Q3",{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345,null,{"$f":"H382+92","v":"1997-09-30"},{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345]
[null,null,"1997Q4",{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602,null,{"$f":"H383+92","v":"1997-12-31"},{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602]
[null,null,"1998Q1",{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454,null,{"$f":"H384+90","v":"1998-03-31"},{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454]
[null,null,"1998Q2",{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841,null,{"$f":"H385+91","v":"1998-06-30"},{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841]
[null,null,"1998Q3",{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293,null,{"$f":"H386+92","v":"1998-09-30"},{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293]
[null,null,"1998Q4",{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846,null,{"$f":"H387+92","v":"1998-12-31"},{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846]
[]
[]
["Aunque ahora tenemos localizados los periodos de decrecimiento del PIB, estos no bastan para detectar los ciclos. A ese fin, debemos concretar las definiciones de los dos elementos claves del ciclo (picos y valles)"]
["para el método de análisis que vamos a utilizar: el de las tasas de crecimiento del PIB. "]
{"$rows_empty":9}
["Si aplicamos estas definiciones a los datos que tenemos y añadimos una columna adicional que recoja la información derivada de la aplicación de esas definiciones, obtendremos la siguiente tabla que ya sí qnos permite detectar los ciclos."]
["Para reconocer mejor las distintas fases del ciclo, las señalamos con distintos colores."]
[]
[]
[null,null,"PRESENTACIÓN 1",{"$nulls":5},"PRESENTACIÓN 2"]
[]
[null,null,"Periodo","PIB pm ","LN(PIB)","ΔPIB","Fase Ciclo",null,"Periodo","PIB pm","LN(PIB)","ΔPIB","Fase Ciclo"]
[null,null,"1970Q1",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(D409)","v":8.536740884258606},{"$nulls":3},"1970-03-31",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(J409)","v":8.536740884258606}]
[null,null,"1970Q2",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(D410)","v":8.538328263946196},{"$f":"(E410-E409)*100","v":0.15873796875904844},{"$f":"IF(AND(F410>=0,F411<0,F412<0,F409>0,F408>0),\"Pico\",IF(AND(F410<=0,F411>0,F412>0,F409<0,F408<0),\"Fondo\",IF(OR(AND(F410<0,F409<0,F408<0),AND(F410<0,F411<0,F412<0),AND(F410<0,F409<0,F411<0)),\"Recesión\",IF(F410>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"},null,"1970-06-30",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(J410)","v":8.538328263946196},{"$f":"(K410-K409)*100","v":0.15873796875904844},{"$f":"IF(AND(L410>=0,L411<0,L412<0,L409>0,L408>0),\"Pico\",IF(AND(L410<=0,L411>0,L412>0,L409<0,L408<0),\"Fondo\",IF(OR(AND(L410<0,L409<0,L408<0),AND(L410<0,L411<0,L412<0),AND(L410<0,L409<0,L411<0)),\"Recesión\",IF(L410>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1970Q3",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(E411-E410)*100","v":0.5097816639802133},{"$f":"IF(AND(F411>=0,F412<0,F413<0,F410>0,F409>0),\"Pico\",IF(AND(F411<=0,F412>0,F413>0,F410<0,F409<0),\"Fondo\",IF(OR(AND(F411<0,F410<0,F409<0),AND(F411<0,F412<0,F413<0),AND(F411<0,F410<0,F412<0)),\"Recesión\",IF(F411>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"},null,"31/09/1970",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(K411-K410)*100","v":0.5097816639802133},{"$f":"IF(AND(L411>=0,L412<0,L413<0,L410>0,L409>0),\"Pico\",IF(AND(L411<=0,L412>0,L413>0,L410<0,L409<0),\"Fondo\",IF(OR(AND(L411<0,L410<0,L409<0),AND(L411<0,L412<0,L413<0),AND(L411<0,L410<0,L412<0)),\"Recesión\",IF(L411>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1970Q4",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629,"Expansión",null,"1970-12-31",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629,"Expansión"]
[null,null,"1971Q1",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691,"Expansión",null,"1971-03-31",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691,"Expansión"]
[null,null,"1971Q2",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763,"Expansión",null,"1971-06-30",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763,"Expansión"]
[null,null,"1971Q3",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723,"Expansión",null,"31/09/1971",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723,"Expansión"]
[null,null,"1971Q4",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813,"Expansión",null,"1971-12-31",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813,"Expansión"]
[null,null,"1972Q1",{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977,"Expansión",null,{"$f":"I416+91","v":"1972-03-31"},{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977,"Expansión"]
[null,null,"1972Q2",{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555,"Expansión",null,{"$f":"I417+91","v":"1972-06-30"},{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555,"Expansión"]
[null,null,"1972Q3",{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044,"Expansión",null,{"$f":"I418+92","v":"1972-09-30"},{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044,"Expansión"]
[null,null,"1972Q4",{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897,"Expansión",null,{"$f":"I419+92","v":"1972-12-31"},{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897,"Expansión"]
[null,null,"1973Q1",{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934,"Expansión",null,{"$f":"I420+90","v":"1973-03-31"},{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934,"Expansión"]
[null,null,"1973Q2",{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583,"Expansión",null,{"$f":"I421+91","v":"1973-06-30"},{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583,"Expansión"]
[null,null,"1973Q3",{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803,"Expansión",null,{"$f":"I422+92","v":"1973-09-30"},{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803,"Expansión"]
[null,null,"1973Q4",{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789,"Expansión",null,{"$f":"I423+92","v":"1973-12-31"},{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789,"Expansión"]
[null,null,"1974Q1",{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282,"Expansión",null,{"$f":"I424+90","v":"1974-03-31"},{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282,"Expansión"]
[null,null,"1974Q2",{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368,"Expansión",null,{"$f":"I425+91","v":"1974-06-30"},{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368,"Expansión"]
[null,null,"1974Q3",{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703,"Expansión",null,{"$f":"I426+92","v":"1974-09-30"},{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703,"Expansión"]
[null,null,"1974Q4",{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158,"Pico",null,{"$f":"I427+92","v":"1974-12-31"},{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158,"Pico"]
[null,null,"1975Q1",{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404,"Desaceleración",null,{"$f":"I428+90","v":"1975-03-31"},{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404,"Desaceleración"]
[null,null,"1975Q2",{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585,"Desaceleración",null,{"$f":"I429+91","v":"1975-06-30"},{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585,"Desaceleración"]
[null,null,"1975Q3",{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723,"Expansión",null,{"$f":"I430+92","v":"1975-09-30"},{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723,"Expansión"]
[null,null,"1975Q4",{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598,"Expansión",null,{"$f":"I431+92","v":"1975-12-31"},{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598,"Expansión"]
[null,null,"1976Q1",{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032,"Expansión",null,{"$f":"I432+91","v":"1976-03-31"},{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032,"Expansión"]
[null,null,"1976Q2",{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884,"Expansión",null,{"$f":"I433+91","v":"1976-06-30"},{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884,"Expansión"]
[null,null,"1976Q3",{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595,"Expansión",null,{"$f":"I434+92","v":"1976-09-30"},{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595,"Expansión"]
[null,null,"1976Q4",{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861,"Expansión",null,{"$f":"I435+92","v":"1976-12-31"},{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861,"Expansión"]
[null,null,"1977Q1",{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943,"Expansión",null,{"$f":"I436+90","v":"1977-03-31"},{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943,"Expansión"]
[null,null,"1977Q2",{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364,"Expansión",null,{"$f":"I437+91","v":"1977-06-30"},{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364,"Expansión"]
[null,null,"1977Q3",{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603,"Expansión",null,{"$f":"I438+92","v":"1977-09-30"},{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603,"Expansión"]
[null,null,"1977Q4",{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023,"Expansión",null,{"$f":"I439+92","v":"1977-12-31"},{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023,"Expansión"]
[null,null,"1978Q1",{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076,"Expansión",null,{"$f":"I440+90","v":"1978-03-31"},{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076,"Expansión"]
[null,null,"1978Q2",{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176,"Pico",null,{"$f":"I441+91","v":"1978-06-30"},{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176,"Pico"]
[null,null,"1978Q3",{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975,"Recesión",null,{"$f":"I442+92","v":"1978-09-30"},{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975,"Recesión"]
[null,null,"1978Q4",{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787,"Recesión",null,{"$f":"I443+92","v":"1978-12-31"},{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787,"Recesión"]
[null,null,"1979Q1",{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563,"Fondo",null,{"$f":"I444+90","v":"1979-03-31"},{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563,"Fondo"]
[null,null,"1979Q2",{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175,"Expansión",null,{"$f":"I445+91","v":"1979-06-30"},{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175,"Expansión"]
[null,null,"1979Q3",{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773,"Expansión",null,{"$f":"I446+92","v":"1979-09-30"},{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773,"Expansión"]
[null,null,"1979Q4",{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054,"Expansión",null,{"$f":"I447+92","v":"1979-12-31"},{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054,"Expansión"]
[null,null,"1980Q1",{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793,"Expansión",null,{"$f":"I448+91","v":"1980-03-31"},{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793,"Expansión"]
[null,null,"1980Q2",{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892,"Expansión",null,{"$f":"I449+91","v":"1980-06-30"},{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892,"Expansión"]
[null,null,"1980Q3",{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484,"Pico",null,{"$f":"I450+92","v":"1980-09-30"},{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484,"Pico"]
[null,null,"1980Q4",{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978,"Desaceleración",null,{"$f":"I451+92","v":"1980-12-31"},{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978,"Desaceleración"]
[null,null,"1981Q1",{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577,"Desaceleración",null,{"$f":"I452+90","v":"1981-03-31"},{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577,"Desaceleración"]
[null,null,"1981Q2",{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049,"Expansión",null,{"$f":"I453+91","v":"1981-06-30"},{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049,"Expansión"]
[null,null,"1981Q3",{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752,"Expansión",null,{"$f":"I454+92","v":"1981-09-30"},{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752,"Expansión"]
[null,null,"1981Q4",{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758,"Expansión",null,{"$f":"I455+92","v":"1981-12-31"},{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758,"Expansión"]
[null,null,"1982Q1",{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365,"Expansión",null,{"$f":"I456+90","v":"1982-03-31"},{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365,"Expansión"]
[null,null,"1982Q2",{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072,"Expansión",null,{"$f":"I457+91","v":"1982-06-30"},{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072,"Expansión"]
[null,null,"1982Q3",{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269,"Expansión",null,{"$f":"I458+92","v":"1982-09-30"},{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269,"Expansión"]
[null,null,"1982Q4",{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516,"Expansión",null,{"$f":"I459+92","v":"1982-12-31"},{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516,"Expansión"]
[null,null,"1983Q1",{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944,"Expansión",null,{"$f":"I460+90","v":"1983-03-31"},{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944,"Expansión"]
[null,null,"1983Q2",{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303,"Expansión",null,{"$f":"I461+91","v":"1983-06-30"},{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303,"Expansión"]
[null,null,"1983Q3",{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829,"Expansión",null,{"$f":"I462+92","v":"1983-09-30"},{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829,"Expansión"]
[null,null,"1983Q4",{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303,"Expansión",null,{"$f":"I463+92","v":"1983-12-31"},{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303,"Expansión"]
[null,null,"1984Q1",{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464,"Desaceleración",null,{"$f":"I464+91","v":"1984-03-31"},{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464,"Desaceleración"]
[null,null,"1984Q2",{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617,"Expansión",null,{"$f":"I465+91","v":"1984-06-30"},{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617,"Expansión"]
[null,null,"1984Q3",{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272,"Expansión",null,{"$f":"I466+92","v":"1984-09-30"},{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272,"Expansión"]
[null,null,"1984Q4",{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835,"Expansión",null,{"$f":"I467+92","v":"1984-12-31"},{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835,"Expansión"]
[null,null,"1985Q1",{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985,"Expansión",null,{"$f":"I468+90","v":"1985-03-31"},{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985,"Expansión"]
[null,null,"1985Q2",{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039,"Expansión",null,{"$f":"I469+91","v":"1985-06-30"},{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039,"Expansión"]
[null,null,"1985Q3",{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418,"Expansión",null,{"$f":"I470+92","v":"1985-09-30"},{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418,"Expansión"]
[null,null,"1985Q4",{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954,"Expansión",null,{"$f":"I471+92","v":"1985-12-31"},{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954,"Expansión"]
[null,null,"1986Q1",{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934,"Expansión",null,{"$f":"I472+90","v":"1986-03-31"},{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934,"Expansión"]
[null,null,"1986Q2",{"v":8031.7,"d":"8,031.700"},{"$f":"LN(D474)","v":8.99115149063635},0.9143483614291625,"Expansión",null,{"$f":"I473+91","v":"1986-06-30"},{"v":8031.7,"d":"8,031.700"},{"$f":"LN(J474)","v":8.99115149063635},0.9143483614291625,"Expansión"]
[null,null,"1986Q3",{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(E475-E474)*100","v":1.0761513861304195},{"$f":"IF(AND(F475>=0,F476<0,F477<0,F474>0,F473>0),\"Pico\",IF(AND(F475<=0,F476>0,F477>0,F474<0,F473<0),\"Fondo\",IF(OR(AND(F475<0,F474<0,F473<0),AND(F475<0,F476<0,F477<0),AND(F475<0,F474<0,F476<0)),\"Recesión\",IF(F475>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"},null,{"$f":"I474+92","v":"1986-09-30"},{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(K475-K474)*100","v":1.0761513861304195},{"$f":"IF(AND(L475>=0,L476<0,L477<0,L474>0,L473>0),\"Pico\",IF(AND(L475<=0,L476>0,L477>0,L474<0,L473<0),\"Fondo\",IF(OR(AND(L475<0,L474<0,L473<0),AND(L475<0,L476<0,L477<0),AND(L475<0,L474<0,L476<0)),\"Recesión\",IF(L475>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1986Q4",{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516,"Expansión",null,{"$f":"I475+92","v":"1986-12-31"},{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516,"Expansión"]
[null,null,"1987Q1",{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769,"Expansión",null,{"$f":"I476+90","v":"1987-03-31"},{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769,"Expansión"]
[null,null,"1987Q2",{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429,"Expansión",null,{"$f":"I477+91","v":"1987-06-30"},{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429,"Expansión"]
[null,null,"1987Q3",{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832,"Expansión",null,{"$f":"I478+92","v":"1987-09-30"},{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832,"Expansión"]
[null,null,"1987Q4",{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122,"Expansión",null,{"$f":"I479+92","v":"1987-12-31"},{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122,"Expansión"]
[null,null,"1988Q1",{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058,"Expansión",null,{"$f":"I480+91","v":"1988-03-31"},{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058,"Expansión"]
[null,null,"1988Q2",{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193,"Expansión",null,{"$f":"I481+91","v":"1988-06-30"},{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193,"Expansión"]
[null,null,"1988Q3",{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435,"Expansión",null,{"$f":"I482+92","v":"1988-09-30"},{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435,"Expansión"]
[null,null,"1988Q4",{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376,"Expansión",null,{"$f":"I483+92","v":"1988-12-31"},{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376,"Expansión"]
[null,null,"1989Q1",{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368,"Expansión",null,{"$f":"I484+90","v":"1989-03-31"},{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368,"Expansión"]
[null,null,"1989Q2",{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473,"Expansión",null,{"$f":"I485+91","v":"1989-06-30"},{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473,"Expansión"]
[null,null,"1989Q3",{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208,"Expansión",null,{"$f":"I486+92","v":"1989-09-30"},{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208,"Expansión"]
[null,null,"1989Q4",{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242,"Expansión",null,{"$f":"I487+92","v":"1989-12-31"},{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242,"Expansión"]
[null,null,"1990Q1",{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859,"Expansión",null,{"$f":"I488+90","v":"1990-03-31"},{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859,"Expansión"]
[null,null,"1990Q2",{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117,"Expansión",null,{"$f":"I489+91","v":"1990-06-30"},{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117,"Expansión"]
[null,null,"1990Q3",{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913,"Expansión",null,{"$f":"I490+92","v":"1990-09-30"},{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913,"Expansión"]
[null,null,"1990Q4",{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678,"Expansión",null,{"$f":"I491+92","v":"1990-12-31"},{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678,"Expansión"]
[null,null,"1991Q1",{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637,"Expansión",null,{"$f":"I492+90","v":"1991-03-31"},{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637,"Expansión"]
[null,null,"1991Q2",{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469,"Expansión",null,{"$f":"I493+91","v":"1991-06-30"},{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469,"Expansión"]
[null,null,"1991Q3",{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081,"Expansión",null,{"$f":"I494+92","v":"1991-09-30"},{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081,"Expansión"]
[null,null,"1991Q4",{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752,"Expansión",null,{"$f":"I495+92","v":"1991-12-31"},{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752,"Expansión"]
[null,null,"1992Q1",{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655,"Expansión",null,{"$f":"I496+91","v":"1992-03-31"},{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655,"Expansión"]
[null,null,"1992Q2",{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152,"Pico",null,{"$f":"I497+91","v":"1992-06-30"},{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152,"Pico"]
[null,null,"1992Q3",{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002,"Recesión",null,{"$f":"I498+92","v":"1992-09-30"},{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002,"Recesión"]
[null,null,"1992Q4",{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834,"Recesión",null,{"$f":"I499+92","v":"1992-12-31"},{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834,"Recesión"]
[null,null,"1993Q1",{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656,"Recesión",null,{"$f":"I500+90","v":"1993-03-31"},{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656,"Recesión"]
[null,null,"1993Q2",{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506,"Recesión",null,{"$f":"I501+91","v":"1993-06-30"},{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506,"Recesión"]
[null,null,"1993Q3",{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561,"Fondo",null,{"$f":"I502+92","v":"1993-09-30"},{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561,"Fondo"]
[null,null,"1993Q4",{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101,"Expansión",null,{"$f":"I503+92","v":"1993-12-31"},{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101,"Expansión"]
[null,null,"1994Q1",{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413,"Expansión",null,{"$f":"I504+90","v":"1994-03-31"},{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413,"Expansión"]
[null,null,"1994Q2",{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256,"Expansión",null,{"$f":"I505+91","v":"1994-06-30"},{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256,"Expansión"]
[null,null,"1994Q3",{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894,"Expansión",null,{"$f":"I506+92","v":"1994-09-30"},{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894,"Expansión"]
[null,null,"1994Q4",{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251,"Expansión",null,{"$f":"I507+92","v":"1994-12-31"},{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251,"Expansión"]
[null,null,"1995Q1",{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298,"Expansión",null,{"$f":"I508+90","v":"1995-03-31"},{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298,"Expansión"]
[null,null,"1995Q2",{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444,"Expansión",null,{"$f":"I509+91","v":"1995-06-30"},{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444,"Expansión"]
[null,null,"1995Q3",{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747,"Expansión",null,{"$f":"I510+92","v":"1995-09-30"},{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747,"Expansión"]
[null,null,"1995Q4",{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494,"Expansión",null,{"$f":"I511+92","v":"1995-12-31"},{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494,"Expansión"]
[null,null,"1996Q1",{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116,"Expansión",null,{"$f":"I512+91","v":"1996-03-31"},{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116,"Expansión"]
[null,null,"1996Q2",{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627,"Expansión",null,{"$f":"I513+91","v":"1996-06-30"},{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627,"Expansión"]
[null,null,"1996Q3",{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521,"Expansión",null,{"$f":"I514+92","v":"1996-09-30"},{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521,"Expansión"]
[null,null,"1996Q4",{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168,"Expansión",null,{"$f":"I515+92","v":"1996-12-31"},{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168,"Expansión"]
[null,null,"1997Q1",{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192,"Expansión",null,{"$f":"I516+90","v":"1997-03-31"},{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192,"Expansión"]
[null,null,"1997Q2",{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234,"Expansión",null,{"$f":"I517+91","v":"1997-06-30"},{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234,"Expansión"]
[null,null,"1997Q3",{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345,"Expansión",null,{"$f":"I518+92","v":"1997-09-30"},{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345,"Expansión"]
[null,null,"1997Q4",{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602,"Expansión",null,{"$f":"I519+92","v":"1997-12-31"},{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602,"Expansión"]
[null,null,"1998Q1",{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454,"Expansión",null,{"$f":"I520+90","v":"1998-03-31"},{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454,"Expansión"]
[null,null,"1998Q2",{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841,"Expansión",null,{"$f":"I521+91","v":"1998-06-30"},{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841,"Expansión"]
[null,null,"1998Q3",{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293,"Expansión",null,{"$f":"I522+92","v":"1998-09-30"},{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293,"Expansión"]
[null,null,"1998Q4",{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846,{"$f":"IF(AND(F524>=0,F525<0,F528<0,F523>0,F522>0),\"Pico\",IF(AND(F524<=0,F525>0,F528>0,F523<0,F522<0),\"Fondo\",IF(OR(AND(F524<0,F523<0,F522<0),AND(F524<0,F525<0,F528<0),AND(F524<0,F523<0,F525<0)),\"Recesión\",IF(F524>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"},null,{"$f":"I523+92","v":"1998-12-31"},{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846,{"$f":"IF(AND(L524>=0,L525<0,L528<0,L523>0,L522>0),\"Pico\",IF(AND(L524<=0,L525>0,L528>0,L523<0,L522<0),\"Fondo\",IF(OR(AND(L524<0,L523<0,L522<0),AND(L524<0,L525<0,L528<0),AND(L524<0,L523<0,L525<0)),\"Recesión\",IF(L524>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[]
[]
["Comentarios a los datos"]
["Atendiendo a la definción de ciclo que hemos visto, en el periodo analizado sólo existe un ciclo económico, el comprendido entre el primer cuatrimestre de 1979 y el tercer cuatrimestre de 1993, que son los dos fondos de nuestros datos. "]
["La duración de este ciclo es de 13 años y 9 meses, esto es 59 trimestres."]
["La serie del PIB muestra, además, tres picos: en el cuarto trimestre de 1974, al que sigue una desaceleración de la economía, en el tercer trimestre de 1980, al que también le sigue una desacelarción y, finalmente, el segundo trimestre de 1992, "]
["que inicia una recesión."]
[{"$f":"CONCATENATE(\"El crecimiento acumulado del PIB entre el segundo cuatrimestre de 1972 hasta el segundo cuatrimestre de 1992 es del \", FIXED(SUM(F446:F498),2),\"%.\")","v":"El crecimiento acumulado del PIB entre el segundo cuatrimestre de 1972 hasta el segundo cuatrimestre de 1992 es del 34,43%."}]
[{"$f":"CONCATENATE(\"La caída acumulada del PIB en la recesión de 1992 a 1993 es del \",FIXED(SUM(F499:F503),2),\"%.\")","v":"La caída acumulada del PIB en la recesión de 1992 a 1993 es del -1,70%."}]
[]
[]
["Finalmente, construiremos los gráficos en los que se muestra la evolución de las series del PIB y ΔPIB, que nos servirán para tener una imagen de la evolución de la economía. Según el tipo de fecha que hayamos escogido, deberemos utilizar un tipo"]
["de gráfico u otro:"]
[null,"a. Si hemos escogido el formato de fecha \"AñoQ1\"(1970Q1), entoces deberemos escoger un gráfico tipo línea. Este gráfico está pensado para cuando los valores que aparecen en el eje horizontal no son numéricos. Con este tipo de gráfico"]
[" ","el eje horizontal se divide en partes iguales, y se admiten valores no numéricos. Los gráficos de la serie del PIB y de la variación del PIB quedarían como sigue:"]
[]
[]
[null,null,"PRESENTACIÓN 1",{"$nulls":5},"GRÁFICOS PRESENTACIÓN 1"]
[]
[null,null,"Periodo","PIB pm ","LN(PIB)","ΔPIB","Fase Ciclo"]
[null,null,"1970Q1",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(D545)","v":8.536740884258606}]
[null,null,"1970Q2",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(D546)","v":8.538328263946196},{"$f":"(E546-E545)*100","v":0.15873796875904844},{"$f":"IF(AND(F546>=0,F547<0,F548<0,F545>0,F544>0),\"Pico\",IF(AND(F546<=0,F547>0,F548>0,F545<0,F544<0),\"Fondo\",IF(OR(AND(F546<0,F545<0,F544<0),AND(F546<0,F547<0,F548<0),AND(F546<0,F545<0,F547<0)),\"Recesión\",IF(F546>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1970Q3",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(E547-E546)*100","v":0.5097816639802133},{"$f":"IF(AND(F547>=0,F548<0,F549<0,F546>0,F545>0),\"Pico\",IF(AND(F547<=0,F548>0,F549>0,F546<0,F545<0),\"Fondo\",IF(OR(AND(F547<0,F546<0,F545<0),AND(F547<0,F548<0,F549<0),AND(F547<0,F546<0,F548<0)),\"Recesión\",IF(F547>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1970Q4",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629,"Expansión"]
[null,null,"1971Q1",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691,"Expansión"]
[null,null,"1971Q2",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763,"Expansión"]
[null,null,"1971Q3",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723,"Expansión"]
[null,null,"1971Q4",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813,"Expansión"]
[null,null,"1972Q1",{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977,"Expansión"]
[null,null,"1972Q2",{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555,"Expansión"]
[null,null,"1972Q3",{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044,"Expansión"]
[null,null,"1972Q4",{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897,"Expansión"]
[null,null,"1973Q1",{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934,"Expansión"]
[null,null,"1973Q2",{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583,"Expansión"]
[null,null,"1973Q3",{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803,"Expansión"]
[null,null,"1973Q4",{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789,"Expansión"]
[null,null,"1974Q1",{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282,"Expansión"]
[null,null,"1974Q2",{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368,"Expansión"]
[null,null,"1974Q3",{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703,"Expansión"]
[null,null,"1974Q4",{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158,"Pico"]
[null,null,"1975Q1",{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404,"Desaceleración"]
[null,null,"1975Q2",{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585,"Desaceleración"]
[null,null,"1975Q3",{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723,"Expansión"]
[null,null,"1975Q4",{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598,"Expansión"]
[null,null,"1976Q1",{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032,"Expansión"]
[null,null,"1976Q2",{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884,"Expansión"]
[null,null,"1976Q3",{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595,"Expansión"]
[null,null,"1976Q4",{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861,"Expansión"]
[null,null,"1977Q1",{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943,"Expansión"]
[null,null,"1977Q2",{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364,"Expansión"]
[null,null,"1977Q3",{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603,"Expansión"]
[null,null,"1977Q4",{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023,"Expansión"]
[null,null,"1978Q1",{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076,"Expansión"]
[null,null,"1978Q2",{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176,"Pico"]
[null,null,"1978Q3",{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975,"Recesión"]
[null,null,"1978Q4",{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787,"Recesión"]
[null,null,"1979Q1",{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563,"Fondo"]
[null,null,"1979Q2",{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175,"Expansión"]
[null,null,"1979Q3",{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773,"Expansión"]
[null,null,"1979Q4",{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054,"Expansión"]
[null,null,"1980Q1",{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793,"Expansión"]
[null,null,"1980Q2",{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892,"Expansión"]
[null,null,"1980Q3",{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484,"Pico"]
[null,null,"1980Q4",{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978,"Desaceleración"]
[null,null,"1981Q1",{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577,"Desaceleración"]
[null,null,"1981Q2",{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049,"Expansión"]
[null,null,"1981Q3",{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752,"Expansión"]
[null,null,"1981Q4",{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758,"Expansión"]
[null,null,"1982Q1",{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365,"Expansión"]
[null,null,"1982Q2",{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072,"Expansión"]
[null,null,"1982Q3",{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269,"Expansión"]
[null,null,"1982Q4",{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516,"Expansión"]
[null,null,"1983Q1",{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944,"Expansión"]
[null,null,"1983Q2",{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303,"Expansión"]
[null,null,"1983Q3",{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829,"Expansión"]
[null,null,"1983Q4",{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303,"Expansión"]
[null,null,"1984Q1",{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464,"Desaceleración"]
[null,null,"1984Q2",{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617,"Expansión"]
[null,null,"1984Q3",{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272,"Expansión"]
[null,null,"1984Q4",{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835,"Expansión"]
[null,null,"1985Q1",{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985,"Expansión"]
[null,null,"1985Q2",{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039,"Expansión"]
[null,null,"1985Q3",{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418,"Expansión"]
[null,null,"1985Q4",{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954,"Expansión"]
[null,null,"1986Q1",{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934,"Expansión"]
[null,null,"1986Q2",{"v":8031.7,"d":"8,031.700"},{"$f":"LN(D610)","v":8.99115149063635},0.9143483614291625,"Expansión"]
[null,null,"1986Q3",{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(E611-E610)*100","v":1.0761513861304195},{"$f":"IF(AND(F611>=0,F612<0,F613<0,F610>0,F609>0),\"Pico\",IF(AND(F611<=0,F612>0,F613>0,F610<0,F609<0),\"Fondo\",IF(OR(AND(F611<0,F610<0,F609<0),AND(F611<0,F612<0,F613<0),AND(F611<0,F610<0,F612<0)),\"Recesión\",IF(F611>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1986Q4",{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516,"Expansión"]
[null,null,"1987Q1",{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769,"Expansión"]
[null,null,"1987Q2",{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429,"Expansión"]
[null,null,"1987Q3",{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832,"Expansión"]
[null,null,"1987Q4",{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122,"Expansión"]
[null,null,"1988Q1",{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058,"Expansión"]
[null,null,"1988Q2",{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193,"Expansión"]
[null,null,"1988Q3",{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435,"Expansión"]
[null,null,"1988Q4",{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376,"Expansión"]
[null,null,"1989Q1",{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368,"Expansión"]
[null,null,"1989Q2",{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473,"Expansión"]
[null,null,"1989Q3",{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208,"Expansión"]
[null,null,"1989Q4",{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242,"Expansión"]
[null,null,"1990Q1",{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859,"Expansión"]
[null,null,"1990Q2",{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117,"Expansión"]
[null,null,"1990Q3",{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913,"Expansión"]
[null,null,"1990Q4",{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678,"Expansión"]
[null,null,"1991Q1",{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637,"Expansión"]
[null,null,"1991Q2",{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469,"Expansión"]
[null,null,"1991Q3",{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081,"Expansión"]
[null,null,"1991Q4",{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752,"Expansión"]
[null,null,"1992Q1",{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655,"Expansión"]
[null,null,"1992Q2",{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152,"Pico"]
[null,null,"1992Q3",{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002,"Recesión"]
[null,null,"1992Q4",{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834,"Recesión"]
[null,null,"1993Q1",{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656,"Recesión"]
[null,null,"1993Q2",{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506,"Recesión"]
[null,null,"1993Q3",{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561,"Fondo"]
[null,null,"1993Q4",{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101,"Expansión"]
[null,null,"1994Q1",{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413,"Expansión"]
[null,null,"1994Q2",{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256,"Expansión"]
[null,null,"1994Q3",{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894,"Expansión"]
[null,null,"1994Q4",{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251,"Expansión"]
[null,null,"1995Q1",{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298,"Expansión"]
[null,null,"1995Q2",{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444,"Expansión"]
[null,null,"1995Q3",{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747,"Expansión"]
[null,null,"1995Q4",{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494,"Expansión"]
[null,null,"1996Q1",{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116,"Expansión"]
[null,null,"1996Q2",{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627,"Expansión"]
[null,null,"1996Q3",{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521,"Expansión"]
[null,null,"1996Q4",{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168,"Expansión"]
[null,null,"1997Q1",{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192,"Expansión"]
[null,null,"1997Q2",{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234,"Expansión"]
[null,null,"1997Q3",{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345,"Expansión"]
[null,null,"1997Q4",{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602,"Expansión"]
[null,null,"1998Q1",{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454,"Expansión"]
[null,null,"1998Q2",{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841,"Expansión"]
[null,null,"1998Q3",{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293,"Expansión"]
[null,null,"1998Q4",{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846,{"$f":"IF(AND(F660>=0,F661<0,F664<0,F659>0,F658>0),\"Pico\",IF(AND(F660<=0,F661>0,F664>0,F659<0,F658<0),\"Fondo\",IF(OR(AND(F660<0,F659<0,F658<0),AND(F660<0,F661<0,F664<0),AND(F660<0,F659<0,F661<0)),\"Recesión\",IF(F660>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[]
[]
[null,"b. Si hemos escogido el formato de  fecha del día en el que termina el periodo del dato recogido, entoces deberemos escoger un gráfico tipo dispersión. Como Excel trata las fechas como números, el gráfico tipo línea "]
[null,"no es apropiado para trabajar con ellos, sino que debemos utilizar un formato que relacione dos números: este es el formato dispersión. Con esta opción los gráficos de la serie del PIB y de la variación del PIB quedarían como sigue:"]
[]
[]
[null,null,"PRESENTACIÓN 2"]
[]
[null,null,"Periodo","PIB pm","LN(PIB)","ΔPIB","Fase Ciclo"]
[null,null,"1970-03-31",{"v":5098.7,"d":"5,098.700"},{"$f":"LN(D670)","v":8.536740884258606}]
[null,null,"1970-06-30",{"v":5106.8,"d":"5,106.800"},{"$f":"LN(D671)","v":8.538328263946196},{"$f":"(E671-E670)*100","v":0.15873796875904844},{"$f":"IF(AND(F671>=0,F672<0,F673<0,F670>0,F669>0),\"Pico\",IF(AND(F671<=0,F672>0,F673>0,F670<0,F669<0),\"Fondo\",IF(OR(AND(F671<0,F670<0,F669<0),AND(F671<0,F672<0,F673<0),AND(F671<0,F670<0,F672<0)),\"Recesión\",IF(F671>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"31/09/1970",{"v":5132.9,"d":"5,132.900"},8.543426080585999,{"$f":"(E672-E671)*100","v":0.5097816639802133},{"$f":"IF(AND(F672>=0,F673<0,F674<0,F671>0,F670>0),\"Pico\",IF(AND(F672<=0,F673>0,F674>0,F671<0,F670<0),\"Fondo\",IF(OR(AND(F672<0,F671<0,F670<0),AND(F672<0,F673<0,F674<0),AND(F672<0,F671<0,F673<0)),\"Recesión\",IF(F672>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,"1970-12-31",{"v":5173.4,"d":"5,173.400"},8.551285391584006,0.7859310998007629,"Expansión"]
[null,null,"1971-03-31",{"v":5213.8,"d":"5,213.800"},8.559064235491544,0.7778843907537691,"Expansión"]
[null,null,"1971-06-30",{"v":5315.5,"d":"5,315.500"},8.57838235972866,1.9318124237116763,"Expansión"]
[null,null,"31/09/1971",{"v":5413.3,"d":"5,413.300"},8.596614167393133,1.82318076644723,"Expansión"]
[null,null,"1971-12-31",{"v":5522.3,"d":"5,522.300"},8.616549719156357,1.9935551763223813,"Expansión"]
[null,null,{"$f":"C677+91","v":"1972-03-31"},{"v":5611.9,"d":"5,611.900"},8.63264462210422,1.6094902947862977,"Expansión"]
[null,null,{"$f":"C678+91","v":"1972-06-30"},{"v":5744.5,"d":"5,744.500"},8.65599815429342,2.3353532189199555,"Expansión"]
[null,null,{"$f":"C679+92","v":"1972-09-30"},{"v":5870.7,"d":"5,870.700"},8.67772915613827,2.173100184485044,"Expansión"]
[null,null,{"$f":"C680+92","v":"1972-12-31"},{"v":5987,"d":"5,987.000"},8.697345730925353,1.9616574787082897,"Expansión"]
[null,null,{"$f":"C681+90","v":"1973-03-31"},{"v":6097.2,"d":"6,097.200"},8.715584928387687,1.8239197462333934,"Expansión"]
[null,null,{"$f":"C682+91","v":"1973-06-30"},{"v":6205.9,"d":"6,205.900"},8.733255731439895,1.7670803052208583,"Expansión"]
[null,null,{"$f":"C683+92","v":"1973-09-30"},{"v":6308.4,"d":"6,308.400"},8.749637357613402,1.6381626173506803,"Expansión"]
[null,null,{"$f":"C684+92","v":"1973-12-31"},{"v":6412.2,"d":"6,412.200"},8.765957704758906,1.6320347145503789,"Expansión"]
[null,null,{"$f":"C685+90","v":"1974-03-31"},{"v":6521.1,"d":"6,521.100"},8.78279835234693,1.6840647588024282,"Expansión"]
[null,null,{"$f":"C686+91","v":"1974-06-30"},{"v":6603.5,"d":"6,603.500"},8.79535509048386,1.2556738136929368,"Expansión"]
[null,null,{"$f":"C687+92","v":"1974-09-30"},{"v":6650.1,"d":"6,650.100"},8.802387171130821,0.7032080646961703,"Expansión"]
[null,null,{"$f":"C688+92","v":"1974-12-31"},{"v":6654.5,"d":"6,654.500"},8.803048596526612,0.06614253957906158,"Pico"]
[null,null,{"$f":"C689+90","v":"1975-03-31"},{"v":6621.1,"d":"6,621.100"},8.798016798269481,-0.5031798257130404,"Desaceleración"]
[null,null,{"$f":"C690+91","v":"1975-06-30"},{"v":6615.6,"d":"6,615.600"},8.797185775383639,-0.08310228858423585,"Desaceleración"]
[null,null,{"$f":"C691+92","v":"1975-09-30"},{"v":6644.5,"d":"6,644.500"},8.801544723771562,0.4358948387922723,"Expansión"]
[null,null,{"$f":"C692+92","v":"1975-12-31"},{"v":6691.2,"d":"6,691.200"},8.808548509234315,0.7003785462753598,"Expansión"]
[null,null,{"$f":"C693+91","v":"1976-03-31"},{"v":6757.7,"d":"6,757.700"},8.818437874456986,0.9889365222671032,"Expansión"]
[null,null,{"$f":"C694+91","v":"1976-06-30"},{"v":6835.7,"d":"6,835.700"},8.829914157959445,1.1476283502458884,"Expansión"]
[null,null,{"$f":"C695+92","v":"1976-09-30"},{"v":6902,"d":"6,902.000"},8.839566503657949,0.9652345698503595,"Expansión"]
[null,null,{"$f":"C696+92","v":"1976-12-31"},{"v":6955,"d":"6,955.000"},8.847216104357543,0.7649600699593861,"Expansión"]
[null,null,{"$f":"C697+90","v":"1977-03-31"},{"v":7010.1,"d":"7,010.100"},8.855107245262122,0.789114090457943,"Expansión"]
[null,null,{"$f":"C698+91","v":"1977-06-30"},{"v":7041.9,"d":"7,041.900"},8.859633299102951,0.45260538408289364,"Expansión"]
[null,null,{"$f":"C699+92","v":"1977-09-30"},{"v":7065.3,"d":"7,065.300"},8.862950757062118,0.3317457959166603,"Expansión"]
[null,null,{"$f":"C700+92","v":"1977-12-31"},{"v":7112.5,"d":"7,112.500"},8.869609078434586,0.6658321372468023,"Expansión"]
[null,null,{"$f":"C701+90","v":"1978-03-31"},{"v":7156.9,"d":"7,156.900"},8.875832205306207,0.6223126871621076,"Expansión"]
[null,null,{"$f":"C702+91","v":"1978-06-30"},{"v":7171.4,"d":"7,171.400"},8.877856172552827,0.20239672466200176,"Pico"]
[null,null,{"$f":"C703+92","v":"1978-09-30"},{"v":7162.6,"d":"7,162.600"},8.876628322531117,-0.12278500217099975,"Recesión"]
[null,null,{"$f":"C704+92","v":"1978-12-31"},{"v":7152,"d":"7,152.000"},8.87514731685335,-0.14810056777658787,"Recesión"]
[null,null,{"$f":"C705+90","v":"1979-03-31"},{"v":7140.6,"d":"7,140.600"},8.87355208541645,-0.15952314369016563,"Fondo"]
[null,null,{"$f":"C706+91","v":"1979-06-30"},{"v":7151.7,"d":"7,151.700"},8.875105369664855,0.15532842484056175,"Expansión"]
[null,null,{"$f":"C707+92","v":"1979-09-30"},{"v":7168.9,"d":"7,168.900"},8.87750750480873,0.2402135143874773,"Expansión"]
[null,null,{"$f":"C708+92","v":"1979-12-31"},{"v":7194.1,"d":"7,194.100"},8.881016524631574,0.35090198228449054,"Expansión"]
[null,null,{"$f":"C709+91","v":"1980-03-31"},{"v":7225.6,"d":"7,225.600"},8.885385554515288,0.4369029883713793,"Expansión"]
[null,null,{"$f":"C710+91","v":"1980-06-30"},{"v":7270.8,"d":"7,270.800"},8.891621605738944,0.6236051223655892,"Expansión"]
[null,null,{"$f":"C711+92","v":"1980-09-30"},{"v":7280.5,"d":"7,280.500"},8.89295482015096,0.13332144120159484,"Pico"]
[null,null,{"$f":"C712+92","v":"1980-12-31"},{"v":7250.4,"d":"7,250.400"},8.888811918740572,-0.4142901410387978,"Desaceleración"]
[null,null,{"$f":"C713+90","v":"1981-03-31"},{"v":7188.7,"d":"7,188.700"},8.880265627691657,-0.8546291048915577,"Desaceleración"]
[null,null,{"$f":"C714+91","v":"1981-06-30"},{"v":7219.7,"d":"7,219.700"},8.884568679777058,0.4303052085401049,"Expansión"]
[null,null,{"$f":"C715+92","v":"1981-09-30"},{"v":7281.8,"d":"7,281.800"},8.893133363376062,0.8564683599004752,"Expansión"]
[null,null,{"$f":"C716+92","v":"1981-12-31"},{"v":7286.6,"d":"7,286.600"},8.893792323889734,0.0658960513671758,"Expansión"]
[null,null,{"$f":"C717+90","v":"1982-03-31"},{"v":7291.1,"d":"7,291.100"},8.89440970525208,0.06173813623462365,"Expansión"]
[null,null,{"$f":"C718+91","v":"1982-06-30"},{"v":7331.5,"d":"7,331.500"},8.899935412417134,0.5525707165054072,"Expansión"]
[null,null,{"$f":"C719+92","v":"1982-09-30"},{"v":7393.6,"d":"7,393.600"},8.908370040116003,0.8434627698868269,"Expansión"]
[null,null,{"$f":"C720+92","v":"1982-12-31"},{"v":7413.2,"d":"7,413.200"},8.911017473923154,0.26474338071516,"Expansión"]
[null,null,{"$f":"C721+90","v":"1983-03-31"},{"v":7443.3,"d":"7,443.300"},8.915069577875727,0.40521039525724944,"Expansión"]
[null,null,{"$f":"C722+91","v":"1983-06-30"},{"v":7501.9,"d":"7,501.900"},8.922911600774265,0.7842022898538303,"Expansión"]
[null,null,{"$f":"C723+92","v":"1983-09-30"},{"v":7560.1,"d":"7,560.100"},8.930639696599323,0.772809582505829,"Expansión"]
[null,null,{"$f":"C724+92","v":"1983-12-31"},{"v":7578.1,"d":"7,578.100"},8.933017787585435,0.2378090986111303,"Expansión"]
[null,null,{"$f":"C725+91","v":"1984-03-31"},{"v":7576.5,"d":"7,576.500"},8.932806630576216,-0.021115700921825464,"Desaceleración"]
[null,null,{"$f":"C726+91","v":"1984-06-30"},{"v":7609.1,"d":"7,609.100"},8.937100178421613,0.42935478453962617,"Expansión"]
[null,null,{"$f":"C727+92","v":"1984-09-30"},{"v":7652.7,"d":"7,652.700"},8.942813805727965,0.571362730635272,"Expansión"]
[null,null,{"$f":"C728+92","v":"1984-12-31"},{"v":7686.1,"d":"7,686.100"},8.9471687817089,0.43549759809344835,"Expansión"]
[null,null,{"$f":"C729+90","v":"1985-03-31"},{"v":7739.9,"d":"7,739.900"},8.95414404660367,0.697526489476985,"Expansión"]
[null,null,{"$f":"C730+91","v":"1985-06-30"},{"v":7802.1,"d":"7,802.100"},8.962148207210815,0.8004160607145039,"Expansión"]
[null,null,{"$f":"C731+92","v":"1985-09-30"},{"v":7872.5,"d":"7,872.500"},8.97113095297518,0.8982745764365418,"Expansión"]
[null,null,{"$f":"C732+92","v":"1985-12-31"},{"v":7907.3,"d":"7,907.300"},8.975541662416063,0.4410709440882954,"Expansión"]
[null,null,{"$f":"C733+90","v":"1986-03-31"},{"v":7958.597,"d":"7,958.597"},8.982008007022058,0.6466344605994934,"Expansión"]
[null,null,{"$f":"C734+91","v":"1986-06-30"},{"v":8031.7,"d":"8,031.700"},{"$f":"LN(D735)","v":8.99115149063635},0.9143483614291625,"Expansión"]
[null,null,{"$f":"C735+92","v":"1986-09-30"},{"v":8118.6,"d":"8,118.600"},9.001913004497654,{"$f":"(E736-E735)*100","v":1.0761513861304195},{"$f":"IF(AND(F736>=0,F737<0,F738<0,F735>0,F734>0),\"Pico\",IF(AND(F736<=0,F737>0,F738>0,F735<0,F734<0),\"Fondo\",IF(OR(AND(F736<0,F735<0,F734<0),AND(F736<0,F737<0,F738<0),AND(F736<0,F735<0,F737<0)),\"Recesión\",IF(F736>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,{"$f":"C736+92","v":"1986-12-31"},{"v":8215.095,"d":"8,215.095"},9.01372859461631,1.1815590118656516,"Expansión"]
[null,null,{"$f":"C737+90","v":"1987-03-31"},{"v":8341.175,"d":"8,341.175"},9.028959372719278,1.523077810296769,"Expansión"]
[null,null,{"$f":"C738+91","v":"1987-06-30"},{"v":8478.003,"d":"8,478.003"},9.045230205769561,1.6270833050283429,"Expansión"]
[null,null,{"$f":"C739+92","v":"1987-09-30"},{"v":8611.098,"d":"8,611.098"},9.060807115423415,1.5576909653853832,"Expansión"]
[null,null,{"$f":"C740+92","v":"1987-12-31"},{"v":8717.239,"d":"8,717.239"},9.07305783832529,1.2250722901875122,"Expansión"]
[null,null,{"$f":"C741+91","v":"1988-03-31"},{"v":8814.089,"d":"8,814.089"},9.084106742922996,1.10489045977058,"Expansión"]
[null,null,{"$f":"C742+91","v":"1988-06-30"},{"v":8931.979,"d":"8,931.979"},9.097393261860105,1.3286518937109193,"Expansión"]
[null,null,{"$f":"C743+92","v":"1988-09-30"},{"v":9031.254,"d":"9,031.254"},9.10844650720132,1.1053245341214435,"Expansión"]
[null,null,{"$f":"C744+92","v":"1988-12-31"},{"v":9132.705,"d":"9,132.705"},9.119617205721086,1.1170698519766376,"Expansión"]
[null,null,{"$f":"C745+90","v":"1989-03-31"},{"v":9244.954,"d":"9,244.954"},9.131833168146326,1.2215962425239368,"Expansión"]
[null,null,{"$f":"C746+91","v":"1989-06-30"},{"v":9355.919,"d":"9,355.919"},9.143764470120633,1.1931301974307473,"Expansión"]
[null,null,{"$f":"C747+92","v":"1989-09-30"},{"v":9457.422,"d":"9,457.422"},9.154555109050493,1.0790638929860208,"Expansión"]
[null,null,{"$f":"C748+92","v":"1989-12-31"},{"v":9553.114,"d":"9,553.114"},9.164622453622862,1.0067344572368242,"Expansión"]
[null,null,{"$f":"C749+90","v":"1990-03-31"},{"v":9642.296,"d":"9,642.296"},9.173914533519461,0.9292079896599859,"Expansión"]
[null,null,{"$f":"C750+91","v":"1990-06-30"},{"v":9722.119,"d":"9,722.119"},9.182158877810267,0.8244344290805117,"Expansión"]
[null,null,{"$f":"C751+92","v":"1990-09-30"},{"v":9802.427,"d":"9,802.427"},9.19038528705893,0.8226409248663913,"Expansión"]
[null,null,{"$f":"C752+92","v":"1990-12-31"},{"v":9851.455,"d":"9,851.455"},9.19537443899328,0.4989151934349678,"Expansión"]
[null,null,{"$f":"C753+90","v":"1991-03-31"},{"v":9888.737,"d":"9,888.737"},9.199151711709536,0.37772727162561637,"Expansión"]
[null,null,{"$f":"C754+91","v":"1991-06-30"},{"v":9947.364,"d":"9,947.364"},9.205062870430796,0.5911158721259469,"Expansión"]
[null,null,{"$f":"C755+92","v":"1991-09-30"},{"v":10016.847,"d":"10,016.847"},9.212023654460973,0.6960784030177081,"Expansión"]
[null,null,{"$f":"C756+92","v":"1991-12-31"},{"v":10050.227,"d":"10,050.227"},9.215350500296815,0.3326845835841752,"Expansión"]
[null,null,{"$f":"C757+91","v":"1992-03-31"},{"v":10070.344,"d":"10,070.344"},9.217350146003021,0.19996457062063655,"Expansión"]
[null,null,{"$f":"C758+91","v":"1992-06-30"},{"v":10075.613,"d":"10,075.613"},9.217873228636439,0.05230826334177152,"Pico"]
[null,null,{"$f":"C759+92","v":"1992-09-30"},{"v":10044.635,"d":"10,044.635"},9.214793940103036,-0.3079288533403002,"Recesión"]
[null,null,{"$f":"C760+92","v":"1992-12-31"},{"v":9986.851,"d":"9,986.851"},9.209024606736625,-0.5769333366410834,"Recesión"]
[null,null,{"$f":"C761+90","v":"1993-03-31"},{"v":9937.692,"d":"9,937.692"},9.20409007953066,-0.4934527205964656,"Recesión"]
[null,null,{"$f":"C762+91","v":"1993-06-30"},{"v":9907.366,"d":"9,907.366"},9.201033799865883,-0.3056279664777506,"Recesión"]
[null,null,{"$f":"C763+92","v":"1993-09-30"},{"v":9906.048,"d":"9,906.048"},9.200900758684597,-0.013304118128587561,"Fondo"]
[null,null,{"$f":"C764+92","v":"1993-12-31"},{"v":9958.927,"d":"9,958.927"},9.206224613851557,0.5323855166960101,"Expansión"]
[null,null,{"$f":"C765+90","v":"1994-03-31"},{"v":10037.915,"d":"10,037.915"},9.214124702356752,0.7900088505195413,"Expansión"]
[null,null,{"$f":"C766+91","v":"1994-06-30"},{"v":10115.36,"d":"10,115.360"},9.221810339675383,0.7685637318630256,"Expansión"]
[null,null,{"$f":"C767+92","v":"1994-09-30"},{"v":10187.088,"d":"10,187.088"},9.228876315013538,0.7065975338155894,"Expansión"]
[null,null,{"$f":"C768+92","v":"1994-12-31"},{"v":10263.644,"d":"10,263.644"},9.236363221360364,0.7486906346825251,"Expansión"]
[null,null,{"$f":"C769+90","v":"1995-03-31"},{"v":10340.936,"d":"10,340.936"},9.243865666209242,0.7502444848878298,"Expansión"]
[null,null,{"$f":"C770+91","v":"1995-06-30"},{"v":10410.88,"d":"10,410.880"},9.250606692138033,0.6741025928791444,"Expansión"]
[null,null,{"$f":"C771+92","v":"1995-09-30"},{"v":10457.463,"d":"10,457.463"},9.255071165179565,0.4464473041531747,"Expansión"]
[null,null,{"$f":"C772+92","v":"1995-12-31"},{"v":10497.647,"d":"10,497.647"},9.25890641579443,0.38352506148644494,"Expansión"]
[null,null,{"$f":"C773+91","v":"1996-03-31"},{"v":10559.095,"d":"10,559.095"},9.264742852830157,0.5836437035727116,"Expansión"]
[null,null,{"$f":"C774+91","v":"1996-06-30"},{"v":10635.522,"d":"10,635.522"},9.271954809645592,0.7211956815435627,"Expansión"]
[null,null,{"$f":"C775+92","v":"1996-09-30"},{"v":10717.783,"d":"10,717.783"},9.279659603535226,0.7704793889633521,"Expansión"]
[null,null,{"$f":"C776+92","v":"1996-12-31"},{"v":10802.949,"d":"10,802.949"},9.287574431394983,0.7914827859757168,"Expansión"]
[null,null,{"$f":"C777+90","v":"1997-03-31"},{"v":10896.711,"d":"10,896.711"},9.296216279564353,0.8641848169370192,"Expansión"]
[null,null,{"$f":"C778+91","v":"1997-06-30"},{"v":10998.575,"d":"10,998.575"},9.305520997934225,0.9304718369872234,"Expansión"]
[null,null,{"$f":"C779+92","v":"1997-09-30"},{"v":11111.611,"d":"11,111.611"},9.315745876621989,1.022487868776345,"Expansión"]
[null,null,{"$f":"C780+92","v":"1997-12-31"},{"v":11217.216,"d":"11,217.216"},9.32520501994551,0.9459143323521602,"Expansión"]
[null,null,{"$f":"C781+90","v":"1998-03-31"},{"v":11320.396,"d":"11,320.396"},9.334361333477462,0.9156313531951454,"Expansión"]
[null,null,{"$f":"C782+91","v":"1998-06-30"},{"v":11428.749,"d":"11,428.749"},9.343887301979999,0.9525968502536841,"Expansión"]
[null,null,{"$f":"C783+92","v":"1998-09-30"},{"v":11532.808,"d":"11,532.808"},9.352951122207365,0.9063820227366293,{"$f":"IF(AND(F784>=0,F785<0,F788<0,F783>0,F782>0),\"Pico\",IF(AND(F784<=0,F785>0,F788>0,F783<0,F782<0),\"Fondo\",IF(OR(AND(F784<0,F783<0,F782<0),AND(F784<0,F785<0,F788<0),AND(F784<0,F783<0,F785<0)),\"Recesión\",IF(F784>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,null,{"$f":"C784+92","v":"1998-12-31"},{"v":11618.697,"d":"11,618.697"},9.360370889867097,0.7419767659731846,{"$f":"IF(AND(F785>=0,F788<0,F791<0,F784>0,F783>0),\"Pico\",IF(AND(F785<=0,F788>0,F791>0,F784<0,F783<0),\"Fondo\",IF(OR(AND(F785<0,F784<0,F783<0),AND(F785<0,F788<0,F791<0),AND(F785<0,F784<0,F788<0)),\"Recesión\",IF(F785>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[]
[]
[]
[]
["En el segundo ejercicio de la tarea el alumno debe escoger una de las dos siguientes opciones: o analizar el comportamiento de los componentes de la serie del PIB que ha descargado o analizar la variación de la tasa de desempleo y ponerla en relación "]
["con la variación del PIB. Explicaremos los dos."]
[]
[]
[]
["Al medir la volatilidad de la serie, estamos estimando si las variaciones en el PIB son muy grandes o pequeñas. Dicho de otro modo, estamos estudiando si las expansiones y recesiones de la economía son muy fuertes o no: cuanto más volátil sea la"]
["serie, mayor será la diferencia entre las expansiones y las recesiones y los ciclos económicos serán muy pronunciados. La volatilidad se calcula sobre la serie ΔPIB, para lo que se aplica la función de excel DESVEST.M. Para calcular la variación promedio, "]
["simplemente utilizamos la función de excel Promedio."]
[]
[{"$f":"CONCATENATE(\"- La variación total del PIB, aplicando esta fórmula, sería del \",FIXED(_xlfn.STDEV.S(F670:F785),2),\"%. Esto implica que la tasa de variación del PIB suele desviarse un \",FIXED(_xlfn.STDEV.S(F670:F785),2),\"% por encima o por debajo de la media del PIB durante el periodo analizado\")","v":"- La variación total del PIB, aplicando esta fórmula, sería del 0,61%. Esto implica que la tasa de variación del PIB suele desviarse un 0,61% por encima o por debajo de la media del PIB durante el periodo analizado"}]
[{"$f":"CONCATENATE(\"- La variación promedio del PIB, aplicando esta fórmula, sería del \",FIXED(AVERAGE(F670:F785),2),\"%. Esto implica que la tasa de variación del PIB medio es del \",FIXED(AVERAGE(F670:F785),2),\"%\")","v":"- La variación promedio del PIB, aplicando esta fórmula, sería del 0,72%. Esto implica que la tasa de variación del PIB medio es del 0,72%"}]
[]
["El siguiente paso es realizar un análisis similar para cada componente del PIB. En este ejemplo sólo voy a analizar el consumo pero el alumno tendría que hacer lo mismo para la inversión, el gasto público y las exportaciones netas."]
[]
[]
[]
["Si descargamos, formateamos y analizamos la serie del consumo, llegaríamos al siguiente resultado:"]
[]
[]
[null,"DATOS ORIGINALES",null,null,"PRESENTACIÓN 1",null,null,"PRESENTACIÓN 1 (Con variaciones)",{"$nulls":4},"PRESENTACIÓN 1 (con análisis del ciclo)"]
[null,null,"Consumo privado"]
["año","trim","nacional",null,"Periodo","Consumo (C)",null,"Periodo","Consumo (C)","LN(C)","ΔC",null,"Periodo","Consumo (C)","LN(C)","ΔC","Fase Ciclo"]
[1970,1,{"v":3317.3,"d":"3,317.300"},null,"1970Q1",{"$f":"C812","v":{"v":3317.3,"d":"3,317.300"}},null,"1970Q1",{"$f":"F812","v":{"v":3317.3,"d":"3,317.300"}},{"$f":"LN(I812)","v":8.106906478028856},null,null,"1970Q1",{"v":3317.3,"d":"3,317.300"},{"$f":"LN(N812)","v":8.106906478028856}]
[null,2,{"v":3328.3,"d":"3,328.300"},null,"1970Q2",{"$f":"C813","v":{"v":3328.3,"d":"3,328.300"}},null,"1970Q2",{"$f":"F813","v":{"v":3328.3,"d":"3,328.300"}},{"$f":"LN(I813)","v":8.11021694210912},{"$f":"(J813-J812)*100","v":0.3310464080264808},null,"1970Q2",{"v":3328.3,"d":"3,328.300"},{"$f":"LN(N813)","v":8.11021694210912},{"$f":"(O813-O812)*100","v":0.3310464080264808},{"$f":"IF(AND(P813>=0,P814<0,P815<0,P812>0,P811>0),\"Pico\",IF(AND(P813<=0,P814>0,P815>0,P812<0,P811<0),\"Fondo\",IF(OR(AND(P813<0,P812<0,P811<0),AND(P813<0,P814<0,P815<0),AND(P813<0,P812<0,P814<0)),\"Recesión\",IF(P813>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,3,{"v":3350.3,"d":"3,350.300"},null,"1970Q3",{"v":3350.3,"d":"3,350.300"},null,"1970Q3",{"v":3350.3,"d":"3,350.300"},8.116805173048355,{"$f":"(J814-J813)*100","v":0.6588230939234663},null,"1970Q3",{"v":3350.3,"d":"3,350.300"},8.116805173048355,{"$f":"(O814-O813)*100","v":0.6588230939234663},{"$f":"IF(AND(P814>=0,P815<0,P816<0,P813>0,P812>0),\"Pico\",IF(AND(P814<=0,P815>0,P816>0,P813<0,P812<0),\"Fondo\",IF(OR(AND(P814<0,P813<0,P812<0),AND(P814<0,P815<0,P816<0),AND(P814<0,P813<0,P815<0)),\"Recesión\",IF(P814>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,4,{"v":3383.5,"d":"3,383.500"},null,"1970Q4",{"v":3383.5,"d":"3,383.500"},null,"1970Q4",{"v":3383.5,"d":"3,383.500"},8.12666595567228,0.9860782623924536,null,"1970Q4",{"v":3383.5,"d":"3,383.500"},8.12666595567228,0.9860782623924536,"Expansión"]
[1971,1,{"v":3427.6,"d":"3,427.600"},null,"1971Q1",{"v":3427.6,"d":"3,427.600"},null,"1971Q1",{"v":3427.6,"d":"3,427.600"},8.139615586794964,1.294963112268377,null,"1971Q1",{"v":3427.6,"d":"3,427.600"},8.139615586794964,1.294963112268377,"Expansión"]
[null,2,{"v":3480.4,"d":"3,480.400"},null,"1971Q2",{"v":3480.4,"d":"3,480.400"},null,"1971Q2",{"v":3480.4,"d":"3,480.400"},8.154902508691869,1.528692189690517,null,"1971Q2",{"v":3480.4,"d":"3,480.400"},8.154902508691869,1.528692189690517,"Expansión"]
[null,3,{"v":3541.8,"d":"3,541.800"},null,"1971Q3",{"v":3541.8,"d":"3,541.800"},null,"1971Q3",{"v":3541.8,"d":"3,541.800"},8.172390351474698,1.7487842782829333,null,"1971Q3",{"v":3541.8,"d":"3,541.800"},8.172390351474698,1.7487842782829333,"Expansión"]
[null,4,{"v":3611.9,"d":"3,611.900"},null,"1971Q4",{"v":3611.9,"d":"3,611.900"},null,"1971Q4",{"v":3611.9,"d":"3,611.900"},8.191989228660823,1.9598877186124852,null,"1971Q4",{"v":3611.9,"d":"3,611.900"},8.191989228660823,1.9598877186124852,"Expansión"]
[1972,1,{"v":3690.5,"d":"3,690.500"},null,"1972Q1",{"v":3690.5,"d":"3,690.500"},null,"1972Q1",{"v":3690.5,"d":"3,690.500"},8.213517229210106,2.1528000549283277,null,"1972Q1",{"v":3690.5,"d":"3,690.500"},8.213517229210106,2.1528000549283277,"Expansión"]
[null,2,{"v":3768.7,"d":"3,768.700"},null,"1972Q2",{"v":3768.7,"d":"3,768.700"},null,"1972Q2",{"v":3768.7,"d":"3,768.700"},8.234485393389146,2.0968164179040016,null,"1972Q2",{"v":3768.7,"d":"3,768.700"},8.234485393389146,2.0968164179040016,"Expansión"]
[null,3,{"v":3846.3,"d":"3,846.300"},null,"1972Q3",{"v":3846.3,"d":"3,846.300"},null,"1972Q3",{"v":3846.3,"d":"3,846.300"},8.254866926226764,2.038153283761801,null,"1972Q3",{"v":3846.3,"d":"3,846.300"},8.254866926226764,2.038153283761801,"Expansión"]
[null,4,{"v":3923.3,"d":"3,923.300"},null,"1972Q4",{"v":3923.3,"d":"3,923.300"},null,"1972Q4",{"v":3923.3,"d":"3,923.300"},8.274688415373399,1.9821489146634619,null,"1972Q4",{"v":3923.3,"d":"3,923.300"},8.274688415373399,1.9821489146634619,"Expansión"]
[1973,1,{"v":3999.8,"d":"3,999.800"},null,"1973Q1",{"v":3999.8,"d":"3,999.800"},null,"1973Q1",{"v":3999.8,"d":"3,999.800"},8.293999638851986,1.9311223478586825,null,"1973Q1",{"v":3999.8,"d":"3,999.800"},8.293999638851986,1.9311223478586825,"Expansión"]
[null,2,{"v":4072.1,"d":"4,072.100"},null,"1973Q2",{"v":4072.1,"d":"4,072.100"},null,"1973Q2",{"v":4072.1,"d":"4,072.100"},8.311914115885594,1.7914477033608378,null,"1973Q2",{"v":4072.1,"d":"4,072.100"},8.311914115885594,1.7914477033608378,"Expansión"]
[null,3,{"v":4140.4,"d":"4,140.400"},null,"1973Q3",{"v":4140.4,"d":"4,140.400"},null,"1973Q3",{"v":4140.4,"d":"4,140.400"},8.328547680509596,1.6633564624001451,null,"1973Q3",{"v":4140.4,"d":"4,140.400"},8.328547680509596,1.6633564624001451,"Expansión"]
[null,4,{"v":4204.5,"d":"4,204.500"},null,"1973Q4",{"v":4204.5,"d":"4,204.500"},null,"1973Q4",{"v":4204.5,"d":"4,204.500"},8.343910659272952,1.5362978763356239,null,"1973Q4",{"v":4204.5,"d":"4,204.500"},8.343910659272952,1.5362978763356239,"Expansión"]
[1974,1,{"v":4264.6,"d":"4,264.600"},null,"1974Q1",{"v":4264.6,"d":"4,264.600"},null,"1974Q1",{"v":4264.6,"d":"4,264.600"},8.358103668892134,1.4193009619182462,null,"1974Q1",{"v":4264.6,"d":"4,264.600"},8.358103668892134,1.4193009619182462,"Expansión"]
[null,2,{"v":4308.1,"d":"4,308.100"},null,"1974Q2",{"v":4308.1,"d":"4,308.100"},null,"1974Q2",{"v":4308.1,"d":"4,308.100"},8.36825225063454,1.0148581742406293,null,"1974Q2",{"v":4308.1,"d":"4,308.100"},8.36825225063454,1.0148581742406293,"Expansión"]
[null,3,{"v":4335.1,"d":"4,335.100"},null,"1974Q3",{"v":4335.1,"d":"4,335.100"},null,"1974Q3",{"v":4335.1,"d":"4,335.100"},8.374499956999328,0.624770636478722,null,"1974Q3",{"v":4335.1,"d":"4,335.100"},8.374499956999328,0.624770636478722,"Expansión"]
[null,4,{"v":4345.8,"d":"4,345.800"},null,"1974Q4",{"v":4345.8,"d":"4,345.800"},null,"1974Q4",{"v":4345.8,"d":"4,345.800"},8.376965140429336,0.2465183430008011,null,"1974Q4",{"v":4345.8,"d":"4,345.800"},8.376965140429336,0.2465183430008011,"Expansión"]
[1975,1,{"v":4339.9,"d":"4,339.900"},null,"1975Q1",{"v":4339.9,"d":"4,339.900"},null,"1975Q1",{"v":4339.9,"d":"4,339.900"},8.375606585354337,-0.1358555074999046,null,"1975Q1",{"v":4339.9,"d":"4,339.900"},8.375606585354337,-0.1358555074999046,"Desaceleración"]
[null,2,{"v":4358,"d":"4,358.000"},null,"1975Q2",{"v":4358,"d":"4,358.000"},null,"1975Q2",{"v":4358,"d":"4,358.000"},8.379768515504566,0.41619301502286987,null,"1975Q2",{"v":4358,"d":"4,358.000"},8.379768515504566,0.41619301502286987,"Expansión"]
[null,3,{"v":4400.1,"d":"4,400.100"},null,"1975Q3",{"v":4400.1,"d":"4,400.100"},null,"1975Q3",{"v":4400.1,"d":"4,400.100"},8.38938254692082,0.961403141625361,null,"1975Q3",{"v":4400.1,"d":"4,400.100"},8.38938254692082,0.961403141625361,"Expansión"]
[null,4,{"v":4466.3,"d":"4,466.300"},null,"1975Q4",{"v":4466.3,"d":"4,466.300"},null,"1975Q4",{"v":4466.3,"d":"4,466.300"},8.404315604349122,1.4933057428303087,null,"1975Q4",{"v":4466.3,"d":"4,466.300"},8.404315604349122,1.4933057428303087,"Expansión"]
[1976,1,{"v":4556.6,"d":"4,556.600"},null,"1976Q1",{"v":4556.6,"d":"4,556.600"},null,"1976Q1",{"v":4556.6,"d":"4,556.600"},8.42433201036495,2.0016406015827215,null,"1976Q1",{"v":4556.6,"d":"4,556.600"},8.42433201036495,2.0016406015827215,"Expansión"]
[null,2,{"v":4624.8,"d":"4,624.800"},null,"1976Q2",{"v":4624.8,"d":"4,624.800"},null,"1976Q2",{"v":4624.8,"d":"4,624.800"},8.439188405768267,1.485639540331718,null,"1976Q2",{"v":4624.8,"d":"4,624.800"},8.439188405768267,1.485639540331718,"Expansión"]
[null,3,{"v":4671.1,"d":"4,671.100"},null,"1976Q3",{"v":4671.1,"d":"4,671.100"},null,"1976Q3",{"v":4671.1,"d":"4,671.100"},8.449149868964874,0.9961463196606957,null,"1976Q3",{"v":4671.1,"d":"4,671.100"},8.449149868964874,0.9961463196606957,"Expansión"]
[null,4,{"v":4695.4,"d":"4,695.400"},null,"1976Q4",{"v":4695.4,"d":"4,695.400"},null,"1976Q4",{"v":4695.4,"d":"4,695.400"},8.454338585031408,0.5188716066534482,null,"1976Q4",{"v":4695.4,"d":"4,695.400"},8.454338585031408,0.5188716066534482,"Expansión"]
[1977,1,{"v":4697.7,"d":"4,697.700"},null,"1977Q1",{"v":4697.7,"d":"4,697.700"},null,"1977Q1",{"v":4697.7,"d":"4,697.700"},8.454828306219508,0.048972118809942344,null,"1977Q1",{"v":4697.7,"d":"4,697.700"},8.454828306219508,0.048972118809942344,"Expansión"]
[null,2,{"v":4702,"d":"4,702.000"},null,"1977Q2",{"v":4702,"d":"4,702.000"},null,"1977Q2",{"v":4702,"d":"4,702.000"},8.455743229100015,0.09149228805078735,null,"1977Q2",{"v":4702,"d":"4,702.000"},8.455743229100015,0.09149228805078735,"Expansión"]
[null,3,{"v":4708.7,"d":"4,708.700"},null,"1977Q3",{"v":4708.7,"d":"4,708.700"},null,"1977Q3",{"v":4708.7,"d":"4,708.700"},8.45716714042054,0.1423911320523885,null,"1977Q3",{"v":4708.7,"d":"4,708.700"},8.45716714042054,0.1423911320523885,"Expansión"]
[null,4,{"v":4717.6,"d":"4,717.600"},null,"1977Q4",{"v":4717.6,"d":"4,717.600"},null,"1977Q4",{"v":4717.6,"d":"4,717.600"},8.459055474686295,0.18883342657556312,null,"1977Q4",{"v":4717.6,"d":"4,717.600"},8.459055474686295,0.18883342657556312,"Expansión"]
[1978,1,{"v":4728.5,"d":"4,728.500"},null,"1978Q1",{"v":4728.5,"d":"4,728.500"},null,"1978Q1",{"v":4728.5,"d":"4,728.500"},8.461363306455567,0.2307831769272184,null,"1978Q1",{"v":4728.5,"d":"4,728.500"},8.461363306455567,0.2307831769272184,"Expansión"]
[null,2,{"v":4741.1,"d":"4,741.100"},null,"1978Q2",{"v":4741.1,"d":"4,741.100"},null,"1978Q2",{"v":4741.1,"d":"4,741.100"},8.46402445527617,0.26611488206036427,null,"1978Q2",{"v":4741.1,"d":"4,741.100"},8.46402445527617,0.26611488206036427,"Expansión"]
[null,3,{"v":4755.1,"d":"4,755.100"},null,"1978Q3",{"v":4755.1,"d":"4,755.100"},null,"1978Q3",{"v":4755.1,"d":"4,755.100"},8.46697300525257,0.29485499763985956,null,"1978Q3",{"v":4755.1,"d":"4,755.100"},8.46697300525257,0.29485499763985956,"Expansión"]
[null,4,{"v":4770.7,"d":"4,770.700"},null,"1978Q4",{"v":4770.7,"d":"4,770.700"},null,"1978Q4",{"v":4770.7,"d":"4,770.700"},8.47024832363969,0.3275318387121473,null,"1978Q4",{"v":4770.7,"d":"4,770.700"},8.47024832363969,0.3275318387121473,"Expansión"]
[1979,1,{"v":4787.8,"d":"4,787.800"},null,"1979Q1",{"v":4787.8,"d":"4,787.800"},null,"1979Q1",{"v":4787.8,"d":"4,787.800"},8.473826294711024,0.3577971071333508,null,"1979Q1",{"v":4787.8,"d":"4,787.800"},8.473826294711024,0.3577971071333508,"Expansión"]
[null,2,{"v":4803.8,"d":"4,803.800"},null,"1979Q2",{"v":4803.8,"d":"4,803.800"},null,"1979Q2",{"v":4803.8,"d":"4,803.800"},8.477162550359884,0.3336255648859421,null,"1979Q2",{"v":4803.8,"d":"4,803.800"},8.477162550359884,0.3336255648859421,"Expansión"]
[null,3,{"v":4818.5,"d":"4,818.500"},null,"1979Q3",{"v":4818.5,"d":"4,818.500"},null,"1979Q3",{"v":4818.5,"d":"4,818.500"},8.480217955291343,0.30554049314588383,null,"1979Q3",{"v":4818.5,"d":"4,818.500"},8.480217955291343,0.30554049314588383,"Expansión"]
[null,4,{"v":4832.1,"d":"4,832.100"},null,"1979Q4",{"v":4832.1,"d":"4,832.100"},null,"1979Q4",{"v":4832.1,"d":"4,832.100"},8.483036434764744,0.281847947340097,null,"1979Q4",{"v":4832.1,"d":"4,832.100"},8.483036434764744,0.281847947340097,"Expansión"]
[1980,1,{"v":4844.5,"d":"4,844.500"},null,"1980Q1",{"v":4844.5,"d":"4,844.500"},null,"1980Q1",{"v":4844.5,"d":"4,844.500"},8.48559931982506,0.2562885060315878,null,"1980Q1",{"v":4844.5,"d":"4,844.500"},8.48559931982506,0.2562885060315878,"Expansión"]
[null,2,{"v":4847.5,"d":"4,847.500"},null,"1980Q2",{"v":4847.5,"d":"4,847.500"},null,"1980Q2",{"v":4847.5,"d":"4,847.500"},8.486218387116807,0.061906729174765474,null,"1980Q2",{"v":4847.5,"d":"4,847.500"},8.486218387116807,0.061906729174765474,"Pico"]
[null,3,{"v":4840.8,"d":"4,840.800"},null,"1980Q3",{"v":4840.8,"d":"4,840.800"},null,"1980Q3",{"v":4840.8,"d":"4,840.800"},8.48483527530811,-0.13831118086962135,null,"1980Q3",{"v":4840.8,"d":"4,840.800"},8.48483527530811,-0.13831118086962135,"Recesión"]
[null,4,{"v":4824.9,"d":"4,824.900"},null,"1980Q4",{"v":4824.9,"d":"4,824.900"},null,"1980Q4",{"v":4824.9,"d":"4,824.900"},8.48154528816971,-0.3289987138400008,null,"1980Q4",{"v":4824.9,"d":"4,824.900"},8.48154528816971,-0.3289987138400008,"Recesión"]
[1981,1,{"v":4799.5,"d":"4,799.500"},null,"1981Q1",{"v":4799.5,"d":"4,799.500"},null,"1981Q1",{"v":4799.5,"d":"4,799.500"},8.476267024803592,-0.5278263366118807,null,"1981Q1",{"v":4799.5,"d":"4,799.500"},8.476267024803592,-0.5278263366118807,"Recesión"]
[null,2,{"v":4780.8,"d":"4,780.800"},null,"1981Q2",{"v":4780.8,"d":"4,780.800"},null,"1981Q2",{"v":4780.8,"d":"4,780.800"},8.472363175498444,-0.39038493051481993,null,"1981Q2",{"v":4780.8,"d":"4,780.800"},8.472363175498444,-0.39038493051481993,"Recesión"]
[null,3,{"v":4769,"d":"4,769.000"},null,"1981Q3",{"v":4769,"d":"4,769.000"},null,"1981Q3",{"v":4769,"d":"4,769.000"},8.469891918298224,-0.24712572002201227,null,"1981Q3",{"v":4769,"d":"4,769.000"},8.469891918298224,-0.24712572002201227,"Recesión"]
[null,4,{"v":4763.9,"d":"4,763.900"},null,"1981Q4",{"v":4763.9,"d":"4,763.900"},null,"1981Q4",{"v":4763.9,"d":"4,763.900"},8.468821939490818,-0.10699788074060024,null,"1981Q4",{"v":4763.9,"d":"4,763.900"},8.468821939490818,-0.10699788074060024,"Fondo"]
[1982,1,{"v":4765.6,"d":"4,765.600"},null,"1982Q1",{"v":4765.6,"d":"4,765.600"},null,"1982Q1",{"v":4765.6,"d":"4,765.600"},8.469178726314478,0.0356786823660471,null,"1982Q1",{"v":4765.6,"d":"4,765.600"},8.469178726314478,0.0356786823660471,"Expansión"]
[null,2,{"v":4769.2,"d":"4,769.200"},null,"1982Q2",{"v":4769.2,"d":"4,769.200"},null,"1982Q2",{"v":4769.2,"d":"4,769.200"},8.469933854931977,0.07551286174987126,null,"1982Q2",{"v":4769.2,"d":"4,769.200"},8.469933854931977,0.07551286174987126,"Expansión"]
[null,3,{"v":4774.9,"d":"4,774.900"},null,"1982Q3",{"v":4774.9,"d":"4,774.900"},null,"1982Q3",{"v":4774.9,"d":"4,774.900"},8.471128310287158,0.11944553551810344,null,"1982Q3",{"v":4774.9,"d":"4,774.900"},8.471128310287158,0.11944553551810344,"Expansión"]
[null,4,{"v":4782.4,"d":"4,782.400"},null,"1982Q4",{"v":4782.4,"d":"4,782.400"},null,"1982Q4",{"v":4782.4,"d":"4,782.400"},8.472697791529674,0.1569481242515991,null,"1982Q4",{"v":4782.4,"d":"4,782.400"},8.472697791529674,0.1569481242515991,"Expansión"]
[1983,1,{"v":4791.8,"d":"4,791.800"},null,"1983Q1",{"v":4791.8,"d":"4,791.800"},null,"1983Q1",{"v":4791.8,"d":"4,791.800"},8.47466140269726,0.19636111675858103,null,"1983Q1",{"v":4791.8,"d":"4,791.800"},8.47466140269726,0.19636111675858103,"Expansión"]
[null,2,{"v":4793.5,"d":"4,793.500"},null,"1983Q2",{"v":4793.5,"d":"4,793.500"},null,"1983Q2",{"v":4793.5,"d":"4,793.500"},8.475016112517052,0.035470981979202065,null,"1983Q2",{"v":4793.5,"d":"4,793.500"},8.475016112517052,0.035470981979202065,"Pico"]
[null,3,{"v":4787.5,"d":"4,787.500"},null,"1983Q3",{"v":4787.5,"d":"4,787.500"},null,"1983Q3",{"v":4787.5,"d":"4,787.500"},8.473763633488902,-0.12524790281496223,null,"1983Q3",{"v":4787.5,"d":"4,787.500"},8.473763633488902,-0.12524790281496223,"Recesión"]
[null,4,{"v":4773.7,"d":"4,773.700"},null,"1983Q4",{"v":4773.7,"d":"4,773.700"},null,"1983Q4",{"v":4773.7,"d":"4,773.700"},8.470876964538814,-0.2886668950088378,null,"1983Q4",{"v":4773.7,"d":"4,773.700"},8.470876964538814,-0.2886668950088378,"Recesión"]
[1984,1,{"v":4752.1,"d":"4,752.100"},null,"1984Q1",{"v":4752.1,"d":"4,752.100"},null,"1984Q1",{"v":4752.1,"d":"4,752.100"},8.466341904592108,-0.45350599467059993,null,"1984Q1",{"v":4752.1,"d":"4,752.100"},8.466341904592108,-0.45350599467059993,"Fondo"]
[null,2,{"v":4753.2,"d":"4,753.200"},null,"1984Q2",{"v":4753.2,"d":"4,753.200"},null,"1984Q2",{"v":4753.2,"d":"4,753.200"},8.466573354415871,0.023144982376344103,null,"1984Q2",{"v":4753.2,"d":"4,753.200"},8.466573354415871,0.023144982376344103,"Expansión"]
[null,3,{"v":4777,"d":"4,777.000"},null,"1984Q3",{"v":4777,"d":"4,777.000"},null,"1984Q3",{"v":4777,"d":"4,777.000"},8.471568013389962,0.4994658974091237,null,"1984Q3",{"v":4777,"d":"4,777.000"},8.471568013389962,0.4994658974091237,"Expansión"]
[null,4,{"v":4823.7,"d":"4,823.700"},null,"1984Q4",{"v":4823.7,"d":"4,823.700"},null,"1984Q4",{"v":4823.7,"d":"4,823.700"},8.481296547418475,0.9728534028512925,null,"1984Q4",{"v":4823.7,"d":"4,823.700"},8.481296547418475,0.9728534028512925,"Expansión"]
[1985,1,{"v":4893,"d":"4,893.000"},null,"1985Q1",{"v":4893,"d":"4,893.000"},null,"1985Q1",{"v":4893,"d":"4,893.000"},8.495560891289124,1.4264343870648233,null,"1985Q1",{"v":4893,"d":"4,893.000"},8.495560891289124,1.4264343870648233,"Expansión"]
[null,2,{"v":4941.6,"d":"4,941.600"},null,"1985Q2",{"v":4941.6,"d":"4,941.600"},null,"1985Q2",{"v":4941.6,"d":"4,941.600"},8.50544444438169,0.9883553092565833,null,"1985Q2",{"v":4941.6,"d":"4,941.600"},8.50544444438169,0.9883553092565833,"Expansión"]
[null,3,{"v":4969.6,"d":"4,969.600"},null,"1985Q3",{"v":4969.6,"d":"4,969.600"},null,"1985Q3",{"v":4969.6,"d":"4,969.600"},8.511094632954368,0.5650188572678516,null,"1985Q3",{"v":4969.6,"d":"4,969.600"},8.511094632954368,0.5650188572678516,"Expansión"]
[null,4,{"v":4977,"d":"4,977.000"},null,"1985Q4",{"v":4977,"d":"4,977.000"},null,"1985Q4",{"v":4977,"d":"4,977.000"},8.512582578858554,0.14879459041861054,null,"1985Q4",{"v":4977,"d":"4,977.000"},8.512582578858554,0.14879459041861054,"Expansión"]
[1986,1,{"v":5019.735,"d":"5,019.735"},null,"1986Q1",{"v":5019.735,"d":"5,019.735"},null,"1986Q1",{"v":5019.735,"d":"5,019.735"},8.521132422447772,0.8549843589218398,null,"1986Q1",{"v":5019.735,"d":"5,019.735"},8.521132422447772,0.8549843589218398,"Expansión"]
[null,2,{"v":5067.13,"d":"5,067.130"},null,"1986Q2",{"$f":"C877","v":{"v":5067.13,"d":"5,067.130"}},null,"1986Q2",{"$f":"F877","v":{"v":5067.13,"d":"5,067.130"}},{"$f":"LN(I877)","v":8.530529861353623},0.9397438905850208,null,"1986Q2",{"v":5067.13,"d":"5,067.130"},{"$f":"LN(N877)","v":8.530529861353623},0.9397438905850208,"Expansión"]
[null,3,{"v":5132.511,"d":"5,132.511"},null,"1986Q3",{"v":5132.511,"d":"5,132.511"},null,"1986Q3",{"v":5132.511,"d":"5,132.511"},8.543350292095857,{"$f":"(J878-J877)*100","v":1.2820430742234379},null,"1986Q3",{"v":5132.511,"d":"5,132.511"},8.543350292095857,{"$f":"(O878-O877)*100","v":1.2820430742234379},{"$f":"IF(AND(P878>=0,P879<0,P880<0,P877>0,P876>0),\"Pico\",IF(AND(P878<=0,P879>0,P880>0,P877<0,P876<0),\"Fondo\",IF(OR(AND(P878<0,P877<0,P876<0),AND(P878<0,P879<0,P880<0),AND(P878<0,P877<0,P879<0)),\"Recesión\",IF(P878>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,4,{"v":5218.354,"d":"5,218.354"},null,"1986Q4",{"v":5218.354,"d":"5,218.354"},null,"1986Q4",{"v":5218.354,"d":"5,218.354"},8.559937305480593,1.6587013384736338,null,"1986Q4",{"v":5218.354,"d":"5,218.354"},8.559937305480593,1.6587013384736338,"Expansión"]
[1987,1,{"v":5322.779,"d":"5,322.779"},null,"1987Q1",{"v":5322.779,"d":"5,322.779"},null,"1987Q1",{"v":5322.779,"d":"5,322.779"},8.579750814369854,1.981350888926059,null,"1987Q1",{"v":5322.779,"d":"5,322.779"},8.579750814369854,1.981350888926059,"Expansión"]
[null,2,{"v":5377.241,"d":"5,377.241"},null,"1987Q2",{"v":5377.241,"d":"5,377.241"},null,"1987Q2",{"v":5377.241,"d":"5,377.241"},8.589930696337163,1.0179881967308901,null,"1987Q2",{"v":5377.241,"d":"5,377.241"},8.589930696337163,1.0179881967308901,"Expansión"]
[null,3,{"v":5436.611,"d":"5,436.611"},null,"1987Q3",{"v":5436.611,"d":"5,436.611"},null,"1987Q3",{"v":5436.611,"d":"5,436.611"},8.600911167777424,1.0980471440261041,null,"1987Q3",{"v":5436.611,"d":"5,436.611"},8.600911167777424,1.0980471440261041,"Expansión"]
[null,4,{"v":5485.221,"d":"5,485.221"},null,"1987Q4",{"v":5485.221,"d":"5,485.221"},null,"1987Q4",{"v":5485.221,"d":"5,485.221"},8.609812663602291,0.8901495824867212,null,"1987Q4",{"v":5485.221,"d":"5,485.221"},8.609812663602291,0.8901495824867212,"Expansión"]
[1988,1,{"v":5544.975,"d":"5,544.975"},null,"1988Q1",{"v":5544.975,"d":"5,544.975"},null,"1988Q1",{"v":5544.975,"d":"5,544.975"},8.620647391208028,1.083472760573656,null,"1988Q1",{"v":5544.975,"d":"5,544.975"},8.620647391208028,1.083472760573656,"Expansión"]
[null,2,{"v":5627.909,"d":"5,627.909"},null,"1988Q2",{"v":5627.909,"d":"5,627.909"},null,"1988Q2",{"v":5627.909,"d":"5,627.909"},8.635493248949329,1.4845857741301316,null,"1988Q2",{"v":5627.909,"d":"5,627.909"},8.635493248949329,1.4845857741301316,"Expansión"]
[null,3,{"v":5713.14,"d":"5,713.140"},null,"1988Q3",{"v":5713.14,"d":"5,713.140"},null,"1988Q3",{"v":5713.14,"d":"5,713.140"},8.650524063937947,1.5030814988618246,null,"1988Q3",{"v":5713.14,"d":"5,713.140"},8.650524063937947,1.5030814988618246,"Expansión"]
[null,4,{"v":5797.695,"d":"5,797.695"},null,"1988Q4",{"v":5797.695,"d":"5,797.695"},null,"1988Q4",{"v":5797.695,"d":"5,797.695"},8.665215703751617,1.469163981366961,null,"1988Q4",{"v":5797.695,"d":"5,797.695"},8.665215703751617,1.469163981366961,"Expansión"]
[1989,1,{"v":5884.688,"d":"5,884.688"},null,"1989Q1",{"v":5884.688,"d":"5,884.688"},null,"1989Q1",{"v":5884.688,"d":"5,884.688"},8.680109002146237,1.4893298394619947,null,"1989Q1",{"v":5884.688,"d":"5,884.688"},8.680109002146237,1.4893298394619947,"Expansión"]
[null,2,{"v":5967.461,"d":"5,967.461"},null,"1989Q2",{"v":5967.461,"d":"5,967.461"},null,"1989Q2",{"v":5967.461,"d":"5,967.461"},8.694076822791546,1.3967820645309104,null,"1989Q2",{"v":5967.461,"d":"5,967.461"},8.694076822791546,1.3967820645309104,"Expansión"]
[null,3,{"v":6030.496,"d":"6,030.496"},null,"1989Q3",{"v":6030.496,"d":"6,030.496"},null,"1989Q3",{"v":6030.496,"d":"6,030.496"},8.70458454172816,1.0507718936613841,null,"1989Q3",{"v":6030.496,"d":"6,030.496"},8.70458454172816,1.0507718936613841,"Expansión"]
[null,4,{"v":6083.226,"d":"6,083.226"},null,"1989Q4",{"v":6083.226,"d":"6,083.226"},null,"1989Q4",{"v":6083.226,"d":"6,083.226"},8.713290426351257,0.8705884623097404,null,"1989Q4",{"v":6083.226,"d":"6,083.226"},8.713290426351257,0.8705884623097404,"Expansión"]
[1990,1,{"v":6134.8,"d":"6,134.800"},null,"1990Q1",{"v":6134.8,"d":"6,134.800"},null,"1990Q1",{"v":6134.8,"d":"6,134.800"},8.721732756776625,0.8442330425367572,null,"1990Q1",{"v":6134.8,"d":"6,134.800"},8.721732756776625,0.8442330425367572,"Expansión"]
[null,2,{"v":6194.416,"d":"6,194.416"},null,"1990Q2",{"v":6194.416,"d":"6,194.416"},null,"1990Q2",{"v":6194.416,"d":"6,194.416"},8.731403520047351,0.9670763270726468,null,"1990Q2",{"v":6194.416,"d":"6,194.416"},8.731403520047351,0.9670763270726468,"Expansión"]
[null,3,{"v":6237.774,"d":"6,237.774"},null,"1990Q3",{"v":6237.774,"d":"6,237.774"},null,"1990Q3",{"v":6237.774,"d":"6,237.774"},8.738378666950686,0.6975146903334561,null,"1990Q3",{"v":6237.774,"d":"6,237.774"},8.738378666950686,0.6975146903334561,"Expansión"]
[null,4,{"v":6271.587,"d":"6,271.587"},null,"1990Q4",{"v":6271.587,"d":"6,271.587"},null,"1990Q4",{"v":6271.587,"d":"6,271.587"},8.74378471164787,0.5406044697183532,null,"1990Q4",{"v":6271.587,"d":"6,271.587"},8.74378471164787,0.5406044697183532,"Expansión"]
[1991,1,{"v":6297.506,"d":"6,297.506"},null,"1991Q1",{"v":6297.506,"d":"6,297.506"},null,"1991Q1",{"v":6297.506,"d":"6,297.506"},8.747908960985344,0.41242493374742395,null,"1991Q1",{"v":6297.506,"d":"6,297.506"},8.747908960985344,0.41242493374742395,"Expansión"]
[null,2,{"v":6357.591,"d":"6,357.591"},null,"1991Q2",{"v":6357.591,"d":"6,357.591"},null,"1991Q2",{"v":6357.591,"d":"6,357.591"},8.757404810996428,0.9495850011084883,null,"1991Q2",{"v":6357.591,"d":"6,357.591"},8.757404810996428,0.9495850011084883,"Expansión"]
[null,3,{"v":6421.369,"d":"6,421.369"},null,"1991Q3",{"v":6421.369,"d":"6,421.369"},null,"1991Q3",{"v":6421.369,"d":"6,421.369"},8.767386613827005,0.9981802830576925,null,"1991Q3",{"v":6421.369,"d":"6,421.369"},8.767386613827005,0.9981802830576925,"Expansión"]
[null,4,{"v":6479.915,"d":"6,479.915"},null,"1991Q4",{"v":6479.915,"d":"6,479.915"},null,"1991Q4",{"v":6479.915,"d":"6,479.915"},8.776462671976338,0.9076058149332766,null,"1991Q4",{"v":6479.915,"d":"6,479.915"},8.776462671976338,0.9076058149332766,"Expansión"]
[1992,1,{"v":6520.82,"d":"6,520.820"},null,"1992Q1",{"v":6520.82,"d":"6,520.820"},null,"1992Q1",{"v":6520.82,"d":"6,520.820"},8.782755413883875,0.6292741907536481,null,"1992Q1",{"v":6520.82,"d":"6,520.820"},8.782755413883875,0.6292741907536481,"Expansión"]
[null,2,{"v":6560.092,"d":"6,560.092"},null,"1992Q2",{"v":6560.092,"d":"6,560.092"},null,"1992Q2",{"v":6560.092,"d":"6,560.092"},8.788759906230037,0.6004492346162849,null,"1992Q2",{"v":6560.092,"d":"6,560.092"},8.788759906230037,0.6004492346162849,"Pico"]
[null,3,{"v":6550.103,"d":"6,550.103"},null,"1992Q3",{"v":6550.103,"d":"6,550.103"},null,"1992Q3",{"v":6550.103,"d":"6,550.103"},8.787236053696498,-0.15238525335394826,null,"1992Q3",{"v":6550.103,"d":"6,550.103"},8.787236053696498,-0.15238525335394826,"Recesión"]
[null,4,{"v":6490.775,"d":"6,490.775"},null,"1992Q4",{"v":6490.775,"d":"6,490.775"},null,"1992Q4",{"v":6490.775,"d":"6,490.775"},8.778137217052615,-0.909883664388289,null,"1992Q4",{"v":6490.775,"d":"6,490.775"},8.778137217052615,-0.909883664388289,"Recesión"]
[1993,1,{"v":6403.029,"d":"6,403.029"},null,"1993Q1",{"v":6403.029,"d":"6,403.029"},null,"1993Q1",{"v":6403.029,"d":"6,403.029"},8.764526438635517,-1.361077841709779,null,"1993Q1",{"v":6403.029,"d":"6,403.029"},8.764526438635517,-1.361077841709779,"Recesión"]
[null,2,{"v":6387.425,"d":"6,387.425"},null,"1993Q2",{"v":6387.425,"d":"6,387.425"},null,"1993Q2",{"v":6387.425,"d":"6,387.425"},8.762086492760051,-0.243994587546581,null,"1993Q2",{"v":6387.425,"d":"6,387.425"},8.762086492760051,-0.243994587546581,"Recesión"]
[null,3,{"v":6379.841,"d":"6,379.841"},null,"1993Q3",{"v":6379.841,"d":"6,379.841"},null,"1993Q3",{"v":6379.841,"d":"6,379.841"},8.760898454398193,-0.11880383618585455,null,"1993Q3",{"v":6379.841,"d":"6,379.841"},8.760898454398193,-0.11880383618585455,"Recesión"]
[null,4,{"v":6372.548,"d":"6,372.548"},null,"1993Q4",{"v":6372.548,"d":"6,372.548"},null,"1993Q4",{"v":6372.548,"d":"6,372.548"},8.759754668587536,-0.11437858106564391,null,"1993Q4",{"v":6372.548,"d":"6,372.548"},8.759754668587536,-0.11437858106564391,"Fondo"]
[1994,1,{"v":6383.724,"d":"6,383.724"},null,"1994Q1",{"v":6383.724,"d":"6,383.724"},null,"1994Q1",{"v":6383.724,"d":"6,383.724"},8.76150690511236,0.17522365248243688,null,"1994Q1",{"v":6383.724,"d":"6,383.724"},8.76150690511236,0.17522365248243688,"Expansión"]
[null,2,{"v":6413.093,"d":"6,413.093"},null,"1994Q2",{"v":6413.093,"d":"6,413.093"},null,"1994Q2",{"v":6413.093,"d":"6,413.093"},8.766096960836945,0.4590055724584374,null,"1994Q2",{"v":6413.093,"d":"6,413.093"},8.766096960836945,0.4590055724584374,"Expansión"]
[null,3,{"v":6462.933,"d":"6,462.933"},null,"1994Q3",{"v":6462.933,"d":"6,462.933"},null,"1994Q3",{"v":6462.933,"d":"6,462.933"},8.773838518506391,0.7741557669445953,null,"1994Q3",{"v":6462.933,"d":"6,462.933"},8.773838518506391,0.7741557669445953,"Expansión"]
[null,4,{"v":6515.463,"d":"6,515.463"},null,"1994Q4",{"v":6515.463,"d":"6,515.463"},null,"1994Q4",{"v":6515.463,"d":"6,515.463"},8.781933553802817,0.809503529642619,null,"1994Q4",{"v":6515.463,"d":"6,515.463"},8.781933553802817,0.809503529642619,"Expansión"]
[1995,1,{"v":6535.003,"d":"6,535.003"},null,"1995Q1",{"v":6535.003,"d":"6,535.003"},null,"1995Q1",{"v":6535.003,"d":"6,535.003"},8.78492808512478,0.29945313219634784,null,"1995Q1",{"v":6535.003,"d":"6,535.003"},8.78492808512478,0.29945313219634784,"Expansión"]
[null,2,{"v":6535.263,"d":"6,535.263"},null,"1995Q2",{"v":6535.263,"d":"6,535.263"},null,"1995Q2",{"v":6535.263,"d":"6,535.263"},8.784967870084023,0.003978495924172876,null,"1995Q2",{"v":6535.263,"d":"6,535.263"},8.784967870084023,0.003978495924172876,"Expansión"]
[null,3,{"v":6542.815,"d":"6,542.815"},null,"1995Q3",{"v":6542.815,"d":"6,542.815"},null,"1995Q3",{"v":6542.815,"d":"6,542.815"},8.786122779978184,0.11549098941614488,null,"1995Q3",{"v":6542.815,"d":"6,542.815"},8.786122779978184,0.11549098941614488,"Expansión"]
[null,4,{"v":6571.183,"d":"6,571.183"},null,"1995Q4",{"v":6571.183,"d":"6,571.183"},null,"1995Q4",{"v":6571.183,"d":"6,571.183"},8.790449156152441,0.43263761742569073,null,"1995Q4",{"v":6571.183,"d":"6,571.183"},8.790449156152441,0.43263761742569073,"Expansión"]
[1996,1,{"v":6617.439,"d":"6,617.439"},null,"1996Q1",{"v":6617.439,"d":"6,617.439"},null,"1996Q1",{"v":6617.439,"d":"6,617.439"},8.797463716076148,0.7014559923707253,null,"1996Q1",{"v":6617.439,"d":"6,617.439"},8.797463716076148,0.7014559923707253,"Expansión"]
[null,2,{"v":6662.855,"d":"6,662.855"},null,"1996Q2",{"v":6662.855,"d":"6,662.855"},null,"1996Q2",{"v":6662.855,"d":"6,662.855"},8.804303350356658,0.6839634280510154,null,"1996Q2",{"v":6662.855,"d":"6,662.855"},8.804303350356658,0.6839634280510154,"Expansión"]
[null,3,{"v":6694.081,"d":"6,694.081"},null,"1996Q3",{"v":6694.081,"d":"6,694.081"},null,"1996Q3",{"v":6694.081,"d":"6,694.081"},8.80897898208647,0.4675631729812224,null,"1996Q3",{"v":6694.081,"d":"6,694.081"},8.80897898208647,0.4675631729812224,"Expansión"]
[null,4,{"v":6727.539,"d":"6,727.539"},null,"1996Q4",{"v":6727.539,"d":"6,727.539"},null,"1996Q4",{"v":6727.539,"d":"6,727.539"},8.813964679685707,0.4985697599236616,null,"1996Q4",{"v":6727.539,"d":"6,727.539"},8.813964679685707,0.4985697599236616,"Expansión"]
[1997,1,{"v":6780.058,"d":"6,780.058"},null,"1997Q1",{"v":6780.058,"d":"6,780.058"},null,"1997Q1",{"v":6780.058,"d":"6,780.058"},8.821740935470123,0.7776255784415653,null,"1997Q1",{"v":6780.058,"d":"6,780.058"},8.821740935470123,0.7776255784415653,"Expansión"]
[null,2,{"v":6850.683,"d":"6,850.683"},null,"1997Q2",{"v":6850.683,"d":"6,850.683"},null,"1997Q2",{"v":6850.683,"d":"6,850.683"},8.832103634314953,1.0362698844829765,null,"1997Q2",{"v":6850.683,"d":"6,850.683"},8.832103634314953,1.0362698844829765,"Expansión"]
[null,3,{"v":6918.805,"d":"6,918.805"},null,"1997Q3",{"v":6918.805,"d":"6,918.805"},null,"1997Q3",{"v":6918.805,"d":"6,918.805"},8.841998345838178,0.9894711523225297,null,"1997Q3",{"v":6918.805,"d":"6,918.805"},8.841998345838178,0.9894711523225297,"Expansión"]
[null,4,{"v":6982.09,"d":"6,982.090"},null,"1997Q4",{"v":6982.09,"d":"6,982.090"},null,"1997Q4",{"v":6982.09,"d":"6,982.090"},8.851103577871218,0.9105232033039812,null,"1997Q4",{"v":6982.09,"d":"6,982.090"},8.851103577871218,0.9105232033039812,"Expansión"]
[1998,1,{"v":7042.374,"d":"7,042.374"},null,"1998Q1",{"v":7042.374,"d":"7,042.374"},null,"1998Q1",{"v":7042.374,"d":"7,042.374"},8.859700608216674,0.8597030345455892,null,"1998Q1",{"v":7042.374,"d":"7,042.374"},8.859700608216674,0.8597030345455892,"Expansión"]
[null,2,{"v":7120.492,"d":"7,120.492"},null,"1998Q2",{"v":7120.492,"d":"7,120.492"},null,"1998Q2",{"v":7120.492,"d":"7,120.492"},8.870732103142243,1.1031494925569874,null,"1998Q2",{"v":7120.492,"d":"7,120.492"},8.870732103142243,1.1031494925569874,"Expansión"]
[null,3,{"v":7183.694,"d":"7,183.694"},null,"1998Q3",{"v":7183.694,"d":"7,183.694"},null,"1998Q3",{"v":7183.694,"d":"7,183.694"},8.879569014420069,0.8836911277825266,null,"1998Q3",{"v":7183.694,"d":"7,183.694"},8.879569014420069,0.8836911277825266,{"$f":"IF(AND(P926>=0,P927<0,Q928<0,P925>0,P924>0),\"Pico\",IF(AND(P926<=0,P927>0,Q928>0,P925<0,P924<0),\"Fondo\",IF(OR(AND(P926<0,P925<0,P924<0),AND(P926<0,P927<0,Q928<0),AND(P926<0,P925<0,P927<0)),\"Recesión\",IF(P926>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[null,4,{"v":7242.741,"d":"7,242.741"},null,"1998Q4",{"v":7242.741,"d":"7,242.741"},null,"1998Q4",{"v":7242.741,"d":"7,242.741"},8.887755004892433,0.8185990472364679,null,"1998Q4",{"v":7242.741,"d":"7,242.741"},8.887755004892433,0.8185990472364679,{"$f":"IF(AND(P927>=0,Q928<0,Q931<0,P926>0,P925>0),\"Pico\",IF(AND(P927<=0,Q928>0,Q931>0,P926<0,P925<0),\"Fondo\",IF(OR(AND(P927<0,P926<0,P925<0),AND(P927<0,Q928<0,Q931<0),AND(P927<0,P926<0,Q928<0)),\"Recesión\",IF(P927>0,\"Expansión\",\"Desaceleración\"))))","v":"Expansión"}]
[]
[null,"De aquí se obtienen los siguientes análisis gráficos y de volatilidad del consumo, que se realizan de la misma forma que hemos explicado para el PIB."]
[]
[]
[{"$nulls":13},"Finalmente, el resultado del análisis para todas las "]
[{"$nulls":13},"varibles seria el siguiente:"]
[]
[{"$nulls":13},"Variable","Volatilidad total","Volatilidad Promedio"]
[{"$nulls":13},"Consumo",{"$f":"CONCATENATE(FIXED(_xlfn.STDEV.S(P813:P927),2),\"%\")","v":"0,70%"},{"$f":"CONCATENATE(FIXED(AVERAGE(P813:P927),2),\"%\")","v":"0,68%"}]
[{"$nulls":13},"Inversión","0,75%","1,07%"]
[{"$nulls":13},"Gasto Público","2,24%","0,66%"]
[{"$nulls":13},"Exportaciones","1,44%","1,82%"]
[{"$nulls":13},"Importaciones","2,28%","1,71%"]
{"$rows_empty":8}
["El último paso de nuestro análisis será el de calcular la correlación entre el consumo y el PIB. Como es muy probable que los alumnos no estén familiarizados con el concepto de correlación, a continuación introducimos este concepto"]
["de un modo muy breve y esquemático, aunque suficiente para los propósitos del presente análisis."]
{"$rows_empty":58}
["Lo anterior sugiere que, para nuestro análisis del PIB, el coeficiente de correlación se puede usar como una medida del grado en el que cada variable se mueve en el mismo sentido que el PIB. Cuando el coeficiente de correlación sea positivo, el"]
["componente del PIB se moverá en el mismo sentido que éste, y diremos que es una variable procíclica. Cuando es negativo, diremos que es una variable anticíclia y cuando es cero diremos que el componente es acíclico. Para calcular el coeficiente"]
["de correlación, simplemente aplicamos la función de excel COEF.DE.CORR a los datos de las series variación del PIB y variación del consumo. Para aplicar esta función en su sintáxis seleccionamos los datos de la serie ΔPIB como \"matriz 1\"  y los datos de la "]
["serie ΔC como \"matriz 2\"."]
[]
[{"$f":"CONCATENATE(\"-El coeficiente de correlación entre la variación del PIB y la variación del consumo es r(ΔPIB,ΔC)=\",FIXED(CORREL(F546:F660,P813:P927),2))","v":"-El coeficiente de correlación entre la variación del PIB y la variación del consumo es r(ΔPIB,ΔC)=0,83"}]
[]
["Si repetimos el análisis para cada componente del PIB obtenemos la siguiente tabla de correlaciones:",{"$nulls":7},"Variables","Coef. de Corr. (r)"]
[{"$nulls":8},"PIB-Consumo",0.831]
[{"$nulls":8},"PIB-Gasto Püblico",0.422]
[{"$nulls":8},"PIB-Inversión",0.795]
[{"$nulls":8},"PIB-Exportaciones",0.123]
[{"$nulls":8},"PIB-Importaciones",0.601]
[]
["De este análisis concluimos que, durante el periodo estudiado, el consumo y la inversión se han comportado de forma procíclica y con una fuerte correlación con el PIB (>0,75). Las importanciones y el gasto público también de forma procíclica pero con "]
["una correlación menor. Finalmente, las exportaciones se comportan de una manera acíclica casi (su coeficiente de correlación es cercano a cero)."]
[]
[]
[]
["De modo alternativo al análisis del punto anterior, los alumnos pueden estudiar la correlación entre la variación en la tasa de desempleo y la variación del PIB. Para ello, en primer lugar deberemos buscar los datos del desempleo y formatearlos ade-"]
["cuadamente."]
[]
[]
[]
["Los datos del paro los obtenemos del INE. Como sólo hay disponibles datos desde el tercer cuatrimestre del año 1976, el análisis lo realizaremos desde este periodo hasta el último (cuarto trimestre de 1998). En primer lugar descargamos y formateamos"]
["la serie del desempleo. Después calculamos la variación trimestral y, por último, adjuntamos la serie de la variación en el PIB trimestral para los periodos seleccionados. El resultado queda resumido en la siguiente tabla:"]
[]
[]
[]
[null,"Periodo","Tasa Paro (U)","ΔU","ΔPIB"]
[null,"1976Q3",4.41]
[null,"1976Q4",4.72,0.3099999999999996,{"v":0.7649600699593861,"d":"0.765"}]
[null,"1977Q1",4.93,0.20999999999999996,{"v":0.789114090457943,"d":"0.789"}]
[null,"1977Q2",4.78,-0.14999999999999947,{"v":0.45260538408289364,"d":"0.453"}]
[null,"1977Q3",5.34,0.5599999999999996,{"v":0.3317457959166603,"d":"0.332"}]
[null,"1977Q4",5.69,0.35000000000000053,{"v":0.6658321372468023,"d":"0.666"}]
[null,"1978Q1",6.47,0.7799999999999994,{"v":0.6223126871621076,"d":"0.622"}]
[null,"1978Q2",6.61,0.14000000000000057,{"v":0.20239672466200176,"d":"0.202"}]
[null,"1978Q3",7.07,0.45999999999999996,{"v":-0.12278500217099975,"d":"-0.123"}]
[null,"1978Q4",7.62,0.5499999999999998,{"v":-0.14810056777658787,"d":"-0.148"}]
[null,"1979Q1",8.13,0.5100000000000007,{"v":-0.15952314369016563,"d":"-0.160"}]
[null,"1979Q2",8.17,0.03999999999999915,{"v":0.15532842484056175,"d":"0.155"}]
[null,"1979Q3",8.72,0.5500000000000007,{"v":0.2402135143874773,"d":"0.240"}]
[null,"1979Q4",9.52,0.7999999999999989,{"v":0.35090198228449054,"d":"0.351"}]
[null,"1980Q1",10.63,1.1100000000000012,{"v":0.4369029883713793,"d":"0.437"}]
[null,"1980Q2",11.12,0.48999999999999844,{"v":0.6236051223655892,"d":"0.624"}]
[null,"1980Q3",11.48,0.3600000000000012,{"v":0.13332144120159484,"d":"0.133"}]
[null,"1980Q4",12.43,0.9499999999999993,{"v":-0.4142901410387978,"d":"-0.414"}]
[null,"1981Q1",13.38,0.9500000000000011,{"v":-0.8546291048915577,"d":"-0.855"}]
[null,"1981Q2",13.64,0.2599999999999998,{"v":0.4303052085401049,"d":"0.430"}]
[null,"1981Q3",14.11,0.46999999999999886,{"v":0.8564683599004752,"d":"0.856"}]
[null,"1981Q4",14.99,0.8800000000000008,{"v":0.0658960513671758,"d":"0.066"}]
[null,"1982Q1",15.51,0.5199999999999996,{"v":0.06173813623462365,"d":"0.062"}]
[null,"1982Q2",15.33,-0.17999999999999972,{"v":0.5525707165054072,"d":"0.553"}]
[null,"1982Q3",15.93,0.5999999999999996,{"v":0.8434627698868269,"d":"0.843"}]
[null,"1982Q4",16.61,0.6799999999999997,{"v":0.26474338071516,"d":"0.265"}]
[null,"1983Q1",17.28,0.6700000000000017,{"v":0.40521039525724944,"d":"0.405"}]
[null,"1983Q2",16.88,-0.40000000000000213,{"v":0.7842022898538303,"d":"0.784"}]
[null,"1983Q3",17.18,0.3000000000000007,{"v":0.772809582505829,"d":"0.773"}]
[null,"1983Q4",17.97,0.7899999999999991,{"v":0.2378090986111303,"d":"0.238"}]
[null,"1984Q1",19.6,1.6300000000000026,{"v":-0.021115700921825464,"d":"-0.021"}]
[null,"1984Q2",19.67,0.07000000000000028,{"v":0.42935478453962617,"d":"0.429"}]
[null,"1984Q3",19.97,0.29999999999999716,{"v":0.571362730635272,"d":"0.571"}]
[null,"1984Q4",21.08,1.1099999999999994,{"v":0.43549759809344835,"d":"0.435"}]
[null,"1985Q1",21.5,0.4200000000000017,{"v":0.697526489476985,"d":"0.698"}]
[null,"1985Q2",21.53,0.030000000000001137,{"v":0.8004160607145039,"d":"0.800"}]
[null,"1985Q3",21.3,-0.23000000000000043,{"v":0.8982745764365418,"d":"0.898"}]
[null,"1985Q4",21.48,0.17999999999999972,{"v":0.4410709440882954,"d":"0.441"}]
[null,"1986Q1",21.65,0.16999999999999815,{"v":0.6466344605994934,"d":"0.647"}]
[null,"1986Q2",21.02,-0.629999999999999,{"v":0.9143483614291625,"d":"0.914"}]
[null,"1986Q3",20.59,-0.4299999999999997,{"v":1.0761513861304195,"d":"1.076"}]
[null,"1986Q4",20.64,0.05000000000000071,{"v":1.1815590118656516,"d":"1.182"}]
[null,"1987Q1",21.01,0.370000000000001,{"v":1.523077810296769,"d":"1.523"}]
[null,"1987Q2",20.2,-0.8100000000000023,{"v":1.6270833050283429,"d":"1.627"}]
[null,"1987Q3",19.93,-0.2699999999999996,{"v":1.5576909653853832,"d":"1.558"}]
[null,"1987Q4",19.75,-0.17999999999999972,{"v":1.2250722901875122,"d":"1.225"}]
[null,"1988Q1",19.99,0.23999999999999844,{"v":1.10489045977058,"d":"1.105"}]
[null,"1988Q2",19.61,-0.379999999999999,{"v":1.3286518937109193,"d":"1.329"}]
[null,"1988Q3",19.04,-0.5700000000000003,{"v":1.1053245341214435,"d":"1.105"}]
[null,"1988Q4",18.31,-0.7300000000000004,{"v":1.1170698519766376,"d":"1.117"}]
[null,"1989Q1",18.26,-0.04999999999999716,{"v":1.2215962425239368,"d":"1.222"}]
[null,"1989Q2",17.26,-1,{"v":1.1931301974307473,"d":"1.193"}]
[null,"1989Q3",16.56,-0.7000000000000028,{"v":1.0790638929860208,"d":"1.079"}]
[null,"1989Q4",16.88,0.3200000000000003,{"v":1.0067344572368242,"d":"1.007"}]
[null,"1990Q1",16.76,-0.11999999999999744,{"v":0.9292079896599859,"d":"0.929"}]
[null,"1990Q2",16.25,-0.5100000000000016,{"v":0.8244344290805117,"d":"0.824"}]
[null,"1990Q3",15.85,-0.40000000000000036,{"v":0.8226409248663913,"d":"0.823"}]
[null,"1990Q4",16.09,0.2400000000000002,{"v":0.4989151934349678,"d":"0.499"}]
[null,"1991Q1",16.11,0.019999999999999574,{"v":0.37772727162561637,"d":"0.378"}]
[null,"1991Q2",15.88,-0.22999999999999865,{"v":0.5911158721259469,"d":"0.591"}]
[null,"1991Q3",16.33,0.4499999999999975,{"v":0.6960784030177081,"d":"0.696"}]
[null,"1991Q4",16.93,0.6000000000000014,{"v":0.3326845835841752,"d":"0.333"}]
[null,"1992Q1",17.4,0.46999999999999886,{"v":0.19996457062063655,"d":"0.200"}]
[null,"1992Q2",17.71,0.3100000000000023,{"v":0.05230826334177152,"d":"0.052"}]
[null,"1992Q3",18.27,0.5599999999999987,{"v":-0.3079288533403002,"d":"-0.308"}]
[null,"1992Q4",20.03,1.7600000000000016,{"v":-0.5769333366410834,"d":"-0.577"}]
[null,"1993Q1",21.69,1.6600000000000001,{"v":-0.4934527205964656,"d":"-0.493"}]
[null,"1993Q2",22.17,0.4800000000000004,{"v":-0.3056279664777506,"d":"-0.306"}]
[null,"1993Q3",22.87,0.6999999999999993,{"v":-0.013304118128587561,"d":"-0.013"}]
[null,"1993Q4",23.83,0.9599999999999973,{"v":0.5323855166960101,"d":"0.532"}]
[null,"1994Q1",24.55,0.7200000000000024,{"v":0.7900088505195413,"d":"0.790"}]
[null,"1994Q2",24.22,-0.33000000000000185,{"v":0.7685637318630256,"d":"0.769"}]
[null,"1994Q3",23.8,-0.41999999999999815,{"v":0.7065975338155894,"d":"0.707"}]
[null,"1994Q4",23.9,0.09999999999999787,{"v":0.7486906346825251,"d":"0.749"}]
[null,"1995Q1",23.49,-0.41000000000000014,{"v":0.7502444848878298,"d":"0.750"}]
[null,"1995Q2",22.7,-0.7899999999999991,{"v":0.6741025928791444,"d":"0.674"}]
[null,"1995Q3",22.65,-0.05000000000000071,{"v":0.4464473041531747,"d":"0.446"}]
[null,"1995Q4",22.76,0.11000000000000298,{"v":0.38352506148644494,"d":"0.384"}]
[null,"1996Q1",22.83,0.06999999999999673,{"v":0.5836437035727116,"d":"0.584"}]
[null,"1996Q2",22.17,-0.6599999999999966,{"v":0.7211956815435627,"d":"0.721"}]
[null,"1996Q3",21.72,-0.45000000000000284,{"v":0.7704793889633521,"d":"0.770"}]
[null,"1996Q4",21.6,-0.11999999999999744,{"v":0.7914827859757168,"d":"0.791"}]
[null,"1997Q1",21.3,-0.3000000000000007,{"v":0.8641848169370192,"d":"0.864"}]
[null,"1997Q2",20.72,-0.5800000000000018,{"v":0.9304718369872234,"d":"0.930"}]
[null,"1997Q3",20.31,-0.41000000000000014,{"v":1.022487868776345,"d":"1.022"}]
[null,"1997Q4",20.11,-0.1999999999999993,{"v":0.9459143323521602,"d":"0.946"}]
[null,"1998Q1",19.41,-0.6999999999999993,{"v":0.9156313531951454,"d":"0.916"}]
[null,"1998Q2",18.7,-0.7100000000000009,{"v":0.9525968502536841,"d":"0.953"}]
[null,"1998Q3",18.32,-0.379999999999999,{"v":0.9063820227366293,"d":"0.906"}]
[null,"1998Q4",17.99,-0.33000000000000185,{"v":0.7419767659731846,"d":"0.742"}]
[]
[]
[]
[]
[]
["A partir de esta tabla obtenemos el gráfico de dispersión de los datos y el coeficiente de correlación entre la variación entre la tasa de desempleo y la variación del Producto Interior bruto. Los resultados son los siguientes*: "]
[]
[]
[null,"Periodo","Tasa Paro (U)","ΔU","ΔPIB"]
[null,"1976Q3",4.41]
[null,"1976Q4",4.72,0.3099999999999996,{"v":0.7649600699593861,"d":"0.765"}]
[null,"1977Q1",4.93,0.20999999999999996,{"v":0.789114090457943,"d":"0.789"}]
[null,"1977Q2",4.78,-0.14999999999999947,{"v":0.45260538408289364,"d":"0.453"}]
[null,"1977Q3",5.34,0.5599999999999996,{"v":0.3317457959166603,"d":"0.332"}]
[null,"1977Q4",5.69,0.35000000000000053,{"v":0.6658321372468023,"d":"0.666"}]
[null,"1978Q1",6.47,0.7799999999999994,{"v":0.6223126871621076,"d":"0.622"}]
[null,"1978Q2",6.61,0.14000000000000057,{"v":0.20239672466200176,"d":"0.202"}]
[null,"1978Q3",7.07,0.45999999999999996,{"v":-0.12278500217099975,"d":"-0.123"}]
[null,"1978Q4",7.62,0.5499999999999998,{"v":-0.14810056777658787,"d":"-0.148"}]
[null,"1979Q1",8.13,0.5100000000000007,{"v":-0.15952314369016563,"d":"-0.160"}]
[null,"1979Q2",8.17,0.03999999999999915,{"v":0.15532842484056175,"d":"0.155"}]
[null,"1979Q3",8.72,0.5500000000000007,{"v":0.2402135143874773,"d":"0.240"}]
[null,"1979Q4",9.52,0.7999999999999989,{"v":0.35090198228449054,"d":"0.351"}]
[null,"1980Q1",10.63,1.1100000000000012,{"v":0.4369029883713793,"d":"0.437"}]
[null,"1980Q2",11.12,0.48999999999999844,{"v":0.6236051223655892,"d":"0.624"}]
[null,"1980Q3",11.48,0.3600000000000012,{"v":0.13332144120159484,"d":"0.133"},null,{"$f":"CONCATENATE(\"El coeficiente de correlación entre la variación trimestral del desempleo y la variación trimestral del PIB es de \",FIXED(CORREL(D1040:D1128,E1040:E1128),2))","v":"El coeficiente de correlación entre la variación trimestral del desempleo y la variación trimestral del PIB es de -0,69"}]
[null,"1980Q4",12.43,0.9499999999999993,{"v":-0.4142901410387978,"d":"-0.414"}]
[null,"1981Q1",13.38,0.9500000000000011,{"v":-0.8546291048915577,"d":"-0.855"},null,"Tanto el análisis gráfico como el valor del coeficiente de correlación muestran que existe una relación negativa entre la variación trimestral del PIB y la variación del desem-"]
[null,"1981Q2",13.64,0.2599999999999998,{"v":0.4303052085401049,"d":"0.430"},null,"pleo. Aunque la correlación no es muy alta, se puede concluir que un aumento en el PIB se traduce en una disminución del desempleo."]
[null,"1981Q3",14.11,0.46999999999999886,{"v":0.8564683599004752,"d":"0.856"}]
[null,"1981Q4",14.99,0.8800000000000008,{"v":0.0658960513671758,"d":"0.066"}]
[null,"1982Q1",15.51,0.5199999999999996,{"v":0.06173813623462365,"d":"0.062"}]
[null,"1982Q2",15.33,-0.17999999999999972,{"v":0.5525707165054072,"d":"0.553"}]
[null,"1982Q3",15.93,0.5999999999999996,{"v":0.8434627698868269,"d":"0.843"}]
[null,"1982Q4",16.61,0.6799999999999997,{"v":0.26474338071516,"d":"0.265"}]
[null,"1983Q1",17.28,0.6700000000000017,{"v":0.40521039525724944,"d":"0.405"}]
[null,"1983Q2",16.88,-0.40000000000000213,{"v":0.7842022898538303,"d":"0.784"}]
[null,"1983Q3",17.18,0.3000000000000007,{"v":0.772809582505829,"d":"0.773"}]
[null,"1983Q4",17.97,0.7899999999999991,{"v":0.2378090986111303,"d":"0.238"}]
[null,"1984Q1",19.6,1.6300000000000026,{"v":-0.021115700921825464,"d":"-0.021"}]
[null,"1984Q2",19.67,0.07000000000000028,{"v":0.42935478453962617,"d":"0.429"}]
[null,"1984Q3",19.97,0.29999999999999716,{"v":0.571362730635272,"d":"0.571"}]
[null,"1984Q4",21.08,1.1099999999999994,{"v":0.43549759809344835,"d":"0.435"}]
[null,"1985Q1",21.5,0.4200000000000017,{"v":0.697526489476985,"d":"0.698"}]
[null,"1985Q2",21.53,0.030000000000001137,{"v":0.8004160607145039,"d":"0.800"}]
[null,"1985Q3",21.3,-0.23000000000000043,{"v":0.8982745764365418,"d":"0.898"}]
[null,"1985Q4",21.48,0.17999999999999972,{"v":0.4410709440882954,"d":"0.441"}]
[null,"1986Q1",21.65,0.16999999999999815,{"v":0.6466344605994934,"d":"0.647"}]
[null,"1986Q2",21.02,-0.629999999999999,{"v":0.9143483614291625,"d":"0.914"}]
[null,"1986Q3",20.59,-0.4299999999999997,{"v":1.0761513861304195,"d":"1.076"}]
[null,"1986Q4",20.64,0.05000000000000071,{"v":1.1815590118656516,"d":"1.182"}]
[null,"1987Q1",21.01,0.370000000000001,{"v":1.523077810296769,"d":"1.523"}]
[null,"1987Q2",20.2,-0.8100000000000023,{"v":1.6270833050283429,"d":"1.627"}]
[null,"1987Q3",19.93,-0.2699999999999996,{"v":1.5576909653853832,"d":"1.558"}]
[null,"1987Q4",19.75,-0.17999999999999972,{"v":1.2250722901875122,"d":"1.225"}]
[null,"1988Q1",19.99,0.23999999999999844,{"v":1.10489045977058,"d":"1.105"}]
[null,"1988Q2",19.61,-0.379999999999999,{"v":1.3286518937109193,"d":"1.329"}]
[null,"1988Q3",19.04,-0.5700000000000003,{"v":1.1053245341214435,"d":"1.105"}]
[null,"1988Q4",18.31,-0.7300000000000004,{"v":1.1170698519766376,"d":"1.117"}]
[null,"1989Q1",18.26,-0.04999999999999716,{"v":1.2215962425239368,"d":"1.222"}]
[null,"1989Q2",17.26,-1,{"v":1.1931301974307473,"d":"1.193"}]
[null,"1989Q3",16.56,-0.7000000000000028,{"v":1.0790638929860208,"d":"1.079"}]
[null,"1989Q4",16.88,0.3200000000000003,{"v":1.0067344572368242,"d":"1.007"}]
[null,"1990Q1",16.76,-0.11999999999999744,{"v":0.9292079896599859,"d":"0.929"}]
[null,"1990Q2",16.25,-0.5100000000000016,{"v":0.8244344290805117,"d":"0.824"}]
[null,"1990Q3",15.85,-0.40000000000000036,{"v":0.8226409248663913,"d":"0.823"}]
[null,"1990Q4",16.09,0.2400000000000002,{"v":0.4989151934349678,"d":"0.499"}]
[null,"1991Q1",16.11,0.019999999999999574,{"v":0.37772727162561637,"d":"0.378"}]
[null,"1991Q2",15.88,-0.22999999999999865,{"v":0.5911158721259469,"d":"0.591"}]
[null,"1991Q3",16.33,0.4499999999999975,{"v":0.6960784030177081,"d":"0.696"}]
[null,"1991Q4",16.93,0.6000000000000014,{"v":0.3326845835841752,"d":"0.333"}]
[null,"1992Q1",17.4,0.46999999999999886,{"v":0.19996457062063655,"d":"0.200"}]
[null,"1992Q2",17.71,0.3100000000000023,{"v":0.05230826334177152,"d":"0.052"}]
[null,"1992Q3",18.27,0.5599999999999987,{"v":-0.3079288533403002,"d":"-0.308"}]
[null,"1992Q4",20.03,1.7600000000000016,{"v":-0.5769333366410834,"d":"-0.577"}]
[null,"1993Q1",21.69,1.6600000000000001,{"v":-0.4934527205964656,"d":"-0.493"}]
[null,"1993Q2",22.17,0.4800000000000004,{"v":-0.3056279664777506,"d":"-0.306"}]
[null,"1993Q3",22.87,0.6999999999999993,{"v":-0.013304118128587561,"d":"-0.013"}]
[null,"1993Q4",23.83,0.9599999999999973,{"v":0.5323855166960101,"d":"0.532"}]
[null,"1994Q1",24.55,0.7200000000000024,{"v":0.7900088505195413,"d":"0.790"}]
[null,"1994Q2",24.22,-0.33000000000000185,{"v":0.7685637318630256,"d":"0.769"}]
[null,"1994Q3",23.8,-0.41999999999999815,{"v":0.7065975338155894,"d":"0.707"}]
[null,"1994Q4",23.9,0.09999999999999787,{"v":0.7486906346825251,"d":"0.749"}]
[null,"1995Q1",23.49,-0.41000000000000014,{"v":0.7502444848878298,"d":"0.750"}]
[null,"1995Q2",22.7,-0.7899999999999991,{"v":0.6741025928791444,"d":"0.674"}]
[null,"1995Q3",22.65,-0.05000000000000071,{"v":0.4464473041531747,"d":"0.446"}]
[null,"1995Q4",22.76,0.11000000000000298,{"v":0.38352506148644494,"d":"0.384"}]
[null,"1996Q1",22.83,0.06999999999999673,{"v":0.5836437035727116,"d":"0.584"}]
[null,"1996Q2",22.17,-0.6599999999999966,{"v":0.7211956815435627,"d":"0.721"}]
[null,"1996Q3",21.72,-0.45000000000000284,{"v":0.7704793889633521,"d":"0.770"}]
[null,"1996Q4",21.6,-0.11999999999999744,{"v":0.7914827859757168,"d":"0.791"}]
[null,"1997Q1",21.3,-0.3000000000000007,{"v":0.8641848169370192,"d":"0.864"}]
[null,"1997Q2",20.72,-0.5800000000000018,{"v":0.9304718369872234,"d":"0.930"}]
[null,"1997Q3",20.31,-0.41000000000000014,{"v":1.022487868776345,"d":"1.022"}]
[null,"1997Q4",20.11,-0.1999999999999993,{"v":0.9459143323521602,"d":"0.946"}]
[null,"1998Q1",19.41,-0.6999999999999993,{"v":0.9156313531951454,"d":"0.916"}]
[null,"1998Q2",18.7,-0.7100000000000009,{"v":0.9525968502536841,"d":"0.953"}]
[null,"1998Q3",18.32,-0.379999999999999,{"v":0.9063820227366293,"d":"0.906"}]
[null,"1998Q4",17.99,-0.33000000000000185,{"v":0.7419767659731846,"d":"0.742"}]
[]
[]
["* Una explicación más detallada del coeficiente de correlación aparece en el recuadro"]
["\"Entendiendo el Coeficiente de Correlación\""]

{"sheet":"3.Presentación Final","index":3,"n_rows":78,"n_cols":12,"rows_kept":78,"merged":[[25,6,25,8],[26,6,26,7]]}
["En esta hoja se explica cómo deben presentar los alumnos la tarea para subirla al campus virtual."]
[]
["La tarea que suba al campus virtual debe constar de dos ficheros:"]
["1. Un libro de excel"]
["2. Un documento de word"]
[]
[]
["El libro de excel debe constar de las siguientes hojas:"]
[]
["− La primera hoja debe titularse \"Descarga de datos\" y debe contener los datos tal y como los alumnos los hayan descargado de internet. Deben presentarlos de forma que sean legibles (es decir, si han tenido que \"adaptarlos\" deben presentarlos tal y "]
["como quedan después del proceso de \"adaptación\" explicado en el ejemplo de cómo dar formato a los datos que aparece en la hoja 1 )"]
[]
["− La segunda hoja debe titularse \"Datos formateados\" y debe contener TODAS las series de datos presentadas de forma legible, siguiendo los criterios explicados en el punto 1.b (\"Dar formato a la serie del PIB) de la hoja 2 (\"Análisis de datos\") del "]
["presente libro. Las distintas series formateadas deben presentarse una al lado de otra, empezando todas en la fila 1."]
[]
["− Las siguientes hojas deben denominarse como la serie que analiza en la misma. Por ejemplo, para el análisis de la serie del PIB, el alumno debe crear una hoja que se llame \"Análisis del PIB\", mientras que para el análisis del consumo, debe crear otra"]
["hoja llamada \"Análisis del Consumo\", y así sucesivamente. Por lo tanto, además de las dos hojas anteriores, el libro debe tener tantas hojas como series analizadas por el alumno."]
[]
["− En cada hoja debe aparecer el análisis COMPLETO de cada serie. Esto incluye:"]
[null,"● En análisis final de la misma, tal y como aparece en la tabla que aparece en el apartado 1.c (\"Realizar el análisis del ciclo\") de la hoja 2 (\"Análisis de datos\")."]
[null,"● TODOS los gráficos que acompañan al análisis de dicha serie. Cuando el gráfico involucre dos series diferentes (por ejemplo, la variación del desempleo y la variación del PIB), deberá situarse en la hoja en la  que se analiza la última de "]
[null,"las dos series (Por ejemplo, en el análisis de la correlación entre la variación del PIB y la variación del desempleo), el gráfico de dispersión debe aparecer en la hoja en la que se presente el análisis de la variación del desempleo."]
[null,"● TODAS las estadísticas que se calculen en relación con la serie estudiada. Las estadísiticas deben presentarse en una tabla compacta, formataeada de forma que sea identificable y colocada al principio de la hoja. Por ejemplo, en la"]
[null,"hoja en la que se realice el análisis del PIB deberá aparecer una tabla como la siguiente (el formato es opcional, pero debe ser claramente identificable):"]
[]
[{"$nulls":6},"ANÁLISIS SERIE PIB"]
[{"$nulls":6},"VariaciónTotal PIB",null,{"v":0.0061,"d":"0.61%"}]
[{"$nulls":6},"Variación Promedio PIB",null,{"v":0.0072,"d":"0.72%"}]
[]
[null,"Es importante que los datos NO ESTÉN COPIADOS Y PEGADOS, DEBEN ESTAR CALCULADOS APLICANDO LA CORRESPONDIENTE FÓRMULA DE EXCEL."]
[null,"Al igual que en el caso de los gráficos, si el análisis requiere el uso de dos series, éste debe aparecer en la hoja en la que se analice la segunda serie."]
[]
[]
["El documento de word debe estar estructurado de la siguiente manera:"]
["− Una hoja de título. El título debe recoger el nombre de las series analizadas por los alumnos, así como el periodo analizado. En esta hoja deben aparecer también los nombres de los alumnos que han realizado el análisis. "]
["Por ejemplo, si los alumnos realizaran el anális del PIB y sus componentes,  esta hoja tendría el siguiente aspecto:",{"$nulls":10},"Si los alumnos realizan el análisis del PIB y su correlación con el desempleo, esta hoja tendría este aspecto"]
{"$rows_empty":31}
["− El análisis de los datos debe empezar en una hoja diferente y debe estar estructurado en los siguientes apartados:  "]
[null,"● Una introducción en la que se explique los datos y el periodo temporal estudiados. Además, el alumno debe explicar las fuentes de donde ha obtenido los datos y, finalmente, la definición de Recesión y cuál ha sido la fuente de la "]
[null,"que la ha obtenido."]
[null,"● Un primer apartado en el que se describa brevemente el análisis de la serie del PIB, incluyendo los gráficos y las tablas de las estadísticas calculadas. El alumno debe explicar claramente cuántos ciclos ha encontrado, en los periodos en los"]
[null," que están los picos y los valles, la variación total y media que ha experimentado el PIB, así como la tasa de crecimiento y decrecimiento acumulado en cada ciclo. "]
[null,"● Un segundo apartado en el que se expliquen los resultados del segundo ejercicio que hayan elegido realizar los alumnos. "]
[null,null,"a) Si han elegido el análisis de los componentes del PIB, deben explicar muy brevemente la volatilidad de cada componente, así como si es procíclico, anticiclico o acíclico. Obviamente, debe incluir el análisis gráfico de cada "]
[null,null,"serie y una tabla en la que se presenten los resultados sobre la volatilidad y correlación obtenidos."]
[null,null,"b) Si han elegido el análisis de la correlación entre el PIB y el desempleo, deben explicar muy brevemente el signo y el grado de correlación entre estas variables en el periodo estudiado. Como en el apartado (a) debe incluir"]
[null,null," los gráficos y una tabla con los datos sobre la correlación obtenidos en el análisis."]
[" ","● Un último apartado bibliográfico en el que se citen las fuentes consultadas por el alumno."]