Angle of Inclination Calculation

[CallumPerry]

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?

Screen Shot 2020-09-14 at 18.51.40.png

[Jukebox]

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?

Screen Shot 2020-09-14 at 18.51.40.png

Use the ATAN Function to get the answer in radians and then the DEGREES function to convert to degrees

[jimibt]

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?

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.

Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816

[Jukebox]

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?

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.

Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816

I think you need Bet Angle

[jimibt]

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?

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.

Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816

I think you need Bet Angle

very quick - a sure sine of genius

[Atho55]

stick to the topic instead of going off at a tangent..

[MemphisFlash]

thats not 45 Degrees, looks more like 30, and i'm a draughtsman

[CallumPerry]

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?

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.

Maybe give it a bump if you think it'd be useful: viewtopic.php?f=20&t=21816

I think you need Bet Angle

Get out my thread

[CallumPerry]

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?

[Derek27]

[Jukebox]

thats not 45 Degrees, looks more like 30, and i'm a draughtsman

tbf the excel scale has reduced the height considerably - if that is 11 wide does it really look 100 tall?

[Jukebox]

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?

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..

You are really only solving a right angled triangle.

[CallumPerry]

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!

[CallumPerry]

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?

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..

You are really only solving a right angled triangle.

Oops, just behind your reply here when typing my last message. Yep, big brain freeze moment there Thank you for explaining

[Jukebox]

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?

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..

You are really only solving a right angled triangle.

Oops, just behind your reply here when typing my last message. Yep, big brain freeze moment there Thank you for explaining

no probs