quadratic

I currently use LINEST to generate non linear coefficients that I then use in VBA quadratic equations. However I now have the need to do this where there are multiple X values. Does anyone know of a solution to do this? Thank you 100 200 400 2 23 30 37 4 30 37 43 6 40 42 47 8 45 47...

I found UDF that gives the roots to ax^2+bx+c=0 using the quadratic formula. The roots are given in decimals. Is there an easy way to change the decimals to improper fractions? Example: for 15x^2+52x+45=0 the unction returns the roots as -1.8 and -1.667 each in separate cells. What I need is a...

All, I've read this helpful post here about solving four equations and four unknowns, but my question is how to solve four equations with four unknowns when unknowns are exponents? This is way beyond my math or excel abilities, long story, but I need to figure out some way to program this...

This is a bit more of a statistics problem than Excel problem, but thought I would give this forum another try since it worked so well in the past. In Excel I am trying to find the coefficients for a quadratic equation that best fits a set of data. After some incredibly helpful advice from this...

Hi all, This may be asking too much of Excel or VBA. I'm trying to generate the quadratic equation (ax^2 + bx + c) for a set of data using only VBA. I don't have the equation constants (a, b, and c), only the x and y coordinates. As a simple example (x,y): (0, 586) (1, 20450) (2, 46222) and...