Kanda Data

How to Automatically Display Residual Values in Regression Analysis Using Excel

Regression Tutorial using Excel / By /

Residual values play an important role in linear regression analysis. These residuals are used for OLS assumption tests, such as normality tests and heteroskedasticity tests. For instance, one of the key assumptions in linear regression analysis is that the residuals are normally distributed. Therefore, we need to first calculate the residual values before proceeding with …

How to Automatically Display Residual Values in Regression Analysis Using Excel Read More »

Natural Logarithmic Data Transformation using Excel | Simple Steps

Excel Tutorial for Statistics / By /

When conducting analysis using parametric methods, it is generally required that the data follow a normal distribution. However, in reality, data collected from the field often do not meet this expectation. Tests such as the Shapiro-Wilk test or the Kolmogorov-Smirnov test may show that the data are not normally distributed. This situation often leads researchers …

Natural Logarithmic Data Transformation using Excel | Simple Steps Read More »

How to Calculate Tolerance Value and Variance Inflation Factor (VIF)

Assumptions of Linear Regression / By /

The tolerance value and Variance Inflation Factor (VIF) are important metrics that you can use to detect multicollinearity among independent variables. If we recall the basic theory, multicollinearity testing is an assumption test in the Ordinary Least Squares (OLS) regression method, which aims to ensure that there is no strong correlation between independent variables.