Find allowed errors when accuracy, confidence, and number of trials is known

[SerenityNetworks]

I can use the BINOMDIST to find the sample size needed when I provide the required accuracy, confidence level, and number of errors. But I'd like to go the other way and find the number of allowed errors when I know the required accuracy, required confidence level, and number of trials. Is there a similar statistical function or formula I can use to do this? I've searched, but I'm not familiar enough with statistical functions to know if I'm just missing it or not.

Thanks in advance,
Andrew

 

[StephenCrump]

For reference, a lot of posts in this thread to a related question: https://www.mrexcel.com/forum/excel...-required-accuracy-confidence-statistics.html

 

[SerenityNetworks]

Thank you Stephen for looking to possible leads for me, but that was the thread I started to work on a better way to solve for sample sizes. There are four aspects to this topic. Solving for sample sizes, solving for accuracy, solving for confidence level, and solving for allowed errors. The thread you referenced deals with the first three. This thread is for the one remaining; solving for allowed errors.

 

[StephenCrump]

For reference ....

To clarify, I meant for the reference of anyone who might be responding to your question.

Looks to to me as if there will be useful material in this other thread.

 

[SerenityNetworks]

Gotcha. Thank you.

 

[SerenityNetworks]

Never mind. I figured it out.