Back up and national data validation
Download
1 / 11

Back Up and National Data Validation - PowerPoint PPT Presentation


  • 107 Views
  • Uploaded on

Back Up and National Data Validation. Expert Group Meeting on Price Statistics and National Accounts: ICP Round 2011 Jointly organized by: UN-ECLAC, CARICOM, CARTAC and ECCB 3rd-6th December 2012 Santiago de Chile. Summary. Back Up of databases ICP KIT Demonstration.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Back Up and National Data Validation' - mayten


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Back up and national data validation

BackUpandNational Data Validation

Expert Group Meeting on Price Statistics and National Accounts:

ICP Round 2011

Jointly organized by:

UN-ECLAC, CARICOM, CARTAC and ECCB

3rd-6th December 2012

Santiago de Chile


Summary
Summary

  • Back Up of databases

  • ICP KIT Demonstration


Back up of databases
Back Up of databases

  • Create one folder for each quarter

  • In each folder you will save the following files:

    • Country Master file

    • Data Entry file

    • Prices data base in ICP KIT format

    • Average prices files (exported from ICP KIT)

  • You will need to update each folder each time you make corrections to the files.


Icp kit demonstration
ICP KIT Demonstration

  • Remember you need to create one data base for each quarter.

  • In ICP KIT the creation of databases in done in the Data Entry Module, in the Set Up

  • In the “Create Database” box you will click on “…”

  • You will give a name to the database and save it in the correct folder

  • Click on “create”

  • In the “Change Database” box you will click on “…”

  • You will search for the database you have just created

  • Click on “save”

  • The name of the database will be displayed on top of screen.


  • You need to Upload your country master file

  • Click on “import master file”

  • If the master file is imported successfully you will get a “success” message

  • Set the dates for the quarter you are working on. (This step is extremely important)

  • You now need to upload your data

  • Go to multiple entry sheet

  • Click on “Data Entry Mode”

  • Click on “Import”


  • If you get an error message click on the link of the “errors file” on top of the screen

  • Remember to correct your data entry file in excel from bottom to top

  • Once you have finished uploading, click on “save”

  • Then unclick the “data entry mode”

  • Select the corresponding Dates (very important)

  • Click on “Get Data”

  • Make sure you have all the observations you have uploaded by checking the total number of observation at the bottom of the screen


  • You now need to validate your data “errors file” on top of the screen

  • Go to the Validation Module

  • click on “change database”

  • You will search for the database you have just created

  • Get the data (be careful with the dates)

  • Set the parameters (CV =33, T ratio = 2, Overall deviation=50 and MinMax Ratio= 0.5)

  • Click on validate

  • Validate the observations highlighted with colors

  • Remember you have to click on the product you wan to validate and then go to the “observations” sheet to check each of them

  • If you want to reject an observation to “reject” column


  • If your are correcting observations in the ICP KIT Validation Module, it is always a good idea to also correct them in the data entry template. In this case you will have back up in two different formats

  • You can also export the observations from ICP KIT Data entry Module once you have finish validating

  • You can also export the rejected observations separately

  • Make sure you save all the files in the corresponding folder

  • If there is more than one person correcting the database in different computers, she needs to export the raw data and make a joint raw data file to have all the information together. Remember that PCs do not communicate with each other with ICP KIT



How to go from one database to the other
How to go from one database to the other? the averages

  • You need to go to the Data Entry Module

  • In the “change database” box click on “…”

  • Search for the database you want to work on.

  • Click on “save”

  • To make sure you are working with the correct database check the name of it on top of the screen

  • You will set the dates (very important)

  • And then click on “Get Data”

  • In the validation module click on “change database”

  • Select the database and save.


THANK YOU the averages


ad