Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > How do i implement the forcast (Linear regression) method outside excel. Share

How do i implement the forcast (Linear regression) method outside excel.

Excel Help for how Do I Implement The Forcast (linear Regression) Method Outside Excel. in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

how Do I Implement The Forcast (linear Regression) Method Outside Excel.

Rate this:
(3/5 from 1 vote)
Confused  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).
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
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 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