How to Find the Slope of a Line on an Excel Graph. In math and statistics, you may occasionally need to calculate the slope of a line generated by coordinates in the (x,y) format.

Revise how to work out the gradient of a straight line in maths and what formula to use to calculate the value change in this Bitesize guide.

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.