Search for question
Question

Q6. Employee Engagement, Turnover and Unit Performance Over Time

a) Prepare the data for and conduct a multiple regression analysis.

Y = Unit sales (2022)

Coefficients

X1 = Average Unit Engagement Rating from

2022 Raw Engagement Data Subset

(Average of the nine items)

X2 = Unit Turnover Rates (2022)

X3 = Prior Unit Sales (2021)

Number of Observations in Regression Model:

X1 = Average Unit Engagement Rating for

Non-Exempt Employees from

Engagement Survey Results (Average of

then nine items)

X2 = Unit Turnover Rates (2022)

X3 = Prior Unit Sales (2021)

P-value

(Use 4 Decimal

Places)

b) Correlation between your computed unit-level average engagement score, and the value

provided for Non-Exempt employees by unit for 2022. r=

Number of Observations in Regression Model:

c) Conduct the same regression as for Question 6a, but now use the average non-exempt

score from the Engagement Survey Results tab.

Y = Unit sales (2022)

Coefficients

Significant

Effect?

P-value

(Use 4 Decimal

Places)

(p<.05)

(Yes or No)

(Yes or No)

(Yes or No)

Significant

Effect?

(p<.05)

(Yes or No)

d) Compare these two regressions. Which one do you think is better? Why?

(Yes or No)

(Yes or No)

Fig: 1