#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default Finding Equations

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Equations appear as text Dennis Excel Discussion (Misc queries) 1 June 26th 08 12:20 AM
Equations [email protected] Excel Discussion (Misc queries) 8 February 23rd 07 07:46 PM
Trendline Equations Steve Morris Charts and Charting in Excel 1 January 11th 06 04:56 PM
Function equations Judge Excel Worksheet Functions 5 January 24th 05 07:11 AM
Sorting by equations cpastor Excel Worksheet Functions 1 December 20th 04 03:15 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"