![excel trendline set intercept excel trendline set intercept](https://i.stack.imgur.com/UhLGN.png)
![excel trendline set intercept excel trendline set intercept](https://data-flair.training/blogs/wp-content/uploads/sites/2/2020/02/edit-options.png)
You’ll find it way over on the right side of the ribbon: Follow the steps here to enable the Solver.Īfter the Add-In has been loaded, you can open the Solver from the Data tab. If you have never used the Solver Add-In before, you must first enable it. Next, enter some guess values for m and b into some cells on the worksheet. Let’s start again with the x- and y- data we had before.
![excel trendline set intercept excel trendline set intercept](http://www.tushar-mehta.com/publish_train/data_analysis/16_files/image002.gif)