At 4:16 PM +0200 7/1/00, dekkers wrote:
>Hi,
>
>Does someone know were I can download an EXCEL macro for lin reg?
>Besides it calculates the y=bx+a I like the possibility to give Y and
>then the macro calculates the x with s.
>
>thanks
>
>ad dekkers
>
>
Do you really want a macro?
There are four ways to do regression with Excel. Download the file Reg.xls
from http://www.wabash.edu/econometrics
If you really want a macro, you can use
Application.WorksheetFunction(Linest()) to get estimates, SEs, and other
LINEST output.
Hope that helps,
Bert
***********************
Humberto Barreto
Department of Economics
Wabash College
Crawfordsville, IN 47933
Phone: 765-361-6315
FAX: 765-361-6277
Email: [EMAIL PROTECTED]
WWW: http://www.wabash.edu/depart/economic/barretoh/barretoh.html
===========================================================================
This list is open to everyone. Occasionally, less thoughtful
people send inappropriate messages. Please DO NOT COMPLAIN TO
THE POSTMASTER about these messages because the postmaster has no
way of controlling them, and excessive complaints will result in
termination of the list.
For information about this list, including information about the
problem of inappropriate messages and information about how to
unsubscribe, please see the web page at
http://jse.stat.ncsu.edu/
===========================================================================
