《EXCEL统计分析》003 练习数据(人工筛选)

T MAP CVP 20 1 00 8 H 00000000 0505050 40. 77777 2 776677 660099 H 55 056 0000 66 HHHH22222 1111000000001 05 000000000000 777798 443337 5050 86 55767707 9992 44669777333856677555 000 898 3980 .5 22222股 05055 6 235 050505 110 7779557 02578 40. 0000 667898 8911 8a%H 11100000000 222222222222222222222222222222222222222222 113576276676859918 505 0 672 0000 l11 0000 002%%48 78 15 HH 01100000000 000000000 40. 050 4 5. 0000 88865 5859824559

ID group Time1 Time w part HR MAP CVP H1 1 0:20 20.00 1.00 2 78 80 4 H1 1 0:25 25.00 2 78 80 4 H1 1 0:30 30.00 1.00 2 71 76 6 H1 1 0:35 35.00 2 71 76 6 H1 1 0:40 40.00 1.00 2 72 60 9 H1 1 0:45 45.00 2 72 60 7 H1 1 0:50 50.00 1.00 2 86 79 7 H1 1 0:55 55.00 2 86 79 7 H1 1 1:00 60.00 1.00 2 74 62 13 H1 1 1:05 65.00 2 74 62 13 H1 1 1:10 70.00 1.00 2 73 59 13 H1 1 1:15 75.00 2 73 59 8 H2 1 0:20 20.00 1.00 2 93 79 3.5 H2 1 0:25 25.00 2 87 69 6 H2 1 0:30 30.00 1.00 2 86 72 6 H2 1 0:35 35.00 2 74 75 7 H2 1 0:40 40.00 1.00 2 91 101 7 H2 1 0:45 45.00 2 81 73 8.5 H2 1 0:50 50.00 1.00 2 83 69 9.5 H2 1 0:55 55.00 2 95 88 9.5 H2 1 1:00 60.00 1.00 2 87 80 9.5 H2 1 1:05 65.00 2 116 76 10 H2 1 1:10 70.00 1.00 2 112 77 12 H2 1 1:15 75.00 2 107 72 13.5 H3 1 0:15 20.00 1.00 2 66 92 7 H3 1 0:20 25.00 2 66 51 8 H3 1 0:25 30.00 1.00 2 67 57 8 H3 1 0:30 35.00 2 76 78 9 H3 1 0:35 40.00 1.00 2 88 96 11 H3 1 0:40 45.00 2 95 107 13 H3 1 0:45 50.00 1.00 2 89 105 11 H3 1 0:50 55.00 2 109 92 7.5 H3 1 0:55 60.00 1.00 2 101 96 8 H3 1 1:00 65.00 2 108 96 8.5 H3 1 1:05 70.00 1.00 2 100 84 9 H4 1 0:15 20.00 1.00 2 87 58 8 H4 1 0:20 25.00 2 86 81 12 H4 1 0:25 30.00 1.00 2 82 90 14 H4 1 0:30 35.00 2 83 92 15 H4 1 0:35 40.00 1.00 2 80 80 H4 1 0:40 45.00 2 85 78 15 H4 1 0:45 50.00 1.00 2 96 81 H4 1 0:50 55.00 2 95 88 19

H4 10:5560.001.00 104 l1 0065.00 13 55 5002 0:2530. 0:30 12 0:35 40. 00 1.00 0:4045.00 000 6776678877 17 55 566 544 10:15 12 25.00 7 13.5 0:25 1.00 2222222222222222222222 83 16. 5 0 .5 00000 0:4045.00 H6 0:4550.00 1.00 99984 95535 13.5 8410.5 0:5560.00 1.00 81 1:0065.00 15.5 1:0570. 11:1075.00 1:2590.00 1.00 13.5 10:1520.00 1.00 69 7.5 81 68 9 0 10 40.00 766 12.5 0:4045.00 13 0:4550.00 1.00 67 14 10:1520.00 1.00 81 7 0:2025.00 2222222222222222222222222 100 8 0:3035.00 0:3540.001.00 0:4045.00 95 10.5 H8 0:4550.00 1.00 104 H8 0:5055.00 9210.5 0:5560.00 11

H4 1 0:55 60.00 1.00 2 104 78 12.5 H4 1 1:00 65.00 2 89 84 13.5 H4 1 1:05 70.00 1.00 2 91 85 15 H5 1 0:15 20.00 1.00 2 67 62 10 H5 1 0:20 25.00 2 70 66 10 H5 1 0:25 30.00 1.00 2 70 59 12 H5 1 0:30 35.00 2 67 58 12 H5 1 0:35 40.00 1.00 2 67 58 17 H5 1 0:40 45.00 2 76 75 17 H5 1 0:45 50.00 1.00 2 85 78 13.5 H5 1 0:50 55.00 2 85 55 17.5 H5 1 0:55 60.00 1.00 2 76 67 14 H5 1 1:00 65.00 2 76 67 14 H6 1 0:15 20.00 1.00 2 93 69 12 H6 1 0:20 25.00 2 87 73 13.5 H6 1 0:25 30.00 1.00 2 83 79 16.5 H6 1 0:30 35.00 2 78 93 18.5 H6 1 0:35 40.00 1.00 2 93 85 19 H6 1 0:40 45.00 2 95 89 13.5 H6 1 0:45 50.00 1.00 2 95 84 10.5 H6 1 0:50 55.00 2 87 72 13 H6 1 0:55 60.00 1.00 2 94 81 13.5 H6 1 1:00 65.00 2 85 70 15.5 H6 1 1:05 70.00 1.00 2 83 68 15.5 H6 1 1:10 75.00 2 81 66 14.5 H6 1 1:15 80.00 1.00 2 82 66 16.5 H6 1 1:20 85.00 2 84 67 16 H6 1 1:25 90.00 1.00 2 83 66 13.5 H7 1 0:15 20.00 1.00 2 96 69 7.5 H7 1 0:20 25.00 2 81 68 9 H7 1 0:25 30.00 1.00 2 79 67 10 H7 1 0:30 35.00 2 79 71 12 H7 1 0:35 40.00 1.00 2 77 68 12.5 H7 1 0:40 45.00 2 76 64 13 H7 1 0:45 50.00 1.00 2 81 67 14 H8 1 0:15 20.00 1.00 2 93 81 7 H8 1 0:20 25.00 2 100 85 H8 1 0:25 30.00 1.00 2 94 73 7.5 H8 1 0:30 35.00 2 92 81 8 H8 1 0:35 40.00 1.00 2 92 87 9.5 H8 1 0:40 45.00 2 95 78 10.5 H8 1 0:45 50.00 1.00 2 104 92 H8 1 0:50 55.00 2 104 92 10.5 H8 1 0:55 60.00 1.00 2 120 88 11

11:0065.00 102 1:0570.00 1.00 102 9 BB股股股股股股股股股股 0:15 47 13.5 0:3035.00 15.5 0:3540.00 14.5 0:4045.00 86 13.5 0:4550.00 1.00 14 0:5055.00 11.5 H10 0:1520.00 55 12 H10 0:2025.00 2222222222222222222222 79 55 14 H10 0:2530.00 1.00 76 15 H10 0:3035.00 76 16.5 H10 0:3540.00 H10 10:4045. 103 H10 0:4550.00 15.5 H10 H10 1.00 16.5 H10 11:0065.00 83 7516.5 H10 8058 1:0570.00 1.00 195 H10 11:1075.00 HIl 10:1520.0 HIl 6 HII 1.00 9 HIl 0:3035.00 71 9 HIl 0:3540.00 1.00 10 HIl 0:4045.00 10 HIl 0:4550.00 HIl 667 HIl 0:5560.001.00 109 HIl 1:0065.00 109 13 HIl 1:0570.001.00 107 12 HIl 1:1075.00 109 12 H12 0:1520.00 1.00 2222222222222222222222222 83 58 6 H12 H12 H12 0:3035.00 5666 H12 0:3540.00 1.00 H12 0:4045.00 73 13.5 H12 0:4550.00 1.00 71 6015.5 10:5055.00 16

H8 1 1:00 65.00 2 102 86 11 H8 1 1:05 70.00 1.00 2 102 63 9 H9 1 0:15 20.00 1.00 2 62 47 7 H9 1 0:20 25.00 2 63 86 12 H9 1 0:25 30.00 1.00 2 66 77 13.5 H9 1 0:30 35.00 2 64 54 15.5 H9 1 0:35 40.00 1.00 2 67 58 14.5 H9 1 0:40 45.00 2 86 80 13.5 H9 1 0:45 50.00 1.00 2 95 70 14 H9 1 0:50 55.00 2 98 59 11.5 H9 1 0:55 60.00 1.00 2 91 71 12 H9 1 1:00 65.00 2 91 69 12 H10 1 0:15 20.00 1.00 2 86 55 12 H10 1 0:20 25.00 2 79 55 14 H10 1 0:25 30.00 1.00 2 76 72 15 H10 1 0:30 35.00 2 76 69 16.5 H10 1 0:35 40.00 1.00 2 87 103 19 H10 1 0:40 45.00 2 85 103 20 H10 1 0:45 50.00 1.00 2 87 77 15.5 H10 1 0:50 55.00 2 86 78 16 H10 1 0:55 60.00 1.00 2 80 70 16.5 H10 1 1:00 65.00 2 83 75 16.5 H10 1 1:05 70.00 1.00 2 85 78 19.5 H10 1 1:10 75.00 2 84 63 16 H11 1 0:15 20.00 1.00 2 98 76 6 H11 1 0:20 25.00 2 98 76 6 H11 1 0:25 30.00 1.00 2 97 71 9 H11 1 0:30 35.00 2 97 71 9 H11 1 0:35 40.00 1.00 2 90 58 10 H11 1 0:40 45.00 2 90 58 10 H11 1 0:45 50.00 1.00 2 87 65 15 H11 1 0:50 55.00 2 87 65 15 H11 1 0:55 60.00 1.00 2 109 76 13 H11 1 1:00 65.00 2 109 95 13 H11 1 1:05 70.00 1.00 2 107 99 12 H11 1 1:10 75.00 2 109 99 12 H12 1 0:15 20.00 1.00 2 83 58 6 H12 1 0:20 25.00 2 74 55 6 H12 1 0:25 30.00 1.00 2 73 62 6 H12 1 0:30 35.00 2 70 67 6.5 H12 1 0:35 40.00 1.00 2 70 63 12 H12 1 0:40 45.00 2 73 63 13.5 H12 1 0:45 50.00 1.00 2 71 60 15.5 H12 1 0:50 55.00 2 76 70 16

l1 00 7 HGGGGGGdGGGd 000000000 50505050 000 95 40. 74 682565589 55 056 0000 G 22222 GGGGGGGGGGGGGGG 222222222222222222222222222222222222222222 2222222222222222222222222222222222222222222 89889787877886 75407447308 895585 1111000000000 10 15 76 15 5. 487 050 l1l11 64 75 00000000 6568 000 800 :5 06 90 7乃乃88%8 ll1 5055 050 0000000001 223 050 000 000 86387666467 467666 5050 668 78 05 GGGG 4444444 000 6050 0000 11 80 025523792358i568689556952534480105 0000 050 l11 00000 505 0000 9095 8778876 10 4 98877 931

H12 1 0:55 60.00 1.00 2 89 74 16 G1 2 0:20 20.00 1.00 2 94 59 8 G1 2 0:25 25.00 2 85 56 12 G1 2 0:30 30.00 1.00 2 87 59 13.5 G1 2 0:35 35.00 2 95 59 16 G1 2 0:40 40.00 1.00 2 74 47 17.5 G1 2 0:45 45.00 2 80 58 14.5 G1 2 0:50 50.00 1.00 2 77 59 18 G1 2 0:55 55.00 2 84 55 19 G1 2 1:00 60.00 1.00 2 74 45 20 G1 2 1:05 65.00 2 77 48 21 G1 2 1:10 70.00 1.00 2 83 54 17.5 G1 2 1:15 75.00 2 80 47 16.5 G2 2 0:15 20.00 1.00 2 68 84 12 G2 2 0:20 25.00 2 68 72 14.5 G2 2 0:25 30.00 1.00 2 54 75 17 G2 2 0:30 35.00 2 54 77 19 G2 2 0:35 40.00 1.00 2 67 67 12 G2 2 0:40 45.00 2 58 73 13 G2 2 0:45 50.00 1.00 2 60 73 14.5 G2 2 0:50 55.00 2 80 80 18 G2 2 0:55 60.00 1.00 2 63 86 16.1 G2 2 1:00 65.00 2 90 96 15 G2 2 1:05 70.00 1.00 2 82 86 16 G2 2 1:10 75.00 2 83 85 18 G2 2 1:15 80.00 1.00 2 86 82 16.5 G3 2 0:15 20.00 1.00 2 73 74 8 G3 2 0:20 25.00 2 68 66 9 G3 2 0:25 30.00 1.00 2 67 67 13.5 G3 2 0:30 35.00 2 66 66 15.5 G3 2 0:35 40.00 1.00 2 61 65 16.5 G3 2 0:40 45.00 2 63 66 19 G3 2 0:45 50.00 1.00 2 64 60 15 G3 2 0:50 55.00 2 63 69 12 G3 2 0:55 60.00 1.00 2 77 81 13.5 G3 2 1:00 65.00 2 78 86 13 G3 2 1:05 70.00 1.00 2 80 77 14 G4 2 0:20 20.00 1.00 2 90 89 4 G4 2 0:25 25.00 2 89 70 8 G4 2 0:30 30.00 1.00 2 90 78 10.5 G4 2 0:35 35.00 2 89 89 10 G4 2 0:40 40.00 1.00 2 85 83 11 G4 2 0:45 45.00 2 75 71 10 G4 2 0:50 50.00 1.00 2 74 68 15.5

0000000000 0:5555.00 17 1:0060.00 1 00 1:0565.00 6490 1:1575.00 1:2080.00 1:2585.00 1:3090.00 l11 57944088 584856652 00 7 GGGGGGGGGGGGG G6 G6 GGGG G6 G6 GGGGGGGGGG 2222222222222222222222222222222222222222222 0:1520.00 198767 0 0:3035.00 0:3540.00 0000000000 0:4045.00 0:4550.00 0:5055.00 98 66 0:5560.00 686349805%44644 17 1:0570.00 0:1520.00 0:2025.00 0:2530.00 0:3035.00 000 0:3540.00 55556 56785565854555 8. 0:4045.0 00000 0:4550.00 0:5560.00 1:0065.00 1:0570.00 1:1075.00 0:2520.00 0: 00000 0:4035.00 ll11111 2222222222222222222222222222222222222222222 677888 8083 16 7 79 8 290011 866666 10 11 0:20 00000000000 0:4540.00 63 0:5045.00 996633242 666555 21 6657576551523555505 1:0560.00 0:2525.00 000 22 0:3030.00 11 20:3535.00

G4 2 0:55 55.00 2 75 70 17.5 G4 2 1:00 60.00 1.00 2 77 86 18 G4 2 1:05 65.00 2 79 94 14 G4 2 1:10 70.00 1.00 2 94 95 18 G4 2 1:15 75.00 2 94 103 15 G4 2 1:20 80.00 1.00 2 80 94 16 G4 2 1:25 85.00 2 84 81 16 G4 2 1:30 90.00 1.00 2 88 75 17.5 G5 2 0:15 20.00 1.00 2 69 65 12 G5 2 0:20 25.00 2 68 67 13.5 G5 2 0:25 30.00 1.00 2 76 62 15 G5 2 0:30 35.00 2 73 70 16 G5 2 0:35 40.00 1.00 2 64 86 17 G5 2 0:40 45.00 2 90 11 18 G5 2 0:45 50.00 1.00 2 89 92 16.5 G5 2 0:50 55.00 2 100 98 16.5 G5 2 0:55 60.00 1.00 2 95 93 16 G5 2 1:00 65.00 2 96 86 17.5 G5 2 1:05 70.00 1.00 2 104 96 18 G6 2 0:15 20.00 1.00 2 84 70 15 G6 2 0:20 25.00 2 76 59 14 G6 2 0:25 30.00 1.00 2 74 56 8.5 G6 2 0:30 35.00 2 74 57 15 G6 2 0:35 40.00 1.00 2 70 56 14.5 G6 2 0:40 45.00 2 68 62 16 G6 2 0:45 50.00 1.00 2 70 87 16 G6 2 0:50 55.00 2 78 86 16.5 G6 2 0:55 60.00 1.00 2 83 100 17 G6 2 1:00 65.00 2 82 85 17.5 G6 2 1:05 70.00 1.00 2 85 82 17 G6 2 1:10 75.00 2 77 69 16 G7 2 0:25 20.00 1.00 2 79 60 8.5 G7 2 0:30 25.00 2 78 60 10.5 G7 2 0:35 30.00 1.00 2 79 61 11 G7 2 0:40 35.00 2 79 61 11.5 G7 2 0:45 40.00 1.00 2 79 63 12 G7 2 0:50 45.00 2 76 60 13 G7 2 0:55 50.00 1.00 2 76 64 12.5 G7 2 1:00 55.00 2 73 65 11.5 G7 2 1:05 60.00 1.00 2 73 64 12.5 G8 2 0:20 20.00 1.00 2 102 59 12.5 G8 2 0:25 25.00 2 104 59 10 G8 2 0:30 30.00 1.00 2 92 59 11.5 G8 2 0:35 35.00 2 89 59 12