Welcome to my blog!
This blog will be primarily aimed at innovative educational techniques but will however have the occasional post about education in general.

Friday, August 15, 2014

Google updates sheets to allow inserting Trendlines

Today ladies and gentlemen I am happy and sad at the same time.  As many of you are aware, I created an "add on" for Google Sheets to allow for adding trendlines to graphed data.  I recently made version 2 public (here is link Trendline Add on Ver 2).  In this version I included the statistical analysis to include showing the "r^2" value as well as the slope and y intercept.

I just learned today that Google has updated Sheets to allow.... wait for it.....  adding trendlines to a chart!!!

Here is a link to a GoogleGooru video that discusses adding trendlines: Adding Trendlines to Charts

Something that the video did not cover is how to show the "r^2" value and the equation of the trendline.  The "r^2" value is easy: there is a box that you can select to show it.  To show the equation you need to select the "Label" dropdown and choose "Use equation".

So, I am a sad that Google added something that I spent a lot of time and energy working on... but happy that they did so!!!