how Do I Implement The Forcast (linear Regression) Method Outside Excel.
Rate this:
(3/5 from 1 vote)
I want to use the forecast method of excel in my program so that i can calculate the next value. can anyone please guide me to get the X(BAR) calculation ??
The equation for FORECAST is a+bx, where:
and:
and where x and y are the sample means AVERAGE(known_x's) and AVERAGE(known y's).
XLSTAT 's a good Excel add-in that can do this. It offers statistical software products for Excel. Here is an example for nonlinear regression model: http://www.xlstat.com/en/support/tutorials/reg.htm
mihir
Posted by kachaliamihir on
Displaying page 1 of 1
Find relevant Excel templates and add-ins for How do i implement the forcast (Linear regression) method outside excel. in the Excel Business Solutions Directory