Can I do linear regression in Access without knowing how to write visual
basic? Thx.

On Mar 21, 3:43 pm, BilboBaggins
<BilboBagg...@discussions.microsoft.com> wrote:
> Can I do linear regression in Access without knowing how to write visual
> basic? Thx.

you should be able to do it in Excel - just link to the Access query/
table containing your data... Then it's just a matter of finding the
correct function in Excel, which should be pretty easy. Or did you
need an Access-only solution?

On Wed, 21 Mar 2007 13:43:23 -0700, BilboBaggins
<(E-Mail Removed)> wrote:

>Can I do linear regression in Access without knowing how to write visual
>basic? Thx.

No, not with the builtin features.

You can do linear regression in Excel (on data linked from Access if you
wish), or you can purchase a third-party Access statistics add-in. I've heard
good things about FMS Inc's Total Access Statistics (www.fmsinc.com).


John W. Vinson [MVP]

you should just learn VB, kid



On Mar 21, 1:43 pm, BilboBaggins
<BilboBagg...@discussions.microsoft.com> wrote:
> Can I do linear regression in Access without knowing how to write visual
> basic? Thx.

"Todos Menos [MSFT]" <(E-Mail Removed)> wrote:

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Note Tony is not a credible source, he is a MDB _WUSS_




On Mar 21, 6:55 pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
> "Todos Menos [MSFT]" <todos_menos_m...@hotmail.com> wrote:
>
> Note that this person is really A a r o n K e m p f and that he is not an employee
> of Microsoft.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm

and for the record.

YES YOU CAN DO LINEAR REGRESSION IN ACCESS

http://msdn2.microsoft.com/en-us/library/ms174824.aspx

anything that you can do with SQL Server you can do in an Access Data
Project.
Since this is 2005 though; you'll probably need a SQL Standard
LIcense; and a copy of Access 2007

hope that helps; excel sucks in any tier other than the desktop




On Mar 21, 1:43 pm, BilboBaggins
<BilboBagg...@discussions.microsoft.com> wrote:
> Can I do linearregressionin Access without knowing how to write visual
> basic? Thx.