finding angle of slope...
Brad wrote on Wed, 21 Jun 2006 15:52:26 -0500:
B Is there any way, using this built-in Excel feature, to
B convert the result into degrees so that I can then label the
B regression line in degrees, for example, 45 degrees?
You could display the equation of the trend line where the
coefficient of X is the slope tho' I believe it would be more
accurate, in earlier versions of Excel, to use LINEST to get the
slope; slope:=INDEX(LINEST(known_y's,known_x's),1). Then all you
have to do is convert the slope, which is the tangent of an
angle, to the angle = DEGREES(ATAN(SLOPE)). See LINEST and other
worksheet functions in HELP.
James Silverton.
|