You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.

The resulting data and graph are shown below. The frequency is derived from the data using this formula: frequency = 300,000,000 m/s / (2 * half-wavelength measurement) ...

Find out how to solve simultaneous equations using a graph in this Bitesize KS3 maths video.