UNISTAT - the ultimate
Excel statistics add-in
Polynomial Regression in Excel with Unistat
The Unistat statistics add-in extends Excel with Polynomial Regression capabilities.
Further documentation is available at section 7.2.2 of the manual, Polynomial Regression.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Polynomial Regression
Regression Results
Valid Number of Cases: 19, 0 Omitted
Dependent Variable: Y
| Coefficient | Standard Error | t-Statistic | Significance | Lower 95% | Upper 95% | |
|---|---|---|---|---|---|---|
| Constant | 37.3890 | 0.4364 | 85.6754 | 0.0000 | 36.4683 | 38.3097 |
| X | 3.1269 | 0.1510 | 20.7087 | 0.0000 | 2.8083 | 3.4454 |
Polynomial Regression
Regression Results
Valid Number of Cases: 19, 0 Omitted
Dependent Variable: Y
| Coefficient | Standard Error | t-Statistic | Significance | Lower 95% | Upper 95% | |
|---|---|---|---|---|---|---|
| Constant | 40.3017 | 1.1335 | 35.5554 | 0.0000 | 37.8988 | 42.7046 |
| X | 0.6666 | 0.9135 | 0.7297 | 0.4761 | -1.2700 | 2.6032 |
| X^2 | 0.4540 | 0.1669 | 2.7203 | 0.0151 | 0.1002 | 0.8077 |
Polynomial Regression
Regression Results
Valid Number of Cases: 19, 0 Omitted
Dependent Variable: Y
| Coefficient | Standard Error | t-Statistic | Significance | Lower 95% | Upper 95% | |
|---|---|---|---|---|---|---|
| Constant | 32.7673 | 3.1132 | 10.5253 | 0.0000 | 26.1317 | 39.4030 |
| X | 10.4109 | 3.9030 | 2.6674 | 0.0176 | 2.0919 | 18.7299 |
| X^2 | -3.3868 | 1.5136 | -2.2377 | 0.0408 | -6.6129 | -0.1607 |
| X^3 | 0.4701 | 0.1844 | 2.5491 | 0.0222 | 0.0770 | 0.8632 |
Polynomial Regression
Regression Results
Valid Number of Cases: 19, 0 Omitted
Dependent Variable: Y
| Coefficient | Standard Error | t-Statistic | Significance | Lower 95% | Upper 95% | |
|---|---|---|---|---|---|---|
| Constant | 6.9265 | 7.2855 | 0.9507 | 0.3579 | -8.6993 | 22.5524 |
| X | 55.8348 | 12.4946 | 4.4687 | 0.0005 | 29.0366 | 82.6330 |
| X^2 | -31.4866 | 7.6054 | -4.1400 | 0.0010 | -47.7986 | -15.1746 |
| X^3 | 7.7625 | 1.9573 | 3.9659 | 0.0014 | 3.5644 | 11.9605 |
| X^4 | -0.6751 | 0.1808 | -3.7346 | 0.0022 | -1.0628 | -0.2874 |