Ls] LS D E F G H Data Description In this project you have six data sets. Three are 40 student samples of standardized test scores from three classrooms each at a different school. The other three are 40 employee samples from three businesses indicating whether the employee participates in a company retirement plan (value =1) or not (value =0). Define "success" as participation in the company retirement plan. Data are uniqueto your group. You must enter all student information on the Instructions page for datato appear. 1 1 1 0 2 61.4 42.5 59.1 1 1 1 3 62.9 445 59.8 1 0 0 4 64 47.2 63 1 1 0 5 64.8 50.8 64.8 1 1 1 6 64.9 50.9 66.2 1 1 0 7 66.9 52.8 68 1 0 1 8 69.5 54.4 68.5 1 1 1 9 70 54.8 70 1 0 0 10 70.9 575 70.3 0 1 0 11 71 58.7 719 1 1 1 12 713 Bo 719 0 0 0 13 724 59.8 72.2 1 1 1 14 73.6 61.2 73.1 1 1 1 15 74 614 737 1 1 1 16 74.2 61.5 75.3 1 1 1 17 744 62.2 75.9 0 0 0 18 749 63.7 76.9 1 0 0 19 75 64.4 71 1 0 0 20 75.1 65.6 79.2 1 1 1 21 75.2 65.9 79.3 1 0 0 22 76 66.1 79.6 1 1 0 23 76.6 66.1 79.7 0 1 0 24 wl 66.9 80.1 1 1 0 25 772 67.6 80.8 0 0 1 26 aad 68.2 81.8 1 1 0 27 779 69.8 82.2 0 1 1 28 78 715 82.9 0 0 1 29 78.3 723 83 0 0 1 30 78.4 727 85.9 1 0 0 31 79.1 729 88.1 0 0 1 32 79.2 729 89.1 1 0 0 33 79.8 74 ors 0 1 1 34 83.2 74.2 91.8 0 1 0 35 85.8 74.2 93.7 1 0 1 36 87.1 76.2 94.9 1 1 1 37 87.2 83.6 97.2 0 1 1 38 88.1 83.6 98.4 1 1 1 39 93.9 84.6 99 1 1 1 40 95.7 92 99.6 0 1 0 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left D16 4 X V fx 0.525 A B C D E F G H Part 1: Find the summary statistics for each group. Normal Group 1 Group 2 Group 3 Mean 75.24 64.73 78.6 5 Median 75.15 65.75 73.4 6 Range 31.3 31 34.4 Round values Note. If you want to use Excel functions within answer boxes, Standard Deviation 9.04 11.68 11.93 to 2 decimal you'll need to use the round 8 function to round the values places Variance 81.77 136.38 142.24 correctly 9 Minimum 46.7 40.5 48.5 10 Maximum 95.7 92 99.6 11 12 Binomial 13 14 Group 4 Group 5 Group 6 Number of successes 27 25 21 Hint: You do not need 15 calculator functions to find Probability of Success 0.675 0.625 0.525 these values. 16 (p) 17 18 Do not enter fractions. Use decimals or whole numbers only. Do not round. 19 20 30 Instructions