

 Thread Tools  Search this Thread 
#1
 
 
How LOGEST interacts with LINEST in Excel?
Hello friends, I have just started with the topic of the function that are statistical and used in Excel. I know the basic things of the functions that are used as statistics. But I am weak when there interaction comes. Now I am confused about an interaction that takes place between the Logest and Linest. So need your help for solving my doubt. Please tell me how LOGEST interacts with LINEST in Excel? Any other information related to the subject would also be helpful.!!
__________________ The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. Joe Martin 
#2
 
 
Re: How LOGEST interacts with LINEST in Excel?
To illustrate LOGEST with the third argument set to FALSE, follow these steps :

#3
 
 
Re: How LOGEST interacts with LINEST in Excel?
LOGEST data are in cells A4: B6. Detailed results for Excel 2002 and earlier versions of Excel and for Excel 2003 and later versions of Excel are presented in cells D4: E8 and G4: H8 cells, respectively. Cells A11: B13 show the same known_x, but have been turned on known_y 's in A4, A6 cells by pulling her by using natural logarithm function ln, Excel. LINEST is then drawn to these transformed data, and results are displayed in G11: H15 cells. Note that the results in cells G12: H15 are the same as the G5 LOGEST results: H8 cells. The coefficients LINEST in cells G11: H11 are converted to exponential. That is to say that the coefficients in LINEST cells are transformed using essentially the function EXP Excel to calculate the coefficients LOGEST in cells G4: H4. 
#4
 
 
Re: How LOGEST interacts with LINEST in Excel?
To summarize how LOGEST and LINEST interact, observe the following sequence of steps :
__________________ Just a reply to say thank you for these links and posts I have a lot to read and learn now! 
#5
 
 
Re: How LOGEST interacts with LINEST in Excel?
In Excel 2002 and earlier versions of Excel, when LINEST is called with its third argument set to FALSE, it always calculates a regression sum of squares which is not correct because it uses a formula that is not correct. This problem was corrected in Excel 2003 and in later versions of Excel. Note that the values in the first two rows in the output table are not affected by this problem. In Excel 2002 and earlier versions of Excel, LINEST describes a workaround to generate the appropriate values in the last three rows in the output table LINEST.
__________________ Dimension 1100 (FMY032J) minitower 2.53ghz Intel Pentium 4 80 gig nfts HDD 512 RAM Main circuit board: Dell 0CF458 BIOS: Dell A00 Display: Intel(R) 82865G Graphics Controller [Display adaptor] Multimedia: Sound MAX Integrated Digital Audio Windows XP Home SP2 
#6
 
 
Re: How LOGEST interacts with LINEST in Excel?
Problems have to be collinear in known_x LOGEST or LINEST in Microsoft Excel 2002 and in earlier versions of Excel. Predictor columns, the known_x are collinear if at least one column, c, can be expressed as a sum of many other users (c1, it and other values). Column C is called redundant because it contains information that can be built on columns (c1, it and other values). The fundamental principle in the presence of collinearity is that results should not be affected by whether a redundant column is included in the original data or removed from the original data. For the version LINEST in Microsoft Excel 2002 and in earlier versions of Excel do not search for collinearity, this principle was easily violated.
__________________ QTechnology UltraQuiet ATX PSU 460W I MSI K8N Neo4F I AMD Opteron 144 CABNE0545 2.66Ghz I 2 x 512MB RAM I 380GB Maxtor SATAI Raid0 Hard Drive I 40GB Maxtor IDE Hard Drive I Nvidia GeForce 7900GTX I Win XP Home Service Pack 2 I Soundblaster Xtreme Fidelity Fatal1ty I Mercury Home Theater HT4500 

Tags: autofit, excel, excel 2003, excel 2007, linest, logest 
Thread Tools  Search this Thread 

Similar Threads for: "How LOGEST interacts with LINEST in Excel?"  
Thread  Thread Starter  Forum  Replies  Last Post 
What are an improvements of LINEST function in Excel 2003?  SKREECH  Windows Software  5  13032010 05:14 AM 
Description of the LINEST function in Excel 2003  PsYcHo 1  Windows Software  5  13032010 04:47 AM 
What is the statistical function:LOGEST in Excel?  N I C K  Windows Software  5  13032010 03:55 AM 
How TREND interacts with LINEST in Excel?  Vandam  Windows Software  5  13032010 03:31 AM 
How GROWTH interacts with LOGEST in an Excel?  Author  Windows Software  5  13032010 01:26 AM 