Formulas and Functions

Table Of Contents

If additional statistics are not returned (stats is FALSE), the array returned is one row

deep. The number of columns is equal to the the number of sets of known-x-values

plus 1. It contains the line slopes (one value for each row/column of x values) in

reverse order (the rst value relates to the last row/column of x values) and then the

value for b, the intercept.

If additional statistics are returned (stats is TRUE), the array contains ve rows. See

“Additional Statistics” on page 267 for the contents of the array.

Examples

Assume the following table contains the test scores of 30 students who recently took an exam you

administered. Assume further that the minimum passing grade is 65 and that the lowest score for

other grades are as given. In order to facilitate building the formulas, an “F” is represented by 1 and

an “A” by 5.

=INDEX(LINEST(A2:A6, C2:C6, 1, 0), 1) returns 0.752707581227437, which is the best-t line slope.

=INDEX(LINEST(A2:A6, C2:C6, 1, 0), 2) returns 0.0342960288808646, which is b, the intercept.