Please upload the answers with excel form Consider the real GDP data, denoted by Yt...
90.2K
Verified Solution
Link Copied!
Question
Accounting
Please upload the answers with excel form
Consider the real GDP data, denoted by Yt , in the Excel file "ECS - TimeSeries". Select the optimal lag length for the GDP process up to the AR(5) model using the data from 1950 to 2018, and use the selected model to estimate the real GDP in year 2019. Then find out the forecast error according to the data in 2019.
countrycode
country
currency_unit
year
Yt
CAN
Canada
Canadian Dollar
1950
170756.3125
CAN
Canada
Canadian Dollar
1951
177143.0938
CAN
Canada
Canadian Dollar
1952
193714.7813
CAN
Canada
Canadian Dollar
1953
203463.1094
CAN
Canada
Canadian Dollar
1954
202076.0625
CAN
Canada
Canadian Dollar
1955
221434.25
CAN
Canada
Canadian Dollar
1956
240490.1563
CAN
Canada
Canadian Dollar
1957
244851.3281
CAN
Canada
Canadian Dollar
1958
249241.3281
CAN
Canada
Canadian Dollar
1959
260682.5
CAN
Canada
Canadian Dollar
1960
268921.7813
CAN
Canada
Canadian Dollar
1961
278586.4688
CAN
Canada
Canadian Dollar
1962
296021.1563
CAN
Canada
Canadian Dollar
1963
310652.125
CAN
Canada
Canadian Dollar
1964
332332.375
CAN
Canada
Canadian Dollar
1965
354861.5938
CAN
Canada
Canadian Dollar
1966
378259.625
CAN
Canada
Canadian Dollar
1967
389247.5938
CAN
Canada
Canadian Dollar
1968
407149.875
CAN
Canada
Canadian Dollar
1969
427915.4375
CAN
Canada
Canadian Dollar
1970
437890.1563
CAN
Canada
Canadian Dollar
1971
459102.3438
CAN
Canada
Canadian Dollar
1972
487027.2188
CAN
Canada
Canadian Dollar
1973
529249.5
CAN
Canada
Canadian Dollar
1974
559392.1875
CAN
Canada
Canadian Dollar
1975
565140.5
CAN
Canada
Canadian Dollar
1976
600391.8125
CAN
Canada
Canadian Dollar
1977
613608
CAN
Canada
Canadian Dollar
1978
631335.9375
CAN
Canada
Canadian Dollar
1979
664797.25
CAN
Canada
Canadian Dollar
1980
676189.875
CAN
Canada
Canadian Dollar
1981
693843.625
CAN
Canada
Canadian Dollar
1982
665228.4375
CAN
Canada
Canadian Dollar
1983
690259.6875
CAN
Canada
Canadian Dollar
1984
736258.4375
CAN
Canada
Canadian Dollar
1985
777071.5
CAN
Canada
Canadian Dollar
1986
791508.25
CAN
Canada
Canadian Dollar
1987
837235.8125
CAN
Canada
Canadian Dollar
1988
886933.375
CAN
Canada
Canadian Dollar
1989
918179.9375
CAN
Canada
Canadian Dollar
1990
915724.6875
CAN
Canada
Canadian Dollar
1991
893206.4375
CAN
Canada
Canadian Dollar
1992
901133.75
CAN
Canada
Canadian Dollar
1993
928149.25
CAN
Canada
Canadian Dollar
1994
979112.6875
CAN
Canada
Canadian Dollar
1995
1023227.563
CAN
Canada
Canadian Dollar
1996
1053691.25
CAN
Canada
Canadian Dollar
1997
1106804.875
CAN
Canada
Canadian Dollar
1998
1136820.125
CAN
Canada
Canadian Dollar
1999
1208894.125
CAN
Canada
Canadian Dollar
2000
1276875.5
CAN
Canada
Canadian Dollar
2001
1272416.75
CAN
Canada
Canadian Dollar
2002
1278943
CAN
Canada
Canadian Dollar
2003
1320633.5
CAN
Canada
Canadian Dollar
2004
1377227.5
CAN
Canada
Canadian Dollar
2005
1436814.125
CAN
Canada
Canadian Dollar
2006
1459523.25
CAN
Canada
Canadian Dollar
2007
1483753.5
CAN
Canada
Canadian Dollar
2008
1500647.875
CAN
Canada
Canadian Dollar
2009
1408601.375
CAN
Canada
Canadian Dollar
2010
1483011.5
CAN
Canada
Canadian Dollar
2011
1552403.5
CAN
Canada
Canadian Dollar
2012
1575739.75
CAN
Canada
Canadian Dollar
2013
1647212.125
CAN
Canada
Canadian Dollar
2014
1685110.5
CAN
Canada
Canadian Dollar
2015
1659691.75
CAN
Canada
Canadian Dollar
2016
1683513.5
CAN
Canada
Canadian Dollar
2017
1771272.75
CAN
Canada
Canadian Dollar
2018
1815590.75
CAN
Canada
Canadian Dollar
2019
1846581.125
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
