35
the result. (Perform the following operation after completing the
operations)
Result:
8106.898
Important:
Regression coefficient, correlation coefficient, and
estimated value calculations can take considerable time when there are
a large number of data items.
Results:
Linear Regression Correlation Coefficient: 0.923
Logarithmic Regression Correlation Coefficient: 0.998
Logarithmic Regression Formula: y = -3857.984 + 2357.532InX
Calculating Estimated Values
Based on the regression formula obtained by paired-variable statistical
calculation, the estimated value of can be calculated for a given X-value.
The corresponding x-value (two values, x
1
and x
2
, in the case of
quadratic regression) also can be calculated for a value of y in the
regression formula.