Linear regression excel template

Simple linear regression is a method we can use to understand the relationship between an explanatory variable, x, and a response variable, y.

This tutorial explains how to perform simple linear regression in Excel.

Example: Simple Linear Regression in Excel

Suppose we are interested in understanding the relationship between the number of hours a student studies for an exam and the exam score they receive.

To explore this relationship, we can perform simple linear regression using hours studied as an explanatory variable and exam score as a response variable.

Perform the following steps in Excel to conduct a simple linear regression.

Step 1: Enter the data.

Enter the following data for the number of hours studied and the exam score received for 20 students:

Step 2: Visualize the data.

Before we perform simple linear regression, it’s helpful to create a scatterplot of the data to make sure there actually exists a linear relationship between hours studied and exam score.

Highlight the data in columns A and B.

Along the top ribbon in Exce

how to calculate linear regression line in excel

how to compute regression analysis in excel