Results 1 to 6 of 6

Regression failure - but why?

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2020
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    3

    Regression failure - but why?

    I'm trying to run a regression analysis on the data, but everytime I include December, it somehow fails with #NUM on the regression.

    If I exclude december tho, it success, but I need the last month in order to make the function.

    I have run a value() on all the numbers to make sure it's numeric.

    I have success with these combinations:

    Sales (Y) + C20 (X) + Temp (X) +Months -December (X) => Works fine!
    Sales (Y) + All months (X) => Works fine!
    Sales (Y) + All variables (X) => Doesn't work


    Can anyone tell me why?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Logistic Regression/Regression to predict if Item will sell or not based on ratings
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2019, 10:01 AM
  2. automative Regression, Macro, update regression with new values
    By #läuftbeimir?! in forum Excel General
    Replies: 6
    Last Post: 12-17-2018, 04:49 PM
  3. Replies: 0
    Last Post: 10-14-2018, 08:38 PM
  4. IF Failure ?
    By lbdyck in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2018, 09:01 PM
  5. Do...Loop failure!
    By foxtrotdelta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2008, 09:17 AM

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