Home > Forum Home > Automating Data Analysis Tasks > simple spreadsheet that finds m and b of y=mx+b given two cartesian points Share

Simple spreadsheet that finds m and b of y=mx+b given two cartesian points

Excel Help for Simple Spreadsheet That Finds M And B Of Y=mx+b Given Two Cartesian Points in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Simple Spreadsheet That Finds M And B Of Y=mx+b Given Two Cartesian Points

Rate this:
(3/5 from 1 vote)
Confused I hope somebody has already done this and could share the solution.
Given two points I would like to have a simple spreadsheet that would calculate m & b of the linear equation y=mx+b ......
It anybody can help that would be great.
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
Thanks I threw something together and verifyed .....
[http://71.236.195.251/wordpress/wp-content/uploads/2015/03/ymx-b.xlsx]
 Posted by on
Confused
Rate this:
(4/5 from 2 votes)
This equation is a simple regression calculation where M is the coefficient (SLOPE function in Excel) and B is the intercept (INTERCEPT function in Excel).

If you two points do not have two dimensions (y and x) just use 1 and 2 for y (sequential for more observations). 
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for simple spreadsheet that finds m and b of y=mx+b given two cartesian points in the