PROBLEM 4 (50 points): As a data analyst working in a marketing firm (BestFirmNYC), you were assigned to investigate some important performance related issues among sales employees in your company. To conduct your analyses, use SPSS and the Excel dataset called BestFirmNYC. This dataset includes the following variables that were collected from the sales employees:

1. Access to relevant information (regarding tasks and projects).
2. Years of service (how long employed at your company)
3. Peer support
4. Intention to quit
5. Employee performance in 2019
6. Employee performance in 2022
7. Employees working from home = 1; Employees working from the office = 2
8. Gender (women = 1; men =2)
9. Annual salary

Use statistical tests to answer the following questions. For full credit, make sure to copy and paste your SPSS output in your answers (word document).

1. Women sales employees have complained that they are paid less than men for doing the same job. Is there a statistically significant difference in pay between men and women employees at your company? Briefly explain the results.
2. Your VP of Sales worries that sales employees who decided to work from home could become more likely to quit. Is there a statistically significant difference in intention to quit between sales employees who work from home and the employees who work in the office? Briefly explain the results.
3. In 2020, your company installed an expensive new computer system for your sales employees. Based on available performance data, did this new system improve the employee performance? Briefly explain the results.
4. Finally, your CEO would like to find out what are the best predictors of employee performance in your company. Test the effects of access to information, peer support, and years of service on employee performance (use performance 2022. Explain the results.

RI Bes FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri EPWrap Text General 2 Cut Copy Paste Format Painter - 11 AA == = BI U - - S.A. Merge & Center $ - % 0.00 .00 7.0 TE Conditic Formatti Clipboard Font Alignment Number S42 3 X v fr J B Years of Service 1 2 2 D Intention to Quit 5 4 C Peer Support 5 5 3 3 2 3 E Performance 2019 5 4 2 2 4 3 5 1 4 3 4 5 3 5 2 2 2 4 2 1 2 1 4 4 5 3 3 4 2 7 1 1 2 3 4 5 6 7 8 S 10 11 12 13 14 5 16 17 T 78 19 20 21 22 23 24 25 25 27 28 29 30 31 22 12 33 34 4 2 3 2 4 3 2 1 4 4 3 2 2 - 4 2 3 4 5 1 5 2 2 3 2 2 3 3 2 2 1 1 2 3 3 3 3 2 1 1 1 2 3 3 2 - 5 3 3 4 Annual Salary 72000 80000 67000 69000 78000 71000 67000 22 74000 79000 73000 79000 74000 71000 76000 Food 7100 72000 ce 77000 reco 77000 69000 70000 78000 85000 70000 69000 75000 ecco 70000 70000 70000 72000 74000 70000 71000 68000 81000 79000 67000 4 F G H Performance_2022 rk from Home 1-yes. 2. Gender (W-1M-2) 5 1 1 5 1 2 3 2 1 2 2 2 4 1 2 4 1 2 4 3 2 1 2 1 3 3 2 1 2 2 2 2 2 2 1 1 2 2 4 1 2 3 1 1 2 2 2 3 3 1 1 3 2 1 4 1 2 2 2 2 2 2 2 3 1 1 5 1 2 4 1 2 3 2 1 3 2 2 4 1 1 4 1 1 4 1 1 4 2 2 2 4 2 1 2 2 2 2 2 4 2 1 4 1 2 3 2 1 1 5 1 1 2 2 5 1 2 4 2 1 1 3 2 1 3 2 2 4 1 2 5 1 1 3 2 2 2 2 2 1 1 4 4 2 2 4 1 3 2 3 2 4 4 2 2 4 2 2 2 4 4 4 1 1 4 2 2 3 3 1 4 3 3 2 4 2 3 5 2 2 4 2 5 5 36 37 38 39 40 41 42 49 5 2 1 4 5 3 3 5 5 5 2 3 3 3 2 5 5 2 2 2 2 2 2 5 5 1 1 2 5 5 4 3 3 5 4 4 71000 4 2 2 2 4 5 2 2 2 4 68000 72000 70000 78000 71000 Sheet1 READY RI Bes FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri EPWrap Text General 2 Cut Copy Paste Format Painter - 11 AA == = BI U - - S.A. Merge & Center $ - % 0.00 .00 7.0 TE Conditic Formatti Clipboard Font Alignment Number S42 3 X v fr J B Years of Service 1 2 2 D Intention to Quit 5 4 C Peer Support 5 5 3 3 2 3 E Performance 2019 5 4 2 2 4 3 5 1 4 3 4 5 3 5 2 2 2 4 2 1 2 1 4 4 5 3 3 4 2 7 1 1 2 3 4 5 6 7 8 S 10 11 12 13 14 5 16 17 T 78 19 20 21 22 23 24 25 25 27 28 29 30 31 22 12 33 34 4 2 3 2 4 3 2 1 4 4 3 2 2 - 4 2 3 4 5 1 5 2 2 3 2 2 3 3 2 2 1 1 2 3 3 3 3 2 1 1 1 2 3 3 2 - 5 3 3 4 Annual Salary 72000 80000 67000 69000 78000 71000 67000 22 74000 79000 73000 79000 74000 71000 76000 Food 7100 72000 ce 77000 reco 77000 69000 70000 78000 85000 70000 69000 75000 ecco 70000 70000 70000 72000 74000 70000 71000 68000 81000 79000 67000 4 F G H Performance_2022 rk from Home 1-yes. 2. Gender (W-1M-2) 5 1 1 5 1 2 3 2 1 2 2 2 4 1 2 4 1 2 4 3 2 1 2 1 3 3 2 1 2 2 2 2 2 2 1 1 2 2 4 1 2 3 1 1 2 2 2 3 3 1 1 3 2 1 4 1 2 2 2 2 2 2 2 3 1 1 5 1 2 4 1 2 3 2 1 3 2 2 4 1 1 4 1 1 4 1 1 4 2 2 2 4 2 1 2 2 2 2 2 4 2 1 4 1 2 3 2 1 1 5 1 1 2 2 5 1 2 4 2 1 1 3 2 1 3 2 2 4 1 2 5 1 1 3 2 2 2 2 2 1 1 4 4 2 2 4 1 3 2 3 2 4 4 2 2 4 2 2 2 4 4 4 1 1 4 2 2 3 3 1 4 3 3 2 4 2 3 5 2 2 4 2 5 5 36 37 38 39 40 41 42 49 5 2 1 4 5 3 3 5 5 5 2 3 3 3 2 5 5 2 2 2 2 2 2 5 5 1 1 2 5 5 4 3 3 5 4 4 71000 4 2 2 2 4 5 2 2 2 4 68000 72000 70000 78000 71000 Sheet1 READY