1 this would be columns B through E (cells B2 to E28).
While entering the y values is no different than for a linear regression, inputting the x values is very different in that the Input X Range box must contain all of the columns containing a power of x. 1 this would be the cells F2 to F28 (enter F2:F28 in the Input Y Rangebox). In the Input Y Range box type in the cell addresses that contains your y values (or click and drag to select them from the worksheet). Sample spreadsheet that is ready to be fit to the cubic expression y = ax + bx 2+ cx 3 + d using Excel’s regression package. Once the spreadsheet is set up as shown below, select Tools, Data Analysis from the menu bar and scroll down to Regression, select it and click OK.įigure 1. Note that in addition to x 1, x 2 and x 3 there must be a column containing x 0, which contains only ones. e., y = ax + bx 2+ cx 3 + d, where a, b, c and d are constants that we need to find), then we would create columns containing the independent variable to the desired powers, as shown in Fig. For example, if we wanted to fit a set of data to a third order polynomial (i. One simple trick is to create columns each containing the variable of interest to the requisite power.
It is possible to have Excel perform a non-linear least square regression.
