Question
Please help me do these questions with excel with the given data set Help me do these questions-To answer the following questions, download the CSV
Please help me do these questions with excel with the given data set
Help me do these questions-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 second quarter of 2005? Round your answer to the nearest second decimal.
- What is the value of the detrended series in the second quarter of 2012? 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 second quarter of 2005? Round your answer to the nearest second decimal.
- What is the value of the low frequency component in the first quarter of 1989? 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 1965? Round your answer to the nearest second decimal.
- What are the four seasonal values of the four quarters? Round your answer to the nearest second decimal.
Data:
| 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 |
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
Intro Stats
Authors: Richard D. De Veaux, Paul F. Velleman, David E. Bock
3rd edition
321533283, 321533289, 9780321463708, 9780321503848, 9780321503800, 9780321499431, 9780321499417, 978-0321500458
