Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend.

A linear relationship (or linear association) is a statistical term used to describe the directly proportional relationship between a variable and a constant.

Correlation is a statistical measure of how two securities move in relation to each other. Investors use correlation to diversify their portfolios and hedge against risk.