Question: Why not use Solver to optimize both the smoothing constant and the damping factor? Solver can't vary more than one input at a time. The
Why not use Solver to optimize both the smoothing constant and the damping factor? Solver can't vary more than one input at a time. The error correction form of the equation doesn't use the damping factor. The worksheet formulas automatically recalculate the damping factor when the smoothing constant changes. Solver won't let you constrain a variable cell
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
