Finding the Mathematical formula

Hi,

In short yes. You have two choices.

1. Either plot the line on a chart, right click the series and choose to add the trendline and tick the display formula option. The equation will then be shown on the chart.

2. Use the LINEST() function wrapped in an INDEX() function to evaluate the slope and intercept, i.e. the m and b values in the general equation y=mx + b

i.e. Slope

Please Login or Register  to view this content.

intercept

Please Login or Register  to view this content.

HTH