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!!!
No comments:
Post a Comment