Member200 invited guests
170 RSVPed yes
162 ended up attending
of those 162 attending:
39 had to drive less than one hour
71 had to drive 1-3 hours
22 had to drive more than 3 hours
30 had to get on a plane
MemberWe invited 187 people, including parents and siblings
Of those that attended,
38 were local (had to drive less than an hour)
6 had to drive one to three hours
37 had to drive more than three hours
27 had to take a plane
Most of those who didn’t attend were out of state and would have had to take a plane. A lot of those same people had military conflicts or were deployed at the time. Only 2 of our in-town guests didn’t RSVP “yes” and 4 invitees from 1-3 hours away couldn’t make it.
Member– your total number of invited guests: 96
– had to drive less than one hour: 0
– had to drive 1-3 hours: 32 people (of all invites)
– had to drive more than 3 hours: 0
– had to get on a plane: 64 people (of all invites)
Final count: 63 people
– had to drive 1-3 hours: 22 people
– had to get on a plane: 41 people
MemberThis Formula never fails
Number of invited guest/2 = that is how many will show up
The topic ‘please help me come up with a formula to estimate what percent will rsvp yes!’ is closed to new replies.