In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> 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.
>
Excel 97 has an add-in for doing regression and certain other statistical
analyses. Select "Extra"->"Add-ins", and check both buttons for the
"Analysis TookPak" (I'm translating from a Dutch version, "Extra" may be
"Tools" or something similar). This will add a "Data Analysis" item to
the bottom of your "Extra" menu that allows elementary statistical
analyses. It's limited to bivariate regression though.
Hope this helps,
John Hendrickx
===========================================================================
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/
===========================================================================
