Estimate number of emails to be send
So, if you have the table with 5000 people, =counta(A:A)-1. -1 removed the
header row from your count.
so, you want 300 to answer.
=300/(.04*.27)
substitue 300, .04 and .27 with the cells that hold those numbers
"CD27" wrote:
Im trying to estimate the number of people I need to pull from a
database based off certain criteria:
1. 5,000 people pulled initially from database and sent emails
2. Of those 5,000 people 4% open email
3. Of that 4% or 200 people only 27% or 54 people actually click and
complete questions in email
4. 300 people needed to complete questions in email
So my question is how can I write this in an excel formula to see
what is the additional number of emails I need to pull above the
original 5000 knowing points 2,3,4?
Thanks for any help.
CD
|