Mark E. answered 03/03/23
Quantitative analyst in the investment industry; taught AP Stats
We want to find the amount budgeted so the probability of it being exceeded is 11%. So the probability that it is not exceeded is 89%.
Since we know the probability and we want to know the number of dollars, we use inverse-normal.
One way to use it is to find the z-score such that 89% is below and 11% is above:
Inverse-norm takes the area to the left as the input and returns the z-score:
invnorm(0.89) = 1.23
So our z-score is 1.23. And z = (x - u) / sigma
we know u=623 and sigma=40 and want x:
1.23 = (x-623)/40 so x=672
You could also use invnorm(0.89,623,40) and let the calculator deal with the z-score