+ Reply to Thread
Results 1 to 2 of 2

Regression with blank values in x range

  1. #1
    Registered User
    Join Date
    06-03-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    33

    Regression with blank values in x range

    Hello,

    I am trying to run a regression but I have blank cells in my x range and my y range has none. I do not want to put a 0 in because my data will be skewed. Is there a way to put a placeholder to skip over those specific cells, meaning do not include them in the regression test. I am using the regression test in the data analysis tool pak.

    Example,

    Y X
    1 5
    2 3
    2
    8 1
    6
    1 5

    Thanks!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,759

    Re: Regression with blank values in x range

    The only way I know to do this is to completely remove the "blank" records from the dataset used in the regression. There are a few different strategies for this, and I am not sure which ones you will like. A couple of ideas:

    1) Use Advanced Filter to create a copy of the dataset that filters out the records where X is blank. Use the filtered list in the regression tool.
    2) Sort the dataset so that all of the blank X are at the bottom (or top) of the data set. With all of the filled cells in one block, it should be easy to specify only that block in the regression tool

    Or whatever strategy you come up with to remove the blank entries from the regression input.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fill blank range with corresponding values..
    By kay007 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2016, 10:02 AM
  2. Count Unique Values within range when other column is not blank
    By samn827 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2015, 09:50 AM
  3. Replies: 8
    Last Post: 03-31-2015, 01:06 PM
  4. Regression code that does not include blank pairs
    By mkeys4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 08:30 AM
  5. [SOLVED] Copy non blank cells in a range where there are certain values in another column
    By Knocknaboula in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 08:51 AM
  6. pick next blank cell in range to add some values.
    By cdafonseca in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2013, 03:15 PM
  7. [SOLVED] Creating a new worksheet by checking for blank values in a range
    By Geoff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2006, 05:35 PM

Tags for this Thread

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