Hacker News new | ask | show | jobs
by ungawatkt 996 days ago
my thought reading this quote was: If you squint and turn it sideways, that's a solver function.

Sure enough, slightly higher in the article: > “We use a circular reference in Excel to do linear regression.”

1 comments

Excel has a solver function. It’s called “Goal Seek” for one unknown or “solver” for multiple.

https://support.microsoft.com/en-us/office/use-goal-seek-to-...

https://support.microsoft.com/en-us/office/define-and-solve-...