Doing Business: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 70: Line 70:
= Instructions on pulling doing business series  =
= Instructions on pulling doing business series  =


#First I downloaded the data from the World Bank’s Doing Business database page [http://data.worldbank.org/data-catalog/doing-business-database http://data.worldbank.org/data-catalog/doing-business-database] by clicking on the link entitled "Doing Business(Excel)"
#The data can be accessed from the World Bank’s Doing Business database page [http://data.worldbank.org/data-catalog/doing-business-database http://data.worldbank.org/data-catalog/doing-business-database]. By clicking on the tab entitled "Data & Resources", the raw data can be downloaded either through CSV format or Excel format.
#This World Bank file contains three sheets with the names Data, Series, and Footnote. The Doing Business data was pulled from the Data tab. Prior to pulling the data from the Doing Business file, the country names were concorded with IFs country names. This resulted in some of the territories in the original World Bank file being excluded from what was imported into IFs.
#Using Excel files as an example, the file contains three sheets with the names Data, Series, and Footnote. The Doing Business data was acquired from the Data tab. Prior to importing the data into the IFs, the raw data needs some pre-processing. The first step is to concord the country names with the IFs country names since the IFs does not have a specific country concording list for Doing Business data. Then, the next step is to separate the data into several individual files based on different series. After those two procedures, the data should be ready for import.
#Certain series we had in the system are not being measured in the Doing Business data. If the data was included in the original download spreadsheet, then it was nearly always marked as Old methodology. Series that were not included in this data were typically not updated last time this data was pulled as well. 
#Certain series we had in the system are not being measured in the Doing Business data. Thus, series that were not included in the original downloaded data were typically not updated.
#Old series that were not updated are as follows: Rigidity of employment, difficulty of hiring, worker redundancy, redundancy index, average days to clear customs, and total tax rate (not a percentage of profit). The first four fall into the Labor Market regulation data, which the World Bank didn't include in their index of ease of doing business. There is separate data for this, however, the variables still don't seem to quite match up. There is no redundancy Index, there is no difficulty of hiring index, or rigidity of employment index. Average days to clear customs used old methodology. Total tax rate % profit was changed to Total tax rate % commercial profits the previous time this was pulled. 
#Series that were not updated are as follows: BetterBusinessIndex, BusinessRegulationIndex, ConstructionPermitDays, ConstructionPermitProcedures, EmpRigiIndex, ExportDocumentationNeeded, ImportDocumentationNeeded, HiringDiffIndex, RedundancyCostperWeekSalary, RedundancyIndex, TotalTaxRate. Note that the Tax%Profit series was updated using the "Total tax rate (% of profit)" in the raw downloaded data.


= Model implications =
= Model implications =

Revision as of 21:02, 8 October 2018

The World Bank has an annual global doing business report available here <http://www.doingbusiness.org/>. The latest data has been pulled from the 2017 report.

Series pulled from the World Bank Doing Business report 

Table
SeriesGovBetterBusinessIndex
SeriesGovBusinessRegulationIndex
SeriesGovWBDoingBusConstructionPermitDays
SeriesGovWBDoingBusConstructionPermitProcedures
SeriesGovWBDoingBusContainerExportCostUSD
SeriesGovWBDoingBusContainerImportCostUSD
SeriesGovWBDoingBusContractEnforceDays
SeriesGovWBDoingBusCostClose
SeriesGovWBDoingBusCreditTransparency
SeriesGovWBDoingBusDirectorLiability
SeriesGovWBDoingBusDisclosureIndex
SeriesGovWBDoingBusEmpRigiIndex
SeriesGovWBDoingBusExportDocumentationNeeded
SeriesGovWBDoingBusHiringDiffIndex
SeriesGovWBDoingBusImportDays
SeriesGovWBDoingBusImportDocumentationNeeded
SeriesGovWBDoingBusinessProcedures
SeriesGovWBDoingBusinessPropRegDays
SeriesGovWBDoingBusinessRanking
SeriesGovWBDoingBusinessStartDays
SeriesGovWBDoingBusInvestorProtection
SeriesGovWBDoingBusLegalRightsStrengthIndex
SeriesGovWBDoingBusPropertyProceduresRequired
SeriesGovWBDoingBusRedundancyCostperWeekSalary
SeriesGovWBDoingBusRedundancyIndex
SeriesGovWBDoingBusShareholderSuits
SeriesGovWBDoingBusTax%Profit
SeriesGovWBDoingBusTaxHoursperPerson
SeriesGovWBDoingBusTimeClose
SeriesGovWBDoingBusTotalTaxRate

Instructions on pulling doing business series 

  1. The data can be accessed from the World Bank’s Doing Business database page http://data.worldbank.org/data-catalog/doing-business-database. By clicking on the tab entitled "Data & Resources", the raw data can be downloaded either through CSV format or Excel format.
  2. Using Excel files as an example, the file contains three sheets with the names Data, Series, and Footnote. The Doing Business data was acquired from the Data tab. Prior to importing the data into the IFs, the raw data needs some pre-processing. The first step is to concord the country names with the IFs country names since the IFs does not have a specific country concording list for Doing Business data. Then, the next step is to separate the data into several individual files based on different series. After those two procedures, the data should be ready for import.
  3. Certain series we had in the system are not being measured in the Doing Business data. Thus, series that were not included in the original downloaded data were typically not updated.
  4. Series that were not updated are as follows: BetterBusinessIndex, BusinessRegulationIndex, ConstructionPermitDays, ConstructionPermitProcedures, EmpRigiIndex, ExportDocumentationNeeded, ImportDocumentationNeeded, HiringDiffIndex, RedundancyCostperWeekSalary, RedundancyIndex, TotalTaxRate. Note that the Tax%Profit series was updated using the "Total tax rate (% of profit)" in the raw downloaded data.

Model implications

What are the biggest differences (in both relative and absolute terms) in 2015? 2050? 2100?

What are the effects of these changes on other variables in the model?

Any other major changes or anomalies?

Retrieved from "https://pardeewiki.du.edu//index.php?title=Doing_Business&oldid=9170"