Linear regression is a statistical analysis technique used to estimate the functional relationship between two or more variables, namely between the dependent variable (dependent variable; response; Y) and one or more independent variables (independent variable, predictor, X). ). If we only use one independent variable to predict the response, it is called simple linear regression, whereas if there is more than 1 independent variable, it is called multiple linear regression.

This tutorial describes how to perform a Simple Linear Regression analysis using the Worksheet Function: LINEST .

You can learn more about Excel: Simple Linear Regression in the following video.

Excel Tutorial: Simple Linear Regression

Form of simple linear regression equation: y = mx + b

Syntax:
LINEST(known_y's, [known_x's], [const], [stats])

Excel Tutorial: Simple Linear Regression

List of other Microsoft Excel Tutorials , you can learn at the following link:

Tutorial Microsoft Excel

Excel Tutorial: Simple Linear Regression