[]
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 | ![]() |
![]() |