Author Archive

Author: <span>Pius</span>

31 articles

Data Cleaning & Preparation

How to Clean Data in Excel

How to Clean Data in Excel A dataset can look tidy on the screen and still create serious problems during analysis. A date column may contain…

Read more →
Data Cleaning & Preparation

How to Clean Data in R

How to Clean Data in R A dataset can look usable and still cause problems the moment analysis begins. Dates may be stored as text, categories…

Read more →
Data Cleaning & Preparation

How to Clean Data in Python

How to Clean Data in Python Raw data rarely arrives ready for analysis. A dataset may contain missing values, duplicated rows, inconsistent labels, mixed date formats,…

Read more →
Statistical Analysis

How to Check for Multicollinearity

How to Check for Multicollinearity Multicollinearity is one of the most important assumptions to review before interpreting a multiple regression model. Many students run a regression,…

Read more →
SPSS Analysis

How to Interpret SPSS Output

How to Interpret SPSS Output If you are trying to understand how to interpret SPSS output, the most important thing is to stop looking at the…

Read more →