Can I perform linear regression with Access?

B

BilboBaggins

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

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?
 
J

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]
 
T

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
 
T

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
 
Top