Tag Archives: Excel VBA Institute

Did You Know That About 1 in 5 Genetic Papers Have MS Excel Errors?

dexlab

If you have ever used a spreadsheet program then you are well-acquainted with the frustrations produced by entering one thing and having it auto formatted into something else. If such formatting errors go unnoticed then it will definitely lead to serious repercussions when it comes to company finances in the commercial scenario, but when it comes to the serious sciences like genetics their outcomes will be catastrophic.

Recently a study published in the journal of Genome Biology stated that 19.6 percent i.e. roughly 1 in 5 of all genetics papers published that contained spreadsheets had such errors. The main reason behind the problem is the way how genomic names are written. To consider an example, the gene called – “Membrane-Associated Ring Finger (C3HC4) 1, E3 Ubiquitin Protein Ligase” is written as MARCH1 in shorthand. But in Excel due to its default settings, it is automatically converted into 1-Mar or some other calendar date format.

Similarly when scientists enter genetic ID numbers they get converted into floating point numbers like – 2310009E13 became 2.31E+13. And as per Popular Mechanics, it is not possible for the scientists to completely reformat their excel files. So, instead they choose to reformat a blank document and then re-enter their data cell by cell. However, fortunately these errors do not have any effects on the paper’s original findings, but they may pose a serious problem for scientists who would want to replicate the study.

Here is some more insight on the issue:

Recently in a convention for geneticists, the speaker began with the snarky statement that – if you thought autocorrect was a bummer for your Whatsapp texts then you should talk to a geneticist instead. While automated features and productivity tweaks are supposed to save people time and work, they are often times counterproductive as they insert errors into our substantial pieces of work. And sadly, that is the case for an alarming number of academic papers in genetics.

Many academic papers come with supplemental files complete with charts, table and other tabular data and ideally such files are there to support the data and other aspects of the research. They are also useful for fellow researchers to take the work further. While all things remain fine in an ideal scenario, but some automated features in Excel some important data such as scientific names, floating point numbers and dates ends up getting reformatted and causes much too trouble for the scientific community causing havoc confusion. This problem with automatic reformatting occurs all the time and scientists had found the issue back in 2004 and the problem has still persisted since then.

An extensive research has been conducted by Mark Ziemann, Yotam Eren and Assam El-Osta on gene name conversion revealed that about 20 percent of all papers with supplemental spreadsheets have such errors appearing in them. The researchers took a note of more than 35,000 supplemental Excel files attached to such research documents related to genetic studies. They employed automated software to search and filter anything that resembled lists of genes and narrowed the field to about 3597 papers with several supplemental files. Then they went on to screen for the 10 most common false positive cases and discovered them in files attached to some 704 publishing houses who have published such papers. That is 19.6 percent of all the research papers they screened.

So, while many of us have been the victim of autocorrect changing the meaning of our text messages, some with hilarious results but in the case of genetic studies this matter is of no big laughs. These papers are assets for the scientific community and are often used by new generations of researchers to further study the matters. But having such massive errors on the papers can definitely slow things down and create problems for science to advance.

Science has already seen several wasted years in the world due to human intervention with obstacles to free thinking and questioning in the past riding on government or authoritarian censorship eating away people’s ideas of genius.

To further worsen the situation, there is no way we can turn off this autocorrect feature in Microsoft Excel permanently. Fortunately, researchers have discovered that Google Sheets does not perform such automated correctional functions, and if people copied such content from Google Sheets into other forms of spreadsheet programs then the formatting of these data were preserved.

So, until the prominent spreadsheet software manufacturers can figure out a way to offer people with the feature to switch off such autocorrect functions, it will probably fall in the hands of some young, unfortunate research assistant to double check this massive amount of data and correct the lists of gene names.

To learn more about common application of MS Excel and some nifty tricks for spreadsheet software take up an advanced Excel course in Gurgaon from DexLab Analytics, the premiere analytics training institute in India.

Advertisements

Get To Know MS Excel Essentials

MS Excel is part and parcel of the workforce and work tools. It is one of those things that have acquired a permanent place in our work habits. This presentation will get you a glimpse of all the things are required to be known in order to be proficient at its basics. But Excel has several advanced uses that are best explored with a course from MS Excel Training Centre of repute like DexLab Analytics.

Related posts :

Business Analyst Training Courses in Delhi & Gurgaon

Best Excel VBA Institute in Gurgaon and Delhi

Advanced excel VBA institute in Gurgaon and Delhi

Benefits Organizations can get from SAS Data Management

Big Data Hadoop- Before You Start Off

How to Use Big Data for Advanced Customer Experience

How to Use Big Data for Advanced Customer Experience

With computerized information development anticipated to increment by 4,300% all over the world by 2020 and viable weights rising, organizations should now like never before convene the growing requests of their customers.

This digital upheaval is additionally giving remarkable chances to enhance the general client experience by means of big data analytics, as per a study conducted by Big Data Hadoop certification in Gurgaon. This is the procedure of gathering and deciphering these boundless amounts of information to separate the important, savvy, and helpful information that gives worth to a customer.

The following are 3 tips to utilize Big Data to improve general customer experience.

Actualize proactive bill shock administration

Bill shock is client agony from unforeseen allegations and is normally the consequence of broadband clients’ powerlessness to evaluate their huge information utilization, particularly while roaming. These disappointed clients can adversely affect the correspondence administration supplier’s repute and at last prompt income misfortune. Broadband organizations can stay away from this by giving continuous authorization activities and choices, through content warnings or email, permit free limited skimming, and divert clients to exchange information arrangements to dodge upcoming concerns.

Make more intelligent customized shopping encounters

Opt-in versatile showcasing correspondences of focused items and administrations can then be offered through customized messages particular to every phase of the purchaser cycle – mindfulness, engagement, thought, change and steadfastness. Suppose somebody selects to get promoting messages from a retailer who has an outlet in the neighborhood shopping center. GPS-incorporated tracking recognizes that the client is close to the store and sends the client an instant message alarming them to a unique one-day offer. With the client’s advantage provoked, she heads into the store and buys utilizing the coupon code as a part of the instant message.

Diminish holding up time in the line

A service organization, for instance, can deal with this perpetual agony of getting, as to orchestrate a home repair visit by getting the purchaser’s favored channel of correspondence, affirming the evening before in a mechanized way by means of that favored channel, and illuminating the client that the administration tech will call at 8:00 a.m. to tell the purchaser where he remains in the everyday line. This joys the client and disposes of the expense of up to three inbound telephone calls.

You have to know clients as people if you need to win them and then you’ll make more intelligent choices about their needs and practices.

Related posts :

Business Analyst Training Courses in Delhi & Gurgaon

Best Excel VBA Institute in Gurgaon and Delhi

Advanced excel VBA institute in Gurgaon and Delhi

%d bloggers like this: