Researchers can perform regression analysis either by doing calculations manually or with the help of statistical software for data analysis.Īs we all know, Excel is an office application that people use widely worldwide. In connection with the importance of linear regression analysis, researchers are expected to be able to carry out regression analysis independently. In various scientific fields, one of the scientific fields that use a lot of linear regression analysis is the field of economics and management. The output of linear regression analysis can be used for consideration in making business decisions in a company.īesides that, linear regression analysis can examine the factors that influence an observed variable. Researchers use linear regression analysis, and practitioners in the industry also often use linear regression analysis.

The regression analysis is intended to determine the effect of independent variables on the dependent variable. Researchers have widely used linear regression analysis to analyze a phenomenon.

Simple linear regression equation excel