Can I perform linear regression with Access?

[Guest]

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

 

[pietlinden]

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?

 

[John W. Vinson]

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]

 

[Todos Menos [MSFT]]

you should just learn VB, kid

 

[Tony Toews [MVP]]

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

 

[Todos Menos [MSFT]]

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

 

[Todos Menos [MSFT]]

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