Using StatsCan Census
- Same instructions as using CANSIM in E-Stat except choose the Censuses in E-Stat option instead.
- Search Censuses Page: Select a Census. Leave this as 2006 Census and press Go!
- Database Selection Page: This page lists different databases where only some of the information is showing (only Aboriginal peoples) or it is organized into different regions (by 3 character postal codes, or by 48 metropolitan areas).
For this step you can keep it at option #1 – 2006 Census of Population (Provinces, Census Divisions, Municipalities). Press Go.
- Profile Selection Page: Leave this as 2006 Cumulative Profile and Press Go.
- Selection Page:
Step #1 – Geographic Region – select the geographic region you want to look at.
Step #2 – Click on View Checklist. Check off multiple criteria that you think might be normally distributed. See HINT in box below! Scroll all the way down to the bottom of the list and click Return to Selection Page
Step #3 – Choose the output format as .csv (comma separated value). This file type will work in both Excel and Fathom!!
- Click Retrieve Now. (It may begin to download automatically, OR you may need to click on click here to fetch the results). Save the results instead of opening them – and change the filename to something more descriptive (just my advice).
- Open the file in Excel and get rid of any extra content … this will hinder the process of Importing into Fathom. Save it, (you may want to do a Save As … to create a second file … some of the information you deleted may come in handy later on) but keep it in CSV format.
- Open Fathom. File – Import – Import from File. Select the file you have.
- You now have a collection. You can select it and drag on a table to see the data you got from E-STAT.
**You need to use data you think is normally distributed! You might not choose something that is! By showing that it isn’t … you can still show me you understand the course material!
Normal Distribution Assignment is now due Tuesday, Dec. 15th.