Author: Kanda Data
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.
Correlation Analysis for Variables Measured with a Likert Scale (Ordinal Scale)
Many researchers choose to use correlation analysis to know the relationship between variables. The simpler analysis technique causes correlation analysis to be widely used by researchers.
If the estimated regression coefficient is negative, what does it mean?
Many researchers chose linear regression analysis to reveal how the influence of the independent variable on the dependent variable. Researchers can make estimates using the data they have to interpret the results.
The Relationship between Research Objectives, Analysis Methods, and Hypothesis Testing
Research objectives, analysis methods, and hypothesis testing have a close relationship with one another. Each research objective requires analytical methods to test research hypotheses. On this occasion, Kanda Data will discuss The Relationship between Research Objectives, Analysis Methods, and Hypothesis Testing.
The Effectiveness of the New Learning Method using Paired Sample t-Test
The effectiveness of a new method can be tested using paired sample t-test. The paired sample t-test was chosen due to using the same sample before and after using the new method.