Modelling and drawing equations

Reference no: EM1398280

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

b) Quadratic trend

c) Exponential trend model

5. Using the most appropriate model as you selected in 4), forecast the closing value for 2008.

a) 13119:8788

b) 15236:6701

c) 19297:45336

Reference no: EM1398280

Questions Cloud

Describe how such a system might work : Based on its structure, explain how the synaptonemal complex could actually represent an obstacle to recombination.

What is the phenotype of a cell : Since it takes 40 min. to replicate the E. coli chromosome, how can the cell have a cell cycle of 35 minutes?

Api 20 e identification system for enterobacteriaceae : In clinical applications of API 20 E Identification System for Enterobacteriaceae and Other gram-negative rods, reagents are added only if the glucose (oxidation/fermentation) test results is yellow or at least three other tests are positive.

Write persuasive essay on tv is bad : Choose a topic and try to convince reader to accept proposition about that topic. You actually require to try to win over your reader in some way.

Modelling and drawing equations : The data represents the closing value of the Dow Jones Industrial Average (DJIA) over the 29-year period from 1979 to 2007.

Which poll is likely to be more reliable : San francisco also reported that a scientific polling organization found that new zealanders favor the law by a margin of 56.4% to 39.3%. Explain why the two polls can give such widely differing results and which poll is likely to be more reliable..

Project the age structure and size of the population : Imagine that you have been studying the population biology of ground squirrels on the UCSC campus for a number of years and have obtained the following information.

Probability that contaminated can is selected for testing : What is the probability that the contaminated can is selected for testing?

Relationship between two variables : Calculate, test, and interpret the relationship between two variables using the correlation coefficient.

User Account

All Pages