Regression

  • Thread starter Thread starter Himansu
  • Start date Start date
H

Himansu

Hello everyone,

Can anyone point me in the right direction to do some regression analysis
(BI) in XL?
 
BI is an ambiguous abbreviation that could stand for bivariate, binary,
biological indicators, ... Please clarify what you are looking for.

In the interim, for simple linear regression, see Help for SLOPE, INTERCEPT,
RSQ, and STYEX. For multiple regression, see Help for LINEST and LOGEST.
You can use worksheet functions from VBA by prefixing the function name with
either Application. or WorksheetFunction. in your expression.

Jerry
 
There is regression capabiities in the analysis toolpak which you should find
under the Addins menu item under tools.

There are also worksheet functions like Linest, Logest, Trend, Slope,
Intercept, Growth, forecast. Look at them in help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple (as in many) regressions 3
How to print LinEst result to a spreadsheet using VBA 3
Big dataset - batch process 1
Passing a range from worksheet to VBA function 5
1004 error when using ATPVBAEN.XLAM!Regress 7
Having trouble using LINEST in Excel 2007 VBA 1
Weighted Linear Regression 2
Do Multiple Regression with VBA Code 2

Back
Top