Employee Exercise Rating Employee Exercise Rating 17 10 You will need to sort the data into ratings for a "Yes" Yes 15 column and ratings for a "No" column. Place your 2 Yes 17 18 No 24 SCENARIO 1: Fitness and Productivity sorted data and the Excel output to the right and 19 No 15 Yes 16 A company decided to include a fitness benefit for its employees with the reference the cells in the Excel output (where Yes 20 20 No 9 appropriate) in your ANSWER CELLS. belief that employees who are in better shape will perform better at work. 5 Yes 20 21 No 14 The company decides to take a simple random sample of the employees 6 Yes 14 22 No 13 Data Analysis (some participated and some did not) to test their claim (alternative Yes 14 23 No 11 hypothesis) that particpation in the fitness program will result in higher Analysis Tools OK 8 Yes 16 24 No 12 Histogram productivity on the average. Use an alpha value of 0.01. Moving Average Cancel Yes 24 25 No 14 Random Number Generation CO Rank and Percentile Help 10 Yes 10 26 No 11 Regression Sampling 11 Yes 23 27 No 11 t-Test: Paired Two Sample for Means Use the "t-test: Two-Sample Assuming Unequal Variances" option in t-Test: Two-Sample Assuming Equal Variances Yes 28 No 15 t-Test: Two-Sample Assuming Unequal Variances 12 22 Excel's Data Analysis menu to answer the questions that follow. z-Test: Two Sample for Means 13 Yes 15 29 No 9 14 Yes 13 30 No 20 Ho: Average productivity is equal. 15 Yes 14 31 No 22 Employee Exercise Rating Ha: Employees who particpate are more productive on average. ANSWER CELLS 16 Yes 15 32 No 12 Yes 15 33 No 22 IN Yes 17 1 What is the value for the test statitistic ("t Stat" as Excel calls it)? 34 No 23 3 Yes 16 35 No Show your co 4 Yes 20 answers to 36 No 5 Yes 20 2 What is the value for the Critical value for t? three decimal 14 places (for 6 Yes example, 1.235) 7 Yes 14 8 Yes 16 3 What is the the p-value for this two-sample hypothesis test? CO Yes 24 10 Yes 10 Yes 23 4 Our conclusion should be that participating in the fitness program does 12 Yes 22 result in employees who are more productive. True or False. 13 Yes 15