Skip to Main Content

Tourism & Outdoor Recreation Management

Vividata Dapresy

 

This page walks you through how to create and read a data table in Vividata using the following sample question.

Sample question:
How many BC residents have taken overnight trips in the past 12 months?

How are Vividata tables organized?

Split = Who do you want to learn about (target population)? This is displayed in the columns (vertical) in blue. The term is called split because as you add variables they split the entire population of Canada up so you are only seeing data about your target population. 

Question = What do you want to know about the target population? This is displayed in the rows (horizontal) in orange.

 

Sample Question: 
- Split: British Columbia residents (target population)
Question: How many have take overnight trips in the past 12 months? (what we want to know)

How to make a table

Step 1: Choose variables

Explore the variables in the left menu by using the keyword search bar or by clicking on an item to expand the category. In the example below, Travel has been expanded. 

Step 2: Add variables as split or question

Hover over a variable in the left drop-down menu to:

  • Add as split (variable defining your target population) or
  • Add as question (variable asking a question about your target population).

The View answers option allows you to see all of the response choices, which can help you choose the most accurate variables. 

  • Hint If you do not need to see data for all possible answers, you can edit the variable. Once you've added the variable as a split or question, click on the left-icon of the variable and select only the answers you want to see.

You can also use filters to narrow your target population. Filters remove survey respondents who are not qualified or experienced enough to answer a subsequent question. For example:

  • Jewellery: personally bought in past 12 months? Yes/No

Subsequent questions will only be asked of those people who have answered "yes":

  • Amount spent
  • Types purchased
  • Where purchased

 

Sample Question: 
The variables added for the sample question are:
- Split: Demographics\Geography\Province (variable edited to only show British Columbia)
Question: Travel\Vacation\Personal Travel-Overnight Trips Personally-Taken Past 12 Months

How to read the table

When you are satisfied with the variables you've added as splits and questions, press Generate

The following data table is from our sample topic and associated variables. 

In the count column, read all numbers (except for unweighted base) with 000 at the end.

-- Vacation Trips (all Canadians 14+) 15,915  = 15,915,000

-- Vacation Trips (British Columbians 14+) 2,577  = 2,577,000

 

Use "Of [split], x have [question variable]" to frame how you describe the table data.

-- "Of [British Columbians aged 14+], 2,577,000 have [taken an overnight vacation trip in the past 12 months]."

 

The unweighted base is the total number of people who identify in your split (target audience). The unweighted base is the only number in the count column you to not add 000 to the end. 

The weighted base adjusts the number of respondents (unweighted base) so they are proportional to the actual base (in this case, all Canadians 14+).

  • Example: Of the 30,451 respondents (unweighted base), who represent 31,664,000 Canadians who are 14+ (weighted base), 50.3% have taken an overnight vacation trip in the past 12 months. This 50.3% represents 215,915,000 Canadians 14+.

Practice: Interpret the numbers for British Columbians using the chart above and the text template below:

Of the [unweighted base] respondents, who represent [weighted based] British Columbians who are 14+, [percentage] have taken an overnight  vacation trip in the past 12 months. This [percentage] represents [count] British Columbians 14+.


Tip: Just because you can add it as a split or question, it doesn't mean that there is enough data available for statistically sound results. For example, if your unweighted base is very small (15), it's not reasonable to extrapolate that those 15 people are representative of 30.3 million Canadians (if that's what your weighted base is). If you try to generate a table where there is insufficient data, Vividata will warn you by highlighting the problematic cells in the table.