BEA140 Exploring Data With Pivot Tables Assignment

MODULE 2 – TOPIC 1 (EXPLORING DATA WITH PIVOT TABLES)

Tools required:

You should use the PivotTable tools that you learned about in computer lab 2.

Scenario.

Concerns have been raised about the effectiveness of this season’s flu vaccination after it was noticed that a high proportion of people with severe illness have been vaccinated. Data has been collected on the following attributes of the flu sufferers (see the file FluVac.xls).

ID - An identification number for the individual with flu

AGE - The person’s age in years

VAC STATUS - Whether or not the person has been vaccinated against the flu

SEVERITY -The severity of the illness (mild or severe)

AGE CAT -A categorical version of the age variable with 5 bins (0-20, 21-40, 41-60, 61-80, 80+)

Your role is to investigate the data to determine if vaccination is effective or not.

Auto-graded questions (submit answers via MyLO Quiz: Assignment Milestones)

1. What percentage of vaccinated and unvaccinated people experience severe illness? [1 mark]
2. What is the average age of patients that are severely ill compared to patients with mild illness? [1 mark]
3. What is the average age of people that are vaccinated compared to people that are unvaccinated? [1 mark]
4. What proportion of people in the age category 41-60 are vaccinated? [1 mark]
5. Is there any age category where a higher proportion of vaccinated people are severely ill compared unvaccinated people? [1 mark]

Questions for the manually graded section of assignment

1. Based on your investigation of the data set create two well-formatted tables that illustrate some important features of the data. Your tables should have informative labels and a readable number of decimal places.
   Each table should include an informative caption. [8 marks]
2. With reference to the tables you have made, is there evidence that the vaccine is effective or not? [4 marks]
3. One reason why it is difficult to ascertain cause and effect based on association is that there may be confounding variables, these are variables which are related to both the explanatory (independent) and response (dependent) variable. In the data set presented here which variable is explanatory, which is response, and which is confounding? [3 marks]
4. Imagine that the data is this study has been collected by surveying people who present at hospital with flu symptoms. Can you identify any potential biases in this form of data collection that might influence our ability to answer our key question? How else could data be collected to avoid this bias? [5 marks]

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.

Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank