Share
Explore BrainMass

# Modelling and Drawing Equations from Data

The data in DJIA.xls (ExcelDataFiles) represents the closing value of the Dow Jones Industrial Average (DJIA) over the 29-year period from 1979 to 2007.

Year | Coded Year | DJIA
1979 | 0 | 838.7
1980 | 1 | 964.0
1981 | 2 | 875.0
1982 | 3 | 1046.5
1983 | 4 | 1258.6
1984 | 5 | 1211.6
1985 | 6 | 1546.7
1986 | 7 | 1896.0
1987 | 8 | 1938.8
1988 | 9 | 2168.6
1989 | 10 | 2753.2
1990 | 11 | 2633.7
1991 | 12 | 3168.8
1992 | 13 | 3301.1
1993 | 14 | 3754.1
1994 | 15 | 3834.4
1995 | 16 | 5117.1
1996 | 17 | 6448.3
1997 | 18 | 7908.3
1998 | 19 | 9181.4
1999 | 20 | 11497.1
2000 | 21 | 10788.0
2001 | 22 | 10021.5
2002 | 23 | 8341.6
2003 | 24 | 10453.9
2004 | 25 | 10788.0
2005 | 26 | 10717.5
2006 | 27 | 12463.2
2007 | 28 | 13264.8

1. Find a linear trend equation to these data. X = 0 represents 1979.
a) Y =-112.33952 + 474.7758X
b) Y=1123.3952 + 474.7758X
c) Y=-1123.3952 + 474.7758X

2. Find a quadratic equation to these data. X = 0 represents 1979.
a) Y = 310:5601 + 156.1190X +11.3806X^2
b) Y = 310:5601 + 156.1190X^2 + 11.3806X
c) Y = -310:5601 + 156.1190X +11.3806X^2

3. Find an exponential equation to these data. X=0 represents 1979.
a) ln Y = 2.9254 + 0.0469X
b) log10 Y=2.9254+0.0469x
c) Y = 2.9254 + 0.0469X

4. Which model appears to be the most appropriate?
a) Linear trend model