Scenario $2-$ Excel Based

Use the scenario described below to answer the following questions.

You are working for a consulting company that specializes in employee satisfaction. A firm that is struggling with high employee turnover and low satisfaction hires you to come in and help them with their issues. You start by collecting data from employees at several different large firms to try to identify what things employees value most regarding their satisfaction. Use this data to answer the following questions. Use a $5\%$ significance level for all testing.

Estimate the following model and answer each of the questions below and note that the variable descriptions are included in the Excel file.

Overall $-$ Ratings $={}_0+{}_1$ Comp $-$ Benefit $+{}_2$ Culture $-$ Values $+{}_3$ Career $-$ Opp $+{}_4$ Senior $-$ Manage $+{}_5$Work$-1$

For this question, you will need to download the Employee Reviews data and then use the datalysis tool pack in Excel to run a regression.

Which of the following is the correct employer and con comment left by the employee with the Anonymous Employee ID number $26506.$ Hint, there are over $50,000$ employee reviews and they are not in any order. If you are trying to manually scroll and find this employee ID you this might take a while. Use some of the tricks we have used in the lab to locate that employee and their comments quickly.

Employer: Apple. Con Comment: Lots of politics. There has been little promotion from within. Senior management has been hiring people from outside Apple that are bringing the negative corporate culture to Apple. Way too many business processes and a very generic approach to running a sales organization.

Employer: Amazon. Con Comment: Difficult shift hours, lack of communication between shifts.

Employer: Microsoft. Con Comment: Extremely competitive environment. Technical skills alone do not determine growth, people skills sometimes overshadow the technical depth.

Employer: Amazon, Con Comment: Bureaucratic. Overburdens employees. Cheap, not frugal. No direction. Got