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
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
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 (June 2, 2023) Assessment 3: Public Health Data Analysis. Retrieved from
"Assessment 3: Public Health Data Analysis." Universal Assignment - June 2, 2023,
Universal Assignment May 25, 2023 Assessment 3: Public Health Data Analysis., viewed June 2, 2023,<>
Universal Assignment - Assessment 3: Public Health Data Analysis. [Internet]. [Accessed June 2, 2023]. Available from:
"Assessment 3: Public Health Data Analysis." Universal Assignment - Accessed June 2, 2023.
"Assessment 3: Public Health Data Analysis." Universal Assignment [Online]. Available: [Accessed: June 2, 2023]

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.

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 . 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

NURBN3034 Assessment Task

NURBN3034 Assessment Task 1a Global Health Issues Group ePoster Presentation Weighting: 30% Due date: Thursday August 18th 13.59pm each group Purpose: The purpose of this learning task is to choose one of the following global health issues that under the right conditions has or is likely to have a significant

Read More »

ISYS3375 Business Analytics

School of Business, IT and Logistics — ISYS3375 Business Analytics Assessment 2: Case Study Assessment Type: Individual report                                               Word limit: 2000-3000 (+/– 10%) Each Table or Figure is counted as Due date: Sunday of Week 5 23:59 (Melbourne time) Weighting: 35% 50 words + the number of words in its

Read More »

NURBN3032 Task 2: Managing a Transition to Practice Issue

NURBN3032 Task 2: Managing a Transition to Practice Issue Weight: 60% Due: Thursday 18th May (Week 11) In this task, students are required to demonstrate knowledge relating to understanding and addressing a transitional issue that can affect new graduate nurses. Using evidence from current scholarly literature (i.e., less than seven

Read More »

ATS2561 Sex and the Media

Assessment Guide – Research Essay Due: Friday Week 12, submit on Moodle Weighting: 40% Length: 2000 words Write an essay responding to one of the following questions/topics: ‘objectifying’ images might be different, or that they should be understood as the same, for men and women. Your argument should address why

Read More »

ITC597 Digital Forensics

ITC597 Digital Forensics – SAMPLE EXAM ONLY This paper is for Distance Education (Distance), Port Macquarie, Study Centre Sydney and Study Centre Melbourne students. EXAM CONDITIONS: NO REFERENCE MATERIALS PERMITTED No calculator is permitted No dictionary permitted WRITING TIME:                     2 hours plus 10 minutes reading time Writing is permitted during

Read More »

Simulation Project- Computer Lab Project

Model and analyse the communication tower at the Casuarina campus. Apply dead, live and wind load as per in AS 1170 or other relevant standards in SAP2000. You should measure size of the elements as far as you can from or make reasonable assumptions about the dimensions. Reasonable assumptions should

Read More »

COM621 UX Strategy

Solent University Coursework Assessment Submission Module Name:    UX Strategy Module Code:    COM621 Module Leader: Assessment Submission Date: Student Number: UX Strategy Contents Part 1 – Introduction to System (1K words) 2 1.0 Introduction. 2 1.1       Current SUAA UX Design and Business Model 2 1.2       Academic and Market Research. 3 1.3      

Read More »

MIT302 Internet of Things

Group Presentation and Video (part 2) Unit:             MIT302 Internet of Things Due Date:       09/06/2023 Total Marks:    This assessment is worth 10% of the full marks in the unit. Instructions: 1.        Students are required to cover all stated requirements. 3.        Please save the document as: MIT302_Firstname_Surname_StudentNumber[assessment1].ppt Requirements: Write a PowerPoint of

Read More »

MBA600 Capstone: Strategy

Assessment 1 Information Subject Code: Subject Name: Assessment Title: Assessment Type: Length: Weighting: Total Marks: Submission: Due Date: MBA600 Capstone: Strategy Competitive Advantage Video Project Individual video recording 5 minutes (no more) 25% 100 Online Week 5 Your task Individually, you are required  to record a 5-minute video, in which 

Read More »


Background You are a newly graduated nurse in the emergency department. Tom has been admitted with left abdominal pain radiating through to the back exacerbated by eating and drinking. The pain has significantly increased over the past two days and he currently rates it as 9/10. He has been unable

Read More »

Strategic Management Assignment

Assignment: Prepare a Comprehensive Strategic Management Analysis Report of Infosys Task: You need to develop a max 3,000-word Comprehensive Strategic Management Analysis Report addressing the four specific tasks set out in the strategic management assignment brief. The 3,000 words, exclude the Title, Abstract, Table of contents, Bibliography and Appendices. The company

Read More »


Progress: What is going on well CHALLENGES (WORKING REMOTELY) AREAS FOR DEVELOPMENT STRENGTHS NEXT PART OF PLACEMENT MULLER, 2014 The power of story Song line and dreaming tracks Defining knowledge, theories, and purposes: The most significant part was likened to a snake whose tail was cut off, and it had

Read More »


Background Local hemp products development company Quattro-Canna Holdings has signed a licence agreement with hemp processing equipment developer, Canadian Greenfield Technologies, to manufacture the HempTrain decorticator plant, designed for mass-processing of hemp straw- bales into bast fibre, hurd and green microfiber (GMF), in South Africa. The HempTrain will be manufactured

Read More »

Information Booklet Scaffold

An information booklet contains-relevant information on a topic for a particular target audience. The format of an information booklet can vary, however, there are common elements, including: The following process can support you in developing an information booklet on a topic for a particular audience. There are three stages to

Read More »

CHCCSM004 Coordinate Complex Case Requirements

Assessment Task 1: Written Questions b. List and describe eight of a coordinators responsibilities. a. Explain how information about external service providers might be sourced. b. List three circumstances it might be necessary for a coordinator to use external service providers to ensure that a consumer’s care plan meets their needs and

Read More »

BU7401 Leadership in Action

A: Assessment Details Module Title Leadership in Action Module Code BU7401 Module Leader Component Number 1 Assessment Type, Word Count & Weighting Individual written assignment 4000 words 100% of module grade Submission Deadline 21/10/2022 Submission Instructions Online submission using Turn It In Feedback Return Date 4 weeks after submission B:

Read More »

Management Research Perspectives

SBS – DBA Assignment – 2023 UNIT TITLE:                                            NAME (in Full):                                                               GENERAL INSTRUCTIONS converted to 90 marks. Total Marks                      / 90 PLAGIARISM Plagiarism is a form of cheating, by representing someone else’s work as your own or using someone else’s work (another student or author) without acknowledging it

Read More »


I.        Executive Summary           The executive summary is a synopsis of the overall marketing plan and easier to write last, after the entire marketing plan has been written. II.       Environmental Analysis Micro Analysis:                     Competitive forces (Five Force Analysis)                               Who are our major competitors?  What are their characteristics (size,

Read More »

MQBS7030 Final Assessment Data Analysis and Report

ASSIGNMENT TASK: For this assignment, you need to refer to “Fringe” dataset. Fringe is concerned with the factors that contribute to the fringe benefits of employees. The dataset includes a range of different variables, which allows for a range of different tests to be performed. You should note that our

Read More »

MIS770 Foundation Skills in Business Analysis

MIS770 Foundation Skills in Business Analysis Department of Information Systems and Business Analytics Deakin Business School Faculty of Business and Law, DeakinUniversity Assignment Two Analysis of Click Sales Data Particulars Assurance of Learning This assignment assesses the following Graduate Learning Outcomes and related Unit Learning Outcomes: Graduate Learning Outcome (GLO)

Read More »

ITECH7407 – Real Time Analytics

Assessment Task – Data Analytics Assignment Overview For this assessment task, you will work in a group to analyse a selected data set, and provide recommendations to the leadership of the company based on your findings. Timelines and Expectations Percentage Value of Task: 25% Due: Week 11, Sunday 5pm Minimum

Read More »

BSB123 Data Analysis

BSB123 Data Analysis Research Report Assessment Semester 1, 2021 Due Date: 11:59 30th May The data for the Assignment can be found in the file Research Report Assessment (2021-01).xlsx on Blackboard The Problem FringeTech is an information technology / electrical engineering company that employs thousands of people Australia wide. Recently

Read More »

Final Analysis Assignment Help

Refer to the attached excel file, answer the questions below. Use graph if required. The file that can be accessed through the link below contains data on 100 employees in a particular occupation. Suppose that interest centres on investigating the factors that explain salary differences. The data set contains the following

Read More »

VETS6103 Data Analysis Assignment

Factors influencing milk production in Australian dairy cattle Assignment overview: This assignment involves analysing a dataset, interpreting results, and drawing conclusions based on the analyses. The dataset can be found in the file “practical_assignment_2021.xls” which is on Canvas under the Assignments folder. It is a group task worth 50% of

Read More »


ECON 1030 – BUSINESS STATISTICS 1: Individual Assignment   Instructions: This is an individual assignment with a total of 40 marks. The allocation of marks is as follows: Statistical Analysis     (including excel) 32 Professional Report 8              Total 40 The response to the assignment must be provided in the form

Read More »

Can't Find Your Assignment?

Open chat
Free Assistance
Universal Assignment
Hello 👋
How can we help you?