Results 1 to 4 of 4

LINEST and managing missing values

Threaded View

  1. #1
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile LINEST and managing missing values

    The attached worksheet describes how a second order polynomial has been characterized not only in the graph but, more importantly, in the context of the worksheet.
    If one deletes any of the data values an error occurs in the array field.
    My question is how can one compensate for this. NA() also does not work.
    Unfortunately, in real life, one can not assume that real values will always be available.

    Stephen Druley
    Attached Files Attached Files

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