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.

Google Sheets offers seamless compatibility with Microsoft Excel, allowing users to export their spreadsheets, complete with graphs, into Excel's format. Click File in the toolbar.

In Microsoft Excel your spreadsheet should allow the inclusion of new data to a series of data points and have the average updated to reflect the new information.

Tired of erasing holes in your graph paper or having to start over from scratch? Here's an easy way to create your own custom graph paper in Excel.