Interactive MS Excel Spreadsheet. Requires macros to be enabled. Contents: Describe the correlation and relationship shown by a scatter graph. Draw a scatter graph and a line of best fit excluding any outliers. Draw a scatter graph and use a line of best fit to estimate values. +ve correlation, y > x +ve correlation, y ≈ x, –ve correlation, y > x, –ve correlation, y ≈ x, Model the relationship between values using regression line analysis.