Pearson correlation is one of the correlation measures used to measure the strength and direction of the linear relationship of two variables while linear regression is a statistical analysis technique used to estimate the functional relationship between two or more variables, namely between the dependent variables (dependent; response; response; Y) with one or more independent variables (independent, predictor, X).

The following is a Microsoft Excel tutorial to calculate the correlation coefficient value of several variables at once ( Output in the form of a correlation matrix )

You can learn more about Excel: Correlation (Toolpak) tutorial in the following video.

Excel Tutorial: Correlation (Toolpak)

Excel Tutorial: Correlation (Toolpak)

You can learn a list of other Microsoft Excel Tutorials at the following link:

Tutorial Microsoft Excel

Excel Tutorial: Correlation (Toolpak)