Q4. The Relationship between Unit Turnover and Performance over time

a) Compute a correlation between the unit turnover rate of 2021 and 2022.

b) Regression Model 1

Y=Unit sales (2022)

X= Unit Turnover Rate (2022)

Number of Observations in Regression Model 1:

c) Regression Model 2

Y-Unit sales (2022)

X1=Unit Turnover Rate (2022)

X2= Unit Prior Sales (2021)

Coefficients

d) Regression Model 3

Number of Observations in Regression Model 2:

Y=Change in Unit sales

(2021-2022)

X= Unit Turnover Rate (2022)

Coefficients

Coefficients

Number of Observations in Regression Model 3:

P-value

(Use 4 Decimal

Places)

P-value

(in 4 Decimal

Places)

P-value

(Use 4 Decimal

Places)

Significant Effect?

(p<.05)

(Yes or No)

Significant Effect?

(p<.05)

(Yes or No)

(Yes or No)

Significant Effect?

(p<.05)

(Yes or No)/ne) Regression Model 4

Y=Change in Unit sales

(2021-2022)

X= Change in Unit Turnover

Rate (2022 rate-2021 rate)

Number of Observations in Regression Model 4:

Regression Model 5

Y= Unit sales (2022)

Coefficients

Xl=Change in Unit Turnover

Rate (2022 rate-2021 rate)

X2= Prior Unit Sales (2021)

Coefficients

Number of Observations in Regression Model 5:

P-value

(Use 4 Decimal

Places)

P-value

(in 4 Decimal

Places)

Significant Effect?

(p<.05)

(Yes or No)

Significant Effect?

(p<.05)

(Yes or No)

(Yes or No)

g) Considering the five regression models you conducted in Question 4b through Question

4f, briefly interpret the results of regression models in a plain language, explaining the

nature of relationships between unit sales and turnover at a given year and over years. Is

there any interesting finding here for Mr. Macky's management?

Answer:/nQ5. Computing the percent of unit-level variance of Employee Engagement Data

a) Compute the following for each of the nine items of employee engagement survey.

Item

Total variance

Variance of group

averages

Percent of variance

attributable to

group membership

Job Satisfaction

Collaboration

Communication

Support

Customer Focus

Personal Growth

Inclusion

Empowerment

Accountability

b) Percent of variance attributable to group membership:

c) Based on your findings in Question 5a and Question 5b above, which individual-level

engagement items can be also considered for aggregated effect at the unit level on other

unit-level? Would it be appropriate to aggregate the overall measure of employee

engagement?

Answer: