Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

using excel, Please Estimate the following regressions, including a constant term: a) RCONS = f[RGDP, RGDP(t-1)] b) RCONS = f(RGDP, YEAR, T) c) RCONS =

using excel, Please Estimate the following regressions, including a constant term:

a) RCONS = f[RGDP, RGDP(t-1)] b) RCONS = f(RGDP, YEAR, T) c) RCONS = f(YEAR, T) d) RCONS = f(RGDP, WAR) e) RCONS = f(RGDP, RGDP2)

*please show steps on excel and ATTATCH EXCEL FILE, thank you!*

I posted this so many time, it is not incomplete. Please solve the best you can.. Answer does not have to be right! please attatch excel file..thank you

image text in transcribed
RGDP RCONS YEAR WAR 1039.200 687.7000 1940 1 0 1227.800 721.8000 1941 2 1473.600 721.1000 1942 3 1 1766.900 742.4000 1943 4 1 1915.500 769.9000 1944 5 1 1838.400 819.5000 1945 6 1459.100 393.6000 1946 7 0 1436.900 898.4000 1947 0 1491.100 932.5000 1948 g 1497.400 953.6000 1949 10 0 1627.000 1002.800 1950 11 0 1787.500 1014.700 1951 12 0 1863.800 1059.100 1952 13 0 1933.200 1012.200 1953 14 0 1919.800 1132.400 1954 15 0 2028.200 1200.900 1955 16 0 2068.700 1231.500 1956 17 0 2108.400 1268.700 1957 18 0 2097.900 1287.100 1958 19 0 2212.300 1394.600 1959 20 0 2261.700 1432.600 1960 21 0 2309.800 1461.500 1961 22 0 2449.100 1533.800 1962 23 0 2554.000 1596.600 1963 24 0 2702.900 1692.300 1964 25 0 2874.800 1799.100 1965 26 0 3060.200 1902.000 1966 27 0 3140.200 1958.600 1967 28 0 3288.600 2070.200 1968 29 0 3388.000 2147.500 1969 30 0 3388.200 2197.800 1970 31 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course In Differential Equations

Authors: J David Logan

3rd Edition

3319178520, 9783319178523

More Books

Students also viewed these Mathematics questions