The Holy Grail of Graphing on iPad: Trend Line & Coefficient of Determination (for free)

It's been the Holy Grail of graphing problems on the iPad for a long time now: creating scatterplot graphs with trend line and r2 value. The Numbers app is great (and free with new iPads) but for high school science teachers it has one huge epic fail: graphs can't display trend lines or the coefficients of determination. There have been a number of workarounds for this issue but there is finally a simple way to do it using Excel for iPad.

The Excel app for iPad has been free since it came out but it could only open and view Excel spreadsheets, not create or edit them. All that changed a few days ago when Microsoft announced they were making some functions in the Excel app available for free with additional features only available with an Office 365 subscription.

When I did my first test I signed into the app with my Microsoft account but I'm not sure if that's required.

What do you think - will the free Excel app help your students do better work in science class? Were you able to skip signing in with your Microsoft account? Let us know in the comments!