Week 6 Homework: Fresh Market

22/SU MBA*546*COBA Business Analytics I Week 6 (June 13-19) Week 6 Homework: Fresh Market X 22/SU MBA*546*COBA A Week 6 Homework: Fresh Market Business Analytics I Start Here 18 Calendar Week 6 Homework Overview and Tasks A Grades Fresh Market is a small grocery chain in New Zealand. A former employee has gone to the press and told them that Fresh Market pays its female employees less than the male employees: particularly, female junior managers make less than male junior managers. Announcements You are consulting for Fresh Market. Senior management and the head of human resources are shocked by the accusation, since they have had non-discrimination policies in place for years. They give you the data that they believe the former employee had access to, and Instructor ask you to analyze it and uncover whether there is any validity to the former employee's claims. Syllabus You decide to approach the problem in the following way: . Obtain summary statistics about salary, for men and women separately; do the men indeed earn more than the women? Resources . You should find that on average, the men are paid around $3,000 more than the women; this is the claim the former employee made. Discussion Board o You have racial classifications as well: White, Maori, or Pacific Islander. You should obtain summary statistics broken down by race also. Zoom Meeting . Build a regression model for salary using the data given: Institutional Resources o Salary is measured in thousands of dollars. o Age and Experience are measured in years. Course Tools o HighSchool, College are Y (1) if the junior manager completed High School or College respectively, N (0) otherwise. E o Race and Gender are categorical variables Learning Tools o DexScore is a measure of manual dexterity that forms part of an on-boarding test for the employees. . You should find that Gender is not significant in your regression; that is, Gender is not useful for predicting salary, taking into account the other variables in the model. Course Material o You need to reconcile these two pieces of information: men are paid more than women on average, but gender is not a Week 1 (Mav 9-15) significant predictor of salary.Zoom Meeting . Build a regression model for salary using the data given: X Institutional Resources . Salary is measured in thousands of dollars. o Age and Experience are measured in years. Course Tools o HighSchool, College are Y (1) if the junior manager completed High School or College respectively, N (0) otherwise. o Race and Gender are categorical variables Learning Tools o DexScore is a measure of manual dexterity that forms part of an on-boarding test for the employees. . You should find that Gender is not significant in your regression; that is, Gender is not useful for predicting salary, taking into account the other variables in the model. Course Material o You need to reconcile these two pieces of information: men are paid more than women on average, but gender is not a significant predictor of salary. 8 Week 1 (May 9-15) o Hint: are men and women identical in your data, or is there some observable difference between the men and women that Week 2 (May 16-22) explains the observed difference in salary. Week 3 (May 23-29) As always, write up your process and findings as a case report. Week 4 (May 30-June 5) . Be very clear in your Executive Summary about what upper management needs to know. Does it seem that Fresh Market is discriminating, or does some other factor explain the former employee's claims. Week 5 (June 6-12) Submit your homework by 11:59pm Sunday night! Week 6 (June 13-19) Week 7 (June 20-26) Fresh Market Salary data Week 6 Case Report Upload your Week 6 case report here