An obvious story, perhaps, but one that demonstrates the ease and versatility of using a pivot table to sort your data. You can also use the data to create charts that will update themselves when you ...

Learn about calculating the mean, mode and range from a frequency table with this BBC Bitesize Maths article. For students between the ages of 11 and 14.

Learn about the mean, median, mode and range with BBC Bitesize Key Stage 3 Maths.

The Mode function in Excel returns the most frequently repetitive value in an array or range of data. The formula for Mode function is Mode( number1, [number2,..]).