Regression

If you want to check your calculations for a regression line and see the line then Excel and WolframAlpha are both very easy to use. In Excel – just add the data, insert a chart – choose Scatter, then add a trend line.

Regression Excel

…or let WolframAlpha do all the work for you (including a plot)!

WolframAlphaRegression

WolframAlpha Regression

You could also use Desmos. Their video gives clear instructions:

For another example with an A Level question (using the same data as for Excel and WolframAlpha above) check this slideshow.

Try this least squares demonstration on GeoGebra.
GeoGebra least squares

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s