Biostats Tutorial - Week 2 Worksheet 2023
docx
keyboard_arrow_up
School
Monash University *
*We aren’t endorsed by this school
Course
1042
Subject
Medicine
Date
Apr 3, 2024
Type
docx
Pages
13
Uploaded by EarlMandrill3163
BMS1042: Public Health and Preventive Medicine
Biostatistics tutorial – Week 2: Data variables and health
Tutorial objectives
●
Illustrate your data with appropriate graphs, tables and figures
●
Interpret the summary of your results and describe the impact on the population
●
Summarise data using the appropriate summary statistics i.e. mean/SD or median/IQR (ebook)
Things needed for online tutorials:
●
Laptop or tablet with Microsoft Excel toolkit | Graph Pad Prism 9 | SPSS (via MOVE)
(Note: Graph Pad Prism is not required until Week 3 & not available on tablets.)
●
Scientific calculator.
Graph Pad Prism eBook
– relevant lessons this week:
Regardless of software used:
Descriptive statistics
Pivot table (1 variable)
Pivot table (2 variables)
Theory behind contingency table %
If using Graph Pad Prism: All “Graphs” lessons Before the tutorial complete:
●
Worksheet
●
Graphical & Chart Representations – ebook on Moodle
During the tutorial we will cover:
●
Activity 1 ●
Activity 2
●
Small group activity – Identify graphs
After the tutorial, you will complete in your own time:
●
Consolidation Activity 3
Activity 1: Cross tabulation
A study on a university campus looking at alcohol drinking and security found the following:
Binge drinking
Never
Frequent
Total
Trouble with security
Yes
71
398
469
No
4992
2737
7729
Total
5063
3135
8198
Calculate the overall frequency for “trouble with security”
. Which direction % are you calculating?
Calculate the frequency for “trouble with security” for those who never binge drink
.
Calculate the frequency for “trouble with security” for those who frequently binge drink
.
Calculate the overall frequency for “frequent binge drinking”
. Which direction % are you calculating?
Calculate the frequency for “frequent binge drinking” for those who have trouble with security
Calculate the frequency for “frequent binge drinking” for those who DO NOT have trouble with security
.
What conclusions can you draw from the above percentages?
Which percentage is best to use in this particular case? Why?
Before getting the computer to draw a graph, it’s important to know what it should look like!
What type of graph should you do to display the data of trouble with security and binge drinking?
Sketch what the graph should look like.
Now, enter the required data into Microsoft Excel (or Google Sheets), and create the graph yourself.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Activity 2: Manually draw a histogram and boxplot from provided
The haemoglobin levels in the blood of 45 patients in hospital is below:
9.1
10.1
10.7
10.7
10.9
11.3
11.3
11.4
11.4
11.4
11.6
11.8
12.0
12.1
12.3
12.4
12.7
12.9
13.1
13.2
13.4
13.5
13.5
13.6
13.7
13.8
13.8
14.0
14.2
14.2
14.2
14.6
14.6
14.8
14.8
15.0
15.0
15.0
15.1
15.4
15.6
15.7
16.2
16.3
16.9
Data source: Haemoglobin data from p. 16, Advanced Level Mathematics: Statistics 1. Steve Dobbs and Jane Miller. Cambridge University Press. 2002
Task 1: Draw a histogram
a)
Create a frequency distribution table with 8 intervals. (Hint: Lecture slides or eBook)
●
What is a suitable width of each interval?
b)
Draw a Histogram of the data by hand.
Frequency distribution table
Haemoglobin (g/100 ml) range
Number
Draw your histogram here:
Task 2: Draw a boxplot
The haemoglobin levels in the blood of 45 patients in hospital is below:
9.1
10.1
10.7
10.7
10.9
11.3
11.3
11.4
11.4
11.4
11.6
11.8
12.0
12.1
12.3
12.4
12.7
12.9
13.1
13.2
13.4
13.5
13.5
13.6
13.7
13.8
13.8
14.0
14.2
14.2
14.2
14.6
14.6
14.8
14.8
15.0
15.0
15.0
15.1
15.4
15.6
15.7
16.2
16.3
16.9
Data source: Haemoglobin data from p. 16, Advanced Level Mathematics: Statistics 1. Steve Dobbs and Jane Miller. Cambridge University Press. 2002
What is the:
●
Minimum value? ___________
●
Maximum value? ___________
●
Median value? ____________
●
Q1? ____________________ How do you find Q1?
●
Q3? ____________________ How do you find Q3?
Copy-and-paste the data into Excel, and use the QUARTILE.INC() command to check your answers.
Manually draw the Box Plot. Clearly label what each section of the box plot is.
6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7
Small group activity: Identify graphs
For each graph below, identify what type of graph (Bar chart, etc) it is.
8
Consolidation Activity 3: Combining epidemiology & biostatistics = AIHW data
Non-fatal % and fatal % for the various “Disease of injury” categories in 2015.
Males
Females
Persons
Non-fatal
Fatal
Non-fatal
Fatal
Non-fatal
Fatal
All injury
14.5 %
85.5 %
24.7 %
75.3 %
17.7 %
82.3 %
Drowning
1.6 %
98.4 %
2.6 %
97.4 %
1.8 %
98.2 %
Falls
50.6 %
49.4 %
59.4 %
40.6 %
55.1 %
44.9 %
Fires, burns & scalds
50.7 %
49.3 %
60.8 %
39.2 %
54.6 %
45.4 %
Homicide & violence
24.4 %
75.6 %
18.4 %
81.6 %
22.4 %
77.6 %
Poisoning
0.8 %
99.2 %
1.3 %
98.7 %
0.9 %
99.1 %
Road traffic accidents – motor vehicle
8.5 %
91.5 %
13.8 %
86.2 %
10.3 %
89.7 %
Road traffic accidents –
motorbike
19.5 %
80.5 %
23.6 %
76.4 %
19.8 %
80.2 %
Road traffic accident – cyclist
49.1 %
50.9 %
76.6 %
23.4 %
52.7 %
47.3 %
Road traffic accident – pedestrian
12.3 %
87.7 %
19.2 %
80.8 %
14.5 %
85.5 %
Suicide & self-inflicted injuries
0.5 %
99.5 %
2.0 %
98.0 %
0.9 %
99.1 %
Source: https://www.aihw.gov.au/reports/burden-of-disease/abds-2015-interactive-data-disease-burden/contents/
fatal-vs-non-fatal-burden
●
Which categories have a higher Fatal % for Males? What about for Females?
9
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
10
●
Look at the graphs below, and comment on the distribution of males, females and persons by age.
●
How does the age distribution of “drowning” and “falls” compare?
11
●
How does the age distribution for “motor vehicle” and “motorbike” compare?
12
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
13