Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Phosphide" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Equations appear as text | Excel Discussion (Misc queries) | |||
Equations | Excel Discussion (Misc queries) | |||
Trendline Equations | Charts and Charting in Excel | |||
Function equations | Excel Worksheet Functions | |||
Sorting by equations | Excel Worksheet Functions |