I have a question about using cumulative values in calculating FPR and TPR for the ROC curve. The formula for calculating the AUC (cell H18) is =SUM(H7:H17). the formula in cell H9) is shown in Figure 2. The formula for calculating the area for the rectangle corresponding to row 9 (i.e.
5 show that the model’s ability to discriminate between success and failure is due to chance.įor Example 1, the AUC is simply the sum of the areas of each of the rectangles in the step function. The closer AUC is to 1 (the maximum value) the better the fit. In fact, the area under the curve (AUC) can be used for this purpose.
the closer to the line y = 1) the better the fit. Observation: The higher the ROC curve (i.e. The actual ROC curve is a step function with the points shown in the figure. The result is shown on the right side of Figure 1. The ROC curve can then be created by highlighting the range F7:G17 and selecting Insert > Charts|Scatter and adding the chart and axes titles (as described in Excel Charts). the entries for row 9 are calculated via the following formulas: Cellįigure 2 – Selected formulas from Figure 1 We begin by creating the ROC table as shown on the left side of Figure 1 from the input data in range A5:C17.įirst, we create the cumulative values for Failure and Success (columns D and E) and then the values of FPR and TPR for each row (columns F and G). The ROC Curve is a plot of values of the False Positive Rate (FPR) versus the True Positive Rate (TPR) for a specified cutoff value.Įxample 1: Create the ROC curve for Example 1 of Classification Table.
0 kommentar(er)
