Building an Excel calculator to determine statistical significance. I
want to know how large a sample size must be to reach statistical
significance at various confidence levels for various expected
outcomes. For example, I want to know how large my sample must be for
me to be 95% confident that my findings are normal given a particular
expected conversion rate. Here is an example of a
chart to answer the exact question I'm looking for given a 2% expected
conversion rate:

http://www.ar-search.com/media/whitepaper_roiDataSampling.pdf

I want someone to help me build an Excel calculator that will allow me
to build charts like that for ANY assumed conversion rate. If it's not
possible, I'd like a chart like the one shown for conversion rates
from .25% to 15% at each quarter point.

I made one. Change the value in B1 to get different conversion rates.

http://math.berkeley.edu/~jesse/normal.xls

This looks great. I'm going to play with it a little bit, and maybe
come back with some questions. Cool? I think it's right on though.

The sample at the url above is no longer available. Does anyone else
have a solution?