# Regression analysis code/ad in for Access

M

#### Michael

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

Ad

J

#### John Vinson

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.

G

#### GreySky

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

Ad

K

#### kalpanaganeshm

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.

## Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.