I have a quick question I would humbly like to ask for your help to solve: let's assume that I am analyzing a sample series of events with different probabilities of success. There are only 2 possible results: "success" or "failure".
See the table below for reference:
To find the EV of this set, I took the number of Successes (6) and from that, subtracted the sum of all percentages in the column a_prob (7,41). Therefore, 6 - 7,41 = -1,41, which should be the EV for this set.
What I would like to know now is by how much this EV can vary, considering that this data set is a sample of a bigger universe. My first idea was to calculate the Standard Deviation, but the EV is a constant, so I am not sure if I can apply StDev to that.
So first question would be: how can I know the variability of the number?
And second: how can I calculate that using Excel?
Obs: My knowledge in statistics is very limited. I am still learning - please let me know if my question is formulated poorly or if it is just plainly stupid haha.
Thank you so much in advance!
EDIT 1: Grammar, correcting mistakes. And thanks for the answers so far - the question was worded poorly before. I hope it is understandable now.