Business Conditions Analysis

profilecattlejock87
AA1_data.xlsx
Home>Business & Finance homework help>Business Conditions Analysis

Growth Rate

GROSS DOMESTIC Economic Growth
Year PRODUCT (SA) GDP DEFLATOR Real GDP Rate Recession Ln (Real GDP) D(LnRGDP)
1973Q1 18.19 13.39
1973Q2 18.00 13.20
1973Q3 18.60 13.75
1973Q4 19.22 14.24
1974Q1 18.96 14.40
1974Q2 20.46 15.25
1974Q3 21.64 15.97
1974Q4 22.75 17.00
1975Q1 24.51 18.26
1975Q2 25.87 19.59
1975Q3 26.99 20.47
1975Q4 28.50 21.32
1976Q1 29.86 21.98
1976Q2 30.48 22.61
1976Q3 31.49 23.14
1976Q4 33.38 24.02
1977Q1 34.57 24.85
1977Q2 35.80 25.85
1977Q3 36.89 26.44
1977Q4 38.40 27.14
1978Q1 39.98 28.12
1978Q2 41.47 28.90
1978Q3 42.54 29.34
1978Q4 43.92 30.07
1979Q1 45.12 31.16
1979Q2 48.27 31.97
1979Q3 50.73 34.42
1979Q4 53.32 35.81
1980Q1 55.26 37.47
1980Q2 56.72 39.17
1980Q3 58.62 40.56
1980Q4 60.20 42.14
1981Q1 61.25 43.20
1981Q2 62.26 43.86
1981Q3 63.95 44.48
1981Q4 65.69 45.73
1982Q1 67.27 46.69
1982Q2 68.61 47.05
1982Q3 69.73 47.86
1982Q4 71.59 48.91
1983Q1 73.84 49.73
1983Q2 74.41 49.74
1983Q3 76.38 50.48
1983Q4 78.35 51.19
1984Q1 78.93 51.12
1984Q2 80.75 52.67
1984Q3 81.40 52.87
1984Q4 83.55 53.52
1985Q1 85.36 54.12
1985Q2 88.69 55.35
1985Q3 89.67 55.95
1985Q4 91.56 56.74
1986Q1 92.96 56.81
1986Q2 94.45 57.07
1986Q3 95.89 57.62
1986Q4 98.49 58.21
1987Q1 100.69 59.21
1987Q2 103.19 60.04
1987Q3 107.13 60.99
1987Q4 109.21 61.60
1988Q1 112.53 62.47
1988Q2 114.96 63.52
1988Q3 118.88 64.79
1988Q4 122.67 66.38
1989Q1 125.07 67.52
1989Q2 127.02 68.13
1989Q3 130.03 69.68
1989Q4 132.81 71.09
1990Q1 135.69 72.08
1990Q2 139.45 73.69
1990Q3 141.53 75.69
1990Q4 141.49 76.11
1991Q1 144.24 77.62
1991Q2 146.03 78.85
1991Q3 147.28 79.84
1991Q4 149.54 80.97
1992Q1 151.66 81.94
1992Q2 152.86 82.79
1992Q3 152.97 82.44
1992Q4 154.49 82.80
1993Q1 157.61 83.91
1993Q2 158.94 84.24
1993Q3 161.91 85.08
1993Q4 164.19 85.54
1994Q1 166.37 85.74
1994Q2 168.75 85.74
1994Q3 171.08 85.73
1994Q4 174.78 86.95
1995Q1 176.02 87.32
1995Q2 179.19 88.32
1995Q3 181.45 88.65
1995Q4 183.09 89.11
1996Q1 186.92 90.18
1996Q2 190.42 91.43
1996Q3 193.21 92.05
1996Q4 194.60 91.97
1997Q1 197.69 92.81
1997Q2 200.96 93.61
1997Q3 204.77 94.62
1997Q4 207.77 95.15
1998Q1 210.58 95.57
1998Q2 213.36 96.30
1998Q3 217.42 97.11
1998Q4 219.43 97.30
1999Q1 221.50 97.88
1999Q2 225.10 98.82
1999Q3 228.88 99.17
1999Q4 231.09 99.03
2000Q1 234.65 99.45
2000Q2 237.22 99.81
2000Q3 239.67 100.25
2000Q4 241.69 100.48
2001Q1 246.35 101.49
2001Q2 248.06 102.08
2001Q3 249.45 102.04
2001Q4 253.14 103.14
2002Q1 257.37 104.32
2002Q2 261.03 105.24
2002Q3 264.05 105.68
2002Q4 266.32 106.05
2003Q1 270.92 107.34
2003Q2 275.13 108.38
2003Q3 280.02 109.11
2003Q4 284.22 109.58
2004Q1 286.98 109.85
2004Q2 293.12 111.19
2004Q3 296.00 111.86
2004Q4 300.43 112.87
2005Q1 301.18 112.91
2005Q2 304.41 113.51
2005Q3 306.38 113.79
2005Q4 312.75 115.39
2006Q1 315.72 115.64
Question 1aiii) Average

NIPA

NOMINAL Nominal Real Share of Real GDP Growth
GROSS DOMESTIC Government Government Government Government
Year PRODUCT (SA) Real GDP CPI CONSUMPTION INVESTMENT Purchases Net Exports CONSUMPTION INVESTMENT Purchases Net Exports CONSUMPTION INVESTMENT Purchases Net Exports CONSUMPTION INVESTMENT Purchases
1973Q1 18.19 13.40 11.00 4.16 3.34 -0.25
1973Q2 18.00 13.82 11.08 3.95 3.4 -0.29
1973Q3 18.60 14.03 11.38 4.19 3.55 -0.49
1973Q4 19.22 14.51 11.77 4.46 3.65 -0.75
1974Q1 18.96 15.10 12.10 4.2 3.84 -0.99
1974Q2 20.46 16.02 12.70 4.93 4.04 -1.14
1974Q3 21.64 16.39 13.32 5.08 4.46 -0.99
1974Q4 22.75 17.13 14.09 4.97 4.91 -1
1975Q1 24.51 18.17 14.97 4.53 5.61 -0.54
1975Q2 25.87 19.89 15.91 4.97 5.73 -0.31
1975Q3 26.99 20.75 16.37 5.35 6.09 -0.7
1975Q4 28.50 21.48 16.96 5.65 6.38 -0.25
1976Q1 29.86 22.26 17.68 6.03 6.64 0.07
1976Q2 30.48 23.04 18.24 6.23 6.96 -0.48
1976Q3 31.49 23.59 18.90 6.77 7.07 -0.56
1976Q4 33.38 24.67 19.88 7.39 7.2 -0.42
1977Q1 34.57 25.92 20.33 7.25 7.28 -0.18
1977Q2 35.80 27.08 20.92 7.54 7.58 -0.06
1977Q3 36.89 27.51 21.63 7.12 7.71 0.68
1977Q4 38.40 27.92 22.41 8.12 7.86 0.61
1978Q1 39.98 28.37 23.56 8.16 8.28 0.35
1978Q2 41.47 29.15 24.03 8.52 8.48 0.7
1978Q3 42.54 29.64 25.06 8.39 8.7 0.49
1978Q4 43.92 30.17 25.63 8.95 9.03 0.71
1979Q1 45.12 31.11 26.69 9.49 9.24 -0.52
1979Q2 48.27 32.25 28.97 9.46 9.74 0.42
1979Q3 50.73 34.40 29.65 10.53 10.24 0.5
1979Q4 53.32 35.38 31.30 10.89 10.77 0.34
1980Q1 55.26 37.04 32.95 10.09 11.54 0.51
1980Q2 56.72 39.20 33.26 10.4 12.15 0.65
1980Q3 58.62 40.04 34.29 10.23 13.01 1.82
1980Q4 60.20 40.78 34.84 9.95 13.6 2.18
1981Q1 61.25 41.74 36.20 9.52 13.75 2.77
1981Q2 62.26 43.80 37.13 9.51 14.14 2.14
1981Q3 63.95 44.54 37.94 10.58 14.47 0.95
1981Q4 65.69 45.64 38.97 10.97 14.54 1.31
1982Q1 67.27 46.38 39.69 11.6 15.16 1.27
1982Q2 68.61 47.87 40.36 11.84 15.49 0.83
1982Q3 69.73 48.11 41.52 11.38 15.5 1.22
1982Q4 71.59 48.46 42.86 11.4 15.82 1.75
1983Q1 73.84 48.69 43.78 12.63 16.73 0.83
1983Q2 74.41 49.67 44.57 12.82 16.8 0.32
1983Q3 76.38 50.34 45.86 13.03 16.7 0.86
1983Q4 78.35 50.91 46.36 14.48 17.1 0.45
1984Q1 78.93 51.20 47.12 13.99 17.04 0.66
1984Q2 80.75 52.24 48.30 14.96 17.76 -0.42
1984Q3 81.40 52.69 48.45 15.08 18.13 -0.4
1984Q4 83.55 53.37 49.90 15.85 18.43 -0.75
1985Q1 85.36 54.02 51.05 16.23 18.77 -0.59
1985Q2 88.69 55.88 52.10 16.53 18.63 1.53
1985Q3 89.67 56.02 53.57 15.97 18.93 1.31
1985Q4 91.56 56.29 54.90 16.5 19.14 1.11
1986Q1 92.96 56.68 57.06 15.83 19.84 0.24
1986Q2 94.45 57.43 58.30 16.62 20.26 -0.73
1986Q3 95.89 57.48 59.17 17.79 20.38 -1.46
1986Q4 98.49 58.23 60.06 18.98 20.71 -1.26
1987Q1 100.69 58.93 62.03 17.54 21.13 0
1987Q2 103.19 59.83 63.32 19.33 21.63 -1.09
1987Q3 107.13 59.97 65.25 21.24 21.99 -1.36
1987Q4 109.21 60.62 67.26 21.99 22.39 -2.43
1988Q1 112.53 60.91 69.85 22.8 22.98 -3.1
1988Q2 114.96 62.38 71.68 23.7 23.28 -3.69
1988Q3 118.88 63.24 74.22 25.89 23.31 -4.54
1988Q4 122.67 64.57 75.85 28.23 24.36 -5.77
1989Q1 125.07 65.61 77.69 28.25 24.73 -5.59
1989Q2 127.02 67.49 79.69 28.14 24.84 -5.66
1989Q3 130.03 68.12 80.57 29.58 25.73 -5.85
1989Q4 132.81 69.47 82.42 28.03 26.34 -3.98
1990Q1 135.69 70.70 84.31 29.16 26.93 -4.7
1990Q2 139.45 74.01 86.82 29.29 27.71 -4.37
1990Q3 141.53 75.22 87.61 28.23 28.63 -2.94
1990Q4 141.49 76.40 89.00 25.7 29.15 -2.36
1991Q1 144.24 76.85 89.90 26.77 29.69 -2.12
1991Q2 146.03 78.45 91.90 24.64 30.7 -1.22
1991Q3 147.28 78.81 93.34 23.7 31.52 -1.29
1991Q4 149.54 79.57 94.12 25.05 31.88 -1.51
1992Q1 151.66 80.00 94.88 25.68 32.38 -1.28
1992Q2 152.86 81.72 97.17 24.64 32.66 -1.62
1992Q3 152.97 81.66 97.95 24.07 33.13 -2.17
1992Q4 154.49 82.00 98.67 24.8 33.4 -2.38
1993Q1 157.61 81.45 100.56 25.17 33.61 -1.72
1993Q2 158.94 82.76 102.60 25.47 32.88 -2.01
1993Q3 161.91 83.00 104.59 25.41 33.41 -1.49
1993Q4 164.19 83.27 106.15 25.41 33.74 -1.1
1994Q1 166.37 83.39 107.27 26.14 34.25 -1.28
1994Q2 168.75 84.89 108.00 28.17 33.95 -1.37
1994Q3 171.08 84.91 109.32 27.68 34.78 -0.7
1994Q4 174.78 85.46 110.54 30.37 35.13 -1.26
1995Q1 176.02 86.23 111.94 27.78 35.3 1
1995Q2 179.19 87.79 113.42 31.66 35.67 -1.55
1995Q3 181.45 88.03 115.38 32.14 35.72 -1.79
1995Q4 183.09 88.16 116.75 30.84 36.22 -0.71
1996Q1 186.92 88.61 119.03 31.82 37.42 -1.34
1996Q2 190.42 89.77 121.81 32.79 36.85 -1.03
1996Q3 193.21 89.93 124.07 32.44 37.02 -0.32
1996Q4 194.60 90.47 125.93 31.16 37.35 0.17
1997Q1 197.69 91.00 126.52 32.6 37.33 1.26
1997Q2 200.96 92.16 129.65 33.54 37.44 0.33
1997Q3 204.77 93.06 131.11 35.29 37.61 0.76
1997Q4 207.77 93.80 133.39 36.79 38.18 -0.58
1998Q1 210.58 94.10 135.41 38.34 37.91 -1.06
1998Q2 213.36 95.84 137.97 37.98 38.77 -1.36
1998Q3 217.42 96.15 139.95 39.69 39.56 -1.78
1998Q4 219.43 96.58 141.67 40.54 40.17 -2.94
1999Q1 221.50 96.17 144.27 40.78 40.91 -4.47
1999Q2 225.10 97.19 146.35 39.31 42.43 -2.99
1999Q3 228.88 97.27 148.08 41.08 42.84 -3.11
1999Q4 231.09 97.99 151.17 41.47 43.34 -4.88
2000Q1 234.65 98.38 154.37 41.22 43.58 -4.51
2000Q2 237.22 100.23 154.68 41.09 45.34 -3.89
2000Q3 239.67 100.38 156.41 42.47 46.21 -5.42
2000Q4 241.69 101.01 158.53 41.97 46.72 -5.54
2001Q1 246.35 100.89 160.86 42.99 47.43 -4.94
2001Q2 248.06 102.14 163.13 43.9 47.54 -6.5
2001Q3 249.45 102.18 165.91 43.78 48.97 -9.21
2001Q4 253.14 102.07 167.33 41.39 50.57 -6.15
2002Q1 257.37 102.12 170.26 42.78 51.75 -7.42
2002Q2 261.03 103.40 171.91 43.55 52.93 -7.37
2002Q3 264.05 103.75 173.15 44.54 53.59 -7.23
2002Q4 266.32 104.67 175.21 45.77 54.19 -8.85
2003Q1 270.92 105.26 177.62 43.41 56.03 -6.13
2003Q2 275.13 106.51 180.29 43.65 57.78 -6.58
2003Q3 280.02 106.78 182.34 46.47 58.82 -7.6
2003Q4 284.22 107.45 184.10 49.17 60.08 -9.13
2004Q1 286.98 107.98 187.16 47.06 60.82 -8.06
2004Q2 293.12 109.45 189.80 49.54 62.19 -8.41
2004Q3 296.00 110.09 191.41 50.44 63.18 -9.03
2004Q4 300.43 111.11 193.11 52.28 64.51 -9.47
2005Q1 301.18 111.41 194.86 51.27 65.12 -10.25
2005Q2 304.41 112.74 196.44 51.05 65.94 -9.24
2005Q3 306.38 113.15 198.62 53.68 67.62 -13.81
2005Q4 312.75 113.75 201.39 53.18 68.85 -10.95
2006Q1 315.72 114.07 203.04 55.23 69.76 -12.56
Correlations
Question 1bi) Consumption Investment Gov't Purchases Net Exports Question 1bii) Average Share
Nominal
Real Consumption Investment Gov't Purchases
Question 1biii) Standard Deviation
Variance