Introduction

Menards Corporate $($Eau Claire, WI$)$ hears about your advanced HRM skills in measurement and selection and contacts you for some consulting work. They are considering using an IQ test and a personality measure that captures Agreeabless in their process for selecting new store employees. The rationale for IQ is that there is a lot of information to process, retain, and recall, such as store layout, attributes $/$ comparison of different brands, weekly sales items and prices. The rationale for Agreeableness is that highly agreeable individuals tend to be more cooperative, conflict avoidant, and even nurturing $($which is an often$-$overlooked aspect of Agreeableness$).$ Combined, these two measures should help Menards hire associates who can answer customer inquiries more quickly and in more detail, and come across as friendly and supportive in the process.

Menards already collected some preliminary data from a sample of $100$ current employees. They gave these employees a brief IQ test on a Monday, waited two weeks, and then gave them the same test again. These data are labeled $\text{'}|Q|-$Time $1\text{'}$ and $\text{'}Q-$Time $2^{\text{'}}\text{'}$ in the columns to the left. Your mission is to compute a test$-$retest reliability correlation.

The function in Excel for computing correlations is: $=$CORREL $(x_s$:$x_e,Y_s$:$Y_e).$ CORREL of course denotes correlation. $x_s$:$xe$ is simply the range of data for the first variable $($here Time $1).$ To illustrate using the sample data to the right, the Time $1$ data starts in Cell $T20$ and ends in $T24.$ So$,$ this component would be T$20$:T$24.$ Note the full colon between them, which must be included and must be exact. The Time $2$ data comprises Cells U$20$ to U$24,$ so this component would be U$20$:U$24.$ Putting both together, the $T-R$ correlation formula becomes:

$=$ CORREL$($T$20$:T$24,$U$20$:U$24)$

If you happen to try actually computing this correlation, the correct value is $.93.$ Note that $T-R$ correlations are typically reported with two decimals, which is what you should do in this exercise. Points will be deduced for incorrect decimal reporting.

Your turn! Please enter the appropriate formula for computing the T$-$R reliability of IQ in Cell D$14$ in the upper$-$left. Then do the same for Agreeableness $($Ag$)$ and enter that formula in Cell D$15.$ Your submited Excel spreadsheet SHOULD HAVE the actual formulas in these cells, not just the correlation values themselves.

Now it's time for interpretation. In the space below, $\backslash$give your report to Menards regarding the T$-$R reliability of their IQ and Agreeableness measures $($replace $$ with your text$).$ Be very specific as to what the T$-$R values are and what they mean, including referencing the minimum reliability benchmark noted in the Intro. Conclude by making a formal recommendation as to whether Menards should consider using either the IQ or Agreeableness measure $($or both$)$ in the selection of new store associates based on their reliability.

Q: $$

Agreeableness: $$