Ray G. Butler3 minPreparing your Data for AutoDiscovery (III): Identifying Outliers in Excel.Outliers are one of those statistical issues that everyone knows about, but most people aren’t sure how to deal with. Outliers can skew...
Ray G. Butler3 minPreparing your Data for AutoDiscovery (II): From Numbers to Categories in Excel.Do you have a large list of numbers and you would like to group them into ranges or categories? Do you want to change numerical codes by...
Ray G. Butler4 minPreparing your Data for AutoDiscovery: Table-Like Structure in Excel.In this series of articles I will give you some funny superfast tricks to collect, organize and clean your data for an automated exploratory