Belen Chavez
  • Introduction
  • About
  • Teaching
  • Data Blog
  • Calligraphy

Week 6 - Midterm Project - Part 1

2/24/2016

0 Comments

 
You are to create an Excel file through Stata which requires the use of spmap, sh2dta, mqgeocode, and putexcel to combine multiple data sources and summarize findings.  See instructions in midterm_project_part1.pdf below. 
sd_info.xlsx
File Size: 280 kb
File Type: xlsx
Download File

midterm_project_part_1.pdf
File Size: 101 kb
File Type: pdf
Download File


Data: 
  1. ​Use 2014 ACS 5-year estimates using American FactFinder to download data for your assigned county (with census tract information). ACS Data can also be downloaded here
  2. Shape files for California census tracts (Select Layer: census tracts) 
  3. California Brewery Data located below
CA_Breweries.dta
File Size: 67 kb
File Type: dta
Download File


Use ACS FactFinder to double-check your work to ensure you have the correct results. See screenshot below. Top is from FactFinder Community Facts for San Diego County. The bottom is from the table in SD_Info.xlsx. 
Picture

Helpful Links

  • ​Stata FAQ working with spmap
  • spmap presentation 
  • Multilayered maps
  • Extra: Spatial Data Analysis presentation
  • Stata putexcel 14 help 
0 Comments



Leave a Reply.

    Economics 641L 
    ​Spring 2016

    I will be posting most course material on this page for the Econometrics Lab course at SDSU.

    See Blackboard for assignment submissions.

    Week:

    All
    Week 01
    Week 02
    Week 03
    Week 04
    Week 05
    Week 06
    Week 07
    Week 08
    Week 09
    Week 12

    Monthly Archives:

    April 2016
    March 2016
    February 2016
    January 2016

Proudly powered by Weebly
  • Introduction
  • About
  • Teaching
  • Data Blog
  • Calligraphy