You will use Excel as you calculator, since Excel doesn't have a Chi-square option in its Data Tools. Complete the tables shown and reference cells in the completed tables in your ANSWER CELLS. SCENARIO 3: Concerns about age discrimination A company Human Resources department has data on promotions and age for the last several years (see the data table of ages and promotion status to the right). The Show your DATA: OBSERVED Frequencies answers to HR Manager is concerned the company might be vulnerable to the charge of age three decimal Under 39 39 to 49 50 and over discrimination. The HR Manager asks you to take a look at the data and advise her as places (for Promoted 42 36 18 to whether her concerns might be valid. That is, is there a statistically significant example, 1.235) Not Promoted 78 44 40 relationship between age and promotions? Use an alpha value of 0.01. ANSWER CELLS 9 What is the Expected Frequency for "Under 39" and "Not Promoted?" EXPECTED Frequencies 10 What is the Expected Frequency for "50 and over" and "Promoted?" Under 39 39 to 49 50 and over Promoted Not Promoted 11 What is the value for the Test Statistic? TEST STATISTIC: (Obs-Exp) /Exp 12 What is the p-value for this Chi-square Test of Independence of Under 39 39 to 49 50 and over "Promotion" and "Age?" Note, you will need to use the function: Promoted Not Promoted 13 Does the analysis show a statistically significant association between "age" and "promotion status?" Yes or No