Can Microsoft add a function like CONFIDENCE.P to calculate confidence intervals for proportions? I can put the appropriate equation in a cell and use other cells with values for p, n, and z a/2, but it seems like it wouldn't be that hard to just have a function to calculate it. It wouldn't be that different from CONFIDENCE.NORM or CONFIDENCE..T. Does anyone else think that would be useful?
I submitted this suggestion to MS. Here is the link if you are interested--please vote for it!