Introduction
Noel Mitchell asked how to turn a long mathematical equation into an Excel equation and here is my reply.
Obviously, I have no idea which equation you are talking about but let me generalise a little. By the way, length of the equation could be a red herring.
- I am going to guess that a long equation contains several different variables
- I am going to guess that a long equation contains several different coefficients and possibly uses powers.
My equation, not so long, is Y = z + (aX)^2 + bX^(1/3) + cX + dX and in a situation like this, I would set out my work in this way:
Then I would apply what I have put into the input section in this way:
Consider the graph to be a bonus but I think it helps to prove the quality of my programming.
Since everything that might change is either in the input section or in the application table section, I can update any aspect of this worksheet in seconds.
No need for a downloadable file here, I think
Duncan Williamson
16th March 2020
No comments:
Post a Comment