#Data regression analysis excel series#

Due to the use of the OLS regression method, there are several assumptions that researchers must meet. The data that researchers have collected can be seen in the table below:īased on the data above, researchers can use the linear regression analysis of the OLS method.

The product sales variable is the dependent variable, and the price is the independent variable.

#Data regression analysis excel series#

The data used is monthly time series data for the last 12 months. Researchers aim to determine the effect of price on product sales. Mini research case examplesĪn example of a mini research case study on this occasion is simple linear regression. One of the inferential statistical tests that can be used is the linear regression analysis of the OLS method. In simple linear regression analysis, only one dependent variable and one independent variable, whereas in multiple linear regression analysis, the number of independent variables consists of at least two variables.ĭue to the need for researchers to understand linear regression analysis and its interpretation, Kanda Data will write a tutorial on performing linear regression using Excel data analysis.Īs previously known, Excel can also be used to perform inferential statistical analysis. Linear regression analysis can be divided into simple and multiple linear regression analyses. The difference between the two is that the dependent variable is the affected variable, while the independent variable is the influencing variable.

Linear regression analysis consists of the dependent variable and the independent variable. Researchers have widely used linear regression analysis to analyze the effect of a variable on other variables.