How to Estimate the Y Intercept in Excel. When you graph a series of (x,y) coordinates in Microsoft Excel 2010, you can use the program's built-in functions to display the equation for the line ...

In Microsoft Excel, using a scatter chart allows you to plot the data points against the probability of achieving each observed data point.