Trendline parameters
Is there a way of 'evaluating' the SLOPE and INTERCEPT parameters?
Assuming my (x,y) data are contained in cells L11 to L20 (for the y’s) and in cells K11 to K20 (for the x’s). The slope of line is obtained by using the functions =SLOPE(L11:L20,K11:K20)
Here is my question:
If cells …
I25 contains characters L11
I26 contains characters L20
J25 contains characters K11
J26 contains characters K20
Is there a way of having the slope parameters evaluated, such as:
=SLOPE(I25&":"&I26,J25&":"&J26)
I get an error when I try to do that! Is there an alternate way of automating the range of x,y ... outside the slope and intercept function?
I would use this to automate the regression parameters, as data are added to my data set?
|