+ Reply to Thread
Results 1 to 2 of 2

Linest formula

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    58

    Linest formula

    Can someone please tell me what this formulae does?

    =LINEST($L$7:$L$27,$E$7:$E$27^{1,2,3,4,5,6})

    more specifically the ^{1,2,3,4,5,6} part?

    Thanks in advance
    Lovi

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,369

    Re: Linest formula

    the {1,2,3,...} is an array constant. the ^ is the "raise to a power" operator. So this part raises the array of known_x's to each of those powers, resulting in an nx6 matrix that LINEST() uses to find the coefficients of a 6th order polynomial.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1