Data Entry Error, the Reason Behind Ontario Election Reversal

by | Last updated Jul 15, 2023 | Published on Jul 28, 2014 | Data Entry Services

Data Entry ErrorThe process of data entry, which comprises entering of textual information from print or audio sources into documents, spreadsheets and databases, may seem a simple thing. However, even a simple error can have disastrous consequences and lead to unpredictable results. A clerical mistake occurring when entering details into electoral databases and when entering election results is not something new. A recent alarming incident that happened during the elections at Ontario confirms this fact.

According to a recent report, a data entry error led to the progressive conservative candidate Gila Martow being declared to have lost to her opponent Ms. Yeung Racco by 85 votes. However, after an official tabulation of votes it was found that Ms. Martow had actually received eighty-five votes more than Ms. Yeung Racco. 21, 868 ballots had been cast for Ms. Martow and 21, 783 for Ms. Yeung Racco.

Errors in documentation can have serious consequences, and are therefore best avoided. The common reasons for erroneous entry of information are:

  • Entering words in place of numbers
  • Entering multiple values in a column/cell
  • Copying errors like 0 entered as ‘o’
  • Transposition errors – 19 will be wrongly entered as 91
  • Range errors – responses outside the range of possible answers

Even though data entry errors cannot be eliminated completely, adopting certain measures can prevent them to a certain extent.

  • During data capture, check for completeness and legibility of data
  • Check for range errors, so as to avoid inappropriate results like age greater than 110
  • Mechanism for validation of entered data

However detecting data entry errors is not very easy. Relying on histograms or frequency tables is not a permanent solution. It is better to implement a mechanism with advanced methods such as double data entry.

Recent Posts

Navigating the Steps to Successful Data Cleansing

Navigating the Steps to Successful Data Cleansing

Dirty data refers to any data that is inaccurate, incomplete, or inconsistent. It’s reported that companies believe at least 26% of their data is dirty and that they experience losses because of this. Businesses are increasingly turning to data cleansing companies to...

Strategies for Effective Data Entry Outsourcing: 10 Practical Tips

Strategies for Effective Data Entry Outsourcing: 10 Practical Tips

Data entry plays a vital role in many industries. Having timely accurate data is crucial for companies to make informed decisions, manage customer relationships, and track business performance. Data entry is a time-consuming, tedious, and error-prone task. Any company...

Share This