Linear Regression?

[43fan]

Hello! I have a calculation that I currently run in both basic and in
Foxpro 2.6 that does a projection based on linear regression. I can convert
this calculation into VBA, but I'm curious if there's a function that would
do it for me.

Any help?

Thanks!!
Shawn

 

[Jerry W. Lewis]

Use the Excel worksheet functions:
Slope, Intercept, and Forecast
or
LinEst and Trend
by prefixing with Application. in VBA

Jerry

 

[Adrian]

Have a look at the worksheet function TREND.

 

[Tom Ogilvy]

Look at help on Linest, Trend, Forecast, Slope, Intercept.

in Excel. (not VBA).

 

[Tom Ogilvy]

You can also look at the regression function in the analysis toolpak

 

[jamieuk]

Goal Seek or the Solver does it for me!