C
ChasX
Xcel XP. I frequently chart a variable (y) against a continous sequence of
dates(x). I use the resident slope function in xcel to obtain a slope of a
linear regression of the data. I also plot the curve and print-out the
formula for the curve in the form: y=mx+b, where m should equal the same
value as that derived from the resident slope function. This does occur
when I set the x axis(the date component) as "category", in addition when I
do this "b" equals the proper y intercept. When I set the x axis as "time
scale" the y intercept is displayed as an unusually large value and there is
a small discrepancy in the slope(m). Can any one tell me why this
discrepancy occurs.
Thanks
Chas
dates(x). I use the resident slope function in xcel to obtain a slope of a
linear regression of the data. I also plot the curve and print-out the
formula for the curve in the form: y=mx+b, where m should equal the same
value as that derived from the resident slope function. This does occur
when I set the x axis(the date component) as "category", in addition when I
do this "b" equals the proper y intercept. When I set the x axis as "time
scale" the y intercept is displayed as an unusually large value and there is
a small discrepancy in the slope(m). Can any one tell me why this
discrepancy occurs.
Thanks
Chas