Danny's VBA Scripts

Linear Regression

• How To Make Your Own Wind Generator
• Get Everify To Uncover The Truth About Someone
• Designer brand names and fashions

Linear regression is not limited to the case of finding the least-squares slope and intercept of a straight line. Linear regression methods can be applied to any function that is linear in the coefficients . Many functions that produce curved x-y plots are linear in the coefficients, including power series, for example,

and some functions containing exponentials, such as

* Mathematically, a function that is linear in the coefficients is one for which the partial derivatives of the function with respect to the coefficients do not contain coefficients. For example, for the power series equation y = a + bx + cx2, dylda = 1, dy/db = x and dy/dc = x2.