Regression Using Google Sheets

sheets_reg_01Not long ago, Microsoft Excel was the go to tool for making scatter plots and modeling data with regression functions. For the last ten years my students have used Excel to model data in projects. For many students wishing to use Excel on their own computers, Excel was an expensive purchase.

Other students wanted to save money and used ancient versions of Excel that were difficult to use. This was particularly aggravating to me since I had to help them find their models in Excel 2003, 2010, and 2013. The process was different in each platform.

This encouraged me to look at other ways of making pretty graphs with models. Google Sheets was particularly attractive because of its cost…free. Last summer Google added a simple way of adding a regression model to a scatter plot in Sheets. Now you can do just about everything you might want to do in College Algebra or Finite Mathematics in Google Sheets. And you get the added benefit of a single, free, platform in the Google ecosystem.

Continue to PBLPathways.com for more >