What is this formula saying for sample size?

[baindes]

Hello, I have a formula I inherited and I want to use actual cells to populate this. I don't know statistics enough to know what this says but can get kick started is anyone knows the math?

In cell E3 the value is 6419 (the amount of samples I sent out) in F3 where the formula is the value is 362. Here is the formula:
=E3/(1+(((E3-1)*(5^2))/(50*(100-50)*(IF(95=90,2.69,IF(95=95,3.84,6.66))))))

I am trying to figure out 2 things. 1. What can I do to make this formula easier and to understand it so I can type in 90% etc. Also I would like to create another formula that shows if I type in a value what the confidence interval actually is? I understand it on paper but not in excel.

Thank you

 

[fhqwgads]

my first instinct was to simplify the formula to

=E3/(1+(E3-1)/384)

but then i realized that's not what you want

i assume various numbers in the formula are meant to be entered manually or something so maybe change them into cell references and label them

	E       	F             	G     	H         	I
3	samples    	% of something 	stuff	i duno     formula	
4	6419          	95           	50  	5          362.3781241

formula in I4 is
=E4/(1+(((E4-1)*(H4^2))/(50*(100-G4)*(IF(F4=90,2.69,IF(F4=95,3.84,6.66))))))

hope that helps you make the formula easier to understand
sorry i cant help with the stats stuff

 

[baindes]

Hello, thank you for your kind reply. I was able to look further into the formula and get it to work with a little tweaking of what you did. So I appreciate that so very much!