Month: August 2022
The Best Guide for Optimizing Data Analysis in Excel
In addition to understanding the research topic, researchers also need basic data analysis knowledge. Excel is one of the tools often used by researchers to analyze research data. Researchers can use excel for various data analyses. On this occasion, Kanda Data will write the best guide for optimizing data analysis in excel.
How to Solve Multicollinearity in Multiple Linear Regression with OLS Method
Multiple linear regression equations must fulfill the required assumptions to obtain the best linear unbiased estimator. Several assumptions in linear regression using the ordinary least square (OLS) method must be met, one of which is non-multicollinearity.
How to Use Dummy Variables in Linear Regression with Ordinary Least Square Method
Many researchers have chosen linear regression using the ordinary least square (OLS) method because it can obtain the best linear unbiased estimator. To get the best linear unbiased estimator, researchers need to test the assumptions required for linear regression using the OLS method.
Finding the Best Regression Model Based on R Square
The regression model specification is an important step that researchers must consider. The exact specification will get the best regression model and represent real phenomena well.