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 |