ECON 1030 – BUSINESS STATISTICS 1: Group Assignment Instructions: This is a group assignment with groups officially registered on canvas - the maximum group size is three. All group members must be...

1 answer below »
This is both a descriptive statistics and hypothesis testing assignment.


ECON 1030 – BUSINESS STATISTICS 1: Group Assignment Instructions: This is a group assignment with groups officially registered on canvas - the maximum group size is three. All group members must be enrolled in the same tutorial class (i.e. day, time and tutor). There are two parts to this assignment: Part A: Report to the Australian Productivity Commission. Part B: a ministerial brief to the Minister for Employment, Skills, Small and Family Business. This assignment is worth 40 marks. The allocation of marks is as follows: Part A 32 Statistical Analysis (including excel) 24 Professional Report 8 Part B 8 Total 40 The response to Part A must be provided in the form of a professional report with no more than 10 pages (excluding cover page). The structure of your professional report must include: 1] A Title, 2] An Executive Summary, 3] An Introduction, 4] Analysis and 5] Conclusions. The response to Part B must be provided in the form of a ministerial brief with no more than 200 words and 3 graphs. You must submit an electronic copy of your assignment on Canvas. See the attached Template of your submission for more details. Only one submission is required per group. Hard copies will not be accepted. It is very important that you submit an assignment cover sheet with all the group members’ signatures/names at the time of submission. If any dispute arises on your contribution to the group work, the cover sheet will be used as evidence of contribution. Each group is required to submit the following four documents in order: a) cover sheet; b) report; c) a ministerial brief; d) excel file. This assignment requires the use of Microsoft Excel. If you have Windows, you will need to use the Data Analysis Tool Pack. If you have a Mac with Excel 2011, you may need to use StatPlus:MAC LE. You will need to include your Excel output as an excel file submitted with your report. The excel file needs to be clear and carefully organised and must show all workings underlying the Professional report and associated statistical analysis. It will be treated as an appendix to your report, i.e. not included in the page count. Do not refer to the excel workbook within the Professional report. You will need to take the results from your excel workbook and incorporate into your report. Presentation Instructions: Your written professional report should comply with the following presentation standards: 1. Typed using a standard professional font type (e.g. Times Roman), 12-point font size. 2. 1.5-line spacing, numbered pages, and clear use of titles and section headings. 3. Delivered as a Word (.doc or .docx) or PDF (.pdf) file. 4. Checked for spelling, typographical and grammatical errors. Where relevant, round to 3 decimal places. 5. With all relevant tables and charts, the report should be no more than 10 pages long. 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. 1. 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 methods. 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. 2. Repeat step 1 above for the variable wage for the private sector employees. 3. Draw a histogram of the wage distribution for the public and private sector employees respectively. Interpret the graphs carefully. 4. 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. 5. 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. 6. 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. 7. 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. 8. Should the Minister be concerned if the population mean hourly wage rate is higher in the public sector? Part B: Write a ministerial brief of no more than 200 words containing no more than 3 graphs on the public-private pay gap in Australia and any other interesting findings that would be of policy relevance to the Minister. Draw on the relevant evidence you have gathered from Part A, as well as other information/evidence not covered here but you believe is useful. Your brief should summarize your results from part A in a non-technical way and provide relevant conclusions (8 marks).
Answered Same DayMay 09, 2021ECON1030

Answer To: ECON 1030 – BUSINESS STATISTICS 1: Group Assignment Instructions: This is a group assignment with...

Subhanbasha answered on May 10 2021
138 Votes
BUSINESS STATISTICS
PART - A
Introduction:
    The statistical analysis will help us to take the valid decision of the data provided by the any organization. So, it can be easy to ta
ckle the problem in the organization what is needed. And we can get the single shot of any feature of the organization. The analysis consisting of measures and graphs these also will helpful to identify the pattern of the data by visually.
Analysis:
We found the descriptive statistics of private age and public age by the analysis tool pack which is present in the excel the results as follows
1.
Ans:
Public:
    wage
    
    
    Mean
    43.73814837
    Standard Error
    1.58986838
    Median
    41.29583
    Mode
    50
    Standard Deviation
    14.74383282
    Sample Variance
    217.3806062
    Kurtosis
    1.460297716
    Skewness
    0.893772364
    Range
    78.38125
    Minimum
    20.59375
    Maximum
    98.975
    Sum
    3761.48076
    Count
    86

Manual calculation:
    Mean
    43.73815
    Standard Error
    23.44075
    Median
    41.29583
    Mode
    50
    Standard Deviation
    14.74383
    Sample Variance
    217.3806
    Kurtosis
    4.257711
    Skewness
    0.872987
    Range
    78.38125
    Minimum
    20.59375
    Maximum
    98.975
    Sum
    3761.481
    Count
    86
2.
Ans:
Private:
    wage
    
    
    Mean
    37.50266
    Standard Error
    1.724434
    Median
    32.42105
    Mode
    27.16667
    Standard Deviation
    19.88714
    Sample Variance
    395.4984
    Kurtosis
    1.503935
    Skewness
    1.263652
    Range
    97.57237
    Minimum
    3.009027
    Maximum
    100.5814
    Sum
    4987.854
    Count
    133
Manual calculation:
    Mean
    37.50266
    Standard Error
    1.724434
    Median
    32.42105
    Mode
    27.16667
    Standard Deviation
    11.23892
    Sample Variance
    126.3134
    Kurtosis
    42.84325
    Skewness
    6.844039
    Range
    97.57237
    Minimum
    3.009027
    Maximum
    100.5814
    Sum
    4987.854
    Count
    133
3.
Ans: For public...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here