NumLockScenario $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 $=$ Bo$+$B$$Comp$-$Benefit $+$ B$2$Culture$-$Values $+$ BaCareer$-$Opp $+$ B$4$Senior$-$Manage$+$B;Work$-$Balance $+$

E

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.

Use Excel to calculate the correlations between the following variables. Round your answers to $4$ decimals. Hint, you could use the $=$correl$()$ command for each of these, but it might be more efficient to use the correlation function within the data analysis ToolPak.

Senior$-$Management and Career$-$Opportunities $=$

Career$-$Opportunities and Compensation$-$Benefits $=$

Work$-$Balance and Culture$-$Values $=$