Results 1 to 6 of 6

Thread: How LOGEST interacts with LINEST in Excel?

  1. #1
    Join Date
    Aug 2006
    Posts
    139

    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. #2
    Join Date
    May 2008
    Posts
    353

    Re: How LOGEST interacts with LINEST in Excel?

    To illustrate LOGEST with the third argument set to FALSE, follow these steps :
    1. Create an Excel spreadsheet empty. Then you will have to make the appropriate table. Or you can also copy it from the Microsoft site.
    2. After pasting the table into your new Excel worksheet, click Paste Options, then click Match formatting destination.
    3. When the pasted range is selected, use one of the following procedures, depending on the version of Excel you are running :
      • In Microsoft Excel 2007, click the Home tab, click Format in the Cells group, and then adjust the width of the column.
      • In Excel 2003 and in earlier versions of Excel, point to Column on the Format menu, then click AutoFit.

  3. #3
    Join Date
    May 2008
    Posts
    390

    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. #4
    Join Date
    Aug 2006
    Posts
    222

    Re: How LOGEST interacts with LINEST in Excel?

    To summarize how LOGEST and LINEST interact, observe the following sequence of steps :
    1. You call LOGEST (known_y's, known_x's, constant, TRUE).
    2. LOGEST calls LINEST (LN of known_y's, known_x's, constant, TRUE).
    3. LOGEST receives the results table for this call to LINEST.
    4. LOGEST changes LINEST coefficients in the first row of the result table in LINEST exponential. For example, replace each LINEST coefficient, m, by EXP (m).
    5. LOGEST returns this result table LINEST amended to you that the result table LOGEST.
    Just a reply to say thank you for these links and posts I have a lot to read and learn now!



  5. #5
    Join Date
    Aug 2006
    Posts
    287

    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) mini-tower
    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. #6
    Join Date
    Aug 2006
    Posts
    181

    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 Ultra-Quiet ATX PSU 460W I MSI K8N Neo4-F 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 HT-4500

Similar Threads

  1. What are an improvements of LINEST function in Excel 2003?
    By SKREECH in forum Windows Software
    Replies: 5
    Last Post: 13-03-2010, 05:14 AM
  2. Description of the LINEST function in Excel 2003
    By PsYcHo 1 in forum Windows Software
    Replies: 5
    Last Post: 13-03-2010, 04:47 AM
  3. What is the statistical function:LOGEST in Excel?
    By N I C K in forum Windows Software
    Replies: 5
    Last Post: 13-03-2010, 03:55 AM
  4. How TREND interacts with LINEST in Excel?
    By Vandam in forum Windows Software
    Replies: 5
    Last Post: 13-03-2010, 03:31 AM
  5. How GROWTH interacts with LOGEST in an Excel?
    By Author in forum Windows Software
    Replies: 5
    Last Post: 13-03-2010, 01:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •