Age ISO code FR FR FR 7 8 9 10 11 12 11 14 15 LU FR SOURCE Woute barce.com Course Year Dropout Stages Starters Finishers Average 1903 Dropouts distance, km Winner time km/h 60 39 65 1900 2,428 94h 33m os 25.58 6 38 27 61 69 2,426 1905 11 60 96 Sm 365 25.27 24 36 1906 60 2,994 13 27.11 110h 26m 58s 82 14 6B 83 1907 4,637 $4 93 33 24.46 189h 34m Os 60 1900 44BB 14 112 35 158 45m 5s 28,47 75 66 1909 14 156h 53m 21 55 26.74 150 95 63 1910 4,497 157h im 22s 110 15 28.66 41 69 63 1911 4,734 162h 41m 30s 94 15 29 2910 56 67 1912 5,343 15 195h 37m Os 131 41 27.32 90 69 1913 15 5,299 190 30m 283 25 115 02 5,287 29.76 1914 26.72 15 145 197h 54m Os 54 93 63 1919 5,100 15 26.04 69 200 20m 400 11 58 84 1920 5,500 231h 7m 15 15 113 24.06 22 95 81 5,503 1921 15 228 om 131 123 30 24.07 85 69 1922 5,45 22n Som 260 24.72 15 123 33 1933 5,375 222n mos 15 139 24,20 40 91 65 5,106 1934 222 15mos 15 157 60 24.23 97 1925 62 5,425 130 220 in 210 24.25 49 21 62 5.440 1926 17 136 41 219 10m 10 25 24.02 1927 67 5,745 24 142 2h 4m 25s 30 24.27 1920 103 23 22 5.300 190 1420 162 41 29.22 121 1929 5,476 22 75 155 60 192h 4m 58s 26.40 95 61 1930 5,286 21 100 186 39m 16s 28 59 1931 41 41 4,022 25.00 24 1721 12m 165 35 1932 46 5,091 57 21 30 57 177h 10m 35 28.74 23 1933 29 23 4,429 154h 12m 59s 29.05 40 1934 40 50 4,395 23 39 147h Sim 37s 29.82 21 35 19:15 4,470 21 147h 13m 58s 30.36 51 43 4,239 141h 23mnos 47 30:65 1901-2017 A PS4Q1 Data APS492(No Opel A-P5402-) A PS426) Employee A-P5404 A-P5405(e) APS. 52 142h 47m2 ***************222scaszeneted =s sa38 3 Ba aasa 17 10 19 Winner M. Garin H. Cornet Trousselier R. Pottier L. Petit-Dreton L. Petit Breton F.Faber 0. Lapise G Garrigou 0. Defraye P. Thys P. Thys F. Lambot P. Thys L. Scieur F. Lambot H. Pelissier O Bottecchia O. Bottecchia L. Buys N. Fanta N Frantz M. Dewaele A. Leduca A Magne A. Leduca 6 Speicher A. Magne R. Maes S. Maes Country France France France France France France Luxembourg France France Belgium Belgium Belgium Belgium Belgium Belgium Belgium France Italy Daly Belgiun Luxembourg Luxembourg Belgium France France France France France Belgium Benim 20 24 27 24 25 22 21 27 24 23 24 33 30 33 36 33 10 31 34 20 29 33 26 27 28 26 30 22 22 BE 21 24 25 IT FT BE LU LED BE FR 30 11 32 8888 FR FR FR BE 5235 Country France Italy 33 54 35 36 37 Age 26 24 30 26 34 30 31 26 33 23 29 30 29 23 ISO code FIL LI BE ER IT IT CH CH 39 40 41 42 43 44 122 FR ER FR TE SOURCES percento.com Dropout Course Average Year Stages Starters Finishers 1932 Dropouts distance, km Winner time km/h Winner 20 90 46 52 53 4,415 138h Sm 315 31.27 Ruapedie 96 55 41 43 1999 4,694 146h 29m 125 31.57 79 49 G. Bartali 30 33 4,224 132h 3m 17s 31.90 1947 21 100 5. Maes 53 47 4,542 31.41 145h 1m 25 3. Rabac 1948 21 120 44 76 63 4,922 33.44 1949 21 147h 10m 36s G. Bartal 120 55 65 54 4,000 140h 40m 49 32.12 1950 F. Coppi 22 116 51 65 56 4,773 1951 145h 36m 465 32.78 123 F. Kubier 24 66 57 46 4,690 1952 142h 20m 145 32.95 22 I koblet 78 44 4,690 1953 151h 57m 20 32.23 F. Cappe 22 119 76 43 36 4,476 129h 21m 25 34.59 1954 L. Bobet 23 110 69 41 37 4,656 1400 m 55 33.23 1955 Lbobet 130 09 61 47 4495 1 30 29 203 14.45 1956 L. Bebet 22 120 58 JZ 27 4,490 124111m 165 36:27 1957 R. Wakowiak 22 120 56 64 50 4,669 1950 1.35h 44m 42s 3452 24 120 1. Anquetil 28 42 35 4319 116 555 36.92 C. Gaul 1959 22 65 SS 45 4358 1960 121h 46m 450 35.47 F. Babamontes 22 128 81 47 37 4,123 112h 8m 429 37.21 1961 G. Nencini 21 132 72 45 4397 12h im 33 36.63 1962 22 149 94 J. Ang 55 ( 37 4,274 3732 1963 114h 31m 45s 21 1. Angel 130 76 54 42 4,138 113h 30m 5s 27.00 14 1. Anquetil 22 132 31 51 39 4,504 12 443 35.42 1955 Angueil 22 130 96 14 26 116 42m 6s 1966 35.89 F. Gimondi 22 130 82 13 37 1967 117h34m 235 36.76 L Amar 22 130 30 4 32 4,779 136 5m 50 34.76 1960 Pigeon 22 110 47 43 4,492 133649m 320 33.56 1969 22 130 36 2. Janssen 44 94 4,112 35.41 1970 116h 16m 2 150 E Merckx 22 100 110 m 498 Merck 20 130 94 96h 45m 14s 38.08 1028 E. Merckx 20 132 30 3,840 1922 100h 17m 103 3551 20 Merck 45 IP4 Land 1901.2017 15:41 Data APS421N0 Dupe APS APS Employeelata AP54044 APSAQSMS.TR 40 47 48 40 50 51 120 31 30 27 20 29 30 Belgium France Italy Italy Switzerland Switzerland Italy France France France France France Luxembourg Spain Italy France France France Prance Italy France France Netherlands Belgium Belum Delov Belgium TE 18 29 57 22 28 24 25 26 27 BE 254 300 CO GI BE 9141 ISO code 13 54 29 27 30 56 24 FR FR F N FR F 65 OC 34 29 20 23 125 72 73 34 75 SE Us TE 7 76 79 DO 81 82 Dropout Year Course Average Stages Starters Finishers Dropouts 96 1974 22 130 distance, km Winner time km/h Winner 105 25 19 4,098 1975 22 116h 16m 58s 140 35.24 E Merckx 16 54 4,000 22 114h35m 1976 130 34.91 B. Thevenet B7 43 23 4,017 3452 1977 22 116 22 23 100 L. Van mod 53 47 47 1978 4,096 22 110 115h 38m 30s 35.42 B. Thvenet 78 32 29 3.908 1979 150 108 18m Os 36.00 B. Hinault 90 60 40 3,75 1980 22 130 85 10h 6m 50s 36.51 B. Hinault 45 35 1981 3,842 509h 19m 145 35.14 24 150 1. Zoetemelk 121 29 19 3,753 1902 21 169 96 19m 38 38.96 B. Hinault 44 26 3,507 1993 22 92 am 30.06 140 B. Hint 55 52 37 3,809 1904 23 170 105h 7m 52s 36.23 Lignon 124 45 22 4,021 112h 3m 40s 1905 22 150 14 35.88 Lignan 36 20 4,109 1986 23 In 24m 23s 26.23 210 132 0. Hinault 78 32 4,094 1987 Iron 35m 19 25 202 37.02 135 3. LeMond 72 4,231 115 27m 425 1900 36.65 22 196 151 S. Roche 42 24 3,206 1989 21 198 14 27m 536 38.91 138 Delgado 60 30 1990 3,285 07h 30 356 198 37.49 21 156 G. Le Mond 42 21 1991 3.504 38.62 22 90 41m 20s 190 150 G. LeMond 40 20 3,914 1992 101h im 203 21 198 33.75 130 M. Indurain 68 34 1993 130 3,983 20 136 100 49m 30s 39.50 44 24 M Indurain 3,714 1994 38.24 21 956 57m 95 109 M Indurain 72 30 1995 3,970 Oh 30m 30s 29 109 3830 39 74 Indurain 3,635 1996 21 198 92 44m 59 39.19 120 69 35 M Indurain 3,765 1997 190 130 95h 52m 16s 30 3923 B, Ris 59 1990 3,950 toon 50m 35s 21 189 96 39,24 92 49 1. Ulrich 1999 3,895 20 92h 49m 465 39.90 100 141 39 22 M. Pantan 3,890 H521 40,20 2000 2: 172 123 25 Larong 2001 20 189 3,662 144 9 am 24 LO 45 3,458 2002 20 -HM 40.0 169 153 Ang 35 19 3,220 200320 110 82 512 39.93 147 SL 26 Ang 1903-2017 AP5401 Data APXo Dupe A P5402ab) AP540Xce Employee AP54040A PS105ASI J422 Bm 40 Limon 31 25 28 20 20 29 27 28 29 30 31 32 Country Belgium France Belgium France France France Netherlands France France France France France United States Ireland Spain United States United States Spain Spain Spain Spain Spain Denmark Germany taly United States United States U States United States us ES ES ES EW ZIT SIT 014 05 06 07 DK DC 20 28 H os 90 US US US US Us 33 32 w Dropouts Age 33 Finishers 147 155 139 14: ISO code US US ES es Year Stages Starters 2004 100 2005 189 2005 176 2007 189 2008 180 2009 180 2010 20 198 2011 19 51 2012 20 198 02 2013 198 23 2014 198 14 2015 195 05 2016 198 06 2017 21 198 07 06 AVERAGES 20.1 142.3 100 156 170 167 153 169 164 150 174 167 34 37 48 35 24 28 31 45 29 34 35 24 31 22 18 21 25 19 13 14 16 23 15 17 19 12 16 distance, km 3,391 3,593 3,657 3,570 3,550 3,460 3,642 3,630 3,497 3,404 3,659 3,360 3,535 7.540 Winner time 83 36 26 865 89h 39m 30s 91n Om 264 B7h 52m 525 85h 48m 355 91h 58m 485 36h 12m 22s 37H 34m 4s 83h Sm 40s 89h 59m 65 34h 46m 145 on 04m 485 36h 20m 55 km/h 40,55 4,65 40.78 39.23 40.49 40.32 39.59 39.79 39.88 40.55 40.69 39.64 39.62 41.00 Winner Armstrong Armstrong 0. Pereiro A Contador C. Sastre A. Contador A. Schleck C, Evans B. Wiggins C. Froome V. Nibali C. Froome C Froome C. Froome 30 24 33 26 25 34 32 29 29 31 32 33 Country United States United States Spain Spain Spain Spain Luxembourg Australia United Kingdom United Kingdom Italy United Kingdom United Kingdom United Kingdom SSSLEEEEEE GO 88.4 540 4232,4 341 1. The analytics data file: Tour de France winners.xlsx provides data for the years 1903-2017: (a) Create a pivot table to display the count of winners, the average % Dropout, and the average km/hr by country. What are these three values for the US? Age ISO code FR FR FR 7 8 9 10 11 12 11 14 15 LU FR SOURCE Woute barce.com Course Year Dropout Stages Starters Finishers Average 1903 Dropouts distance, km Winner time km/h 60 39 65 1900 2,428 94h 33m os 25.58 6 38 27 61 69 2,426 1905 11 60 96 Sm 365 25.27 24 36 1906 60 2,994 13 27.11 110h 26m 58s 82 14 6B 83 1907 4,637 $4 93 33 24.46 189h 34m Os 60 1900 44BB 14 112 35 158 45m 5s 28,47 75 66 1909 14 156h 53m 21 55 26.74 150 95 63 1910 4,497 157h im 22s 110 15 28.66 41 69 63 1911 4,734 162h 41m 30s 94 15 29 2910 56 67 1912 5,343 15 195h 37m Os 131 41 27.32 90 69 1913 15 5,299 190 30m 283 25 115 02 5,287 29.76 1914 26.72 15 145 197h 54m Os 54 93 63 1919 5,100 15 26.04 69 200 20m 400 11 58 84 1920 5,500 231h 7m 15 15 113 24.06 22 95 81 5,503 1921 15 228 om 131 123 30 24.07 85 69 1922 5,45 22n Som 260 24.72 15 123 33 1933 5,375 222n mos 15 139 24,20 40 91 65 5,106 1934 222 15mos 15 157 60 24.23 97 1925 62 5,425 130 220 in 210 24.25 49 21 62 5.440 1926 17 136 41 219 10m 10 25 24.02 1927 67 5,745 24 142 2h 4m 25s 30 24.27 1920 103 23 22 5.300 190 1420 162 41 29.22 121 1929 5,476 22 75 155 60 192h 4m 58s 26.40 95 61 1930 5,286 21 100 186 39m 16s 28 59 1931 41 41 4,022 25.00 24 1721 12m 165 35 1932 46 5,091 57 21 30 57 177h 10m 35 28.74 23 1933 29 23 4,429 154h 12m 59s 29.05 40 1934 40 50 4,395 23 39 147h Sim 37s 29.82 21 35 19:15 4,470 21 147h 13m 58s 30.36 51 43 4,239 141h 23mnos 47 30:65 1901-2017 A PS4Q1 Data APS492(No Opel A-P5402-) A PS426) Employee A-P5404 A-P5405(e) APS. 52 142h 47m2 ***************222scaszeneted =s sa38 3 Ba aasa 17 10 19 Winner M. Garin H. Cornet Trousselier R. Pottier L. Petit-Dreton L. Petit Breton F.Faber 0. Lapise G Garrigou 0. Defraye P. Thys P. Thys F. Lambot P. Thys L. Scieur F. Lambot H. Pelissier O Bottecchia O. Bottecchia L. Buys N. Fanta N Frantz M. Dewaele A. Leduca A Magne A. Leduca 6 Speicher A. Magne R. Maes S. Maes Country France France France France France France Luxembourg France France Belgium Belgium Belgium Belgium Belgium Belgium Belgium France Italy Daly Belgiun Luxembourg Luxembourg Belgium France France France France France Belgium Benim 20 24 27 24 25 22 21 27 24 23 24 33 30 33 36 33 10 31 34 20 29 33 26 27 28 26 30 22 22 BE 21 24 25 IT FT BE LU LED BE FR 30 11 32 8888 FR FR FR BE 5235 Country France Italy 33 54 35 36 37 Age 26 24 30 26 34 30 31 26 33 23 29 30 29 23 ISO code FIL LI BE ER IT IT CH CH 39 40 41 42 43 44 122 FR ER FR TE SOURCES percento.com Dropout Course Average Year Stages Starters Finishers 1932 Dropouts distance, km Winner time km/h Winner 20 90 46 52 53 4,415 138h Sm 315 31.27 Ruapedie 96 55 41 43 1999 4,694 146h 29m 125 31.57 79 49 G. Bartali 30 33 4,224 132h 3m 17s 31.90 1947 21 100 5. Maes 53 47 4,542 31.41 145h 1m 25 3. Rabac 1948 21 120 44 76 63 4,922 33.44 1949 21 147h 10m 36s G. Bartal 120 55 65 54 4,000 140h 40m 49 32.12 1950 F. Coppi 22 116 51 65 56 4,773 1951 145h 36m 465 32.78 123 F. Kubier 24 66 57 46 4,690 1952 142h 20m 145 32.95 22 I koblet 78 44 4,690 1953 151h 57m 20 32.23 F. Cappe 22 119 76 43 36 4,476 129h 21m 25 34.59 1954 L. Bobet 23 110 69 41 37 4,656 1400 m 55 33.23 1955 Lbobet 130 09 61 47 4495 1 30 29 203 14.45 1956 L. Bebet 22 120 58 JZ 27 4,490 124111m 165 36:27 1957 R. Wakowiak 22 120 56 64 50 4,669 1950 1.35h 44m 42s 3452 24 120 1. Anquetil 28 42 35 4319 116 555 36.92 C. Gaul 1959 22 65 SS 45 4358 1960 121h 46m 450 35.47 F. Babamontes 22 128 81 47 37 4,123 112h 8m 429 37.21 1961 G. Nencini 21 132 72 45 4397 12h im 33 36.63 1962 22 149 94 J. Ang 55 ( 37 4,274 3732 1963 114h 31m 45s 21 1. Angel 130 76 54 42 4,138 113h 30m 5s 27.00 14 1. Anquetil 22 132 31 51 39 4,504 12 443 35.42 1955 Angueil 22 130 96 14 26 116 42m 6s 1966 35.89 F. Gimondi 22 130 82 13 37 1967 117h34m 235 36.76 L Amar 22 130 30 4 32 4,779 136 5m 50 34.76 1960 Pigeon 22 110 47 43 4,492 133649m 320 33.56 1969 22 130 36 2. Janssen 44 94 4,112 35.41 1970 116h 16m 2 150 E Merckx 22 100 110 m 498 Merck 20 130 94 96h 45m 14s 38.08 1028 E. Merckx 20 132 30 3,840 1922 100h 17m 103 3551 20 Merck 45 IP4 Land 1901.2017 15:41 Data APS421N0 Dupe APS APS Employeelata AP54044 APSAQSMS.TR 40 47 48 40 50 51 120 31 30 27 20 29 30 Belgium France Italy Italy Switzerland Switzerland Italy France France France France France Luxembourg Spain Italy France France France Prance Italy France France Netherlands Belgium Belum Delov Belgium TE 18 29 57 22 28 24 25 26 27 BE 254 300 CO GI BE 9141 ISO code 13 54 29 27 30 56 24 FR FR F N FR F 65 OC 34 29 20 23 125 72 73 34 75 SE Us TE 7 76 79 DO 81 82 Dropout Year Course Average Stages Starters Finishers Dropouts 96 1974 22 130 distance, km Winner time km/h Winner 105 25 19 4,098 1975 22 116h 16m 58s 140 35.24 E Merckx 16 54 4,000 22 114h35m 1976 130 34.91 B. Thevenet B7 43 23 4,017 3452 1977 22 116 22 23 100 L. Van mod 53 47 47 1978 4,096 22 110 115h 38m 30s 35.42 B. Thvenet 78 32 29 3.908 1979 150 108 18m Os 36.00 B. Hinault 90 60 40 3,75 1980 22 130 85 10h 6m 50s 36.51 B. Hinault 45 35 1981 3,842 509h 19m 145 35.14 24 150 1. Zoetemelk 121 29 19 3,753 1902 21 169 96 19m 38 38.96 B. Hinault 44 26 3,507 1993 22 92 am 30.06 140 B. Hint 55 52 37 3,809 1904 23 170 105h 7m 52s 36.23 Lignon 124 45 22 4,021 112h 3m 40s 1905 22 150 14 35.88 Lignan 36 20 4,109 1986 23 In 24m 23s 26.23 210 132 0. Hinault 78 32 4,094 1987 Iron 35m 19 25 202 37.02 135 3. LeMond 72 4,231 115 27m 425 1900 36.65 22 196 151 S. Roche 42 24 3,206 1989 21 198 14 27m 536 38.91 138 Delgado 60 30 1990 3,285 07h 30 356 198 37.49 21 156 G. Le Mond 42 21 1991 3.504 38.62 22 90 41m 20s 190 150 G. LeMond 40 20 3,914 1992 101h im 203 21 198 33.75 130 M. Indurain 68 34 1993 130 3,983 20 136 100 49m 30s 39.50 44 24 M Indurain 3,714 1994 38.24 21 956 57m 95 109 M Indurain 72 30 1995 3,970 Oh 30m 30s 29 109 3830 39 74 Indurain 3,635 1996 21 198 92 44m 59 39.19 120 69 35 M Indurain 3,765 1997 190 130 95h 52m 16s 30 3923 B, Ris 59 1990 3,950 toon 50m 35s 21 189 96 39,24 92 49 1. Ulrich 1999 3,895 20 92h 49m 465 39.90 100 141 39 22 M. Pantan 3,890 H521 40,20 2000 2: 172 123 25 Larong 2001 20 189 3,662 144 9 am 24 LO 45 3,458 2002 20 -HM 40.0 169 153 Ang 35 19 3,220 200320 110 82 512 39.93 147 SL 26 Ang 1903-2017 AP5401 Data APXo Dupe A P5402ab) AP540Xce Employee AP54040A PS105ASI J422 Bm 40 Limon 31 25 28 20 20 29 27 28 29 30 31 32 Country Belgium France Belgium France France France Netherlands France France France France France United States Ireland Spain United States United States Spain Spain Spain Spain Spain Denmark Germany taly United States United States U States United States us ES ES ES EW ZIT SIT 014 05 06 07 DK DC 20 28 H os 90 US US US US Us 33 32 w Dropouts Age 33 Finishers 147 155 139 14: ISO code US US ES es Year Stages Starters 2004 100 2005 189 2005 176 2007 189 2008 180 2009 180 2010 20 198 2011 19 51 2012 20 198 02 2013 198 23 2014 198 14 2015 195 05 2016 198 06 2017 21 198 07 06 AVERAGES 20.1 142.3 100 156 170 167 153 169 164 150 174 167 34 37 48 35 24 28 31 45 29 34 35 24 31 22 18 21 25 19 13 14 16 23 15 17 19 12 16 distance, km 3,391 3,593 3,657 3,570 3,550 3,460 3,642 3,630 3,497 3,404 3,659 3,360 3,535 7.540 Winner time 83 36 26 865 89h 39m 30s 91n Om 264 B7h 52m 525 85h 48m 355 91h 58m 485 36h 12m 22s 37H 34m 4s 83h Sm 40s 89h 59m 65 34h 46m 145 on 04m 485 36h 20m 55 km/h 40,55 4,65 40.78 39.23 40.49 40.32 39.59 39.79 39.88 40.55 40.69 39.64 39.62 41.00 Winner Armstrong Armstrong 0. Pereiro A Contador C. Sastre A. Contador A. Schleck C, Evans B. Wiggins C. Froome V. Nibali C. Froome C Froome C. Froome 30 24 33 26 25 34 32 29 29 31 32 33 Country United States United States Spain Spain Spain Spain Luxembourg Australia United Kingdom United Kingdom Italy United Kingdom United Kingdom United Kingdom SSSLEEEEEE GO 88.4 540 4232,4 341 1. The analytics data file: Tour de France winners.xlsx provides data for the years 1903-2017: (a) Create a pivot table to display the count of winners, the average % Dropout, and the average km/hr by country. What are these three values for the US