General Information: The objective of this project is to analyse the provided young employee's information in Tasmania and to discuss issues related to relationships between employee's wages and abilities, etc. You need to work in a group (no groups of more than FOUR members will be permitted) to complete the assignment. You will need to complete the assignment group work sheet (available on Moodle) and atmch no your assignment, For a group submission, each student in the group needs to write a brief statement of his/her contribution on the cover sheet, All students must sign this work sheet if you workin a group. It is NOT acceptable for one student to sign for all group members. An electronic copy of the assignment needs to be submitted to the Assignment Folder on Moodle on Monday 3rd October at 5.00pm. You will be required to use appropriate technique or method to evaluate or to present data, DO NOT use every technique you can think of as this only shows that you do not understand what is required. Use the most appropriate, although you should also remember that different rechniques/uests/graphs may provide you with different types of information Use your judgement carefully Use Microsoft Excel to generate graphs and calculate numerical measures for describing random variables. Your explanations must be clear, concise and complete. Wherever calculation is required, please show your work in detail as partial marks are given so each step. Ensure that you analyse data thoroughly and present results carefully. Make sure that you interpret results in the context of the initial problun in order no show your understanding. You can also make recommendations about further research that should be conducted in order to provide a better answer. All mbles and diagrams should be accurately labelled and referenced and referred to in the text. It is recommended that you type your assignment using a computer. A hand-written assignment can be accepted only if it is legible and easy to follow. However, all of tables/ graphs/ estimation results must be printed. All hypothesis tests must be performed at the 5% level of signicance Students are NOT allowed to directly use the test function in MS Excel to conduct hypothesis tests, All hypothesis tests must follow the structure below: 1. State the null and alternative hypotheses. . Show how to construct the test statistic and what the distribution is under the null hypothesis . Calculate the test statistic. . State the signicance level of the test. Australian National Institute of Management ll and Commerce 5. State the rejection rule 6. State the conclusion of test expressed in terms of the aim of the test. Please note that teaching staff may provide advice but are not responsible for resolving personal difficulties you may have when working with peers. mm You should be aware that assignments will be checked for plagiarism. Plagian'sm is punishable by reduction or cancellation of marks, and in the most serious cases, exclusion trom a unit, a course or the University. This warning applies to a case where a student submits somebody else's work as their own, AND to a student who willingly allows another to copy and submit their work I expect your plagiarism match with any source (interact or other groups) to be less than 15%. Plagiarism policy is described in the TSTA602 unit outline. 5].. in E .. Submit your assignment including a cover sheet through TURNIT'IN found on Moodle under the rMajor Assignment' icon. The electronic copy must have signed cover sheet with name and student ID on the Cover Sheet. Please remember that you are responsible for lodging the assignment on or before the due date. If you have problems submitting your assignment; you MUST contact your lecturer immediately explaining the situation by email and attach your assignment in the email before the due time. In your email, you must clearly identify in the title of your email that you experiencing n problem in TSTA602 Quantitative Methods for Accounting and Finance. In the body of the email, explain the specic problem. The late assessment and Extension Policy applies. Please refer to this policy in the Unit Outline. Australian National Institute of Management ll and Commerce DATA DESCRIPTION (A FICTITIO gs DATASET DESIQE ED FOR THE ASSIQEMEN 1 051.21 A consulting rm randomly selected 150 young employees in Tasmania. These selected employees answered questions and undertook a standard IQ test and a KW test. The KW test examines respondents' knowledge about the duties in their workplaces and the knowledge about the Australian and Tasmanian labour markets. Respondents' answers are entered a spreadsheet where each column represents a variable. These variables include: 1. wage: monthly earnings in dollars 2. hours: average weekly working hours 3. IQ: IQ score 4. KW: knowledge of work score 5. educ: years of education 6. exper: years of work experience 7. tenure: years with the current employer 8. age: age in years 9. marriage: marriage status 10. gender: female or male ill urban: =Y if lives in urban areas =N if lives in rural areas 12. sibs: the number of siblings 13r brthord: birth order, ergr =2 means he/she is the second ehildin the family. 14. meduc: mother's education 15. feduc: father's education The missing values are shown by a \"l\" in the cells Australian National Institute of Management ll and Commerce Questions: 1. Read the provided raw data carefully to check whether all respondents have provided information for each variable. Explain what you have done to manage the missing data. Clearly indicate the nal number of observations (respondents) you will use in the following analysis. Submit an electronic copy of the Excel spreadsheet of the final dataset together with your assignment. All your following analysis should be based on this nal dataset. [10 marks] . Pick up two numerical variables and two categorical variables and then desctibe each of them one by one. Use appropriate tables/graphs and numerical measures to help you describe the distribution of the variables. [10 marks] It's often asked what factors relate to IQ score and KW score. Look through your data and rst pick up one numerical variable that you think may relate to IQ score. Explain why you pick up this van'able. Then use an appropriate graph and an appropriate numerical measure to discuss the empirical relationship between IQ score and this numerical variable. Repeat the same exercise for the relationship between KW score and a numerical variable to which you think Kwrnay relate. [15 marks] l You want to look at the relationship between gender and wages. However, you notice that gender is a categorical variable and wage is a numerical variable One way to work on two different types of variables is to transform one variable to the type of the other. You decide to generate a categorical variable based on the level of wage, and this categorical variable has two values, \"high\" and \"low". For example, you choose a threshold value for wage, and if a respondent's wage is no less than the threshold value, you enter \"high\" and enter \"low" otherwise, Describe in detail how you have decided the threshold value for generating the new categorical variable for the level of wage Then use an appropriate graph to present this variable (Hint: you may choose to use an appropn'ate numerical measure of wage as the threshold value). [6 marks] Australian National Institute of Management II and Commerce . Present these two categorical variables together using an appropriate graph, and then discuss what the graph shows [4 marks] Produce a contingency table to present these two categorical variables Based on the contingency table, calculate the related (empiiical) joint and marginal probabilities You may nd helpful to produce another contingency table to show your calculated probabilities. (Hint: you may need Excel skills -- e,g, use the commands such as \"sort\" or \"countit\" to count the relevant frequencies, or use PivotTable function) [8 marks] . Based on the sample information, calculate the probability of either being a female or getting a low wage level, and calculate the probability of being a female conditional on getting a low wage level [5 marks] Examine whether the statement \"Males tend to receive high wages than females" is true, false or inconlusive based on the sample information Explain your response. [5 marks] [Total Marks 23] Suppose that the population average of (monthly) wage of young employees in Tasmania in the previous year before this survey was conducted was $900. Conduct a hypothesis test that the population average wage of young employees in Tasmania during the year of survey remains the same as in the previous year, [7 marks] . Construct a 95% condence estimate for the population average wage, and comment whether the population average wage in the year of survey remains the same as in the previous year. [Smarks] [Total Maths 12] Australian National Institute of Management ll and Commerce 6. You want to use the collected data to study what is the most important factor that affects young employees wage in Tasmania. Use simple regression analysis to answer the following questions, (For each regression you run, show the Excel regression output and report the regression equation Partial marks from the following questions assign to your regression results). Do the years of education have signicant impact on the wages? (You need to explain the choice of the null and the alternative hypotheses.) [5 marks] i Do the IQ scores have signicant impact on the wages? (You need to explain the choice of the null and the alternative hypotheses) [5 marks] Which of the two variables is a better predictor for the wage, years of education or IQ scores? Explain why, [3 marks] . Do the years of work experience have signicant impact on the wages? (You need to explain the choice of the null and the alternative hypotheses. [3 marks] Do the KW scores have signicant impact on the wages? (You need to explain the choice of the null and the alternative hypotheses.) [3 marks] Which of the two variables is a better predictor for the wages, years ofwotk experience or KW scores? Explain why. [3 marks] i Newspapers often criticize a weak link between wage and education comparing with the link between wage and work experience. Discuss if the criticism is consistmt with our data, [3 marks] [Total Marks 25] The end of question Australian National Institute of Management ll and Commerce Marking Rubric Organisation of No clear hierarchy of Some solutions backed arguments and /20 Adequate solutions Well-presented arguments or solutions Exceptionally well- by arguments presented Assessment Criteria and Performance Standards for Report solutions presented backed by provided but not particularly clear well-presented arguments and rgued solutions- solutions- will lead to clear, concise and or relevant arguments Performance Standard relevant resolutions particularly insightful Unacceptable level of Acceptable level of Acceptable level of achievement - High level of Exceptional - achievement - some achievement - meets 0 - 1 Mark chievement - displays the 5 minimal or n minimal evidence of minimal requirements displays the application of Writing style & Very poor Low levels of Average levels of High level of Very high level of evidence of understanding of application of professional and grammar /10 grammatical writing ability writing ability expression and writing ability - understanding of industry standards evident, simple with some writing ability with theory professional & clear concise theory to a very high level spelling errors no grammatical or industry standards structural expression with spelling and expression with ssues in many spelling and grammatical ew grammatical or spelling errors. Report 0 -1 4 5 grammatical errors spelling context and No real evidence of Some minimal evidence Written errors problem Adequate evidence of High level of ability of Very high level of material inaccuracies understanding the case of understanding the understanding the case identification understanding the understanding the case /10 study within the context case study within the study within the within the context of a study within the Detailed Comments of a body of knowledge context of a body of ontext of a body of body of knowledge or ontext of a body of Total Marks /100 or the principal issues (these might be directly owledge or the cipal issues knowledge or the the princip knowledge or the and Feedback written on the hard requiring solutions principal issues principal issues requiring solutions principal issues copy or electronic copy equiring solutions equiring solutions equiring solutions Areas of 0- 1 improvement Depth of No real evidence of research Some minimal Adequate evidence /20 High level of research - Very high level of research underpinning evidence of research of appropriate goes beyond prescribed research - goes the case study research. readings beyond prescribed readings and applied 0-1 Analysis & 2 synthesis Very little or no Some understanding of /40 Adequate evidence of Good understanding Very high level of evidence of the topic evident but ability to comprehend of the topic with understanding of the with little evidence of understanding with case study discussion evidence of deep topic analysis insightful evaluation and facts, leading to analysis and synthesis comments and research. of information conclusions 0- 1 IMC Australian National risticute of Management MC Australian National and Commerce istitute of Management and Commerce