0% found this document useful (0 votes)
12 views10 pages

Chapter Four

Download as doc, pdf, or txt
Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1/ 10

CHAPTER FOUR

DATA PRESENTATION, ANALYSIS AND INTERPRETATION

4.1 INTRODUCTION

The data analysis and result interpretation for the dependent variable

and independent variables are presented in this chapter, together with the

findings from the testing of the study hypotheses.

4.2 DATA PRESENTATION

Oil Revenue (Billions in


Year GDP($)
Niara)
1980 $64.20B 36.58
1981 $164.48B 38.49
1982 $142.77B 27.86
1983 $97.09B 27.43
1984 $73.48B 39.08
1985 $73.75B 19.66
1986 $54.81B 28.92
1987 $52.68B 33.06
1988 $49.65B 43.03
1989 $44.00B 42.52
1990 $54.04B 45.33
1991 $49.12B 44.43
1992 $47.79B 44
1993 $27.75B 43.34
1994 $33.83B 46.07
1995 $44.06B 51.35
1996 $51.08B 50.53
1997 $54.46B 45.35
1998 $54.60B 47.44
1999 $59.37B 46.98
2000 $69.45B 136.78
2001 $72.80B 126
2002 $95.05B 137.96
2003 $104.74B 151.76
2004 $135.76B 166.93
2005 $175.67B 183.66
2006 $238.45B 202.17
2007 $278.26B 222.39
2008 $339.48B 237.85
2009 $295.01B 237.85
2010 $366.99B 255.16
2011 $414.47B 271
2012 $463.97B 223.52
2013 $520.12B 344.71
2014 $574.18B 311.38
2015 $493.03B 200.88
2016 $404.65B 205.97
2017 $375.75B 148.92
2018 $421.74B 143
2019 $448.12B 98.12
2020 $432.20B 37.07
2021 $440.83B 19.3

Source; CBN Statistical Bulletin December 2021

4.3 PRESENTATION OF DESCRIPTIVE STATISTICS

The descriptive statistics displays the difference between each

independent variable's mean and standard deviation and the dependent

variable's mean and standard deviation.

Table 4.1: Descriptive Statistics of the Variables

GDP GNP PCY NRV OPV ORV

Mean 167.72 41.63 76.78 20.05 42.2 70.17


Median 97.09 45.28 18.30 26.50 22.00 45.34
Maximum 574.18 54.28 24.71 32.00 45.00 344.71
Minimum 27.75 13.47 13.3 2.00 0.15 19.3
Std. Dev. 137.74 16.52 54.46 72.66 47.52 76.94
Observations 42 42 42 42 42 42
Source: Computed using E-view 9

Table 4.1 shows the descriptive statistics result of the dependent and

independent variables, indicating data availability for each year from 1980 to

2021 in Billion USD.

There were 42 observations in all. The dependent and independent

variables' means, medians, and standard deviations are displayed in the table
together with their minimum and maximum ranges. The mean (or average) is

the sum of all values divided by the number of observations. For GDP, the

mean is approximately 167.72 USD billions, while for oil revenue, it is

approximately 70.17 Billion Naira. These values provide an estimate of the

central tendency of the data.

The standard deviation measures the dispersion or spread of the data

points around the mean. It indicates how much the values deviate from the

average. In this case, the standard deviation is around 137.74 Billion Dollars

for GDP and 76.94 Billion Naira for oil revenue. Higher standard deviations

suggest greater variability in the data.

The minimum represents the smallest value in the dataset. For GDP,

the minimum is 27.75 USD billions, and for oil revenue, it is 19.3 billion

Naira. These values indicate the lowest recorded levels for each respective

variable.

The median is the middle value in the dataset when arranged in

ascending order. It represents the value that separates the lower half from the

upper half of the data. The median for GDP is 97.09 USD billions, and for oil

revenue, it is 45.34 Billion Naira. This value provides insight into the central

tendency, regardless of extreme values.


Oil price volatility (OPV), an independent variable, has an average of

42.2 USD billions, a median of 22 USD billions, a minimum of 0.15 USD

billion, a maximum of 45 USD billions, and a standard deviation of 47.52

USD billions, or 100%, indicating that the OPV of the sampled companies

varies widely. Oil revenue (ORV), an independent variable, The average value

of GDP over the 42-year period is approximately $167.72 billion. For oil

revenue, the mean is around 70.17 billion Naira.

The median GDP value is $97.09 billion, which represents the middle

value when the data is arranged in ascending order. The median oil revenue is

45.34 billion Naira. The lowest recorded GDP value is $27.75 billion in 1993,

while the lowest oil revenue is 19.3 billion Naira in 2021. The highest GDP

value is $574.18 billion in 2014, and the highest oil revenue is 344.71 billion

Naira in 2013. The standard deviation measures the dispersion of data points

around the mean. A higher standard deviation indicates greater variability in

the data. For GDP, the standard deviation is $137.74 billion, and for oil

revenue, it is 76.94 billion Naira.

4.3 ANALYSIS OF DATA


The analysis conducted on the data obtained from published statistical

websites and the Central Bank of Nigeria's statistical bulletins for the study

period is presented in this section. It displays the study's descriptive data,

correlations, and regression findings.

4.3.1 Correlation Result

Each independent variable's link to the dependent variable is

depicted by the correlation result. The correlation coefficient has values

between -1 and 1. The absolute value of the correlation coefficient reflects

the strength of the link, with higher values suggesting stronger relationships

and lower values indicating weaker relationships. The sign of the correlation

coefficient indicates the direction of the association (positive or negative).

Each variable has a perfect positive linear relationship with itself, resulting

in correlation coefficients on the major diagonal of 1.0.

Table 4.2: Correlation result

GDP GNP PCY NRV OPV ORV

GDP 1.0000
GNP 0.9997 1.0000
PCY 0.9522 0.9486 1.0000
NRV 0.9649 0.9653 0.8770 1.0000
OPV 0.8623 0.8631 0.7640 0.9367 1.0000
ORV 0.8358 0.8264 0.8832 0.7926 0.7374 1.0000
Source: Computed using E-view 9

Table 4.2 shows the correlation result of the dependent variable GDP, GNP

and PCY and the independent variables NRV, OPV and ORV.

With a coefficient value of 0.9649, or 96.49%, the link between GDP

and the independent variable NRV is both positive and strong. This suggests

that, all other things being equal, the higher the NRV, the larger the GDP. With

a coefficient value of 0.9653, or 96.53%, the link between GNP and the

independent variable NRV is both positive and strong. Accordingly, when all

other factors are equal, the higher the NRV, the larger the GNP. With a

coefficient value of 0.8771, or 87.71%, the association between PCY and the

independent variable NRV is both positive and strong. This suggests that, all

other things being equal, the greater the NRV, the higher the PCY.

With a coefficient value of 0.8624, or 86.24%, the association between

GDP and the independent variable OPV is both positive and strong.

Accordingly, when all other factors are equal, the greater the OPV, the higher

the GDP. With a coefficient value of 0.8632, or 86.32%, the association

between GNP and the independent variable OPV is both positive and strong.

Accordingly, when all other factors are equal, the greater the OPV, the bigger

the GNP. With a coefficient value of 0.7641, or 76.41%, the association


between PCY and the independent variable OPV is both positive and strong.

This suggests that, all other things being equal, the greater the OPV, the higher

the PCY.

The association between GDP and a free variable With a coefficient

value of 0.8359, or 83.59%, the ORV is strong and positive, indicating that, all

other things being equal, a greater ORV will result in a higher GDP. The

association between the independent variable and GNP With a coefficient

value of 0.8265, or 82.65%, the ORV is strong and positive, indicating that, all

other things being equal, a greater ORV will result in a larger GNP. With a

coefficient value of 0.8833, or 88.33%, the association between PCY and the

independent variable ORV is strong and positive. This indicates that, all other

things being equal, the greater the ORV, the higher PCY.

4.3.2. REGRESSION RESULT

The outcome of the regression demonstrates how each independent

variable affected the dependent variable. The regression coefficient values,

which vary from 0% to 100%, show how much of an impact there is. The F

statistics, R2 and corrected R2 of the model are also included in this section.

Table 4.3: Regression Results

MODEL I MODEL II MODEL III


GDP GNP PCY
Var. B t-cal Sig. B t-cal Sig. B t-cal Sig.

Const 18.4800 2.1680 0.0372 16.6341 1.9568 0.0586 1396.57 34.0025 0.0000
NRV 0.1669 10.1414 0.0000 0.1636 9.9700 0.0000 0.3952 4.9841 0.0000
OPV -1.2132 -3.2987 0.0023 -1.1609 3.1651 0.0033 -4.8711 -2.7487 0.0095
ORV 0.0121 3.2406 0.0027 0.0101 2.6952 0.0109 0.0962 5.3357 0.0000

F 259.0320 241.5175 90.8432

P>F 0.0001 0.0001 0.0001


R2 0.9581 0.9552 0.8891
Adj. 0.9544 0.9512 0.8793

2
R

Source: Computed using E-view 9

The dependent variables in the model are the GDP, GNP, and PCY,

while the independent variables are the NRV, OPV, and ORV. the effects of

independent and dependent variables on each other GDP is positive with a

coefficient value of 0.1669, which means that an increase in NRV of one unit

while all other variables remain constant will result in a rise in GDP of

16.69%.

The influence of independent variable NRV on dependent variable

PCY is positive with coefficient value of 0.3952, indicating that increasing

NRV by one unit while keeping other variables constant would result in an

increase in PCY of 16.36%. GNP is positive with coefficient value of 0.1636,


meaning that a one-unit increase in NRV, with all other variables remaining

constant, would result in a 39.52% rise in PCY. the relationship between the

independent variable OPV and the dependent variable GDP is unfavorable

with a coefficient value of -1.2132, which means that an increase in OPV by

one unit while all other variables remain constant would result in a 100%

reduction in GDP; the relationship between the independent variable OPV and

the dependent variable GNP is negative, with a coefficient of -1.1609,

implying that an increase in OPV of just one unit while all other variables

remain constant will result in a 100% reduction in GNP; Increasing ORV by

one unit while holding other variables constant will result in a rise in PCY of

9.62%, according to the relationship between independent variable ORV and

dependent variable PCY, which has a positive impact with a coefficient value

of 0.0962.

The multiple coefficients of determination R2 in the model is 0.9581,

0.9552, and 0.8891. This indicates that while changes in the independent

variables NRV, OPV, and ORV were responsible for 95.81% of the change in

GDP, 95.52% of the change in GNP, and 88.91% of the change in PCY, the

remaining 4.19%, 4.48%, and 11.9% of the change in GDP, GNP, and PCY

were driven by external factors that were not taken into account in the model.

You might also like