Homepage |

IT Services |

Consulting |

Training |

Get help now |

Application Development |

Support and Downloads |

Contact Us |

Send us a comment or question |

Applications |

MS Access |

MS Excel |

Coding and Macros |

Excel VBA |

# Simple Linear Regression (Excel)

Simple linear regression is a statistical way to model the relationship between dependent variable (usually denoted as y) and explanatory variable. We are actually trying to find a linear equation that best describes the given x and y. This in some cases can be also be used to predict future values e.g. in trendline.

In excel there are several ways to do this. First we will use the

Select a range of two cells parallel to each other (e.g. C10:D10).
Create a following formula by typing

As a result you now have the parameters k and b for the linear equation:

Next create a formula

Last modified on August 19 2015