MDM4UIIntroduction to E-STAT

Objective: This activity is an introduction to the Statistics Canada website. You will learn methods of data retrieval and how to create line and bar graphs using E-STAT.

Part A: Are Casinos Successful in Canada?

1.Go to website English.

  1. Select Browse by key resource-Data Tables. Select CANSIM.
  1. Type “gone to a casino” into the search box and select the any of these words option.

4. Select SEARCH for a list of data tables that are related to “gone to a casino.” There are active

tables and terminated tables. While terminated tables may still be used, they are not updated.

The data on active tables are updated on a regular basis (monthly, annually).

5.Select the code 426-0006. From the Subset Selection:

  • Select Add/Remove data tab at the top of the page.
  • Step 1: Check Canada (use the scroll bar).
  • Step 2: Check Went to a casino and deselect the rest.
  • Step 3: Select the earliest year to the most recent available.
  • Step 4: Select HTML table, time as columns.
  • Step 5: Press Apply button (you should be able to see the data now)

6. Select the Download tab at the top of the page

  • Option 1 – Language: English
  • Select the data output format type: time as rows
  • Select the file format: CSV (comma-separated values) English spreadsheet
  • Press Download data (Note: Option 2 downloads the entire table)
  • Click on Download file from CANSIM (CSV Version …..)

7.Next, clean up the data and organize in a table with two columns.

8.Produce aLine Graph, which is best for a relationship over a long period of time (but it is sometimes useful to display the data as a bar chart, table of values, etc.). Remember to label the horizontal and vertical axis of the graph as well as the graph itself.

9.Right click on the graph. Select copy. Open a word-processing document and paste. You may have to adjust the graph (e.g., in Microsoft Word double click and in Layout select square). Write a summary about how this graph could help you answer the question, “Are casinos successful in Canada”. Save the document, but do not close it.

10. Repeat step 8 but this time produce a bar graph and copy it to the word file.

11.Return to your Internet Browser. To compare the number of people who went to a casino who live in Ontario to those who live in Quebec and British Columbia, select the Add/Remove data tab.

  • Step 1: Select Quebec, Ontario, and British Columbia (use the scroll bar to scroll down)
  • Step 5: Press the Apply button.
  • Select the Download tab and follow instructions in step 6

12.Clean up and organize the information in Microsoft Excel and produce a line graph and vertical bar chart. Remember to label the axis as well as the graph (use an appropriate title). Copy the graphs into the word-processing document.

13.In your document, discuss which graph tells you more about the casinos in Canada.

14.You may notice that there are some data missing from the graphs. Select the Data table tab. At the bottom of the table is an explanation of why some data are missing; they are labelled secure or confidential. Copy it into your document by holding control and selecting the cells in the table. Then right click and paste into your word processing document.

15.Write a final summary about the success of casinos in Canada using and referring to the data and graphs. Print the document for your notebook.

Exercise:Investigate if there is a relationship between beer production and impaired driving in Canada.

  1. Type “Food, Beverage and Tobacco” into the search box and select the any of these words option.
  1. Select SEARCH for a list of data tables that are related to the search.” There are active

tables and terminated tables. While terminated tables may still be used, they are not updated. The data on active tables are updated on a regular basis (monthly, annually).

  1. Select Table303-0019. From the Subset Selection:
  • Select Add/Remove data tab at the top of the page.
  • Step 1: Check Canada (use the scroll bar).
  • Step 2: Check Beer production (litres) and deselect the rest.
  • Step 3: Select the earliest month to the most recent available.
  • Step 4: Select HTML table, time as columns.
  • Step 5: Press Apply button (you should be able to see the data now)
  1. Select the Download tab at the top of the page
  • Option 1 – Language: English
  • Select the data output format type: time as rows
  • Select the file format: CSV (comma-separated values) English spreadsheet
  • Press Download data (Note: Option 2 downloads the entire table)
  • Click on Download file from CANSIM (CSV Version …..)

7.Next, clean up the data and organize in a table with two columns. Save the file as you will need it later.

8. Repeat Step 1, but this time search for “impaired driving”. Select Table 255-0001 (last table in page 2)

9. In Step 2: Select Driving while impaired(section 234 Criminal Code).

10. Download the file by repeating the steps above.

11. Open a Microsoft Excel file and copy and paste the information for “Food, Beverage, and Tobacco” and for “Impaired driving”and produce a line graph.

Note: If the information doesn’t match for the “impaired driving”, then you can go back to the internet browser and select the Manipulate tab and select Year-to-date averages.

HitApplyto see the data and download the file.

  1. Copy this graph into a word-processing document and discuss: What might this data imply? What information may also be helpful to investigate? Is there a relationship? Would you investigate this data further?
  2. What factors might explain the overall trend in impaired driving charges?
  3. What factors might explain the overall trend in beer production?