Question
Input the following data into Excel. Regression Homework Q2 data Excel file Assume we have the following time series data on variable Y below: YEAR/TimeY=Output
Input the following data into Excel.
Regression Homework Q2 data Excel file
Assume we have the following time series data on variable Y below:
YEAR/TimeY=Output
1953482
1954312
19551221
19561800
19572419
19582958
19593454
19603897
19614317
19624705
19635056
19645378
19655681
19665964
19676216
19686425
19696632
19706836
19717003
19727170
19737315
19747456
19757595
19767715
19777815
19787918
19797995
19808079
19818164
19828239
19838292
19848355
19858402
19868461
19878493
19888539
19898561
19908609
19918649
19928660
19938680
19948726
19958740
19968760
19978783
19988805
19998812
20008854
20018841
20028869
20038893
20048883
20058888
20068904
20078913
20088913
20098923
20108948
20118962
a)Fit a simple trend model to the time series data and discuss the findings.
b)Fit a quadratic trend model to the time series and discuss the findings: (square time).
c)Compare your results in part (b) to part (a) and use the best of the two models to forecast 2012 and 2013
values of Y.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Discrete Mathematics and Its Applications
Authors: Kenneth H. Rosen
7th edition
0073383090, 978-0073383095
