Review and manipulate patient data table

In this assignment, you will use Excel to sort spreadsheet content in ascending order. 

Part 1

Download and open the Excel spreadsheet below:

The results you see in the spreadsheet are from blood sugar tests done on patients at Clinic XYZ in Tampa, FL, during the month of March, 2016. 

  1. Review the column headings and become familiar with the contents of the file. This is known as a “flat file,” since there is just a single table.
  2. Use Excel to perform a Data Sort on the field Glucose mg per dl, in ascending order. 
    • Note: Be sure you avoid “scrambling” your data — make sure you select the entire range as shown in the video. If you only select the column of data that you want to sort by, then only that data will be sorted and it will likely become disassociated from the rest of the data for that person. (Excel will even try to warn you if you try to sort but neglect to include adjacent data.)
  3. After you have performed the Sort, double-check to make sure you did not “scramble” the records (make sure the Glucose values are sorted but that the same people are still associated with their original values).
  4. Save your sorted Excel spreadsheet

Part 2

Download and open the question sheet below:

Use your sorted version of the Patient Fasting Blood Glucose Results Spreadsheet (from Part 1) to answer the questions.

Submit your completed Excel file from Part 1 and your Question Sheet from Part 2 to the drop box below.







Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10