1 / 7

Comprehensive Data Analysis and Cleaning for Animal Health Reports

This project focuses on analyzing animal health data to evaluate the treatment efficacy of vitamins and antibiotics. Key metrics include total species counts, vitamin usage rates, survival proportions among treated and untreated animals, and a breakdown of the five most common diseases. The analysis includes visual representations of data trends over time, including a monthly chart of disease incidence and seasonal patterns. The data cleaning process integrates all information into a single worksheet, removing merged cells and unnecessary rows while utilizing various Excel functions for effective management.

sef
Télécharger la présentation

Comprehensive Data Analysis and Cleaning for Animal Health Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data analysis exercise

  2. Data LaporanPetugas • Questions • Total animals of each species • Vitamin usage • Proportion treated with vitamins • Of those treated, proportion survived • Of those not treated, proportion survived • List the five most common diseases • Display on a graph • Seasonal pattern of disease • Chart of reported incidence by month

  3. Data cleaning • Move all data into single worksheet • Remove all merged cells • Sort all data by date • Headers and empty fields go to bottom • Delete unneeded rows • Remove all lines

  4. Separating species and number • Two approaches • Use of formula • A bit complex • Some manual correction needed • Use of “Text to Column function” • Faster, simpler • Some manual correction needed

  5. Formulae that could be used • Search() • Trim() • Left() • Proper() • Mid() • Iserror() • As well as some manual error correction

  6. Text to columns • Make empty column • HighlighJenis & JML column • Click Text to Columns on Data tab • Delimited, then Next • Check space and other, then enter ‘-’ for other • Click Finish

  7. Use of Antibiotics or Vitamins • Formulae • Trim • Proper • If() • Isblank()

More Related