| Home > Forum Home > Automating Data Analysis Tasks > simple spreadsheet that finds m and b of y=mx+b given two cartesian points > Simple regression functions | Share |
Simple regression functions
Excel Help for Simple Regression Functions in Automating Data Analysis Tasks
| Forum Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Simple regression functions in the Excel Business Solutions Directory |