By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

correlation and regression analysis

P: 1
My questions are can you use access to query correlation and regression analysis or should i link an excel spreadsheet to the database that has those functions specific to the analysis. if you can do it within access can anyone help me with the method of query to have these analysis show when the query is run
Aug 8 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
My questions are can you use access to query correlation and regression analysis or should i link an excel spreadsheet to the database that has those functions specific to the analysis. if you can do it within access can anyone help me with the method of query to have these analysis show when the query is run
You can set a reference to the Excel object Library from MS Access.

See these links for a "How To":
http://support.microsoft.com/kb/198571
http://www.fabalou.com/Access/Queri...l_functions.asp

See also:
http://www.cpearson.com/excel/ATP.htm
an add-in for scientific and engineering calculations
Aug 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.