Find The Slope of Three Points

Hi
A point in 2D is a pair of values (x, y) not a number. In 3d is (x, y ,z). Can you explain this better?

Hi artiststevens

The values of [Point A] and the values of [Point C] are correlated.
To get the slope of the regression line use the following formula which gives you the value 1,002898049

Formula:

Please Login or Register  to view this content.

To get the intercept of the regression line use the following formula which gives you the value -0,002377799

Formula:

Please Login or Register  to view this content.

To get the correlation coeficient of the regression line use the following formula which gives you the value 0,999943945 (one is 100%)

Formula:

Please Login or Register  to view this content.

Is this you want?

Hello Everyone,
Sorry for the late reply. Thank you everybody for your input and attempting to help me find a solution. After reading the post I’m going to try to better clarify what I need. I know that two numbers are required on both axis two on the X and two on the Y but I only have the single values. What Richard stated though is correct that each value is 1 unit apart. I attempted to use the formulas provided but the result appears a little wonky.

I’m attaching a new file with the formula entered along with examples of different angles in one instance plotted on a grid and the other solely examples of different angles. Point B serves as the vertex with the most important angle being “C”.

Please see attached files for a better explanation.

Thank you very much for attempting to assist me with my problem. I figured it would be difficult to understand but I'll try to explain it better.

Thanking you in advance again for any and all help.

Hi
Try to use the following

Formula:

Please Login or Register  to view this content.

Is the tangent of the angle ABC

The file slope2(2).xlsm include a macro to show the 'vertex'

Regards

Hello,
I first wanted to say thank you very much Richard and Jose for the help, it is greatly appreciated. Thank you Richard for explaining the reasons why the results don’t look right. I see now how such small changes can make a big difference.

A huge thank you to you Jose. I really appreciate you creating a formula and a macro to show the vertex, that’s above and beyond what I was expecting. I’ve been reviewing the file and everything looks great but I have a few more questions.

Also, I’ve included another spreadsheet with new point values along with the actual corresponding images to each point, so you can visually see the slope/angle of the line. On the new spreadsheet is an image of a circle which is intending to give a visual breakdown of what I’m looking for as well. Everything above the vertex of (B) would be consider positive and everything below it would be considered negative. Hopefully that explains it better.

Questions
1. The most important point is C and my desire is to see how strong the angle/slope of C is in conjunction with the other two points, whether the slope is positive or negative. There are six variations of angles and my goal is to find the ideal angle/slope for each.

Is there a way I formulaically determine the variation or maybe a better way to express the slop/angle to different each one?

2. When the values of any of the points is equal the result is #DIV/0!?

3. I’ve added new points and moved things around and now the “vertex” macro isn’t working any longer. How can I fix that?


Thank you very much again both of you for all of the help and any further help you could provide. Also, if I’m asking too much and need to post this in commercial services please let me know. Thank you again.

Sorry for the late reply. Had the opportunity to review the file Jose and I wanted to say thank you very much for the help. It is greatly appreciated that you took the time to do this for me. Above and beyond what I was expecting. Thank you very much.

Hi Stevens
My pleasure and many thanks for reputation.