Multiple regression in Access 2013

J

j235

New member

Local time

Today, 11:31

Joined

Nov 16, 2014

Messages

6

• Nov 17, 2014

• #1

I want to do multiple regression in Access 2013. Can anyone help me with the VB code?

 

jdraw

Super Moderator

Staff member

Local time

Today, 14:31

Joined

Jan 23, 2006

Messages

15,555

• Nov 17, 2014

• #2

j235 said:

I want to do multiple regression in Access 2013. Can anyone help me with the VB code?

Click to expand...

Please tell us in plain English exactly what you want to accomplish.
Then put some context on your set up:
-Web or desktop database?
-subject of the database?
-what you have tried with what results (errors, messages???)

This may be what you're looking for, or at least a start.

Good luck - more info may get you more focused responses.

 

J

j235

New member

Local time

Today, 11:31

Joined

Nov 16, 2014

Messages

6

• Nov 17, 2014

• #3

I working on complex desktop database.My main point is making the application for the simulation of tax revenue in Access 2013. Currently I have SQL code to calculate simple linear regression but I need code for multiplle regression.

 

jdraw

Super Moderator

Staff member

Local time

Today, 14:31

Joined

Jan 23, 2006

Messages

15,555

• Nov 17, 2014

• #4

Based on your response, I would think (mainly because I don't work with Excel) that Excel might be the better tool for you.
see http://www.wikihow.com/Run-Regression-Analysis-in-Microsoft-Excel

Other:
http://cameron.econ.ucdavis.edu/excel/ex61multipleregression.html
https://faculty.fuqua.duke.edu/~pecklund/ExcelReview/Use Excel 2007 Regression.pdf
https://www.youtube.com/watch?v=zYm6koNvAts


Also, you can call Excel from Access.