Questions to Answer with the Data Software

To answer the following questions,download the CSV file

(or, copy-paste the data from the table on the right) and import it into your data software. The file is a quarterly times series from the first quarter of 1960 to the fourth quarter of 2019. Organize your dataset as a time series and assume that the series is a flow variable.

Estimate the trend of the series using a quadratic trend.

What is the value of the trend in the third quarter of 2018? Round your answer to the nearest second decimal.

What is the value of the detrended series in the third quarter of 2004? Round your answer to the nearest second decimal.

Using the detrended series, compute the cyclical component of the series.

What is the value of the cycle in the fourth quarter of 1976? Round your answer to the nearest second decimal.

What is the value of the low frequency component in the fourth quarter of 1969? Round your answer to the nearest second decimal.

Compute the seasonal component of your series.

What are the four seasonal values of the four quarters? Round your answer to the nearest second decimal.

Quarter 1:

Quarter 2:

Quarter 3:

Quarter 4:

What is the value of the seasonally adjusted series in the first quarter of 1968? Round your answer to the nearest second decimal.

writ r-codes so answer these questions using the following table

Year	Quarter	Data
1960	1	285
1960	2	293
1960	3	262
1960	4	282
1961	1	289
1961	2	291
1961	3	264
1961	4	288
1962	1	296
1962	2	304
1962	3	271
1962	4	293
1963	1	298
1963	2	306
1963	3	278
1963	4	301
1964	1	306
1964	2	308
1964	3	279
1964	4	299
1965	1	303
1965	2	312
1965	3	285
1965	4	305
1966	1	315
1966	2	323
1966	3	294
1966	4	315
1967	1	320
1967	2	332
1967	3	298
1967	4	320
1968	1	325
1968	2	333
1968	3	308
1968	4	330
1969	1	331
1969	2	337
1969	3	309
1969	4	333
1970	1	339
1970	2	355
1970	3	322
1970	4	341
1971	1	346
1971	2	353
1971	3	318
1971	4	341
1972	1	349
1972	2	356
1972	3	326
1972	4	351
1973	1	355
1973	2	364
1973	3	332
1973	4	355
1974	1	361
1974	2	372
1974	3	344
1974	4	363
1975	1	373
1975	2	382
1975	3	352
1975	4	365
1976	1	383
1976	2	383
1976	3	353
1976	4	373
1977	1	383
1977	2	392
1977	3	360
1977	4	381
1978	1	386
1978	2	404
1978	3	369
1978	4	392
1979	1	409
1979	2	419
1979	3	383
1979	4	407
1980	1	401
1980	2	410
1980	3	377
1980	4	404
1981	1	416
1981	2	426
1981	3	393
1981	4	415
1982	1	421
1982	2	423
1982	3	398
1982	4	424
1983	1	428
1983	2	440
1983	3	409
1983	4	436
1984	1	431
1984	2	448
1984	3	414
1984	4	426
1985	1	441
1985	2	453
1985	3	423
1985	4	440
1986	1	448
1986	2	454
1986	3	427
1986	4	449
1987	1	453
1987	2	466
1987	3	442
1987	4	459
1988	1	455
1988	2	466
1988	3	436
1988	4	458
1989	1	464
1989	2	477
1989	3	446
1989	4	467
1990	1	476
1990	2	491
1990	3	462
1990	4	478
1991	1	489
1991	2	493
1991	3	462
1991	4	488
1992	1	502
1992	2	509
1992	3	478
1992	4	508
1993	1	512
1993	2	517
1993	3	486
1993	4	506
1994	1	514
1994	2	532
1994	3	500
1994	4	520
1995	1	531
1995	2	535
1995	3	502
1995	4	525
1996	1	534
1996	2	547
1996	3	521
1996	4	544
1997	1	553
1997	2	561
1997	3	526
1997	4	547
1998	1	559
1998	2	566
1998	3	530
1998	4	560
1999	1	555
1999	2	573
1999	3	546
1999	4	566
2000	1	578
2000	2	580
2000	3	546
2000	4	561
2001	1	569
2001	2	584
2001	3	565
2001	4	587
2002	1	584
2002	2	603
2002	3	575
2002	4	602
2003	1	605
2003	2	621
2003	3	586
2003	4	623
2004	1	621
2004	2	626
2004	3	589
2004	4	613
2005	1	628
2005	2	628
2005	3	610
2005	4	631
2006	1	648
2006	2	656
2006	3	619
2006	4	630
2007	1	650
2007	2	657
2007	3	633
2007	4	652
2008	1	664
2008	2	676
2008	3	642
2008	4	656
2009	1	664
2009	2	671
2009	3	662
2009	4	671
2010	1	688
2010	2	684
2010	3	661
2010	4	692
2011	1	704
2011	2	700
2011	3	665
2011	4	687
2012	1	699
2012	2	710
2012	3	681
2012	4	711
2013	1	724
2013	2	728
2013	3	693
2013	4	703
2014	1	742
2014	2	742
2014	3	717
2014	4	740
2015	1	744
2015	2	754
2015	3	733
2015	4	750
2016	1	765
2016	2	773
2016	3	747
2016	4	764
2017	1	770
2017	2	791
2017	3	764
2017	4	785
2018	1	796
2018	2	798
2018	3	773
2018	4	784
2019	1	801
2019	2	809
2019	3	775
2019	4	802