+ Reply to Thread
Results 1 to 4 of 4

Regression returns Linest() error

  1. #1
    Registered User
    Join Date
    03-25-2016
    Location
    the moon
    MS-Off Ver
    office 365
    Posts
    2

    Regression returns Linest() error

    Regression keeps returning Linest error. All values are numbers (although I've tried as general as well). What's the deal? Thanks in advance!

    X Y (I cant get Y to line up. the left column is an x variable and the right column is my y variable)
    1.7 13%
    1.7 13%
    1.7 27%
    2.0 -7%
    2.0 11%
    2.0 20%
    2.0 26%
    2.0 8%
    2.0 11%
    2.0 15%
    2.0 17%
    2.0 18%
    2.0 19%
    2.0 20%
    2.0 20%
    2.0 20%
    2.0 23%
    2.0 24%
    2.0 37%
    2.0 40%
    2.0 36%
    3.2 18%
    3.2 27%
    3.2 19%
    3.2 18%
    3.5 43%
    3.5 20%
    3.5 20%
    3.5 21%
    3.5 29%
    3.5 32%
    3.5 22%
    3.9 16%
    3.9 10%
    3.9 15%
    3.9 23%
    3.9 26%
    3.9 29%
    3.9 71%
    4.6 56%
    4.7 19%
    4.7 34%
    5.1 33%
    5.1 35%
    5.1 22%
    5.1 23%
    5.1 23%
    5.1 26%
    6.1 15%
    6.1 53%
    6.2 59%
    6.2 70%
    6.2 20%
    6.2 73%
    6.5 -14%
    6.5 25%
    6.5 10%
    6.5 10%
    6.5 14%
    6.5 14%
    6.5 15%
    6.5 16%
    6.5 24%
    6.5 25%
    6.5 29%
    6.5 29%
    6.5 7%
    6.5 15%
    6.5 51%
    7.1 72%
    7.2 25%
    7.2 7%
    7.2 26%
    7.2 -9%
    7.5 23%
    7.5 16%
    7.5 17%
    7.5 24%
    7.5 27%
    7.5 35%
    7.5 44%
    8.0 -4%
    8.5 -49%
    8.5 4%
    8.5 18%
    8.5 24%
    8.5 32%
    8.5 0%
    8.5 5%
    8.5 10%
    8.5 13%
    8.5 13%
    8.5 18%
    8.5 29%
    8.5 30%
    8.5 34%
    8.5 50%
    8.7 9%
    8.7 10%
    8.7 10%
    8.7 22%
    8.7 35%
    8.7 53%
    8.7 50%
    9.0 20%
    9.0 64%
    9.2 65%
    9.7 44%
    10.3 35%
    10.6 14%
    10.6 14%
    10.7 22%
    10.7 26%
    10.7 44%
    10.7 44%
    10.7 6%
    10.7 10%
    10.7 12%
    10.7 12%
    10.7 13%
    10.7 15%
    10.7 17%
    10.7 17%
    10.7 18%
    10.7 22%
    10.7 23%
    10.7 25%
    10.7 26%
    10.7 27%
    10.7 32%
    10.7 33%
    10.7 36%
    10.7 36%
    10.7 37%
    10.7 38%
    10.7 38%
    10.7 39%
    10.7 39%
    10.7 39%
    10.7 43%
    10.7 45%
    10.7 50%
    10.7 54%
    10.7 54%
    10.6 64%
    10.6 12%
    10.7 37%
    10.7 38%
    10.6 61%
    10.6 69%
    10.7 74%
    11.8 10%
    11.8 27%
    11.8 35%
    12.1 62%
    12.2 38%
    14.1 27%
    14.1 40%
    14.1 48%
    14.1 8%
    14.1 8%
    14.1 19%
    14.6 47%
    15.2 30%
    15.2 32%
    15.2 34%
    15.2 37%
    15.2 40%
    15.5 21%
    15.5 24%
    15.5 34%
    15.5 56%
    15.5 19%
    15.5 38%
    15.5 -28%
    17.5 8%
    17.5 9%
    17.5 9%
    17.5 18%
    17.5 23%
    17.5 25%
    17.5 32%
    18.7 26%
    19.3 -16%
    19.3 21%
    19.3 24%
    21.9 21%
    22.3 26%
    22.3 -27%
    22.3 16%
    22.3 20%
    22.3 29%
    22.3 31%
    22.3 32%
    22.3 80%
    22.3 32%
    23.6 27%
    23.6 -33%
    23.6 5%
    24.2 21%
    24.2 26%
    24.2 8%
    24.2 29%
    24.4 24%
    24.4 15%
    24.4 18%
    24.4 18%
    24.4 21%
    24.4 24%
    24.4 29%
    24.4 33%
    24.4 37%
    24.4 -43%
    26.1 15%
    26.6 -28%
    26.6 8%
    26.6 15%
    26.6 20%
    26.6 21%
    26.6 24%
    26.6 24%
    26.6 33%
    26.6 8%
    26.6 11%
    26.6 11%
    26.6 14%
    26.6 18%
    26.6 20%
    26.6 20%
    26.6 21%
    26.6 22%
    26.6 22%
    26.6 25%
    26.6 26%
    26.6 26%
    26.6 26%
    26.6 31%
    26.6 32%
    26.6 36%
    26.6 33%
    27.4 7%
    27.4 13%
    27.4 15%
    27.4 17%
    27.4 25%
    27.4 26%
    27.4 30%
    27.4 31%
    31.0 13%
    31.0 48%
    31.3 14%
    33.5 -8%
    33.5 20%
    33.5 39%
    33.5 64%
    34.8 0%
    36.6 9%
    36.6 16%
    36.6 68%
    37.1 20%
    38.4 46%
    42.2 21%
    42.2 23%
    42.2 33%
    42.2 44%
    48.5 38%
    53.1 52%
    58.0 17%
    58.0 19%
    61.2 47%
    61.8 26%
    66.7 29%
    66.7 35%
    66.7 7%
    66.7 13%
    66.7 18%
    66.7 35%
    68.5 35%
    70.5 17%
    70.5 26%
    70.5 -29%
    70.5 -17%
    70.5 19%
    70.5 28%
    70.5 52%
    70.5 6%
    70.5 25%
    70.5 19%
    70.6 46%
    70.6 27%
    74.8 33%
    74.8 13%
    74.8 34%
    77.4 55%
    90.0 44%
    90.0 -2%
    90.0 61%
    94.0 13%
    95.4 -27%
    95.4 12%
    95.4 7%
    95.4 2%
    95.4 51%
    112.2 11%
    122.2 39%
    122.2 31%
    134.0 26%
    134.0 15%
    142.8 20%
    142.8 25%
    142.8 49%
    142.8 65%
    142.8 28%
    142.8 29%
    142.8 31%
    167.3 33%
    167.3 -32%
    167.3 9%
    167.3 35%
    175.2 16%
    175.2 21%
    175.2 26%
    175.2 27%
    175.2 37%
    175.2 37%
    207.3 11%
    207.3 11%
    207.3 15%
    207.3 15%
    207.3 17%
    207.3 19%
    207.3 22%
    207.3 25%
    207.3 27%
    207.3 29%
    207.3 30%
    207.3 41%
    207.3 63%
    207.3 75%
    207.3 9%
    207.3 18%
    236.0 -7%
    249.2 38%
    249.2 23%
    249.2 31%
    249.9 -20%
    249.9 11%
    249.9 21%
    249.9 22%
    249.9 24%
    249.9 58%
    254.9 26%
    261.0 29%
    279.7 81%
    296.5 17%
    296.5 27%
    475.4 23%
    559.6 -7%
    559.6 6%
    559.6 12%
    559.6 48%
    570.6 -12%
    570.6 34%
    570.6 10%
    715.6 39%
    715.6 24%
    715.6 25%
    715.6 26%
    1141.1 44%
    1141.1 22%
    1141.1 33%
    1368.5 19%
    1486.1 22%
    2764.9 -11%
    2764.9 20%
    2764.9 7%
    2764.9 14%
    2764.9 17%
    2764.9 19%
    2764.9 20%
    2764.9 21%
    2764.9 23%
    2764.9 23%
    2764.9 26%
    2764.9 38%
    2767.0 26%
    2767.0 16%
    2767.0 24%
    2769.7 0%
    2769.7 17%
    2769.7 73%
    2771.8 -13%
    2771.8 12%
    2771.8 28%
    2771.8 30%
    2771.8 64%
    2771.8 38%

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Regression returns Linest() error

    I get -9.83524E-06 which is really close to zero? - Is that your sample?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    03-25-2016
    Location
    the moon
    MS-Off Ver
    office 365
    Posts
    2

    Re: Regression returns Linest() error

    Ultimately, I got this to work by copy/pasting my dataset into a new workbook and then simply running the regression from there!
    I don't recall what my results were, they were not found to be statistically significant so I deleted the regression and moved on with my analysis.

    Thanks anyway!

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Regression returns Linest() error

    You're welcome!

+ 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. LINEST / Regression skipping blanks help
    By smeador in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-01-2014, 03:33 AM
  2. LinEst for polynomial regression in VBA - error...
    By IDidNotWantToRegiste in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2014, 11:03 PM
  3. LINEST for specifying polynomial regression function
    By InderpalHothi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-27-2014, 03:11 PM
  4. [SOLVED] trend/linest regression error
    By MrShorty in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-07-2013, 01:16 PM
  5. Regression - Predicting trends with LINEST
    By excelbuddy82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2013, 11:34 AM
  6. Help with multiple regression using LINEST function
    By joe71010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2013, 11:56 AM
  7. Replies: 0
    Last Post: 08-21-2005, 04:05 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