Confidence Interval of the Average of a F1 Score Samples I have a number of individual F1 score samples and right now I am measuring the average F1 score across this group. However, I would also like to present a confidence interval on it. Its a continuous value between 0 and 1 but which formula should i use? I know each F1 score has its own confidence interval based on Wilson's adjustment but when I take an average of a bunch of them, then what ? Thanks !

Given the SQL constraint, you might consider doing a comparison between bootstrap and a normal approximation. If you can show them to be close on a representative sample, you and your boss/customer might feel a lot better about using the normal approximation in a pure SQL pipeline. If the results are not close, then you know to take a different approach, such as something involving a beta distribution that is bounded between $0$ and $1$.
(You get to decide what qualifies as “close”.)
