I'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?
Angle of Inclination Calculation
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
You do not have the required permissions to view the files attached to this post.
Use the ATAN Function to get the answer in radians and then the DEGREES function to convert to degreesCallumPerry 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
weirdly, i was puzzling over this a whgile back. Slope() seemed to be the closest approxiamtion for what i was after. i was actually asking if functions could be exposed in BA to allow this sort of thing.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
Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816
I think you need Bet Anglejimibt wrote: ↑Mon Sep 14, 2020 8:19 pmweirdly, i was puzzling over this a whgile back. Slope() seemed to be the closest approxiamtion for what i was after. i was actually asking if functions could be exposed in BA to allow this sort of thing.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
Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816
very quick - a sure sine of geniusJukebox wrote: ↑Mon Sep 14, 2020 8:21 pmI think you need Bet Anglejimibt wrote: ↑Mon Sep 14, 2020 8:19 pmweirdly, i was puzzling over this a whgile back. Slope() seemed to be the closest approxiamtion for what i was after. i was actually asking if functions could be exposed in BA to allow this sort of thing.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
Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816
- MemphisFlash
- Posts: 2159
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
thats not 45 Degrees, looks more like 30, and i'm a draughtsman
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Get out my threadJukebox wrote: ↑Mon Sep 14, 2020 8:21 pmI think you need Bet Anglejimibt wrote: ↑Mon Sep 14, 2020 8:19 pmweirdly, i was puzzling over this a whgile back. Slope() seemed to be the closest approxiamtion for what i was after. i was actually asking if functions could be exposed in BA to allow this sort of thing.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
Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Thank 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?
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?
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
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.