EXCEL回回剖析结果剖析(国外英语资料).doc

EXCEL回归分析结果分析 Excel regression analysis details A series of statistical parameters can be obtained using the data analysis of Excel. The following 10 years of snow depth and irrigation area sequence (figure 1) are given in detail. Figure 1. Maximum snow depth and irrigation area (1971-1980) for 10 consecutive years The Summary Output (Summary Output) is as follows (figure 2) : Figure 2 shows the regression results from the data analysis tool Part 1: regression statistics This section gives the correlation coefficient, determination coefficient, calibration coefficient, standard error and sample number (table 1) : Table 1 returns statistics Line by line is as follows: The corresponding data is the correlation coefficient, which is R = 0.989416. The corresponding value of R Square is the determination coefficient, or the goodness of fit, which is the correlation coefficient squared, which is R2 = 0.9894162 = 0.978944. The corresponding method is the calibration determination coefficient, which is calculated by the formula N is the sample number, m is the variable number, R2 is the measuring coefficient. For this example, n is equal to 10, m is equal to 1, R2 is equal to 0.978944, and you plug it in Standard error corresponds to the so-called standard error, which is calculated by the formula Here the SSe is the sum of the remaining squares and can be read from the following variance analysis table, which is SSe = 16.10676, which is available in the top form The last row of observations corresponds to the number of samples, which is n = 10. The second part, the variance analysis table The variance analysis consists of degrees of freedom, error squared, mean variance, F, P, and so on (table 2). Table 2 variance analysis table (ANOVA) Column by column and branch description are as follows: The first df corresponds to the degree of freedom, the first line is the return of freedom DFR, which is equal to the number of variables, which is DFR = m. The second behavior, dfe,