![]() ![]() The following is a summary of all the various regression and ANOVA functions provided in the Real Statistics Resource Pack. To estimate the true slope of an existing trend such as amount of change per year, Sens nonparametric method is used and the test has been performed using XLSTAT 2017 software. ARIMACoeff(R1, p, q, d, con, lab) a p+q+1 × 4 array, each row of which contains the coefficient, standard error, t-stat and p. In particular, the first function is used to calculate the ARIMA coefficients and their standard errors. The following are ordinary, non-array functions where R1 contains the X data and R2 contains the Y data:Ī second R2 parameter can be used with each of the df functions above, although this parameter is not used. Real Statistics Function: The Real Statistics Resource Pack provides the following array functions. Similarly, you can use SSRegTot(R1, R2) and its value will be equivalent to SSRegTot(R2). All these functions can optionally take a third argument con, where con = TRUE (default) means that the regression model takes a constant term and con = FALSE means that the regression model doesn’t have a constant term.Ĭlick here for more details about these functions. There is also a second form of the RSquare function in which RSquare(R1, k) = R 2 where the X data consists of all the columns in R1 except the kth column and the Y data consist of the kth column of R1. The following are array functions where R1 contains the X data and R2 contains the Y data. ![]() ![]() Leverage vector = diagonal of hat matrix for the data in R1Ĭovariance matrix for the regression coefficients of the regression line DESIGN(R1)ĭiagonal of the hat matrix for the data in R1Ĭore of the hat matrix for the data in R1 Two-column array with the regression coefficients for the regression line in the first column and the corresponding standard errors in the second columnħ × 1 column array containing the predicted y value for the data in R0, the standard error for the confidence interval, the lower and upper ends of the 1– alpha confidence interval, the standard error for the prediction interval, the lower and upper ends of the 1– alpha prediction interval ( alpha defaults to. Predicted y values for x values in range R0 based on the regression coefficients in column range Rc handles case with and w/o an interceptĬolumn array with the standardized regression coefficients for R1 and R2 based on the regression coefficients in the column range Rc (including an intercept coefficient). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |