Reviewing the above data please show what calculation formula would be used to determine the...

90.2K

Verified Solution

Question

Finance

image

Reviewing the above data please show what calculation formula would be used to determine the average for columns B, C, D, E, F G, H

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 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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students