+ Reply to Thread
Results 1 to 2 of 2

Help understanding the use of Linest function

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Help understanding the use of Linest function

    I understand this is a bit more of a math question than an excel question, so if it's beyond the scope of this forum that's okay. I'm trying to model multi variable linear regression. I have all the data I need but I don't really understand what the data means. I know it gives me beta/slope values for each variable, but where I get lost is how the beta values are affected by co linearity. I know that somehow each beta value represents how much that variable adds relative to the other variables but I'm not sure what to do with that information, or how you're able to determine how much information is added. Lastly I don't really know what to do with this information. I'm supposed to create a model that determines the highest chance of achieving a y value of 1 (indicating a credit card default in this context), but I'm not sure how to use the linest results to do that.

    I've included a screenshot of the data with the linest function applied. For some reason the attachment button isn't working so a screenshot will have to do until I can get it to work. Sorry!

    linest screenshot.JPG

  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Help understanding the use of Linest function

    You don't say how you are trying to upload the sample file. If you are trying to use the attach button, you should be made aware that it doesn't work (and hasn't for a long time). The only reliable way I am aware of for uploading files to the forum is to click on "go advance" or "reply to thread" to bring up the main post editing window. Below the message box is a "manage attachments" link that will bring up the file uploader that you can use to upload files and they will attach to your post.

    I'm not sure I understand your question, or if we even have a statistician who would adequately understand the issues around collinearity.

    A quick internet search found:
    Wikipedia: https://en.wikipedia.org/wiki/Multicollinearity
    a Penn State lesson outline: https://onlinecourses.science.psu.edu/stat501/node/345
    I find a bias against Excel among many statisticians, but this guy specifically targets the Excel audience: http://www.real-statistics.com/multi.../collinearity/

    There are many other internet resources for studying collinearity. Your question sounds more like you want to understand the statistics behind collinearity. I expect that once you review the statistics, programming the collinearity tests into Excel will be much easier.

    As for the question of using the results, the output of a multivariate regression should be an equation something like y=m1x1+m2x2+m3x3+... Once you have the m's from the LINEST() function, you should be able to put your values for the x's in and calculate y, or whatever you need to do.

    Does any of that help?
    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] VBA + LINEST Function
    By ryllex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2013, 08:20 AM
  2. [SOLVED] Linest Function - Unable to get LinEst property of the WorksheetFunction class
    By fbs13 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-25-2013, 09:55 AM
  3. Linest function help
    By GreggEdwards in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-26-2011, 09:40 PM
  4. [SOLVED] linest function
    By Mitch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 06:50 PM
  5. Linest Function
    By lucstruggler in forum Excel General
    Replies: 0
    Last Post: 03-23-2005, 02:17 AM
  6. LINEST Function
    By sydodman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2005, 07:16 AM
  7. LINEST Function
    By sydodman in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-01-2005, 03:38 AM

Tags for this Thread


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