N
Nick H
I have two columns of numbers, and I want to calculate the slope of the
regression line for the data from the current row to the bottom of the table.
I built this formula:
=SLOPE(INDIRECT("$L"&TEXT(ROW(),0)&":$L$"&TEXT($B$9,0)),INDIRECT("$A"&TEXT(ROW(),0)&":$A$"&TEXT($B$9,0)))
The y values are in column L, the x values in column A, and the row number
of the bottom of the table is in cell B9.
I'm getting #NUM; when I step through the error analysis, it seems like I'm
getting valid ranges. Can anyone help me with this? Thanks.
regression line for the data from the current row to the bottom of the table.
I built this formula:
=SLOPE(INDIRECT("$L"&TEXT(ROW(),0)&":$L$"&TEXT($B$9,0)),INDIRECT("$A"&TEXT(ROW(),0)&":$A$"&TEXT($B$9,0)))
The y values are in column L, the x values in column A, and the row number
of the bottom of the table is in cell B9.
I'm getting #NUM; when I step through the error analysis, it seems like I'm
getting valid ranges. Can anyone help me with this? Thanks.