Lab-Type Questions

In this section, you will use excel to answer the following questions. all the necessary computations in excel. You can copy the output from excel into Word document and do the discussion.

Suppose you are an Economist at the Reserve Bank and provided the following data on investment.

Year General Government Investment Private Public Enterprises Investment 1980 4.61 20.78 1981 6.89 19.66 1982 5.48 18.12 1983 3.17 17.76 1984 2.97 14.12 1985 3.10 15.06 1986 2.96 11.77 1987 2.29 13.40 1988 2.54 9.52 1989 3.24 8.80 1990 3.27 9.25 1991 4.01 10.44 1992 2.99 8.47 1993 2.51 11.96 1994 2.58 9.41 1995 2.43 10.33 1996 2.99 13.71 1997 3.20 15.60 1998 3.37 23.58 1999 3.42 18.00 2000 2.91 12.46 2001 3.68 11.62 2002 4.56 14.61 2003 4.05 17.41 2004 3.44 15.06 2005 3.05 16.58 2006 3.21 13.92 2007 2.17 11.20 2008 2.56 18.30 2009 4.03 12.17 2010 2.88 13.00 2011 3.14 14.93 2012 3.47 11.45 2013 4.87 21.09 Source: Reserve Bank of Fiji Vote: Both series are measured as percentage of GDP