Excel provides the necessary tools to create a basic ROC curve, but it lacks some advanced features:
Creating an ROC curve in Excel is feasible, but it requires technical expertise and can be time-consuming. While Excel provides the necessary tools, its limitations, such as lack of threshold optimization and bootstrapping, may lead to incomplete or inaccurate analysis. For users who frequently work with ROC curves, we recommend exploring specialized software or programming libraries. roc curve excel
You need to calculate the Cumulative True Positives and Cumulative False Positives for every unique probability score (threshold). Excel provides the necessary tools to create a