Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Nonlinear regression using excel's data analysis tool Share

Nonlinear regression using excel's data analysis tool

Excel Help for Nonlinear Regression Using Excel's Data Analysis Tool in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Nonlinear Regression Using Excel's Data Analysis Tool

Rate this:
(2.5/5 from 2 votes)
Confused  I’m trying to understand how to make use of the equation suggested by excel when fitting a trendline through the following set of data

x
y
2004
17%
2005
19%
2006
22%
2007
24%
2008
25%
2009
26%

and selecting the polynomial curve as the best fit. The regression returns the following coefficients:

Y=-0.0022x^2 +8.8713x-8919.6

So to evaluate Y when x=2010 I would calculate:

Y=-0.0022*(2010)^2 +8.8713*2010-8919.6

Which results in Y being equal to 23.493  which is non sensible and doesn’t match the Y value the graph would imply for the year 2010 (something around 27%).




Can somebody please tell me what I’m doing wrong?
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 2 votes)
Hi
the software take x as 1,2,3,4,5,6
not as you expecet as 2004,2005......2009
then if you aplay x=7    (which should be 2010)

the result will be close to what you expect
 All the best - m.saad
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
That makes perfect sense actually. Thanks so much!
 Posted by on
Confused Setting up a nonlinear regressionAfter opening XLSTAT, select the XLSTAT / Modeling data / Nonlinear regression command. The nonlinear regression dialog box pops up. Select the data on the Excel sheet. The Dependent variable (or variable to model, or response variable) is in our case the "Speed".
Regards,Rachel Gomez
 rachel
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Nonlinear regression using excel's data analysis tool in the