In meeting with PLE$$s human resources director, Elizabeth discovered a concern about high rate of

turnover in its field service staff. Senior managers have suggested that the department look closer at its

recruiting policies, particularly to try to identify the characteristics of individuals that lead to greater

retention. However, in a recent staff meeting, HR managers could not agree on these characteristics.

Some argued that years of education and grade points averages were good predictors. Others argued

that hiring more mature applicants would lead to greater retention. To study these factors, the staff

agreed to conduct a statistical study to determine the effect that years of education, college grade point

average and age when hired have on retention. A sample of $40$ field service engineers hired $10$ years ago

was selected to determine the influence of these variables on how long each individual stated with the

company. Data are compiled in the Employee Retention workbook.

Using Excel use techniques of regression analysis to assist her in evaluating the data and reach useful

conclusions. Datasheet: Employee Retention

YrsEducation College College GPA Age YearsPLE

$18$ Amherst $3\mathrm{.}013310$

$16$ Barnard $2\mathrm{.}782510$

$18$ Bates $3\mathrm{.}152610$

$18$ Berkeley $3\mathrm{.}862410$

$16$ Bowdoin $2\mathrm{.}58259\mathrm{.}6$

$16$ Brown $2\mathrm{.}96238\mathrm{.}5$

$17$ Bryn Mawr $3\mathrm{.}56358\mathrm{.}4$

$16$ Cal Tech $2\mathrm{.}64238\mathrm{.}4$

$18$ Carleton $3\mathrm{.}43328\mathrm{.}2$

$15$ Carnegie Mellon $2\mathrm{.}75347\mathrm{.}9$

$13$ Claremont McKenna $2\mathrm{.}95287\mathrm{.}6$

$13$ Colby $2\mathrm{.}50237\mathrm{.}5$

$16$ Colgate $2\mathrm{.}86247\mathrm{.}5$

$15$ Columbia $2\mathrm{.}38237\mathrm{.}2$

$16$ Cornell $3\mathrm{.}47276\mathrm{.}8$

$16$ Davisdson $3\mathrm{.}10266\mathrm{.}5$

$13$ Duke $2\mathrm{.}98216\mathrm{.}3$

$16$ Georgetown $2\mathrm{.}71236\mathrm{.}2$

$13$ Grinnell $2\mathrm{.}95205\mathrm{.}9$

$18$ Hamilton $3\mathrm{.}36255\mathrm{.}8$

$16$ Harvard $2\mathrm{.}75245\mathrm{.}4$

$17$ Haverford $2\mathrm{.}48325\mathrm{.}1$

$14$ Johns Hopkins $2\mathrm{.}76284\mathrm{.}8$

$16$ Middlebury $3\mathrm{.}12254\mathrm{.}7$

$13$ MIT $2\mathrm{.}96234\mathrm{.}5$

$16$ Mount Holyoke $2\mathrm{.}80254\mathrm{.}3$

$17$ Northwestern $3\mathrm{.}57244$

$16$ Oberlin $3\mathrm{.}00263\mathrm{.}9$

$16$ Amherst $2\mathrm{.}86233\mathrm{.}7$

$15$ Barnard $3\mathrm{.}19243\mathrm{.}7$

$16$ Bates $3\mathrm{.}50233\mathrm{.}7$

$14$ Berkeley $2\mathrm{.}84213\mathrm{.}5$

$16$ Bowdoin $3\mathrm{.}13243\mathrm{.}4$

$13$ Brown $1\mathrm{.}75222\mathrm{.}5$

$16$ Bryn Mawr $2\mathrm{.}98251\mathrm{.}8$

$15$ Cal Tech $2\mathrm{.}13221\mathrm{.}5$

$16$ Carleton $2\mathrm{.}79230\mathrm{.}9$

$18$ Carnegie Mellon $3\mathrm{.}15260\mathrm{.}8$

$13$ Claremont McKenna $1\mathrm{.}84220\mathrm{.}7$

$18$ Colby $3\mathrm{.}79240\mathrm{.}3$