Assessment 3: Public Health Data Analysis

Assessment 3: Public Health Data Analysis

Assessment 3: Public Health Data Analysis

Weighting: 30 %

Details of task:

This assignment involves the presentation and interpretation of descriptive statistics and statistical test results.

  1. You have been randomly allocated to 1 of a large number of different datasets from the Crescentville Data Set on Moodle.
  2. This task will take approximately 10 – 12 hrs to complete.

On completion of this assessment task, you will be able to:

  • Demonstrate an ability to present data clearly and interpret its results
  • Conduct and show workings where appropriate for various statistical tests
  • Describe the epidemiological foundations for obtaining the data
  • Ability to generate an interpret results based on various statistical tests and public health tasks

Word limit: This assessment is 2,500 word equivalent with a focus on calculations and reporting.

Format: Your results will be submitted in a question and answer format using a quiz mode on Moodle. This report requires extensive data analysis and interpretation skills.

Submission is final and your attempt can NOT be reopened.

Criteria for marking: Question set and marking guide are available on the unit’s Moodle site

Attempts allowed: 1

Release date: Monday, 2 August 2021, 10:00 AM

Due date: Wednesday 13 October 2021, 10:00 AM

Assessment 3: Public Health Data Analysis

In 2002, arthritis and musculoskeletal conditions were identified as a National Health Priority Area and a major health problem in Australia. Arthritis can have a profound impact on a person’s quality of life and wellbeing due to acute and chronic pain, physical limitations, management of the condition and mental health issues. This can often result in withdrawal from social, community and occupational activities.

According to the Australian Institute of Health and Welfare (AIHW) the burden of disease is (updated 06/05/2020):

  • Nearly 1 in 7 Australians have some form of arthritis;
  • 3 in 4 Australians over 45 with arthritis have self-reported at least one other chronic condition
  • 1 in 2 Australians with arthritis experience moderate to severe pain
  • 1 in 5 Australian with arthritis experience high or very high levels of psychological distress Please see the Impact of Arthritis report for more information.

There are many different types of arthritis. This assignment is focused on osteoarthritis.

Dataset: The Council of Crescentville

The Council of Crescentville is interested in investigating factors associated with people with osteoarthritis in their population. They have sent out a tender for the brightest researchers to inform their future public health policies and health promotion interventions.

They have existing historical data, collected from a census index from the Council of Crescentville which has 17,935 residents aged between 6 years to 80 years. Each individual’s data were identified by a six- letter identification code. From the records given on Moodle in the Excel file “Crescentville Dataset.xlsx”, the age group and gender of each person in this population are known. This data is a snapshot in time and there is no post-research data available. This historical data only collected gender in two categories: male and female.

The Council wanted to examine the association between reaction time and physical activity, as these may be affected by osteoarthritis. Therefore, they have conducted a one-off test as part of their health assessments and collected the reaction time of the individuals.

A stratified random sample of 100 Crescentville residents has been obtained. The stratification was based on the age groups and the sample size from each stratum was in proportion to that in the population:

Age Group6-2021-3536-5051-6565-80
%2223251911
VariableDescriptors
AgeYears (collected as date of birth )
GenderMale (M) and Female (F)
HandednessLeft Handed (LH) and Right Handed (RH)
Physical activityHours
Reaction timeSeconds
Reaction time: Quick and SlowQuick and Slow

Looking at your dataset complete the following questions by entering the answers into your Moodle quiz:

Introduction (3 marks)

It is important to have an understanding of your data and variables in research.

Watch the <Crescentville – overall info> video embedded in the quiz.

Before we get started, let’s ask some preliminary questions.

  1. Describe the condition under investigation i.e. osteoarthritis.

List 2 risk factors that contribute to the development of osteoarthritis?      (3 marks)

Section A: Describing & Summarising Data (21 marks)

It is important to have an understanding of your data and variables in research.

Before we start, we need to understand our sampling method, and what types of variables we’ve got. Then we do descriptive statistics before any complicated analysis.

Watch the <Crescentville – Section A> video embedded in the quiz

  • The Crescentville sample was obtained by stratified random sampling with the strata based proportionally on age groups. This type of sampling may be necessary for investigating the average reaction time.

What had to be known to achieve it? (Select one or more correct answers) [3 marks]

  • A sampling frame of the entire population, along with their age and the proportions of each sub- group in the population is needed to achieve this stratified sampling.
  • Age is not relevant to the condition investigated and therefore will have no effect on reaction time or cognition.
  • Stratified sampling allows for sequential order within the sample which ensures that the attribute studied is random.
  • Stratified sampling allows for the sampling to be random within each sub-group being investigated (in this case, each age group) – so the proportions of the different age groups are the same in the population and the sample.
  • Age is often referred to as “the universal confounder” – so reaction time might be affected by age.
  • A sampling frame which divides the population into a set of different coherent areas and randomly selects areas to assess.
  • Create a table of variables and type of data by matching two terms: [6 marks]
VariableDescriptorsType of Data
AgeYears 
GenderMale (M) and Female (F) 
Physical activityHours 
Reaction timeSeconds 
Reaction time: Slow and QuickSlow (>= 0.31 sec) & Quick (<0.31 sec) 
HandednessLeft Handed (LH) and Right Handed (RH) 
  • A graph is a really useful way to see how the data is distributed.

Therefore your next step is to:

Draw a graph of reaction time.

Please attach the graph as a file below and in the text box, type the file name only. [5 marks]

  • Time to identify the appropriate numerical summaries to describe the typical reaction time of individuals in Crescentville.

What is the mean of the sample? (4 decimal places) [1 mark]

  • What is the median of the sample? (4 decimal places) [1 mark]
  • Indicate if this statement is True or False in regards to the graph and statistics obtained so far.

“The graph shows a fairly normal distribution, and the values of the mean & median are fairly similar. Hence, the mean is an appropriate statistic to describe reaction time.”                                                                                                                  [1 mark]

  • Pick the 2 appropriate summary statistics you should report regarding the reaction time of the sample of the Crescentville people who are aged 6 – 80 years?

Select one or more: [2 marks]

  • Range
    • Mean
    • Inter-quartile range
    • Mode
    • Median
    • Standard deviation
  • We need some more information to continue.

What is the range of your sample? (4 decimal places) [1 mark]

  1. What is the standard deviation (SD)? (4 decimal places) [1 mark]

Section B: Conducting statistical tests (38 marks: 13 Part 1 & 25 Part 2)

Great news. The Council of Crescentville has found your preliminary results very valuable. However, let’s look at the data closer in this next section.

Watch the <Crescentville – Section B part 1> video embedded in the quiz.

Information for Questions 11 to 16. (13 marks for Section B, Part 1)

The Council of Crescentville has contacted you and is really interested in relationship between physical activities and how this impacts on your reaction time to the test.

Is there a correlation between the physical activity reported and their reaction times?

You are going to need to justify your answer using appropriate graphs, interpreting correlation coefficients and appropriate summary conclusions.

  • Therefore your next step is to:

Draw a graph for the variables: physical activity and reaction time.

Please attach the graph as a file below and in the text box, type the file name only.                                                                                                                                                         [6 marks]

  • What is your line of best fit? (All numbers to 4 decimal places) [1 mark]
  • What is the predicted reaction time for someone with 3 hours of physical activity per week? (3 decimal places) [1 mark]
  • State your r (correlation) value (4 decimal places) [1 mark]
  • State your R2 (coefficient of determination) value (4 decimal places) [1 mark]
  • Using your results from this section interpret your data by completing this sentence. [3 marks]

“Overall, there was a [X] correlation between reaction times and physical activity. [Y] in physical activity were correlated with [Z] reaction times of individuals.”

[X] = strong negative;      weak negative;      weak positive;      strong positive

[Y] = increases ; decreases

[Z] = increased; decreased

Well that was an interesting conclusion. Let’s see what else we can look at.

Watch the <Crescentville – Section B part 2> video embedded in the quiz.

Information for Questions 17 to 32. (25 marks for Section B, Part 2)

Do males and females differ in their reaction times?

Over the next few questions you will need to create a summary table and conduct a test of significance (95% CI and p-value) between the males and females to answer if there is a difference between their reaction times. Follow all steps clearly and write a clear conclusion.

Hint: Let’s complete all the steps in hypothesis testing.

  1. State the Null & Alternative hypotheses[2 marks]
  1. For the following, match the assumption with how it is met in this test. [4 marks]
  1. What is the reaction time mean for females? (4 decimal places) [1 marks]
  • What is the reaction time standard deviation for females? (4 decimal places) [1 marks]
  • What is the reaction time mean for males? (4 decimal places) [1 marks]
  • What is the reaction time standard deviation for males? (4 decimal places) [1 marks]
  • Calculate the difference in means (Female – Male) (4 decimal places) [1 mark]
  • Calculate standard error (SE) (4 decimal places) [1 marks]
  • Calculate the degrees of freedom [1 mark]
  • What is the T-multiplier? (2 decimal places) [1 mark]

Congratulations. You’ve now got the necessary statistics to calculate the p-value and 95%CI

Order Now

Get expert help for Assessment 3: Public Health Data Analysis and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (April 10, 2026) Assessment 3: Public Health Data Analysis. Retrieved from https://universalassignment.com/assessment-3-public-health-data-analysis/.
"Assessment 3: Public Health Data Analysis." Universal Assignment - April 10, 2026, https://universalassignment.com/assessment-3-public-health-data-analysis/
Universal Assignment May 25, 2023 Assessment 3: Public Health Data Analysis., viewed April 10, 2026,<https://universalassignment.com/assessment-3-public-health-data-analysis/>
Universal Assignment - Assessment 3: Public Health Data Analysis. [Internet]. [Accessed April 10, 2026]. Available from: https://universalassignment.com/assessment-3-public-health-data-analysis/
"Assessment 3: Public Health Data Analysis." Universal Assignment - Accessed April 10, 2026. https://universalassignment.com/assessment-3-public-health-data-analysis/
"Assessment 3: Public Health Data Analysis." Universal Assignment [Online]. Available: https://universalassignment.com/assessment-3-public-health-data-analysis/. [Accessed: April 10, 2026]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Categories

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Professional Nursing Assignment Help for Students: Achieve Academic Excellence with Expert Support

Introduction Nursing is a demanding field that combines theoretical knowledge with practical skills. Students pursuing nursing courses often face challenges in completing assignments that require accuracy, critical thinking, and real-world application. This is where nursing assignment help becomes an essential academic support system. With increasing academic pressure and clinical responsibilities,

Read More »

Economics Assignment Help: A Complete Guide for Students

Introduction Economics is a fundamental subject that helps students understand how markets, governments, and individuals make decisions regarding resources. While it is highly relevant in today’s world, many students find economics assignments challenging due to complex theories, graphs, and data analysis. This is where economics assignment help becomes extremely useful.

Read More »

Law Assignment Help: A Complete Guide for Students

Introduction Law is a complex and intellectually demanding field that requires critical thinking, analytical skills, and a deep understanding of legal principles. Students pursuing law often face challenges in completing assignments due to extensive research requirements and intricate case analysis. This is where law assignment help becomes highly beneficial. With

Read More »

Nursing Assignment Help: A Complete Guide for Students

Introduction Nursing is a highly respected and demanding field that requires a strong understanding of medical concepts, patient care, and clinical practices. Students pursuing nursing often face intense academic pressure due to complex assignments, practical responsibilities, and tight deadlines. This is where nursing assignment help becomes essential. With expert assistance,

Read More »

Finance Assignment Help: A Complete Guide for Students

Introduction Finance is a core subject in business and management studies, covering areas like investment analysis, financial management, and risk assessment. While it offers excellent career opportunities, many students find finance assignments challenging due to complex calculations and analytical concepts. This is where finance assignment help becomes essential. With expert

Read More »

Computer Science Assignment Help: A Complete Guide for Students

Introduction Computer Science is one of the most popular and dynamic fields of study, offering vast career opportunities in software development, data analysis, cybersecurity, and more. However, students often face difficulties in completing assignments due to the technical complexity and time constraints. This is where computer science assignment help becomes

Read More »

Digital Marketing Assignment Help: A Complete Guide for Students

Introduction Digital marketing has become a vital part of modern business strategies, making it a popular subject among students worldwide. From social media campaigns to search engine optimization, the field is dynamic and constantly evolving. However, completing assignments in this subject can be challenging due to its practical and analytical

Read More »

Cloud Computing Assignment Help: A Complete Guide for Students

Introduction Cloud computing has become a fundamental part of modern technology, powering everything from mobile apps to enterprise systems. As universities increasingly include this subject in their curriculum, students often find it challenging to keep up with assignments and projects. This is where cloud computing assignment help becomes essential. With

Read More »

Blockchain Assignment Help: A Complete Guide for Students

Introduction Blockchain technology has rapidly gained popularity across industries such as finance, healthcare, and supply chain management. As a result, it has become an important subject in academic programs worldwide. However, students often struggle with its technical concepts and practical applications. This is where blockchain assignment help becomes highly valuable.

Read More »

Data Science Assignment Help: A Complete Guide for Students

Introduction Data Science has become one of the most in-demand fields in today’s digital era, combining statistics, programming, and analytical thinking. However, many students find it difficult to keep up with the complexity of assignments and projects in this subject. This is where data science assignment help plays a crucial

Read More »

Artificial Intelligence Assignment Help: A Complete Guide for Students

Introduction Artificial Intelligence (AI) is transforming industries across the globe, making it one of the most sought-after academic subjects today. However, mastering AI concepts and completing assignments can be challenging for many students. This is where artificial intelligence assignment help becomes essential. With expert guidance, students can better understand complex

Read More »

Assignment Writing Services: A Complete Guide for Students

Introduction Assignments are a crucial part of academic life, helping students develop knowledge, research skills, and critical thinking. However, managing multiple assignments along with exams and personal responsibilities can be overwhelming. This is where assignment writing services become highly beneficial. These services provide expert assistance, helping students complete their assignments

Read More »

Blockchain Assignment Help: A Complete Guide for Students

Introduction Blockchain technology has emerged as one of the most revolutionary innovations in recent years. From cryptocurrencies to secure data management, blockchain is transforming industries like finance, healthcare, and supply chain. Students studying blockchain often face challenges due to its technical concepts and real-world applications. This is where blockchain assignment

Read More »

Assignment Writing Services: A Complete Guide for Students

Introduction Assignments are a crucial part of academic life, helping students develop knowledge, research skills, and critical thinking. However, managing multiple assignments along with exams and personal responsibilities can be overwhelming. This is where assignment writing services become highly beneficial. These services provide expert assistance, helping students complete their assignments

Read More »

Academic Writing Services: A Complete Guide for Students

Introduction Academic writing is a fundamental part of education, requiring students to produce essays, research papers, case studies, and dissertations. It demands strong writing skills, proper structure, and in-depth research. However, many students struggle with academic writing due to time constraints and lack of expertise. This is where academic writing

Read More »

Online Homework Help Services: A Complete Guide for Students

Introduction Homework is an essential part of a student’s learning process, helping reinforce classroom knowledge and improve understanding. However, with increasing academic pressure and multiple responsibilities, students often struggle to complete their homework on time. This is where online homework help services become highly beneficial. They provide expert guidance, save

Read More »

Thesis Writing Help: A Complete Guide for Students

Introduction A thesis is one of the most important academic documents a student will write during their educational journey. It requires in-depth research, critical analysis, and a clear presentation of ideas. However, many students find thesis writing overwhelming due to its complexity and time-consuming nature. This is where thesis writing

Read More »

Essay Writing Help: A Complete Guide for Students

Introduction Essay writing is a fundamental part of academic life, helping students express their ideas, analyze topics, and develop critical thinking skills. Whether it’s argumentative, descriptive, or analytical, writing a high-quality essay requires proper structure, research, and clarity. However, many students struggle with essay writing due to time constraints and

Read More »

Content Writing Assignment Help: A Complete Guide for Students

Introduction Content writing has become a crucial skill in the digital era, playing a key role in blogging, marketing, and online communication. From academic essays to website content, strong writing skills are essential for students across all fields. However, many students struggle with structuring content, maintaining clarity, and optimizing for

Read More »

Digital Marketing Assignment Help: A Complete Guide for Students

Introduction Digital marketing has become one of the most important skills in today’s online-driven world. From social media marketing to search engine optimization (SEO), businesses rely heavily on digital strategies to reach their audience. Students studying digital marketing often face challenges in understanding strategies, tools, and real-world applications. This is

Read More »

UI/UX Design Assignment Help: A Complete Guide for Students

Introduction UI/UX design is a crucial aspect of modern digital products, focusing on creating visually appealing and user-friendly interfaces. From websites to mobile apps, good design enhances user experience and engagement. Students studying UI/UX design often face challenges in creativity, tools, and usability principles. This is where UI/UX design assignment

Read More »

Can't Find Your Assignment?