Excel Data Validation

This assignment provides you an opportunity to utilize the functions and tools of Excel to solve a basic
analytics scenario: data validation. The purpose of this assignment is to use Excel to quickly identify the
possible errors within the database, and not to visually examine all 6,000+ database records.
The HR tab in Hospital.xlsxPreview the document file contains the employee records downloaded from the
Human Resource database of a fictitious hospital. As with any acquired data, you must be aware of the
limitations of your dataset.
The sourcing database for Hospital.xlsx has a limit of twenty (20) characters for the Address 1 and Address 2
fields. Therefore, truncated addresses are not considered errors. The only errors in the Address fields that can
be easily identified in Excel would be a missing address or an address of insufficient length to contain a
deliverable address. Six characters is the minimum length for an address (e.g. “1 U St”.)
To accurately identify the possible errors in the Address 1 field, through Excel, you would need to create a
parsing algorithm to correctly determine the components of an address including the primary address number,
pre-directional, street name, suffix, post-directional, secondary address identifier, and secondary address.
Compound this with the Address 1 truncation issue and the creation of such an algorithm would be way too
advanced for this course. Therefore, there are NO Address 1 fields errors except a missing address or an
address of insufficient length to contain a deliverable address.
Data is required in all fields except Address 2 and Phone. If a phone number is entered it must adhere to the
999-999-9999 format. No rules concerning cases exist for any field.
Both five-digit zip codes and zip+4 zip codes are allowed in the Postal Code field. Also, remember that a zip
code may have more than one authorized city or spelling. Only one US zip code in Arizona (85142) crosses
county lines.
On the Errors tab in Hospital.xlsx Preview the document file, document each error by identifying the location of
the error (ID Number), the type of error (omission, range, data entry, etc.), the correct information if known, and
the formula used to identify the error. You receive one point for each error record identified; i.e. even if a record
contains more than one error, you receive only one point for that record. At least 100 data error records exist in
this file. Extra credit is available.
An additional file name Zipcode.xlsxPreview the document is available as a reference.
Remember, use Excel to sort and filter the database. Also, use the lookup and reference; text; and logical
functions to complete this assignment. If you do not explain how the error was identified, you do not get credit
for the error.

Sample Solution

The Back Bones Connected to the Neck Bone, and The X-beams Connected to Liberal Arts Education

Patients who don’t realize a lot of will pose a great deal of inquiries that specialists must comprehend. As new associates who are inexperienced with new openings or new machines, they need another person’s assistance. One of the respondents referenced in the Eriksson article said that they took in a ton from individuals cooperating, so as a partner they will help one another. Consequently, you can improve as a group by showing each other partners. In the event that they are effective laborers, particularly in the event that they have great relational abilities with one another, they can complete the work as fast as could be expected under the circumstances.

In the event that you are breaking a bone or doing an intensive dental test, you will be influenced by the X – beam gadget. X-beam photography is a technique for capturing interior organs and bones through garments and skin. This method decreases the requirement for exploratory medical procedure and makes determination and treatment of wounds and sicknesses quicker and more secure quicker. X-beam itself was found by German physicist Wilhelm Röntgen in 1896. In the same way as other different researchers, X – beam contemplates cathode lines. Since the mid-nineteenth century researchers have found that they can spill out of a charged conductor (called a cathode) to another conductor through a vacuum (generally a glass vessel from which practically the sum total of what air has been evacuated). did. . At the point when charge streams, the radiation has all the earmarks of being discharged from the contrarily charged terminal (called the cathode) to the anode, which is the decidedly charged cathode. This is a cathode line

In 1895, German researcher Wilhelm Conrad Röntgen first watched and recorded X-beams. He found that transmitting X – beams through his arms and hands made a point by point picture of the bones. At the point when you take X-beams, X-beam delicate movies are put on one side of the body and X-beams go through you. Bones are denser than the skin and retain more X-beams, so the bone shadow stays on the X-beam film and the skin looks straightforward. Our sun oriented radiation tops in the noticeable range, however the’s sun is more sultry, principally transmitting X-beams. So as to consider the sundial, researchers utilized information gathered by X – beam identifiers made on earth circle satellites. The dawn rocket in Japan made these x – beam pictures of the sun, permitting researchers to view and record the progression of sundial vitality

Different pieces of the body ingest X-beams to shifting degrees. Thick bones ingest the greater part of the radiation, however delicate tissues, for example, muscle, fat, organs send more X-beams. Thus, bone seems white with X-beams, delicate tissue is dim shadow, and air seems dark. Up to this point, the X-beam picture was still put away on an enormous film (it resembles a major photographic negative). Today, most pictures are electronically put away advanced records. These spared pictures are anything but difficult to get to and are frequently contrasted with ebb and flow X-beam pictures for conclusion and sickness the executives.

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.