This is the data link: https://emailarizona-my.sharepoint.com/:x:/g/personal/tanishkabansal_arizona_edu/EY9NYBVnE-xKsMzHf5vvm3MBfmDmu1-qSkBaMT52_SfEOw?e=whY1G7

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.

OverallRatings=0+1CompBenefit+2CultureValues+3CareerOpp+4SeniorManage+5WorkBalance+OverallRatings=0+1CompBenefit+2CultureValues+3CareerOpp+4SeniorManage+5WorkBalance+

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

If you had to pick one area of employee satisfaction to try to improve, which of them would have the largest positive impact on how the employees rate the company as a whole? Assume the cost to improve each would be equal for all the categories. Hint, think about how you interpret the coefficient and what they tell you.

Work-Balance

Compensation-Benefits

Culture-Values

Career-Opportunities

Senior-Management