EXCEL DATA ANALYSI REGRESSION HOW TO
EXCEL DATA ANALYSI REGRESSION SERIES

Interpretation of Linear Regression Analysis Output The last step that researchers need to do is click ok. The analysis output is saved on the same Excel sheet based on the picture above. Will the analysis output be saved on the same Excel sheet, a different Excel sheet, or a new Excel file? Next, in the output option, Excel provides an option for researchers to save the output of the analysis results.

It shows that the maximum error rate in the study is 5%. Then, the researcher must enable the label, which in detail can be seen in the image below:īased on the picture above, researchers can set a confidence level of 95%. Researchers can input all existing data, including the label. In the next stage, the researcher needs to input the dependent variable data, namely product sales, and the independent variable, namely price. These steps in detail can be seen in the image below:Īfter the researcher clicks on regression, the regression window will appear. The next step that needs to be done by researchers is to look for regression and then click ok. In the Data Analysis window, several analysis tools are provided by Excel.

EXCEL DATA ANALYSI REGRESSION HOW TO

For a tutorial to activate the Data Analysis Toolpak menu in Excel, you can read the previous article entitled: “ How to Enable Data Analysis Button for t-test in Excel“.Īfter the researcher clicks on the Data Analysis menu, the Data Analysis window will then appear. In that case, the researcher must first activate the Data Analysis menu in Excel. Suppose the researcher does not find the Data Analysis menu after clicking on Data menu. After Excel is opened, the researcher can click on the “Data” menu, then the researcher selects the “Data Analysis” menu, which is in the upper right corner which in detail can be seen in the image below: The steps for simple linear regression analysis in Excel can use in the data analysis menu in Excel. The stages of the linear regression test in Excel In this tutorial, Kanda Data does not write an OLS assumption test but will immediately provide a tutorial on how to test a simple linear regression using data analysis in Excel. The minimum assumption tests that need to be carried out by researchers are the normality test, linearity test, non-heteroscedasticity test, and autocorrelation test. 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.

EXCEL DATA ANALYSI REGRESSION 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.

Excel data analysi regression