How to Use Excel to Find the Mean, Median & Mode Ranges. Microsoft Excel 2010 is designed to store numerical inputs and permit calculation on those numbers, ... mode and range for a set of numbers.

The mode is the number or item that appears most frequently in a set of data. ... Que 2: Calculate the mode from the dataset below: Grades Obtained. Number of students. A - B. 24. C - D. 22.

Learn about and revise how to find the mean, median and mode averages from data with this BBC Bitesize GCSE Maths Edexcel study guide.