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