View the step-by-step solution to:

ln(GDP) CPI DATE VALUE DATE 1947-01-01 1932.6 1947-01-01 7.5666215 1947-04-01 1930.4 1947-04-01 7.5654825 1947-07-01 1928.4 1947-07-01 7.5644459...

hello , can you please try to attempt this assignment in excel? I don't mind if some answers are wrong

DATE VALUE DATE ln(GDP) CPI ln(CPI) DATE chln(gdp) ln(GDP)-1 1947-01-01 1932.6 1947-01-01 7.5666215 21.700 3.0773123 1947-01-01 1947-04-01 1930.4 1947-04-01 7.5654825 22.010 3.0914969 1947-04-01 -0.001139 1947-07-01 1928.4 1947-07-01 7.5644459 22.490 3.1130708 1947-07-01 -0.001037 1947-10-01 1958.8 1947-10-01 7.5800873 23.127 3.1410008 1947-10-01 0.015641 1948-01-01 1987.6 1948-01-01 7.5946832 23.617 3.1619668 1948-01-01 0.014596 1948-04-01 2019.9 1948-04-01 7.6108033 23.993 3.1777621 1948-04-01 0.01612 1948-07-01 2031.2 1948-07-01 7.616382 24.397 3.1944602 1948-07-01 0.005579 1948-10-01 2033.3 1948-10-01 7.6174154 24.173 3.1852363 1948-10-01 0.001033 1949-01-01 2005.6 1949-01-01 7.6036985 23.943 3.175676 1949-01-01 -0.013717 1949-04-01 1998.8 1949-04-01 7.6003023 23.917 3.1745895 1949-04-01 -0.003396 1949-07-01 2020.8 1949-07-01 7.6112488 23.717 3.1661921 1949-07-01 0.010946 1949-10-01 2002.7 1949-10-01 7.6022515 23.660 3.1637859 1949-10-01 -0.008997 1950-01-01 2082.5 1950-01-01 7.6413244 23.587 3.1606957 1950-01-01 0.039073 1950-04-01 2145.5 1950-04-01 7.6711279 23.767 3.1682981 1950-04-01 0.029804 1950-07-01 2228.2 1950-07-01 7.7089494 24.203 3.1864766 1950-07-01 0.037821 1950-10-01 2271.2 1950-10-01 7.7280636 24.693 3.2065198 1950-10-01 0.019114 1951-01-01 2302.3 1951-01-01 7.7416639 25.697 3.2463743 1951-01-01 0.0136 1951-04-01 2342.3 1951-04-01 7.7588886 25.947 3.256056 1951-04-01 0.017225 1951-07-01 2390.5 1951-07-01 7.7792578 25.933 3.2555163 1951-07-01 0.020369 1951-10-01 2395.8 1951-10-01 7.7814725 26.317 3.2702151 1951-10-01 0.002215 1952-01-01 2421.1 1952-01-01 7.7919773 26.417 3.2740077 1952-01-01 0.010505 1952-04-01 2426.2 1952-04-01 7.7940815 26.487 3.276654 1952-04-01 0.002104 1952-07-01 2443.7 1952-07-01 7.8012686 26.667 3.2834268 1952-07-01 0.007187 1952-10-01 2523.9 1952-10-01 7.8335606 26.697 3.2845512 1952-10-01 0.032292 1953-01-01 2570.9 1953-01-01 7.8520113 26.620 3.2816628 1953-01-01 0.018451 1953-04-01 2591.0 1953-04-01 7.8597992 26.720 3.2854123 1953-04-01 0.007788 1953-07-01 2576.4 1953-07-01 7.8541484 26.843 3.2900051 1953-07-01 -0.005651 1953-10-01 2537.3 1953-10-01 7.8388558 26.890 3.2917545 1953-10-01 -0.015293 1954-01-01 2525.6 1954-01-01 7.8342339 26.953 3.2940946 1954-01-01 -0.004622 1954-04-01 2528.3 1954-04-01 7.8353024 26.910 3.292498 1954-04-01 0.001068 1954-07-01 2556.9 1954-07-01 7.8465509 26.840 3.2898933 1954-07-01 0.011248 1954-10-01 2606.8 1954-10-01 7.8658787 26.757 3.2867961 1954-10-01 0.019328 1955-01-01 2681.2 1955-01-01 7.8940197 26.793 3.2881407 1955-01-01 0.028141 1955-04-01 2724.8 1955-04-01 7.9101503 26.757 3.2867961 1955-04-01 0.016131 1955-07-01 2761.5 1955-07-01 7.9235293 26.777 3.2875433 1955-07-01 0.013379 1955-10-01 2778.1 1955-10-01 7.9295225 26.857 3.2905265 1955-10-01 0.005993 1956-01-01 2767.4 1956-01-01 7.9256635 26.860 3.2906382 1956-01-01 -0.003859 1956-04-01 2790.2 1956-04-01 7.9338686 27.037 3.2972063 1956-04-01 0.008205 1956-07-01 2787.9 1956-07-01 7.9330439 27.317 3.3075092 1956-07-01 -0.000825 1956-10-01 2833.5 1956-10-01 7.949268 27.550 3.3160025 1956-10-01 0.016224 1957-01-01 2851.8 1957-01-01 7.9557057 27.777 3.3242083 1957-01-01 0.006438 1957-04-01 2845.5 1957-04-01 7.9534941 28.013 3.3326687 1957-04-01 -0.002212 1957-07-01 2873.2 1957-07-01 7.9631817 28.263 3.3415535 1957-07-01 0.009688 1957-10-01 2843.7 1957-10-01 7.9528613 28.400 3.3463891 1957-10-01 -0.01032 1958-01-01 2770.0 1958-01-01 7.9266026 28.737 3.3581855 1958-01-01 -0.026259 1958-04-01 2788.3 1958-04-01 7.9331874 28.930 3.3648791 1958-04-01 0.006585 1958-07-01 2852.7 1958-07-01 7.9560212 28.913 3.3642913 1958-07-01 0.022834 1958-10-01 2919.5 1958-10-01 7.9791676 28.943 3.3653284 1958-10-01 0.023146 1959-01-01 2973.8 1959-01-01 7.9975959 28.993 3.3670544 1959-01-01 0.018428 1959-04-01 3046.1 1959-04-01 8.0216174 29.043 3.3687775 1959-04-01 0.024021 1959-07-01 3040.2 1959-07-01 8.0196786 29.193 3.373929 1959-07-01 -0.001939 1959-10-01 3052.2 1959-10-01 8.0236179 29.370 3.3799737 1959-10-01 0.003939 1960-01-01 3120.2 1960-01-01 8.0456524 29.397 3.3808926 1960-01-01 0.022034 1960-04-01 3108.4 1960-04-01 8.0418634 29.573 3.3868618 1960-04-01 -0.003789 1960-07-01 3116.1 1960-07-01 8.0443375 29.590 3.3874365 1960-07-01 0.002474 1960-10-01 3078.4 1960-10-01 8.0321653 29.780 3.393837 1960-10-01 -0.012172 1961-01-01 3099.3 1961-01-01 8.0389316 29.840 3.3958498 1961-01-01 0.006766 1961-04-01 3156.9 1961-04-01 8.0573458 29.830 3.3955146 1961-04-01 0.018414 1961-07-01 3209.6 1961-07-01 8.0739016 29.947 3.3994292 1961-07-01 0.016556 1961-10-01 3274.6 1961-10-01 8.093951 29.990 3.400864 1961-10-01 0.020049 1962-01-01 3333.6 1962-01-01 8.1118081 30.107 3.4047577 1962-01-01 0.017857 1962-04-01 3369.5 1962-04-01 8.1225196 30.220 3.408504 1962-04-01 0.010712 1962-07-01 3401.6 1962-07-01 8.1320012 30.307 3.4113787 1962-07-01 0.009482 1962-10-01 3414.8 1962-10-01 8.1358742 30.380 3.4137845 1962-10-01 0.003873 1963-01-01 3452.8 1963-01-01 8.1469408 30.477 3.4169723 1963-01-01 0.011067 1963-04-01 3497.8 1963-04-01 8.1598895 30.533 3.4188081 1963-04-01 0.012949 1963-07-01 3566.1 1963-07-01 8.1792278 30.720 3.4249139 1963-07-01 0.019338 1963-10-01 3591.5 1963-10-01 8.1863252 30.803 3.4276121 1963-10-01 0.007097 1964-01-01 3669.2 1964-01-01 8.2077289 30.930 3.4317266 1964-01-01 0.021404 1964-04-01 3712.9 1964-04-01 8.2195685 30.980 3.4333418 1964-04-01 0.01184 1964-07-01 3763.3 1964-07-01 8.2330515 31.050 3.4355988 1964-07-01 0.013483 1964-10-01 3776.6 1964-10-01 8.2365794 31.193 3.4401937 1964-10-01 0.003528 1965-01-01 3869.8 1965-01-01 8.2609581 31.290 3.4432986 1965-01-01 0.024379 1965-04-01 3922.7 1965-04-01 8.2745355 31.490 3.44967 1965-04-01 0.013577 1965-07-01 4002.4 1965-07-01 8.2946495 31.583 3.452619 1965-07-01 0.020114 1965-10-01 4096.7 1965-10-01 8.3179371 31.750 3.4578927 1965-10-01 0.023288 1966-01-01 4197.9 1966-01-01 8.3423397 32.047 3.4672036 1966-01-01 0.024403 1966-04-01 4215.1 1966-04-01 8.3464286 32.337 3.4762121 1966-04-01 0.004089 1966-07-01 4245.2 1966-07-01 8.3535442 32.617 3.4848336 1966-07-01 0.007116 1966-10-01 4281.6 1966-10-01 8.3620821 32.883 3.4929558 1966-10-01 0.008538
Background image of page 1
1967-01-01 4320.9 1967-01-01 8.371219 32.967 3.4955071 1967-01-01 0.009137 1967-04-01 4324.7 1967-04-01 8.3720981 33.167 3.5015554 1967-04-01 0.000879 1967-07-01 4362.0 1967-07-01 8.3806859 33.500 3.5115454 1967-07-01 0.008588 1967-10-01 4397.1 1967-10-01 8.3887005 33.867 3.5224411 1967-10-01 0.008015 1968-01-01 4486.4 1968-01-01 8.4088059 34.200 3.5322256 1968-01-01 0.020105 1968-04-01 4562.2 1968-04-01 8.4255602 34.533 3.5419154 1968-04-01 0.016754 1968-07-01 4595.0 1968-07-01 8.432724 35.000 3.5553481 1968-07-01 0.007164 1968-10-01 4615.4 1968-10-01 8.4371538 35.433 3.5676436 1968-10-01 0.00443 1969-01-01 4687.1 1969-01-01 8.4525693 35.867 3.5798177 1969-01-01 0.015416 1969-04-01 4702.1 1969-04-01 8.4557645 36.433 3.595475 1969-04-01 0.003195 1969-07-01 4731.5 1969-07-01 8.4619976 36.933 3.6091055 1969-07-01 0.006233 1969-10-01 4711.0 1969-10-01 8.4576555 37.500 3.6243409 1969-10-01 -0.004342 1970-01-01 4702.8 1970-01-01 8.4559134 38.100 3.6402143 1970-01-01 -0.001742 1970-04-01 4711.1 1970-04-01 8.4576767 38.633 3.6541068 1970-04-01 0.001763 1970-07-01 4752.8 1970-07-01 8.4664892 39.033 3.6644074 1970-07-01 0.008812 1970-10-01 4703.9 1970-10-01 8.4561472 39.600 3.6788291 1970-10-01 -0.010342 1971-01-01 4829.9 1971-01-01 8.482581 39.933 3.687203 1971-01-01 0.026434 1971-04-01 4857.4 1971-04-01 8.4882586 40.300 3.6963515 1971-04-01 0.005678 1971-07-01 4895.3 1971-07-01 8.4960308 40.700 3.7062281 1971-07-01 0.007772 1971-10-01 4909.5 1971-10-01 8.4989274 41.000 3.7135721 1971-10-01 0.002897 1972-01-01 4997.0 1972-01-01 8.516593 41.333 3.7216612 1972-01-01 0.017666 1972-04-01 5112.7 1972-04-01 8.5394829 41.600 3.7281002 1972-04-01 0.02289 1972-07-01 5159.8 1972-07-01 8.5486531 41.933 3.7360731 1972-07-01 0.00917 1972-10-01 5245.5 1972-10-01 8.5651258 42.367 3.7463698 1972-10-01 0.016473 1973-01-01 5374.7 1973-01-01 8.589458 43.033 3.7619673 1973-01-01 0.024332 1973-04-01 5435.6 1973-04-01 8.6007252 43.933 3.7826657 1973-04-01 0.011267 1973-07-01 5406.1 1973-07-01 8.5952832 44.800 3.8022081 1973-07-01 -0.005442 1973-10-01 5456.5 1973-10-01 8.6045628 45.933 3.8271838 1973-10-01 0.00928 1974-01-01 5411.2 1974-01-01 8.5962262 47.300 3.8565103 1974-01-01 -0.008337 1974-04-01 5425.4 1974-04-01 8.5988469 48.567 3.8829443 1974-04-01 0.002621 1974-07-01 5372.8 1974-07-01 8.5891045 49.933 3.9106821 1974-07-01 -0.009742 1974-10-01 5351.4 1974-10-01 8.5851135 51.467 3.9409408 1974-10-01 -0.003991 1975-01-01 5286.7 1975-01-01 8.5729495 52.567 3.9620885 1975-01-01 -0.012164 1975-04-01 5327.4 1975-04-01 8.5806186 53.200 3.9740584 1975-04-01 0.007669 1975-07-01 5415.5 1975-07-01 8.5970205 54.267 3.9939163 1975-07-01 0.016402 1975-10-01 5488.5 1975-10-01 8.6104103 55.267 4.012176 1975-10-01 0.01339 1976-01-01 5612.4 1976-01-01 8.6327337 55.900 4.0235644 1976-01-01 0.022323 1976-04-01 5654.8 1976-04-01 8.64026 56.400 4.0324692 1976-04-01 0.007526 1976-07-01 5683.6 1976-07-01 8.6453401 57.300 4.0483006 1976-07-01 0.00508 1976-10-01 5726.2 1976-10-01 8.6528074 58.133 4.0627335 1976-10-01 0.007467 1977-01-01 5792.9 1977-01-01 8.6643883 59.200 4.0809215 1977-01-01 0.011581 1977-04-01 5906.6 1977-04-01 8.6838256 60.233 4.0982204 1977-04-01 0.019437 1977-07-01 6011.1 1977-07-01 8.701363 61.067 4.1119716 1977-07-01 0.017537 1977-10-01 6011.7 1977-10-01 8.7014628 61.967 4.126602 1977-10-01 9.98E-005 1978-01-01 6032.6 1978-01-01 8.7049334 63.033 4.1436584 1978-01-01 0.003471 1978-04-01 6267.2 1978-04-01 8.743085 64.467 4.1661535 1978-04-01 0.038152 1978-07-01 6328.5 1978-07-01 8.7528185 65.967 4.1891546 1978-07-01 0.009734 1978-10-01 6413.3 1978-10-01 8.7661292 67.500 4.2121276 1978-10-01 0.013311 1979-01-01 6426.1 1979-01-01 8.7681231 69.200 4.2370009 1979-01-01 0.001994 1979-04-01 6433.9 1979-04-01 8.7693362 71.400 4.2682979 1979-04-01 0.001213 1979-07-01 6480.1 1979-07-01 8.7764912 73.700 4.3000028 1979-07-01 0.007155 1979-10-01 6496.8 1979-10-01 8.779065 76.033 4.3311675 1979-10-01 0.002574 1980-01-01 6517.9 1980-01-01 8.7823075 79.033 4.3698655 1980-01-01 0.003242 1980-04-01 6385.7 1980-04-01 8.7618164 81.700 4.403054 1980-04-01 -0.020491 1980-07-01 6376.0 1980-07-01 8.7602962 83.233 4.4216439 1980-07-01 -0.00152 1980-10-01 6494.1 1980-10-01 8.7786494 85.567 4.4492997 1980-10-01 0.018353 1981-01-01 6628.6 1981-01-01 8.7991489 87.933 4.4765752 1981-01-01 0.0205 1981-04-01 6580.2 1981-04-01 8.7918204 89.767 4.4972174 1981-04-01 -0.007328 1981-07-01 6655.7 1981-07-01 8.8032289 92.267 4.5246865 1981-07-01 0.011408 1981-10-01 6578.0 1981-10-01 8.791486 93.767 4.540813 1981-10-01 -0.011743 1982-01-01 6468.0 1982-01-01 8.7746222 94.600 4.5496575 1982-01-01 -0.016864 1982-04-01 6503.3 1982-04-01 8.780065 95.967 4.5640044 1982-04-01 0.005443 1982-07-01 6479.8 1982-07-01 8.7764449 97.633 4.5812156 1982-07-01 -0.00362 1982-10-01 6486.2 1982-10-01 8.7774321 97.933 4.5842836 1982-10-01 0.000987 1983-01-01 6571.1 1983-01-01 8.7904365 98.000 4.5849675 1983-01-01 0.013004 1983-04-01 6721.1 1983-04-01 8.8130071 99.133 4.5964624 1983-04-01 0.022571 1983-07-01 6852.7 1983-07-01 8.832398 100.100 4.6061697 1983-07-01 0.019391 1983-10-01 6994.0 1983-10-01 8.8528079 101.100 4.6161101 1983-10-01 0.02041 1984-01-01 7132.9 1984-01-01 8.8724732 102.533 4.6301847 1984-01-01 0.019665 1984-04-01 7258.2 1984-04-01 8.8898871 103.500 4.6395716 1984-04-01 0.017414 1984-07-01 7329.6 1984-07-01 8.8996762 104.400 4.6482297 1984-07-01 0.009789 1984-10-01 7388.1 1984-10-01 8.9076259 105.300 4.6568134 1984-10-01 0.00795 1985-01-01 7461.5 1985-01-01 8.9175117 106.267 4.6659548 1985-01-01 0.009886 1985-04-01 7529.9 1985-04-01 8.926637 107.233 4.675004 1985-04-01 0.009125 1985-07-01 7647.0 1985-07-01 8.9420687 107.900 4.6812049 1985-07-01 0.015432 1985-10-01 7704.4 1985-10-01 8.9495469 109.000 4.6913479 1985-10-01 0.007478 1986-01-01 7775.8 1986-01-01 8.9587716 109.567 4.6965362 1986-01-01 0.009225 1986-04-01 7811.5 1986-04-01 8.9633523 109.033 4.6916506 1986-04-01 0.004581 1986-07-01 7890.1 1986-07-01 8.9733641 109.700 4.6977494 1986-07-01 0.010012 1986-10-01 7931.0 1986-10-01 8.9785344 110.467 4.7047168 1986-10-01 0.00517 1987-01-01 7986.4 1987-01-01 8.9854954 111.800 4.7167116 1987-01-01 0.006961
Background image of page 2
Show entire document
Background image of page 1
Background image of page 1
Background image of page 1
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question