4 ms·
I'm confused about the circular reference thing. Like, was there a reason to do the linear regression that way? Is there a secret story in a story where next we
by abeppu 3y ago
I'm confused about the circular reference thing. Like, was there a reason to do the linear regression that way? Is there a secret story in a story where next week, in a spinoff / sequel episode, the data scientist responsible will explain why they took the weird/surprising choices they did?
- andy81 3y agoI used it once to run a Monte-Carlo simulation in a spreadsheet. After enabling iterative calculation and manual calculation, every press of refresh runs a loop. Fun stuff.
- DwnVoteHoneyPot 3y agoIt's a common excel trick in finance. For example, let say you have $0. If you borrow $1,000,000 at 5% interest, by end of year you'll be short $50k. That means you actually needed to borrow $1,050,000. But the extra $50K causes more interest ($2,500)... so you needed to borrow $1,052,500, which causes more interest... and so on. Instead of doing some Excel Goal Seek or Solver or VBA macro, it's nice to let the excel "reactivity" handle it for you.
- hu3 3y agoYour explanation is brilliant!
- DrDroop 3y agoI didn't know you could do this in excel but it reminded me of the converge adverb in k: https://xpqz.github.io/kbook/Adverbs.html#converge-f-f https://xpqz.github.io/kbook/Adverbs.html#converge-f-f
- itigtohft 3y agohttps://en.wikipedia.org/wiki/Fixed-point_iteration https://en.wikipedia.org/wiki/Fixed-point_iteration