Regression analysis code/ad in for Access

Discussion in 'Access VBA Modules' started by Michael, Jun 23, 2004.

  1. Michael

    Michael Guest

    Does anyone know of the location of a good access
    procedure or ad-in for linear regression analysis (I don't
    mind paying if its is only abailable commercially)

    Cheers
     
    Michael, Jun 23, 2004
    #1
    1. Advertisements

  2. Michael

    John Vinson Guest

    On Tue, 22 Jun 2004 23:56:07 -0700, "Michael"
    <> wrote:

    >Does anyone know of the location of a good access
    >procedure or ad-in for linear regression analysis (I don't
    >mind paying if its is only abailable commercially)
    >
    >Cheers


    Look for "Total Access Statistics" at http://www.fmsinc.com. I haven't
    used it but some of my friends and clients swear by it.

    John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
    http://go.compuserve.com/msdevapps?loc=us&access=public
     
    John Vinson, Jun 23, 2004
    #2
    1. Advertisements

  3. Michael

    Michael Guest

    Thanks John


    >-----Original Message-----
    >On Tue, 22 Jun 2004 23:56:07 -0700, "Michael"
    ><> wrote:
    >
    >>Does anyone know of the location of a good access
    >>procedure or ad-in for linear regression analysis (I

    don't
    >>mind paying if its is only abailable commercially)
    >>
    >>Cheers

    >
    >Look for "Total Access Statistics" at

    http://www.fmsinc.com. I haven't
    >used it but some of my friends and clients swear by it.
    >
    > John W. Vinson[MVP]
    > Come for live chats every Tuesday and Thursday
    >http://go.compuserve.com/msdevapps?loc=us&access=public
    >.
    >
     
    Michael, Jun 24, 2004
    #3
  4. Michael

    GreySky Guest

    You can locate the formulas required for linear regression, and convert those to formulas required.

    I had to do this here (I work for a major investment institution) in order to calculate betas (i.e., how closely a portfolio tracks its benchmark) and correlation coefficients (this one's even more fun). It's by no means rocket science; rather, being able to read a little math-geek (aka calculus) and converting it to a relevant expression.

    Beta: (Sum([q].[Benchmark]*[q].[Composite])-Sum([q].[Benchmark])*Sum([q].[Composite])/Count(*))/(Sum([q].[Benchmark]*[q].[Benchmark])-Sum([q].[Benchmark])*Sum([q].[Benchmark])/Count(*))

    This Beta is a linear regression. The inputs are Benchmark returns and Composite returns. If I have x movement in the benchmark, how much movement do I get in comparison in my portfolio? That's a beta. Take my [Benchmark] and [Composite] fields and substitute them for your values you are attempting to regress against linearly.

    In case you care to see correlation of coefficients:

    r: ((Sum([a].[Gross]*.[Gross])-Sum([a].[Gross])*Sum(.[Gross])/Count(*)))/(Sqr(CDbl(nz((Sum([a].[Gross]*[a].[Gross])-Sum([a].[Gross])*Sum([a].[Gross])/Count(*))*(Sum(.[Gross]*.[Gross])-Sum(.[Gross])*Sum(.[Gross])/Count(*))))))

    In this case, take two distinct gross returns (before fees applied to the investment returns), as identified by [a] and . How well do these correlate? This is interesting in terms of comparing differing investment products to see how the returns compare on a period-by-period basis.

    David Atkins, MCP





    "Michael" wrote:

    > Does anyone know of the location of a good access
    > procedure or ad-in for linear regression analysis (I don't
    > mind paying if its is only abailable commercially)
    >
    > Cheers
    >
     
    GreySky, Jun 26, 2004
    #4
  5. Michael

    Guest

    Informatics Outsourcing is an Offshore Market Research service company for Clinical Research, Bio Chemistry, Bio Technologies. Market Research services includes both Quantitative and Qualitative Market Research services Worldwide with affordable price.
     
    , Nov 30, 2012
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rob Hick

    speed up vba data analysis function

    Rob Hick, Sep 15, 2003, in forum: Access VBA Modules
    Replies:
    8
    Views:
    101
    Rob Hick
    Sep 22, 2003
  2. John Halloran

    Problem converting VB Code from Access 2.0 to Access 2003

    John Halloran, Jun 1, 2004, in forum: Access VBA Modules
    Replies:
    7
    Views:
    150
    Alex Dybenko
    Jun 2, 2004
  3. JMG

    Principal component analysis

    JMG, Nov 18, 2004, in forum: Access VBA Modules
    Replies:
    0
    Views:
    104
  4. Phred Bear
    Replies:
    7
    Views:
    129
    Dave Patrick
    Jan 26, 2005
  5. BlockNinja
    Replies:
    3
    Views:
    210
    BlockNinja
    Jan 2, 2006
  6. John Luquer
    Replies:
    5
    Views:
    220
  7. WhatTha
    Replies:
    0
    Views:
    271
    WhatTha
    Jan 24, 2006
  8. Patrice

    Linear regression - Statistic

    Patrice, Feb 6, 2008, in forum: Access VBA Modules
    Replies:
    1
    Views:
    79
    Patrice
    Feb 19, 2008
Loading...