Posts by nimbleangler21

I've been messing around with Z-tests, NORM.DIST, PROB, and a whole bunch of other formulas, but I can't seem to get a single accurate result out of any of them... It’s driving me crazy because the formula keeps asking me to input a probability, but I don't actually have the probability yet—that's the whole point of the calculation 🤷 I've already crunched the numbers for returns, standard deviations, and Value at Risk, so now I'm supposed to use those to figure out the likelihood that the return will be a) positive, or b) greater than 1

Hey everyone, how do you actually calculate probability in Excel? Specifically, I'm trying to figure out the odds of returns being positive (
I tried messing around with that NORM.INV function, but it’s just not working for me...