SINGLE-VARIABLES REPORT
In this preliminary data analysis, you will examine the individual measures of your variables for appropriateness and key statistics. This is also an opportunity to refine your thesis, develop your analytic skills, and expand your list of references.
DUE: Monday, April 30 by, 4 pm on paper, with an electronic version of your spreadsheet on disk or CD-ROM
or by email
Your report must be word processed (an electronic version of this form is available at: mdm4u.pbworks.com
A State your thesis. Your thesis is a statement describing the relationship you are studying. Keep in mind the purpose of this project is to determine IF your thesis is correct not THAT it is correct.
State the variables you are studying. These variables, and the measures below, may be different from those you listed in your proposal.
Individual Variable :Data Type (check): Absolute Relative
Codebook Measures:
# or Formula / Descriptioni
ii
iii
iv
Income Variable:
Data Type (check): Absolute Relative
Codebook Measures:
# or Formula / Descriptioni
ii
iii
iv
B Now you are ready to retrieve your data. For each of the variables in part A, download all the components of all the measures for your city from the E-Stat website http://estat.statcan.ca. The steps below will help guide you through this process.
Once at the E-Stat website http://estat.statcan.ca, click on “English”.
1. If you are working from home, the user name is “tdsbstu” and the password is “estat”.
2. Click on “Search Census” in the E-STAT menu on the left.
3. In the “Search for a geographic area” box, Search in: “2001 Census” and Search for your city. You will be using the data for “Large Urban Centres in Canada” or “Census Tracts”. (If your search does not return any items, search again for “Toronto”) This is usually the third group of listings.
4. Select the appropriate listing for one of your variables.
5. In the “Geography” box, select your assigned city.
6. Under “Characteristics”, click on “View Checklist”, then select all components of your measures listed in part A. When you are finished, click on “Return to Main Selection Form”.
7. If you were assigned all census tracts of a city, go to step 8. If you were assigned a portion of a city, under “Choose an output format” click on “Reduce or Sort Geo List”. Then highlight only the neighbourhood numbers in your assigned range.
8. Under Download to a file, select “Tab-Separated File”. This will create a file that Excel can understand.
9. Repeat steps 2 through 8 for your second variable.
Converting your data to a spreadsheet:
1. Launch Excel. Under the “File” menu, select “Open”. At the bottom of the window in the “Files of Type” box, select “All Files”. Find your data files and select to open.
2. Since your file from E-Stat was not an Excel file, the software needs to translate it. Click on “Finish”.
3. You may copy and paste the data from one spreadsheet to the other so that all your data is in a single file. Make sure that the “Geo” identifiers match.
4. Save your new file: Under the “File: menu select “Save As”. In the “Files of Type” box at the bottom, select “Microsoft Excel Workbook”. Specify the name of your new file and click “Save”.
Time to do some analysis:
1. The data you retrieved from E-Stat may not be the measures you have specified in part A. For each of these measures, use a formula to perform the calculation you described for the first neighbourhood. Then copy and paste this formula for the rest of the neighbourhoods of your assigned city.
2. Use the features of Excel and the skills learned in this course to complete the analysis table on the next page.
C. Select one of the measures from your individual variable from part B and one of the measures from your income variable for further analysis. For each of these two measures, construct a histogram according the criteria discussed in class and provide a two-page analysis, double-spaced, for each of the graphs. Your analysis must demonstrate your understanding of calculations and concepts of this course as well as provide insight into the people and processes that affect your variables. Cite any of the references from your proposal which help support your explanations. Keep in mind that the data you have will help explain what is happening but you need other sources to help explain why these patterns are occurring. If any of these references were not in your proposal, list the bibliographical information in APA format at the end of your analysis.
D. You may be asked by your teacher to present either one of the graphs and its analysis from part C to the class.
CP_SVR.doc
MDM4U Culminating Project / NameSINGLE-VARIABLES REPORT
INDIVIDUAL VARIABLE MEASURES / i / ii / iii / ivMeasure description from part A
Measure reference formula from part A
Measures of Central Tendency / Mean
Median
Mode
Which central tendency is the best representation for this variable, explain your reasoning
Measures of Spread / Minimum
First Quartile
Median
Third Quartile
Maximum
Interquartile Range
Identify any outliers for this variable by listing the Geography number for those observations
Measure of Variance / Standard Deviation
Identify the distribution type for this measure.
MDM4U Culminating Project / Name
SINGLE-VARIABLES REPORT
INCOME / i / ii / iii / ivMeasure description from part A
Measure reference formula from part A
Measures of Central Tendency / Mean
Median
Mode
Which central tendency is the best representation for this variable, explain your reasoning
Measures of Spread / Minimum
First Quartile
Median
Third Quartile
Maximum
Interquartile Range
Identify any outliers for this variable by listing the Geography number for those observations
Measure of Variance / Standard Deviation
Identify the distribution type for this measure.
CP_SVR.doc
MDM4U Culminating Project
SINGLE-VARIABLES REPORT
CP_SVR.doc