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 (August 31, 2025) 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 - August 31, 2025, https://universalassignment.com/assessment-3-public-health-data-analysis/
Universal Assignment May 25, 2023 Assessment 3: Public Health Data Analysis., viewed August 31, 2025,<https://universalassignment.com/assessment-3-public-health-data-analysis/>
Universal Assignment - Assessment 3: Public Health Data Analysis. [Internet]. [Accessed August 31, 2025]. Available from: https://universalassignment.com/assessment-3-public-health-data-analysis/
"Assessment 3: Public Health Data Analysis." Universal Assignment - Accessed August 31, 2025. 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: August 31, 2025]

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.

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

Assignment Help in Parkville – Universal Assignment

Parkville, located just 3 km north of Melbourne CBD, is one of Melbourne’s most prestigious academic hubs. It is home to The University of Melbourne, Monash University (Pharmacy campus), and major research institutes like the Walter and Eliza Hall Institute and the Royal Melbourne Hospital precinct. With such a concentration

Read More »

Assignment Help in Oakleigh East – Universal Assignment

Oakleigh East, located about 17 km south-east of Melbourne CBD, is a peaceful and residential suburb in the City of Monash, known for its family-friendly environment and convenient access to shopping and educational facilities. With nearby institutions like Monash University, Holmesglen Institute, and TAFE Victoria, many students living in Oakleigh

Read More »

Assignment Help in Preston – Universal Assignment

Preston, located about 9 km north of Melbourne’s CBD, is a thriving multicultural suburb that attracts many university and TAFE students. With the presence of Melbourne Polytechnic (Preston Campus) and close proximity to La Trobe University (Bundoora campus) and RMIT University, Preston has a large student population. While the suburb

Read More »

Assignment Help in Point Cook – Universal Assignment

Point Cook, located around 25 km southwest of Melbourne’s CBD, is a fast-growing residential suburb in the City of Wyndham. Known for its modern housing estates, coastal beauty, and cultural diversity, Point Cook is also home to many university and TAFE students. With Victoria University, RMIT, Deakin University, and the

Read More »

Assignment Help in Pascoe Vale South – Universal Assignment

Pascoe Vale South, situated about 9 km north of Melbourne’s CBD, is a quiet, family-friendly suburb within the City of Merri-bek. Known for its leafy streets, community parks, and excellent schools, the suburb is also home to many university students due to its proximity to RMIT University, La Trobe University,

Read More »

Assignment Help in Pascoe Vale – Universal Assignment

Pascoe Vale, located just 10 km north of Melbourne’s CBD, is a thriving suburb in the City of Merri-bek. It is a popular residential area for students due to its proximity to leading universities such as RMIT University, La Trobe University, and the University of Melbourne. With excellent transport links

Read More »

Assignment Help in Prahran – Universal Assignment

Prahran, located just 5 km southeast of Melbourne’s CBD, is one of the city’s most vibrant inner suburbs. Known for its trendy cafes, boutique shopping on Chapel Street, and buzzing nightlife, Prahran also has a large student population. Its close proximity to Monash University (Caulfield campus), Swinburne University of Technology,

Read More »

Assignment Help in Parkdale – Universal Assignment

Parkdale, located around 23 km south-east of Melbourne CBD, is a beautiful beachside suburb in the City of Kingston. Known for its relaxed lifestyle, coastal charm, and proximity to Monash University, Holmesglen Institute, and Deakin University, Parkdale is home to many students balancing academic studies with personal and professional commitments.

Read More »

Assignment Help in Oakleigh South – Universal Assignment

Oakleigh South, located about 20 km south-east of Melbourne CBD, is a suburban area in the City of Kingston, known for its family-friendly environment, parks, and convenient access to educational facilities. With nearby institutions like Monash University, Holmesglen Institute, and TAFE campuses, students in Oakleigh South often require professional assignment

Read More »

Assignment Help in Ormond – Universal Assignment

Ormond, located about 12 km south-east of Melbourne CBD, is a well-connected residential suburb in the City of Glen Eira. Known for its proximity to Monash University Caulfield Campus, Holmesglen Institute, and local schools, Ormond attracts both local and international students. With increasing academic demands, many students search for assignment

Read More »

Assignment Help in Oakleigh – Universal Assignment

Oakleigh, located about 14 km south-east of Melbourne CBD, is a lively suburb in the City of Monash, known for its multicultural community, shopping precincts, and proximity to educational institutions. With access to Monash University, Holmesglen Institute, and nearby TAFE campuses, many students in Oakleigh seek professional assignment help in

Read More »

Assignment Help in Oak Park – Universal Assignment

Oak Park, located about 12 km north of Melbourne CBD, is a suburban area in the City of Moreland, known for its peaceful residential streets, schools, and local amenities. With access to nearby institutions such as RMIT University, University of Melbourne, and TAFE campuses, many students in Oak Park seek

Read More »

Assignment Help in Nunawading – Universal Assignment

Nunawading, located about 20 km east of Melbourne CBD, is a thriving suburb in the City of Whitehorse, known for its leafy streets, shopping centres, and proximity to educational institutions. With access to Deakin University, Box Hill Institute, and nearby TAFE campuses, students in Nunawading often seek professional assignment help

Read More »

Assignment Help in Notting Hill – Universal Assignment

Notting Hill, located about 22 km south-east of Melbourne CBD, is a residential suburb in the City of Monash, known for its peaceful environment and proximity to shopping centres, schools, and educational institutes. With access to nearby campuses like Monash University, Holmesglen Institute, and TAFE Victoria, many students in Notting

Read More »

Assignment Help in Northcote – Universal Assignment

Northcote, located about 7 km north-east of Melbourne CBD, is a vibrant suburb known for its multicultural community, trendy cafes, and lively student population. With easy access to RMIT University, University of Melbourne, and nearby TAFE institutes, Northcote has become a popular area for students pursuing higher education. Many students

Read More »

Assignment Help in North Melbourne – Universal Assignment

North Melbourne, located just 2 km north-west of Melbourne CBD, is a bustling inner-city suburb known for its historic architecture, multicultural community, and proximity to major educational institutions. With easy access to RMIT University, University of Melbourne, and nearby TAFE campuses, students in North Melbourne often require professional assignment help

Read More »

Assignment Help in Noble Park – Universal Assignment

Noble Park, located about 25 km south-east of Melbourne CBD, is a thriving suburb in the City of Greater Dandenong. Known for its multicultural community, shopping centres, and schools, Noble Park is home to a growing student population. With access to nearby institutions like Monash University, Chisholm Institute, and TAFE

Read More »

Assignment Help in Niddrie – Universal Assignment

Niddrie, located about 10 km north-west of Melbourne CBD, is a bustling suburb known for its residential communities, shopping centres, and schools. With easy access to Victoria University, RMIT, and nearby TAFE institutes, Niddrie is home to many students who often seek assignment help in Niddrie to manage academic workloads

Read More »

Assignment Help in Narre Warren South – Universal Assignment

Narre Warren South, located 38 km south-east of Melbourne CBD, is a growing suburb in the City of Casey. Known for its residential communities, schools, and green spaces, Narre Warren South is home to many students who pursue higher education at nearby institutions such as Monash University Clayton Campus, Federation

Read More »

Assignment Help in Narre Warren North – Universal Assignment

Narre Warren North, located about 36 km south-east of Melbourne CBD, is a fast-growing suburb in the City of Casey. Known for its family-friendly community, excellent schools, and green spaces, the suburb also attracts students pursuing higher education in Melbourne. With access to nearby institutions like Monash University Clayton Campus,

Read More »

Assignment Help in Narre Warren – Universal Assignment

Narre Warren, located about 38 km south-east of Melbourne CBD, is one of the fastest-growing suburbs in the City of Casey. Known for Fountain Gate Shopping Centre, family-friendly communities, and excellent schools, Narre Warren also attracts a large number of students pursuing higher education in Melbourne and surrounding areas. With

Read More »

Assignment Help in Mulgrave – Universal Assignment

Mulgrave, located 21 km south-east of Melbourne CBD, is a vibrant suburb with a mix of residential, business, and educational opportunities. With close access to Monash University Clayton Campus, Holmesglen Institute, and nearby TAFE colleges, Mulgrave attracts a large number of students. Many students here face challenges with assignments and

Read More »

Assignment Help in Mount Waverley – Universal Assignment

Mount Waverley, located 16 km south-east of Melbourne CBD, is a popular residential suburb with excellent schools, universities nearby, and a strong student community. With easy access to Monash University Clayton Campus, Holmesglen Institute, and Deakin University, Mount Waverley has become a hub for students pursuing higher education. To manage

Read More »

Assignment Help in Mordialloc – Universal Assignment

Mordialloc, located 24 km south-east of Melbourne CBD, is a picturesque bayside suburb known for its beaches, boating culture, and community lifestyle. Along with its relaxed environment, it is home to students from nearby institutions such as Monash University, Chisholm Institute, and Holmesglen TAFE. Many of these students seek assignment

Read More »

Assignment Help in Mooroolbark – Universal Assignment

Mooroolbark, located 31 km east of Melbourne’s CBD, is a vibrant suburb in the Yarra Ranges, known for its family-friendly environment, schools, and proximity to tertiary institutions like Swinburne University and Box Hill Institute. Many local and international students live in the area and often seek assignment help in Mooroolbark

Read More »

Assignment Help in Moorabbin – Universal Assignment

Moorabbin, located 15 km southeast of Melbourne’s CBD, is a busy suburb well-known for its business district, schools, and proximity to Monash University, Holmesglen Institute, and other major educational hubs. Many students in Moorabbin balance studies with part-time jobs, making assignment help in Moorabbin a vital service for academic success.

Read More »

Assignment Help in Moonee Ponds – Universal Assignment

Moonee Ponds, located just 7 km northwest of Melbourne’s CBD, is a lively inner-city suburb known for its shopping precincts, schools, and close connection to major universities. Students living in Moonee Ponds enjoy easy access to educational institutions but often struggle with heavy workloads and tight deadlines. That’s why assignment

Read More »

Assignment Help in Montmorency – Universal Assignment

Montmorency, a leafy suburb located 18 km northeast of Melbourne’s CBD, is a peaceful and family-friendly area known for its natural charm, schools, and close-knit community. Students in Montmorency benefit from being near Melbourne’s major universities and colleges, but they often face challenges balancing academics with work and personal life.

Read More »

Assignment Help in Mont Albert North – Universal Assignment

Mont Albert North, a welcoming residential suburb located 13 km east of Melbourne’s CBD, is well-known for its family-friendly community, green spaces, and proximity to leading schools and universities. Many students living here juggle study, part-time jobs, and personal commitments, which can make academic life stressful. That’s where our assignment

Read More »

Assignment Help in Mont Albert – Universal Assignment

Mont Albert, a leafy suburb located 12 km east of Melbourne’s CBD, is known for its quiet residential streets, historic architecture, and excellent access to educational facilities. Many students living in Mont Albert are enrolled in nearby universities, colleges, and TAFE institutes. To support their academic journey, our assignment help

Read More »

Can't Find Your Assignment?