Teaching analytics with modern Excel
Traditionally, filtering a dataset by multiple AND/OR conditions involved use of the Advanced Filters feature. While menu-driven, Advanced Filters can be difficult to manage and applies filters …
Continue Reading about How to filter a dataset by one or more criteria using Excel formulas →
A common practice in machine learning and predictive analytics is to split a dataset into training and testing subsets. The training subset is used to build the actual model, while the testing is used …
Continue Reading about How to create training and testing data samples in Excel →
