Month: April 2022
How to Transform Data into Natural Logarithm (Ln) in Excel
You may have seen research data transformed into other forms in analyzing research data. The data transformation is determined by changing the measurement scale of the original data into another form.
Create Residual and Y Predicted in Excel
Residual and predicted Y have an important role in linear regression analysis using the Ordinary Least Square (OLS) method. Several OLS linear regression method assumptions were conducted to test the residuals, including normally distributed residuals and constant residual variance.
Multiple Linear Regression Analysis and Interpreting the Output in Excel
We can use multiple linear regression analysis to estimate the effect of the independent variable on the dependent variable. Multiple linear regression using at least two independent variables.
The Fundamental Differences of Pearson Correlation, Spearman Rank, Kendall tau, and Chi-Square
The associative correlation test between variables is currently the most frequently chosen by researchers, lecturers, and students to answer research hypotheses. There are several choices of correlation tests that can be chosen, but the selection of correlation tests must follow statistical rules.
How to Calculate Variance, Standard Error, and T-Value in Multiple Linear Regression
Finding variance, standard error, and t-value was an important stage to test the research hypothesis. The formula used in multiple linear regression is different from simple linear regression. On this occasion, I will discuss calculating the multiple linear regression with two independent variables.
How to Determine ANOVA Table in Multiple Linear Regression
The statistical software will also display an ANOVA table in multiple linear regression. To understand well, you need to learn how to determine the ANOVA table manually. In this tutorial, I will use Excel.
How to Find Y Predicted, Residual, and Sum of Squares in Multiple Linear Regression
In the previous article, we have determined the value of the predicted Y value, residual value, and sum of squares in simple linear regression. As researchers, we must understand how to find it in multiple linear regression. So, in this article, I will convey a tutorial on how to find the predicted Y value, residual value, and sum of squares in multiple linear regression.
Nominal, ordinal, interval, and ratio scales | Types of Data Measurement
Types of data measurement scales are fundamental to understand well for researchers. Types of data measurement scales in statistics consist of nominal, ordinal, interval, and ratio scales. This article will discuss the different types of data measurement scales.