Hello everyone,

Can anyone point me in the right direction to do some regression analysis
(BI) in XL?

--
Thnaks,
Himansu

On Mar 27, 8:45 am, "Himansu" wrote:
Hello everyone,

Can anyone point me in the right direction to do some regression analysis
(BI) in XL?

--
Thnaks,
Himansu

I would start by search the Excel Help for "LINEST" and then try the
following link:

http://office.microsoft.com/en-us/ex...CL100570551033.

Excel also has an analysis tool pack add-in which appears in the Tools
menu as "Data Analysis."

Matt

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

"Himansu" wrote:

Hello everyone,

Can anyone point me in the right direction to do some regression analysis
(BI) in XL?

--
Thnaks,
Himansu

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.

--
Regards,
Tom Ogilvy


"Himansu" wrote:

Hello everyone,

Can anyone point me in the right direction to do some regression analysis
(BI) in XL?

--
Thnaks,
Himansu