![]() It can be thought of as an indicator of fit. ![]() The r 2 value is an indicator of the strength of the correlation of the model. The highlighted cells show the slope = 2, intercept = 0 and r 2 = 1. Using the above example and selecting TRUE for the stats parameter: The main statistics to understand are the slope coefficients, y-intercept and the coefficient of determination or the r 2 value of the model. ![]() ![]() The F statistic (to determine if the variables’ relationship occurs by chance) Standard error for each slope coefficient You may be wondering what each variable means. When the stats option is set to TRUE, the organization of the regression statistics are as follows: = LINEST ( B3 : B7, C3 : C7, TRUE, FALSE )
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |