Regression Analysis

Performs linear, logarithmic, or power regression analysis of a data set comprising one dependent variable and multiple independent variables.

For example, a crop yield (dependent variable) may be related to rainfall, temperature conditions, sunshine, humidity, soil quality and more, all of them independent variables.

このコマンドの見つけ方

「メニューバー」から

Choose Data - Statistics - Regression

From the tabbed interface:

Choose Data - Statistics - Regression.

On the Data menu of the Data tab, choose Statistics - Regression.


note

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


データ

独立変数(X)の範囲:

Enter a single range that contains multiple independent variable observations (along columns or rows). All X variable observations need to be entered adjacent to each other in the same table.

従属変数(Y)の範囲:

Enter the range that contains the dependent variable whose regression is to be calculated.

X範囲とY範囲の両方にラベルをつける

Check to use the first line (or column) of the data sets as variable names in the output range.

結果貼り付け先:

The reference of the top left cell of the range where the results will be displayed.

Grouped By

Select whether the input data has columns or rows layout.

出力に用いる回帰の種類

Set the regression type. Three types are available:

オプション

信頼水準

A numeric value between 0 and 1 (exclusive), default is 0.95. Calc uses this percentage to compute the corresponding confidence intervals for each of the estimates (namely the slopes and intercept).

残差を計算する

Select whether to opt in or out of computing the residuals, which may be beneficial in cases where you are interested only in the slopes and intercept estimates and their statistics. The residuals give information on how far the actual data points deviate from the predicted data points, based on the regression model.

切片を0とする

Calculates the regression model using zero as the intercept, thus forcing the model to pass through the origin.

ご支援をお願いします!