Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

H. ZhouLearn Data Mining Through Excelhttps://doi.org/10.1007/978-1-4842-9771-1_5

5. Cross-Validation and ROC

Hong Zhou¹  

(1)

Department of Mathematics and Computer Science, University of Saint Joseph, West Hartford, CT, USA

 

Please download the sample Excel files from https://github.com/hhohho/Learn-Data-Mining-through-Excel-2 for this chapter’s exercises.

General Understanding of Cross-Validation

A prediction model should be validated before it can be successfully applied to scoring data. Using the same training dataset as the testing dataset to assess the constructed model is not a good way to validate the model. Such a validating strategy is called