70.2K

Verified Solution

Link Copied!

Using excel what formula would you use to get the average for column B,C,D,E,F, H? Please show on excel the steps required and the formula

A B D E TI F G H NMD 1 Year 2 1903 3 1904 4 1905 5 1906 6 1907 7 1908 8 1909 9 1910 10 1911 11 1912 12 1913 13 1914 14 1919 15 1920 16 1921 17 1922 18 1923 19 1924 20 1925 Winner's avg speed 25.68 25.27 27.11 24.46 28.47 28.74 28.66 29.10 27.32 27.76 26.72 26.84 24.06 24.07 24.72 24.20 24.23 24.25 24.82 Total distance (km) 2,428.00 2,420.00 2,994.00 4,545.00 4,488.00 4,488.00 4,497.00 4,737.00 5,344.00 5,289.00 5,287.00 5,380.00 5,560.00 5,503.00 5,485.00 5,375.00 5,386.00 5,425.00 5,440.00 Number of stages 6.00 6.00 11.00 13.00 14.00 14.00 14.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 18.00 Finishers 21.00 27.00 24.00 14.00 33.00 36.00 55.00 41.00 28.00 41.00 25.00 54.00 10.00 22.00 38.00 38.00 48.00 60.00 49.00 Entrants Winner 60.00 Maurice Garin 88.00 Henri Cornet 60.00 Louis Trousselier 82.00 Ren Pottier 93.00 Lucien Petit-Breton 112.00 Lucien Petit-Breton 150.00 Franois Faber 110.00 Octave Lapize 84.00 Gustave Garrigou 131.00 Odile Defraye 140.00 Philippe Thys 145.00 Philippe Thys 69.00 Firmin Lambot 113.00 Philippe Thys 123.00 Lon Scieur 121.00 Firmin Lambot 139.00 Henri Plissier 157.00 Ottavio Bottecchia 130.00 Ottavio Bottecchia IWinner's Nationality France France France France France France Luxembourg France France Belgium Belgium Belgium Belgium Belgium Belgium Belgium France Italy Italy

Answer & Explanation Solved by verified expert

See Answer