![]() ![]() I just find it easier to write formulas like this in smaller bites rather than put the whole thing into a single cell. You can use TREND for polynomial curve fitting by regressing against the same variable raised to different powers. =(-B-sqrt(disc))/2/A or -B/2/A-sqrt(disc)/2/A or -B/(2*A)-sqrt(disc)/(2*A) or whatever configuration you want. TREND (knowny's, knownx's, newx's, const) The TREND function syntax has the following arguments: Remarks For information about how Microsoft Excel fits a line to data, see LINEST. ![]() With individual cells for A, B, C and the discriminant, then the final formulas are much easier to write. Having the discriminant calculate separately, you can then test the discriminant's sign and either block the calculation (if you are only interested in real roots) or branch off into complex roots when needed. This can be a useful calculation, because the sign on the discriminant will tell you if the roots of the equation are real or complex. Then I would have a cell that calculates the "discriminant" (b^2-4ac). For example, in this case, I would probably have separate cell for A, B, and C (=c-y). I often find it easier to build them if I use multiple cells for the calculation. ![]() I don't have any magic solutions for building formulas like this that require a lot of brackets. You will also see that it is not dividing by 2a at all, but dividing by 2 then multiplying by a. If you follow the calculation (maybe using the formula evaluation tool ), you will see that it is not dividing the initial 0.514 by 2a. Have I got the brackets in the wrong place
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |