Hey, I need to do a series of calculations using the norminv function and some other things I'm unfamiliar with. Here is a description of what I need to do:
If you have Excel, you put in the daily odds, then get prob = 1/(1+odds), then zscore = norminv(p) and make the zscore negative if the odds were below chance. Then add up all the zscores and divide by sqrt(numdays), and convert back to probability with normdist(z).
Could I anyone give me step by step instructions on how to do this on Excel? I would be *deeply* appreciative. thanks a lot!