Determined by the STUDIST( t-statistics ). P-value ¾ is the value of significance levels corresponding to the calculated t- statisticians. Analysis of variance, line Y-intersection contains the value of coefficient, standard error and t-statistics. Analysis of variance, line Total contains the sum of the first two columns.ĥ. Parameter MS is determined by the formula. If the resulting number exceeds, then the hypothesis is accepted (no linear relationship), otherwise the hypothesis is accepted (there is a linear relationship). Statistics F is determined by the formula Parameter MS is determined by the formula Parameter SS is determined by the formula Parameter df equals m(number of sets of factors x) Standard error S calculated by the formula Ģ. Normalized R-square is calculated by the formula (is used for multiple regression) Multiple R is defined by the formula ( Pearson correlation coefficient) Default build mode New worksheet ħ) Block Remains allows you to include the output of residuals and the construction of their graphs.Īs a result, information is displayed that contains all the necessary information and is grouped into three blocks: Regression statistics, Analysis of variance, Balance withdrawal. If this value does not suit you, then you need to enable this feature and enter the required value ĥ) Sign Zero constant is included if it is necessary to construct an equation in which the free variable Ħ) Output Options determine where the results should be placed. Values must be in columns ģ) Sign Tags set if the first cells contain explanatory text(data signatures) Ĥ) Reliability level¾ is the confidence level, which is assumed to be 95% by default. Values must be in a column Ģ) Input interval X¾ contains a link to cells that contain the values of the factors. A dialog box will appear that needs to be filled in:ġ) Input interval Y¾ contains a link to cells that contain the values of the resulting attribute y. (In Excel 2007, this mode is in the Data/Data Analysis/Regression). To build a regression model, select the item Service\Data Analysis\Regression.
In Excel 2007, to enable the Analysis Pack, click Go to Block Excel Options by pressing the button on the left upper corner, and then the button Excel Options» at the bottom of the window: Requires add-on to work Analysis package, which must be enabled in the menu item Service\Add-ons It is important to understand how to interpret the results. The MS Excel package allows when constructing an equation linear regression most do the job very quickly.
0 kommentar(er)
