The RegressionStatistics property returns a RegressionStatistics object that contains the statistical results of a regression model. When a trend line is not regressive or the solution of a regression does not exist for current data, the RegressionStatistics property returns Nothing (VB) or null (C#).
The following table defines the values used in statistical equations:
Value | Definition |
n | Number of points. |
nt | Number of regression coefficients. |
x values |
|
y values |
|
mean y value |
|
Fitted y values |
|
The following table displays the name, description, and formula for each member in the RegressionStatistics object:
Name | Description | Formula | Formula(UseYIntercept=true) |
Ssr | The sum of squares due to regression |
|
|
Sse | The sum of squares due to error |
|
|
Rsq | The coefficient of determination (R-squared) |
|
|
DF | The degrees of freedom |
|
|
F | The F-observed(F-statistic) value |
|