We can chart a regression in Excel by highlighting the data and charting it as a scatter plot. To add a regression line, choose "Add Chart Element" from the "Chart Design" menu.

Want to get an idea of how to deal with a large amount of data? Trying to discern a pattern in your dataset? You're going to want to use LINEST, the Excel feature that runs a simple linear ...