Column1 Race A Race B Race C SUM AVERAGE MAX MIN
Mike 6.75 6.56 6.55 19.86 6.62 6.75 6.55
Jane 6.20 5.35 5.60 17.15 5.72 6.20 5.35
Chen 4.62 5.56 5.25 15.43 5.14 5.56 4.62
Javier 5.42 4.52 4.51 14.45 4.82 5.42 4.51
Total Entries
in Race A 4
Delete Race D data
avg
max
min
2 dec places
Race B imp over Race A
Move Javiers data above Mike's data
Delete Janet's data
Sort by Average on Values, with Order Largest to Smallest
Select all your data and Format as a Table, Select one of the Light Table Styles
Count Entries in Race A and place the formula and data for the count in cell A10
Race B Max/Min
Improvement Difference
0.19 0.20
0.85 0.85
-0.94 0.94
0.90 0.91
Race A Race B Race C Race D
Jane 6.20 5.35 5.60 5.42
Javier 5.42 4.52 4.51 4.21
Mike 6.75 6.56 6.55 2.65
Chen 4.62 5.56 5.25 2.65