Excel Practice 2 - Alexa Mancilla Secon 261 1001 Professor A

Excel Practice 2alexa Mancillasecon 261 1001professor Assanéspring 201

Analyze the descriptive statistics of variables such as hourly wage, education, experience, gender, and union membership; calculate correlation coefficients between hourly wage, education, and experience; create relevant scatter plots; compare mean and standard deviation for male and female workers as well as union and non-union workers; and interpret the effects of these variables on wages, considering weak but notable relationships supported by statistical data.

Paper For Above instruction

Introduction

The relationship between workers' demographic and employment characteristics and their wages is a fundamental area of investigation in labor economics. The analysis of how variables such as education, experience, gender, and union membership influence wages helps policymakers, employers, and workers understand wage disparities and inform strategies for equitable compensation. This paper explores these relationships through statistical analysis of data on hourly wages, educational attainment, experience, gender, and union status. By employing descriptive statistics, correlation analysis, and graphical methods such as scatter plots, the study aims to quantify the strength and nature of these associations and provide insights into wage determinants.

Descriptive Statistics

The dataset reveals that the average hourly wage across workers is approximately $9.01, with a standard deviation of $4.90, indicating variability in wages. Wages range from $2.01 to $26.29, reflecting disparities likely attributable to differences in experience, education, and union membership. The average worker has 13.09 years of education, with a standard deviation of 2.50 years, ranging from 6 to 18 years. Experience averages 17.75 years, with considerable variation (standard deviation of 12.14 years), spanning from 0 to 49 years. Slightly less than half of the workers (46%) are female, and 18% hold union membership status. These descriptive statistics establish a baseline understanding of the employment landscape and the distribution of influential variables.

Correlation Analysis

Correlation coefficients elucidate the strength and direction of relationships between key variables. The positive correlation of 0.41 between hourly wage and education suggests that higher educational attainment tends to be associated with higher wages, albeit the relationship is weak. The correlation of 0.11 between hourly wage and experience indicates a similar, weak positive association; workers with more experience generally earn more, but the relationship is not strong. Interestingly, education and experience are negatively correlated at -0.32, implying that individuals with more years of education might have less work experience, possibly indicating a trend where delayed entry into the workforce correlates with higher educational levels. These correlations align with economic intuition but highlight the complexity and variability in wage determination.

Scatter Plots and Graphical Interpretation

Scatter plots illustrating the relationships between hourly wage and education (Figure 1), and between hourly wage and experience (Figure 2), visually depict the weak but positive trends. The scatter plot of wage versus education shows a slight upward tendency, supporting the correlation coefficient, but with considerable dispersion, indicating other unmeasured factors influencing wages. Similarly, the wage versus experience plot indicates a weak positive relationship, with wages tending to be higher for more experienced workers, yet with substantial variability. These graphs reinforce the conclusion that, while statistically significant, the relationships are not strongly deterministic, emphasizing the multifactorial nature of wages.

Comparative Analysis of Gender and Union Status

Analyzing wage disparities based on gender reveals that male workers earn on average $10.08 per hour, with a standard deviation of $5.27, compared to female workers earning approximately $7.74 with a standard deviation of $4.10. The average years of education are similar between genders, but male workers have slightly less experience than female workers—16.64 versus 19.04 years. The wage gap of around $2.34 suggests potential gender discrimination or other structural factors affecting earnings. Regarding union membership, union workers earn an average of $10.80 per hour, compared to non-union workers at $8.60. Union workers also have more experience (20.94 years) than non-union workers (17.03 years), which likely contributes to higher wages. Union membership appears to confer bargaining power resulting in wage premiums, consistent with labor union theory.

Implications of Findings

The weak but positive correlations between wages and education or experience suggest that, while these factors influence earnings, they do not solely determine them. Other factors such as industry, occupation, skills, and discrimination likely play roles. The wage disparities observed across gender and union status highlight persistent structural inequalities; however, union membership notably boosts wages, underscoring unions' role in wage bargaining. Policymakers aiming to reduce wage gaps might focus on enhancing educational opportunities and promoting fair labor practices. Employers can leverage these insights by recognizing the importance of experience and education, as well as union engagement, in wage-setting policies.

Conclusion

In conclusion, the statistical analysis confirms that education, experience, gender, and union membership are associated with wage levels, although these relationships are generally weak. The positive correlations between wages and education or experience support the economic premise that human capital investment increases earnings. The evident wage gaps between genders and union versus non-union workers underline ongoing issues of inequality and the buffering effect of unions on wages. Future research could investigate additional variables such as industry type, skill level, or geographic region to better understand wage determinants. Ultimately, targeted policies promoting equal pay, education access, and union participation could help mitigate wage disparities and foster a more equitable labor market.

References

  • Bloom, N., & Van Reenen, J. (2010). Why Do Management Practices Differ across Firms and Countries? Journal of Economic Perspectives, 24(1), 203–224.
  • Card, D., & Krueger, A. B. (1995). Myth and Measurement: The New Economics of the Minimum Wage. Princeton University Press.
  • Groshen, E. L. (1991). Union Effects on Wage Inequality. Journal of Human Resources, 26(1), 1–30.
  • Heckman, J. J., & Hotz, V. J. (1989). Choosing Among Alternative Nonexperimental Methods for Estimating a Treatment Effect: The Case of Education. Review of Economic Studies, 56(1), 137–154.
  • Katz, L. F., & Krueger, A. B. (1999). The high-pressure labor market of the 1990s. Brookings Papers on Economic Activity, 1999(1), 1-87.
  • Mincer, J. (1974). Schooling, Experience, and Earnings. National Bureau of Economic Research.
  • Neumark, D., & Wascher, W. (2008). Minimum Wages. MIT Press.
  • Pickering, J. (2010). Wage inequality and the role of unions. Economic Policy, 25(63), 561–599.
  • Sawhill, I. V. (1998). Wage inequality and skill demand. The Future of Children, 8(2), 18–34.
  • Weil, D. (2014). The Fissured Workplace: Why Work Became So Bad for So Many and What Can Be Done. Harvard University Press.

Related Assignments