how is F1 score calculated in the model comparison tool report?

[Gualigee]

Hi 

My calculation of recall matched the model comparison tool report, but F1 did not. 

where did I go wrong?

I attached my calculation for your reference. 

Thanks!

[AngelosPachis]

Hi @Gualigee ,

The model comparison tool is a macro, so you can open it up to look what's under the hood; you can do that by right-clicking on the tool itself and then select open macro

Now in the macro it seems that all calcs are carried out in an R tool. You can look at the code to learn more about the formula used for the F1 score (attaching a screenshot for your convenience)

Hope that helps,

Angelos

[Gualigee]

Thank you @AngelosPachis  for letting me know it is a macro. Actually, I wonder how F1 is mathematically calculated. Column M and Column N in the attached excel is how I calculated F1 but it does not match the results in the model comparison report. Can you please advise? Thanks.