3 ms·
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 circu
by ungawatkt 3y 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.”
- seanhunter 3y agoExcel 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-find-the-result-you-want-by-adjusting-an-input-value-320cb99e-f4a4-417f-b1c3-4f369d6e66c7 https://support.microsoft.com/en-us/office/use-goal-seek-to-... https://support.microsoft.com/en-us/office/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040 https://support.microsoft.com/en-us/office/define-and-solve-...