A Study of Wage Discrimination at a Local Store Compared

A study of wage discrimination at a local store compared employees' race and status. Partial results of the study follow. Use Excel and test at α = .05 to determine if race is independent of status. $\begin{array}{lllll} \text { Employee } &\text { Race } & \text { Status } & \text { Employee } & \text { Race } & \text { Status } \\1&\text { white } & \text { manager } & 26 & \text { non-white } & \text { associate } \\2&\text { non-white } & \text { associate } & 27 & \text { white } & \text { district mgr. }\\3&\text { white } & \text { district mgr. } & 28 & \text { non-white } & \text { manager } \\4&\text { white } & \text { manager } & 29 & \text { white } & \text { associate } \\5&\text { white } & \text { manager } & 30 & \text { non-white } & \text { districtmgr. } \\6&\text { non-white } & \text { associate } & 31 & \text { non-white } & \text { districtmgr. }\\7&\text { non-white } & \text { associate } & 32 & \text { white } & \text { districtmgr. } \\8&\text { white } & \text { associate } & 33 & \text { white } & \text { districtmgr. } \\9&\text { non-white } & \text { associate } & 34 & \text { non-white } & \text { associate } \\10&\text { white } & \text { manager } & 35 & \text { white } & \text { districtmgr. } \\11&\text { non-white } & \text { manager } & 36 & \text { non-white } & \text { associate }\\12&\text { non-white } & \text { associate } & 37 & \text { non-white } & \text { manager } \\13&\text { white } & \text { associate } & 38 & \text { non-white } & \text { associate } \\14&\text { non-white } & \text { associate } & 39 & \text { white } & \text { districtmgr. } \\15&\text { white } & \text { districtmgr. } & 40 & \text { non-white } & \text { associate } \\16&\text { white } & \text { districtmgr. } & 41 & \text { non-white } & \text { manager } \\17&\text { non-white } & \text { associate } & 42 & \text { non-white } & \text { districtmgr. }\\18&\text { non-white } & \text { associate } & 43 & \text { white } & \text { manager } \\19&\text { white } & \text { associate } & 44 & \text { white } & \text { districtmgr. } \\20&\text { non-white } & \text { manager } & 45 & \text { non-white } & \text { associate } \\21&\text { white } & \text { districtmgr. } & 46 & \text { non-white } & \text { associate }\\22&\text { non-white } & \text { districtmgr. } & 47 & \text { non-white } & \text { district mgr. } \\23&\text { non-white } & \text { manager } & 48 & \text { white } & \text { manager } \\24&\text { non-white } & \text { associate } & 49 & \text { non-white } & \text { manager } \\25&\text { non-white } & \text { associate } & 50 & \text { non-white } & \text { associate }\end{array}$