We could use SQL to calculate the percent change between each question, but it’s just as easy to analyze these manually with a calculator or in a spreadsheet program like Microsoft Excel or Google Sheets.

If we divide the number of people completing each step by the number of people completing the previous step:

Question Percent Completed this Question
1 100%
2 95%
3 82%
4 95%
5 74%

We see that Questions 2 and 4 have high completion rates, but Questions 3 and 5 have lower rates.

This suggests that age and household income are more sensitive questions that people might be reluctant to answer!


We learned how to build a funnel from a single table. Next, let’s see how we compare funnels for A/B Testing.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?