Q3. Computing SDy based on Performance Rating and Unit Performance

a) Using the standardized scores of performance ratings for managers and assistant

managers, compute SDy by running regressions on the unit sales of the same years.

Y=Unit sales (all years)

Significant Effect?

(p<.05)

X1=Standardized

Performance Rating of

Managers

X2= Standardized

Performance Rating of

Assistant Managers

Number of Observations in Regression Model:

b) SDy of Managers = $_

c) SDy of Assistant Managers = $_

Y=One-Year Change in Unit sales

(for all years possible)

Coefficients

X1=Standardized Performance

Rating of Managers

X2= Standardized Performance

Rating of Asst. Managers

d) Repeat Question 3a and compute SDy for managers and assistant managers yet by

regressing one-year change in unit sales rather than the unit sales of concurrent years. Fill

in the table below and blanks for SDy.

Coefficients

P-value

(Use 4 Decimal

Places)

Number of Observations in Regression Model:

e) SDy of Managers = $_

f) SDy of Assistant Managers = $_

(Yes or No)

P-value

(Use 4 Decimal

Places)

(Yes or No)

Significant Effect?

(p<.05)

(Yes or No)

(Yes or No)/ng) Repeat Question 3a and compute SDy for managers and assistant managers yet after

controlling for one-year prior unit sales and store market information. Fill in the table

below and blanks for SDy.

Y=Unit sales (for all possible years

except 2016)

X1= Standardized Performance

Rating of Managers

X2= Standardized Performance

Rating of Asst. Managers

X3= Store Market

X4=Prior unit sales (one-year)

Coefficients

Number of Observations in Regression Model:

h) SDy of Managers = $_

i) SDy of Assistant Managers = $_

P-value

(Use 4 Decimal

Places)

Significant Effect?

(p<.05)

(Yes or No)

(Yes or No)

(Yes or No)

(Yes or No)

₁) Compare the SDy's that you have computed above. Among them, (1) which SDy do you

think provides the most precise estimate? (2) why?

"I think the best estimates of SDy for managers and assistant managers are from

(please check):

I Question 3a

Question 3d

Question 3g

k) "I have chosen the SDy above because..." (briefly state with 100 words maximum):