Regression Analysis

Produces the regression analysis of a data set

このコマンドの見つけ方

Choose Data - Statistics - Regression

For more information on regression analysis, refer to the corresponding Wikipedia article.

入力範囲: 分析対象のデータ範囲の参照です。

結果貼り付け先: 検定の結果表示の先頭のセルの参照です。

Select whether the input data has columns or rows layout.

Output Regression Type

Set the regression type. Three types are available:

Linear Regression: find a straight line in the form of y = a.x + b, where a is the slope and b is the intercept that best fits the data.
Logarithmic regression: find a logarithmic curve in the form of y = a.ln(x) + b, where a is the slope, b is the intercept and ln(x) is the natural logarithm of x, that best fits the data.
Power regression: Find a power curve in the form of y = a.x^b, where a is the coefficient, b is the power that best fits the data.

The following table has samples of a physical phenomenon taken in 1 second interval.

The results of the three types of regression analysis of the measurements in the table above are shown below.