Hello, I am a new user so please forgive me if I fail to include anything.
When using the 'SLOPE' function in Excel 2007, is the returned value in degrees, percent or radians? Below is an example:
Column A (Y-values)
2359.7546
2359.6244
2359.4944
2357.1235
2356.7319
2356.4566
2355.6608
2355.2594
Column B (X-values)
0.0000
0.5208
0.5814
5.6406
5.7726
7.6469
11.7451
13.3342
When I use the function " =SLOPE(A1:A8;B1:B8) " I get the following result: -0.349. Is this number reported in degrees, percent, or radians?
Assuming that the value is not in degrees but simply an angle, I then use the function " =DEGREES(-0.349). The result from this function is -20.
Am I correct in interpreting this value (-20) as being the slope in degrees?
Does this seem to be a correct way of converting the original slope value into degrees or am I wrong? Any help would be appreciated.
Bookmarks