ASSIGNMENT HELP ON EDUCATION AND WAGE

Analyzing Relationship Between Education and Wage Rate Via Simple Linear Regression

  1. Purpose

The purpose of this assignment is to analyze the relationship between education and wage rate by means of simple linear regression. In short, the chief purpose of this task is to analyze how much education affects wage rate.

 

  1. Background

The intellectual abilities of an individual are developed by education. According to Psacharopoulos (1994), every person has loads of potential capabilities that can be enriched via education and appropriate education paves the way and directs individuals to virtue. In accordance with Psacharopoulos (1993), a vital role is played by education in formulating individuals to enter the workforce plus preparing them with the abilities to participate in enduring learning experiences. Thus, one’s income is raised by the achievement of education. Policymakers give emphasis to investment in human capital for the reason that they believe that it upsurges labor efficiency. Hence, it is anticipated that labor with a comparatively higher education should possess higher efficiency as well as an equivalent greater wage.

 

  1. Method

In this assignment, different statistical methods have been used in order to fulfill the research objectives. Initially, summary statistics is presented. Summary statistics abridges and provide information about the considered dataset. It states something concerning the values in the dataset comprising where the average lies and whether the considered dataset is skewed.

 

For modeling an association between a scalar dependent variable and one or more independent variables, linear regression is used. The case of one independent or explanatory variable is referred to as a simple linear regression.

 

Since, a linear regression model is not always suitable for the data; fitness of the model is evaluated by defining residuals and scrutinizing residual plots.

 

Quadratic regression model is taken into account considering that sometimes data fits well with a polynomial curve. 

Graphical representation of the distribution of numerical values obtained from ln (wage rate) is shown by histogram.

 

Log linear regression is also considered. It allows searching for associations among the variables in a multi-way contingency table.

 

  1. Results

In this section, results obtained after applying different statistical procedures are elucidated.

 

Need Urgent Assignment Help?
Get Assignment Help from Australia's No.1 Assignment Help Service
*
*
*

 

  • Data Characteristics

Table 1 gives a broader characteristic of the considered dataset. Summary statistics includes three chief classifications namely; measures of location (also referred to as central tendency), measures of spread, and charts and graphs. Central tendency or measures of location enlightens where the data is concentrated at, or in other words where a trend places. Mean values of Wage and Education are 22.31 and 13.76 respectively. 19.39 & 13 represent the Median values whereas the Mode values of wage and education are 38.45 and 12. Furthermore, measures of spread elucidates how assorted or spread out the dataset is. And such information holds significance. Table 2 and table 3 shows calculations on the basis of which the histograms for wage rate and education are made. The graphical representation of these histograms is shown in appendix A.

 

 

Table 1: Summary Statistics

VariablesMeanMedianModeMaximum ValueMinimum Value
Wage22.308119.3938.4576.394.33
Education13.761312216

 

Table 2: Calculations for Histogram – Wage rate

BinFrequencyCumulative %BinFrequencyCumulative %
153737.00%304343.00%
304380.00%153780.00%
451292.00%451292.00%
60698.00%60698.00%
75199.00%75199.00%
901100.00%901100.00%
More0100.00%More0100.00%

 

Table 3: Calculations for Histogram – Education

BinFrequencyCumulative %BinFrequencyCumulative %
622.00%185454.00%
124042.00%124094.00%
185496.00%24498.00%
244100.00%62100.00%
More0100.00%More0100.00%

 

  • Linear Regression Analysis

 

Linear regression is used to model the association between a dependent variable wage rate denoted by ‘y’ and an independent variable education denoted by ‘x’. Considering that only one independent variable is considered, such case is referred to as a simple linear regression. Values of slope (m), y-intercept, b, and correlation are presented in table 4. Besides, graphical representation of linear regression for wage rate and education is presented in Appendix A.

 

Table 4: Linear Regression Analysis

SLOPE (m)2.123756384
y-intercept, b-6.914787841
Correlation0.413051559

 

 

  • Calculation of Residuals

 

Regression statistics is presented in table 5. Residual values are included in table 6. Besides, residuals display how distant the actual data points are from the anticipated data points (by means of the equation). Residual values are plotted against the independent variable i.e. education and is presented in Appendix A.

 

 

Table 7: Quadratic Regression Analysis

SUMMARY OUTPUT
  
Regression Statistics
Multiple R0.413991
R Square0.171388
Adjusted R Square0.154303
Standard Error12.89436
Observations100

 

Table 8: ANOVA – Quadratic Regression Analysis

ANOVA     
 dfSSMSFSignificance F
Regression23335.8081667.90410.031630.00011
Residual9716127.66166.2646  
Total9919463.47

 

 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept-0.8770621.10524-0.041560.966938-42.7741.01099-42.76741.01099
X Variable 11.2494742.9384010.4252220.671616-4.587.081388-4.587.081388
X Variable 20.0304650.1010420.3015060.763674-0.170.231004-0.170.231004

 

  • Analysis of Histogram

 

Histogram for ln (wage rate) is constructed which is presented in Appendix A. Table 9 contains the calculations. 

 

Table 9: Calculations for Histogram – ln (wage rate)

BinFrequencyCumulative %BinFrequencyCumulative %
100.00%34848.00%
266.00%44492.00%
34854.00%2698.00%
44498.00%52100.00%
52100.00%10100.00%
More0100.00%More0100.00%

 

  • Log Linear Regression Analysis

 

Log-linear regression is estimated and table 10 and 11 contain the values obtained.

 

Table 10: Log Linear Regression Analysis

SUMMARY OUTPUT
  
Regression Statistics
Multiple R0.423907
R Square0.179697
Adjusted R Square0.171327
Standard Error0.544913
Observations100

 

Table 11: ANOVA – Log Linear Regression Analysis

ANOVA     
 dfSSMSFSignificance F
Regression16.3745136.37451321.468091.11E-05
Residual9829.099110.29693  
Total9935.47362

 

 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept1.650.2825.8526.45E-081.0892.2071.0892.207
X Variable 10.0930.024.6331.11E-050.0530.1330.0530.133

 

  1. Discussion

 

The slope ‘m’ obtained is positive. A positive slope expresses that there is a positive association between the two variables namely education and wage rate which means that when years of education increases, the wage rate also increases.

 

While plotting residuals against education, an obvious pattern has been observed. Since, the scatterplots show a pattern, the association may be nonlinear and the model will require to be altered correspondingly. Seeing that a pattern can be observed, there may be ‘heteroscedasticity’ in the errors. In other words, the variance of the residuals may not be uniform. An alteration of the predicted variable (for example, a logarithm or square root) may be needed so as to prevail over this issue.

 

While estimating quadratic regression, it has been observed that R Square equals 0.171, which is not a good fit. It indicates that 17% of the variation in wage rate is explained by the independent variable education. The Adjusted R Square value of 15% and p-value shows that the model is not a good fit for the data. The fact that the p-value both x variables is not near 0 also approves that the quadratic coefficient is not significant. This is more approved by seeing at the scatter diagram in Appendix A, which displays that the quadratic trend line is not a better bit for the data as compared to the linear trend line. The marginal effect of another year of education on wage for a person with 12 years of education, and for a person with 14 years of education is 14.99 and 17.49 respectively. However, considering the analysis of log-linear regression, the marginal effect of another year of education on wage for a person with 12 years of education, and for a person with 14 years of education is 1.12 and 1.3 respectively.

 

Both histograms of wage rate and ln (wage rate) have compared. Both display an example of data that are skewed to the right. Few greater values take the mean up but do not actually shake the median. Thus, the mean is larger than the median when data are skewed right.

 

  1. Recommendations

                                                               

It is recommended that government strategies should be set to upsurge registration in schooling. Well-organized management and checking of such program should be implemented so that the policy would survive to its bated breath. Besides, investments to both education as well as other learning activities should be backed by legislative bodies so that low wage workforces can simply make these investments to advance their economic happiness. Furthermore, it is recommended to increase the sample size so as to get a better picture. More advanced statistical and innovative data mining approaches should be considered to acquire more pertinent and precise results.

 

 

References

 

  • Psacharopoulos, G. (1993). Returns to Investment in Education. The World Bank, Working Papers 1067.

 

  • Psacharopoulos, G.(1994). Returns to Investment in Education: A Global Update. World Development 22(9): 1325-1343.