tbf the excel scale has reduced the height considerably - if that is 11 wide does it really look 100 tall?MemphisFlash wrote: ↑Mon Sep 14, 2020 9:08 pmthats not 45 Degrees, looks more like 30, and i'm a draughtsman
Angle of Inclination Calculation
If x is 10 then y is 90 according to your constant. 10/90=9 ATAN of 9 = 1.460139 radians = 83.65981 degrees. The reason is doesn't look like 83.65981 degrees is because excel has scaled the y axis to something you can see - if you made the x and y the same scale you'd see it..CallumPerry wrote: ↑Mon Sep 14, 2020 9:27 pmThank you but the ATAN is for a value not a series, which value?
I tried taking the slope of the two series (10) so =ATAN(10) gives 1.47112767. =Degrees() of this number gives 84.289. Doesn’t look like 84 degrees?
You are really only solving a right angled triangle.
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
I've just managed to scale it so the axis use the same increments and now visually it matches the number I am getting. Thank you for your help! Yeah Excel tricked me with the scale of the line; something to remember in future analysis I suppose!
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Oops, just behind your reply here when typing my last message. Yep, big brain freeze moment there Thank you for explainingJukebox wrote: ↑Mon Sep 14, 2020 10:25 pmIf x is 10 then y is 90 according to your constant. 10/90=9 ATAN of 9 = 1.460139 radians = 83.65981 degrees. The reason is doesn't look like 83.65981 degrees is because excel has scaled the y axis to something you can see - if you made the x and y the same scale you'd see it..CallumPerry wrote: ↑Mon Sep 14, 2020 9:27 pmThank you but the ATAN is for a value not a series, which value?
I tried taking the slope of the two series (10) so =ATAN(10) gives 1.47112767. =Degrees() of this number gives 84.289. Doesn’t look like 84 degrees?
You are really only solving a right angled triangle.
no probsCallumPerry wrote: ↑Mon Sep 14, 2020 10:27 pmOops, just behind your reply here when typing my last message. Yep, big brain freeze moment there Thank you for explainingJukebox wrote: ↑Mon Sep 14, 2020 10:25 pmIf x is 10 then y is 90 according to your constant. 10/90=9 ATAN of 9 = 1.460139 radians = 83.65981 degrees. The reason is doesn't look like 83.65981 degrees is because excel has scaled the y axis to something you can see - if you made the x and y the same scale you'd see it..CallumPerry wrote: ↑Mon Sep 14, 2020 9:27 pmThank you but the ATAN is for a value not a series, which value?
I tried taking the slope of the two series (10) so =ATAN(10) gives 1.47112767. =Degrees() of this number gives 84.289. Doesn’t look like 84 degrees?
You are really only solving a right angled triangle.
- firlandsfarm
- Posts: 2688
- Joined: Sat May 03, 2014 8:20 am
Sorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.CallumPerry wrote: ↑Mon Sep 14, 2020 6:57 pmI'm having a bit of a mind blank here, hope somebody can help. The line is this attached screenshot (to my eye) has an angle of about 45 degrees. Does anybody know what calculation would I need to do to achieve this value? =SLOPE() gives me the first 10 (M value) in 'Y = 10X - 10'.
I can not for the life of me remember how to use this to give me the angle of inclination in Excel. From what I've read it's TAN^-1 or something. Before I overly complicate it, I was hoping somebody here knew of a simple function or calculation please?
Screen Shot 2020-09-14 at 18.51.40.png
yeah, so the feature request that i put into the suggestions was to exploit this very fact -comparison between SAME spaced x axis time duration. that way, you can calculate the trend as index comparisons, rather than was ltp > ltp 10 seconds ago etc.. that tells no real story, tan does...firlandsfarm wrote: ↑Tue Sep 15, 2020 3:29 pmSorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.CallumPerry wrote: ↑Mon Sep 14, 2020 6:57 pmI'm having a bit of a mind blank here, hope somebody can help. The line is this attached screenshot (to my eye) has an angle of about 45 degrees. Does anybody know what calculation would I need to do to achieve this value? =SLOPE() gives me the first 10 (M value) in 'Y = 10X - 10'.
I can not for the life of me remember how to use this to give me the angle of inclination in Excel. From what I've read it's TAN^-1 or something. Before I overly complicate it, I was hoping somebody here knew of a simple function or calculation please?
Screen Shot 2020-09-14 at 18.51.40.png
- firlandsfarm
- Posts: 2688
- Joined: Sat May 03, 2014 8:20 am
yeah but to get a true comparison with something else both the X and the Y need to be in the same proportion with the originaljimibt wrote: ↑Tue Sep 15, 2020 3:34 pmyeah, so the feature request that i put into the suggestions was to exploit this very fact -comparison between SAME spaced x axis time duration. that way, you can calculate the trend as index comparisons, rather than was ltp > ltp 10 seconds ago etc.. that tells no real story, tan does...firlandsfarm wrote: ↑Tue Sep 15, 2020 3:29 pmSorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.CallumPerry wrote: ↑Mon Sep 14, 2020 6:57 pmI'm having a bit of a mind blank here, hope somebody can help. The line is this attached screenshot (to my eye) has an angle of about 45 degrees. Does anybody know what calculation would I need to do to achieve this value? =SLOPE() gives me the first 10 (M value) in 'Y = 10X - 10'.
I can not for the life of me remember how to use this to give me the angle of inclination in Excel. From what I've read it's TAN^-1 or something. Before I overly complicate it, I was hoping somebody here knew of a simple function or calculation please?
Screen Shot 2020-09-14 at 18.51.40.png
the SCALE has to be the same and the INTERVAL has to be the same. BUT the price should by virtue be different in order to get our index...firlandsfarm wrote: ↑Tue Sep 15, 2020 3:39 pmyeah but to get a true comparison with something else both the X and the Y need to be in the same proportion with the originaljimibt wrote: ↑Tue Sep 15, 2020 3:34 pmyeah, so the feature request that i put into the suggestions was to exploit this very fact -comparison between SAME spaced x axis time duration. that way, you can calculate the trend as index comparisons, rather than was ltp > ltp 10 seconds ago etc.. that tells no real story, tan does...firlandsfarm wrote: ↑Tue Sep 15, 2020 3:29 pm
Sorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.
so if looking over 30 seconds, you may measure the price every 5 seconds based on a 5 second interval. the price may (in a crazy world) look a bit like this:
time price
00:00:05 2.5
00:00:10 3.5
00:00:15 4.0
00:00:20 3.5
00:00:25 3.5
00:00:30 3.0
So, your index (slope, tan etc) would/could measure the index between each interval OR could group intervals into the same sized buckets and measure them, horses and courses
- firlandsfarm
- Posts: 2688
- Joined: Sat May 03, 2014 8:20 am
I don't know why it's only just dawned on me, yes I do it's because over 50 years have passed since I did this in a classroom but I think what you are looking for is not the angle of inclination but the Gradient (https://www.mathsisfun.com/gradient.html)! That way the scales of the axes is irrelevant. The Gradient measures how many ups (negative = downs) there are for each across.