Manipulating Data » Walkthrough Exercise » Importing and exporting data

Importing and exporting data

  1. Create a new CIS census file
  2. Import the ascii census data file under 'Exercise 3' - Wheat in 1970, England and Wales
  3. Copy the map into Word
  4. Open 'political.ccf' and 'westmidlands.rgn'
  5. Overlay the region with the counties
  6. Copy the table into Excel

Time: 15 minutes

Questions

Advanced: Add the tables of Wheat 1970 to the data table in 'File Details' for your new census file. What was the percentage cover of wheat in the West Midlands in 1970?

Answers

Advanced: Add the tables of Wheat 1970 to the data table in 'File Details' for your new census file. What was the percentage cover of wheat in the West Midlands in 1970? 6.431

click here for answers