ECON1030-Business Statistics Report Writing – Statistics Assignment Help

Task

Problem Description:

This is a further analysis of the gender pay gap in the Australian population. According to a recent report by KPMG Consulting, gender discrimination continues to be the single largest factor contributing to the gender pay gap (KPMG, 2019). In order to estimate the extent of discrimination in the job market where women with identical labour market characteristics as their male counterparts receive different wages, you will estimate a set of linear regression models.

Since this is an additional analysis on the gender pay gap, the content in the Introduction section of your report may overlap with the one in the Group Assignment. However, you are encouraged to develop/source new background materials. You will use the same dataset as in Assignment 2. The data are drawn from the 2019 Household, Income and Labour Dynamics in Australia (HILDA) survey. The sample used for analysis comprises 1099 full-time Australian workers in the age group 20-74. The dataset contains the following information:

1. Worker’s earnings: weekly earnings in 1000 AU dollars of full-time workers. [note the unit of measurement].

2. Gender: the dummy variable male = 1 if the individual is a male, and = 0 for a female.

3. Educational attainment: the dummy variable degree = 1 if the individual has a bachelor degree or higher qualification, and = 0 for lower than degree qualifications.

4. Skill level: the dummy variable skill = 1 if the individual is highly skilled, and = 0 if not highly skilled.

5. Experience: number of years of work experience.

Locate the data file (IndividualBusStats.xls) on CANVAS.

1. Before estimating the regression equation, conduct a preliminary analysis of the relationship between workers’ earnings and 1) gender; 2) educational attainment; 3) skill level; and 4) experience. Use tables and/or appropriate graphs for the categorical variables (male, degree, skill) and the numerical variable (experience). Interpret your findings by answering the following questions: how much more/less does a male worker earn compared to a female worker? how much more/less does a degree holder earn versus a non degree holder? How much more/less does a highly skilled worker earn versus a worker who is not highly skilled? What kind of relationship do you observe between workers’ earnings and experience? (5 marks)

2. Use a simple linear regression to estimate the relationship between workers’ earnings and gender (Model A). You may use the Data Analysis Tool Pack. Based on the Excel regression output, first write down the estimated regression equation and interpret the slope coefficient. Carry out any relevant two-tailed hypothesis test of the slope coefficient using the critical value approach, at the 5% significance level, showing the step by step workings/diagram in your report. Interpret your hypothesis test results. (6 marks)

3. Now use a multiple regression model to explore the relationship of workers’ earnings with gender, educational attainment, skill level, and experience (Model B). You may use Data Analysis Tool Pack for this. Based on the Excel regression output, first write down the estimated regression equation and interpret carefully the slope coefficients. Carry out any relevant two-tailed hypothesis tests for each individual slope coefficient using the p-value approach, at the 5% significance level. Carry out an overall significance test using the p-value approach. Carefully interpret your hypothesis test results. (9 marks)

4. Interpret the R-squared in Model A and adjusted R-squared in Model B. Which one is a better model? Explain why, relating your answer to the interpretations. (2 marks)

5. Compare the coefficients of male in Model A and Model B. Explain carefully why the results are different, relating your discussion to gender discrimination. (5 marks)

6. Predict the earnings of a male worker who has a university degree, is highly skilled and has 15 years of work experience. Next, predict the earnings of a female worker with the same characteristics. (2 marks)

7. If you could request additional data to study the factors that influence workers’ earnings, what extra variables would you request? Discuss two such variables, explaining why you choose them and how each of your proposed variables could be measured in the regression model. [You could draw evidence from journal articles, newspapers, etc]

This ECON1030-Statistics Assignment has been solved by our Statistics Expert at TV Assignment Help. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.