If known_x's is omitted, it is assumed to be the array that is the same size as known_y's. known_x's (optional) are independent data values.known_y's (required) are dependent data values,.To calculate the linear trendline values, Excel offers the array function TREND () (see the notes above about array functions) that returns values along a linear trend: If the count of known_y's is different from known_x's, the INTERCEPT () and SLOPE () functions returns #N/A.If there is only one value in known_y's or known_x's, the INTERCEPT () and SLOPE () functions will return #DIV/0!. The SLOPE () function returns the slope (the parameter a) of a linear regression line based on known_y's and known_x's data: known_x's (required) are independent data values (see an example below) - a range or array of numeric values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |