Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data in the table represent the January 1 stock price for the 33-year period from 1987 to 2019 for General Electric, one of the

The data in the table represent the January 1 stock price for the 33-year period from 1987 to 2019 for General Electric, one of the world's largest companies.

Year GE Stock Price
1987 2.25
1988 2.36
1989 2.48
1990 3.68
1991 3.38
1992 4.65
1993 5.35
1994 6.74
1995 6.76
1996 9.80
1997 13.75
1998 20.77
1999 29.99
2000 44.98
2001 42.27
2002 35.90
2003 22.37
2004 29.25
2005 35.29
2006 34.79
2007 22.30
2008 22.54
2009 8.15
2010 11.35
2011 14.62
2012 14.05
2013 17.36
2014 20.22
2015 19.90
2016 26.39
2017 15.09
2018 9.75
2019 6.89

a. Fit a third-order autoregressive model to the GE stock price and test for the significance of the third-order autoregressive parameter. ( Use alpha=0.05).

b. If necessary, fit a second-order autoregressive model to the GE stock price and test for the significance of the second-order autoregressive parameter. ( Use alpha=0.05).

c. If necessary, fit a first-order autoregressive model to the GE stock price and test for the significance of the first-order autoregressive parameter. ( Use alpha=0.05). Plot the predicted values by this model.

d. Forecast the GE stock price for years 2020 and 2021 using the appropriate autoregressive model among a b and c.

Please use excel to show answer. ty!

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

Profit First For Lawn Care And Landscape Businesses

Authors: Christeen Era, Steven A Rigolosi, Mike Michalowicz

1st Edition

0578908158, 978-0578908151

More Books

Students also viewed these Finance questions

Question

Show that (y v2) if x y or x 2.

Answered: 1 week ago

Question

Describe the menstrual cycle in a woman.

Answered: 1 week ago

Question

Explain methods of metal extraction with examples.

Answered: 1 week ago