Emerging Infectious Diseases Data Analysis Exercise for Australia-Indonesia Partnership
Data analysis exercise
Data Laporan Petugas
•
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
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
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
Formulae that could be used
•
Search()
•
Trim()
•
Left()
•
Proper()
•
Mid()
•
Iserror()
•
As well as some manual error correction
Text to columns
•
Make empty column
•
Highligh Jenis & JML column
•
Click Text to Columns on Data tab
•
Delimited, then Next
•
Check space and other, then enter ‘-’ for other
•
Click Finish
Use of Antibiotics or Vitamins
•
Formulae
–
Trim
–
Proper
–
If()
–
Isblank()
Explore the data analysis exercise conducted under the Australia-Indonesia Partnership for Emerging Infectious Diseases. The exercise involves tasks such as analyzing total animals of each species, vitamin usage, disease prevalence, seasonal patterns, and data cleaning techniques. Various images illustrate steps like separating species and numbers, using formulae, and data manipulation for efficient analysis.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Data analysis exercise AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
Data Laporan Petugas 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 AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
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 AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
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 AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
Formulae that could be used Search() Trim() Left() Proper() Mid() Iserror() As well as some manual error correction AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
Text to columns Make empty column Highligh Jenis & JML column Click Text to Columns on Data tab Delimited, then Next Check space and other, then enter - for other Click Finish AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
Use of Antibiotics or Vitamins Formulae Trim Proper If() Isblank() AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
