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 Topic

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

Rate this:

(3/5 from 1 vote)

	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 mackconsult on 04 Mar 2015

Replies - Displaying 1 to 2 of 2

Order Replies By: Most recent | Chronological | Highest Rated

	found a solution 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 mackconsult on 05 Mar 2015

	Simple regression functions 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 Excel Helper on 04 Mar 2015

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 Excel Business Solutions Directory