instruction in file

Assignment 6 – Overall Instruction 1 Assignment 6: Assessing Pay Discrimination (60 points) Due: by 11:59 pm , Sun day, April 18th, 20 21 * No assignments will be accepted afterward without written documentation of an unavoidable or unforeseeable event. Why this assignment? This assignment is intended to achieve the goal of our Module 11 learning objective, ^ Assess pay discrimination withi n an organization by analyzing data and mak e further suggestions . _ Prerequisite knowledge and skills In this assignment, you will be assessing whether ther e is pay discrimination within an organization in terms of race . To do this, you [ll first n eed to watch the video Pay Discrimination in Module 1 1. This video will be the only example given out for this assignment. All the information you need to do this assignment is in this video. If you can analyze the data in the example dataset that was provided with the video, and if you are getting the same results as the results in the video, you will be able to complete this assignment without a problem. To do this assignment, you [ll need to conduct linear regression analyses. All the information that you ne ed to conduct a simple linear regression analysis is in the v ideo Simple Linear Regression Refresher in Module 6. And all the information that you need to conduc t a multiple linear regression analysis is in the video Multiple Linear Regression Refresher in Module 10 . Yo u also have done Assignment 5: Multiple Linear Regression Refresher for this. Instruction Imagine that you are an HR manager at the law firm Yoon & Comp. The partners in the law firm want to make sure that the pay practice o f Yoon & Comp is race -neutral. So, the partners have asked you to analyze the pay data of the employees working at the firm. In particular, the partners have asked you to examin e if the non -White employees are paid less than the White employees . Analyze th e data (attached Excel file ) and write a report to the partners of Yoon & Comp. Based on your data analysis results, please state your opinion about whether the pay practice in this la w firm is race -neutral or not. If a clear judgment cannot be made based on your data analysis results, please suggest further actions that need to be take n to make a clear judgment of whether the pay of the firm is race -neutral. Please follow the b elow steps in doing this assignment. Step 1. Con duct a simple linear regression analysis and investigate whether there is a raw difference in the salary level between White and non -White employees. (10 points) Step 2. If there is a raw difference in the salary level between White and non -White employees, conduct a serie s of multiple linear regression analyses to identify the reason (s) for this difference . (30 points) Step 3. Based on the data analysis results, state your opinion and make suggestions to the Assignment 6 – Overall Instruction 2 partners of Yoon & comp. Make sure that your opinion and suggestions are supported by your data analysis results . (20 points) Important Note s 1. Do not turn in the Excel file that you have analyzed . You are making a report that the executives (or par tners) of the firm will read. However, make tables or figures (that are easy to read ) to show your data analysis results and have it as an appendi x. Without this appendix, you will not receive full credit for Steps 1 and 2. There is no page limit for this assignment. But try to write the report within a page (excluding the appendix). Executives will normally not have the time to read a long report . 2. In writing your answers, NEVER copy -and -paste any part of the textbook or any other sources . Write the an swers in your own words. If more than seven consecutive words are identical to a writing in another source (including the textbook , your past assignm ents, and any other sources), it will be considered as plagiarism, and you will receive 0 points for this a ssignment. You will also be referred to Students Affairs. 3. I change the numbers on the dataset every semester. So, do not copy -and -paste the answe rs from the assignments that w ere given out in this course in the past . In the case of your answers being t he same as the answers in the past, it will be regarded as plagiarism and behavior that violates the ‘ . Ethics [ category of the professional etiquette outlined on page 5 of our syllabus. In this case, you will receive a failing grade ^F _ in this course an d be referred to Students Affairs. . In Excel, ‘E [ is often used to indicate a very small decimal number. For example, 2.37E -20 is not 2.37. 2.37E -20 is 0.0000000000000000000237 . How to interpret ‘E [ was explained in the video Simple Linear Regression Re fresher in Module 6 (in a yellow box from runtime 23:14 to 23:42). 5. See Appendix for the grading rubric. Assignment 6 – Grad ing Rubric 3 Appendix . Grading Rubric Steps Grading Standard Point(s) Step 1 (10 point s) The raw salary difference between White and non -White employees is estimated through conducting a simple linear regression analysis without an error . 10 The raw salary difference between White and non -White employees is estimated. However, EITHER the difference was NOT estimated through conducting a simple linear regress ion analysis OR some errors can be found in the estimation process. 7 The raw salary difference between White and non -White employees is estimated. However, NEITHER the difference was estimated through conducting a simple linear regression analysis NOR t he estimation process is without an error. 4 The raw salary difference between White and non -White employees is NOT estimated. 0 Step 2 (30 points) The reason for the race pay gap is correctly identified through a series of multiple linear regression an alyses without an error . 30 The reason for the race pay gap is correctly identified . However, EITHER the gap is NOT identified through a series of multiple linear regression analyses OR some errors can be found in the identification process. 20 The rea son for the race pay gap is correctly identified . However, NEITHER the gap is identified through a series of multiple linear regression analyses , NOR the identification process is without an error. 10 The reason for the race pay gap is NOT correctly iden tified . 0 Step 3 (20 points) A suggestion is logical and is made based on the analysis results in Step 2 . 20 A suggestion is made . However, EITHER the suggestion is NOT logical OR the suggestion is NOT based on the analysis results in Step 2. 14 A sug gestion is made . However, NEITHER the suggestion is logical , NOR the suggestion is based on the analysis results in Step 2. 7 A suggestion is NOT made . 0