本次澳洲代写主要为商业统计的assignment
问题描述：
在运作良好的劳动力市场上，具有同等生产属性（例如，受教育程度，工作经验）的个人应得到同等报酬。因此，具有相似生产特征的个人的公私薪资差距的存在对劳动力市场的效率和公平具有影响。例如，这意味着公共部门的雇员要以纳税人的代价来收取租金，而私营部门的活动可能会被挤出，因为留住雇员变得越来越困难。
您已被澳大利亚生产力委员会任命来分析澳大利亚公私部门的薪酬差距。数据摘自2017年HILDA（澳大利亚家庭，收入和劳动力动态）调查。使用您当前在“商业统计”课程中学习的工具，向委员会提供对公私薪资差距的分析。您可以假设委员会成员对基本统计数据有很好的理解。此外，委员会希望您准备一份部长简介，以向就业，技术，小型和家族企业部长说明您的分析结果。
此任务分为两部分，下面分别详细介绍：
A部分（3 + 2 + 3 + 3.5 + 3.5 + 3 + 3.5 + 2.5 = 24分；专业报告= 8分）
在CANVAS上找到数据文件（AssignmentBusStats.xls）。在相关时使用5％的显着性水平和95％的置信度。
仅针对此问题，重点关注公共部门雇员的可变工资：如几次讲座所示，有两种不同的方法可以使用Excel计算汇总或描述性统计数据。该问题要求您同时使用“首次使用Excel数据分析工具包”（描述性统计信息选项）来计算和解释汇总统计信息。其次，使用Excel计算报告中记录的所有描述性统计数据。这些计算应在Excel中仔细进行布局，并且不应使用任何固定的Excel统计功能，例如平均，中位数，模式，STDEV等。您可以使用Excel排序命令，sum命令以及任何其他非统计excel命令。
对私营部门雇员的可变工资重复上述步骤1。
分别绘制公共部门和私营部门雇员的工资分布的直方图。仔细解释图形。
公共部门和私营部门的雇员在人口统计学和社会经济特征上的主要区别是什么？用适当的表格/图表帮助您回答。
提出一种统计方法来分别估计所有公共部门雇员和所有私营部门雇员的平均小时工资率。清楚地标记您的图表并指出所做的任何假设并仔细解释。
媒体报道称，2017年澳大利亚所有公共部门雇员的平均小时工资为49澳元。你同意？以5％的显着性水平执行假设检验。清楚地标记您的图表并指出所做的任何假设。仔细解释您的决策中是否有潜在错误。
由于数据文件（AssignmentBusStats.xls）表明公共部门的平均小时工资率较高，因此研究人员得出结论，人口的平均小时工资率在两个部门之间不相等。你同意？提出一种统计方法，以检查公共部门和私营部门的人口平均小时工资率是否相等。明确指出所做的任何假设。
部长是否应该担心公共部门的人口平均小时工资率更高？
Problem Description:
In a well-functioning labor market, individuals with same productive attributes (e.g. education attainment, working experience) should be equally paid. The existence of public-private pay gap for individuals with similar productive characteristics thus has implications for efficiency and equity in the labour market. For instance, this implies that employees in the public sector receive rents at the cost of tax payers, and the private sector activities may be crowded out as it becomes hard to retain employees.
You have been appointed by the Australian Productivity Commission to analyse the public-private pay gap in Australia. The data are drawn from the 2017 HILDA (Household, Income and Labour Dynamics in Australia) survey. Using the tools learned in your current Business Statistics course provide the Commission with an analysis of the public-private pay gap. You may assume the Commission members have a good understanding of basic statistics. In addition, the Commission would like you to prepare a ministerial brief to illustrate the key findings of your analysis to the Minister for Employment, Skills, Small and Family Business.
There are two parts to this assignment, each described in detail below:
Part A (3 + 2 + 3 + 3.5 + 3.5 + 3 + 3.5 + 2.5 = 24 marks; professional report = 8 marks)
Locate the data file (AssignmentBusStats.xls) on CANVAS. Use the 5% significance level and the 95% confidence level where relevant.
- Focusing on the variable wage for the public sector employees only for this question: as shown in several lectures there are two distinct methods of calculating summary or descriptive statistics using Excel. This question requires you to use both First use Excel Data Analysis Tool Pack (the descriptive statistics option) to calculate and interpret the summary statistics. Second use Excel to calculate all descriptive statistics documented in your report. These calculations should be carefully laid out in Excel and should NOT use any hard-wired Excel statistical functions e.g. Average, Median, Mode, STDEV et al. You can use the Excel sort command, the sum command, and any other non-statistical excel commands.
- Repeat step 1 above for the variable wage for the private sector employees.
- Draw a histogram of the wage distribution for the public and private sector employees respectively. Interpret the graphs carefully.
- What are the main differences in demographic and social-economic characteristics between employees in the public and private sector? Aid your answer with appropriate tables/graphs.
- Propose a statistical method to estimate the mean hourly wage rate for all public sector employees and all private sector employees, respectively. Clearly label your diagram and indicate any assumptions made and explain carefully.
- A media report claims that the mean hourly wage rate for all public sector employees in Australia in 2017 was 49 AU$. Do you agree? Perform a hypothesis test at the 5% significance level. Clearly label your diagram and indicate any assumptions made. Explain carefully if any potential errors in your decision making.
- Since the data file (AssignmentBusStats.xls) suggests a higher mean hourly wage rate in the public sector, a researcher hence concludes that the population mean hourly wage rates are not equal between two sectors. Do you agree? Propose a statistical method to examine if the population mean hourly wage rates are equal for the public and private sector. Clearly indicate any assumptions made.
- Should the Minister be concerned if the population mean hourly wage rate is higher in the public sector?