Line-fitting and scatter-plots

Video: Regression 1 - Line-fitting and scatter-plots in Excel

The first step in doing a regression in Excel is to fit the line using a Scatter plot. This video shows how to do this, illustrated by the story of Helen and the effect of temperature on her sales of choconutties.

This video is available through Statistics Learning Centre. Supporting resources on Statistics Learning Centre include quizzes and notes in NZ Statistics Level 3.