Finding Equations

[Phosphide]

Does excel have a built in ability to view the equation/function to the
computations I am looking for? For example, I did a linear regression model
and I get all these great statistics (T-stat, P-value, etc.). However, I want
to know what their equations are. Does anyone have a suggestion?

 

[Gord Dibben]

See Excel help on the functions under "regression"


Gord Dibben MS Excel MVP

 

[Phosphide]

There is only one or two equations but it doesn't describe the variables or
go into any details. Or did I miss something?

 

[Gord Dibben]

Excel 2003 under regression>About statistical analysis tools

Excel 2007 under regression>Perform statistical and engineering analysis
with the Analysis ToolPak

You will find the various functions and the equations and logic behind most
of them.


Gord

 

[Mike Middleton]

Phosphide -

In general, I suggest using Google or some other search engine to get more
information about regression equations.

For simple regression, i.e., for one explanatory X variable, some functions
are described in Excel's Help for "SLOPE function" and "INTERCEPT function."

However, to avoid rounding errors and other problems, the methods used for
computer computations may be different from the basic equation. For more
information, consult the computer science areas usually called "numerical
methods" or "numerical analysis."

For multiple regression, i.e., more than one explanatory X variable, the
"functions" are usually described using matrix algebra notation.

Excel's Regression tool uses the LINEST function for many calculations. For
information about Excel's LINEST function, see
http://support.microsoft.com/kb/828533

- Mike
http://www.MikeMiddleton.com



Does excel have a built in ability to view the equation/function to the
computations I am looking for? For example, I did a linear regression model
and I get all these great statistics (T-stat, P-value, etc.). However, I
want
to know what their equations are. Does anyone have a suggestion?