USA: +1(669)289-8683 
Sign in
-I need part A and part B completed by FRIDAY APRIL 12TH BY 9PM.
-TORONTO, Canada zone.
-I want the news article to be somewhat creative and target audience in 18-40. 20
– Seperate graphs are needed for each interview question in the survey. (8 graphs in total)
-Pie graphs are needed for question #7,#8
– A chart is needed for all of the collected Data
CHART IS COMPLETED
OPEN DOCUMENT FOR FURTHER INFORMATION.
Part A – Assessing Healthcare Use
In this part, you will collect data, analyse data, and create graphs that will be used in part B of this activity.
Items to submit for Part A:
· Electronic versions of the six to eight surveys in a digital format.
· A spreadsheet with all the information from the surveys entered
· Statistical analysis (mean, median and mode for the questions)
· Fully labelled graphs showing each question
· A digital document containing a statement describing which age group was surveyed and conclusions drawn from the survey findings
This part of the unit assessment will focus on healthcare access for Canadians in one of the three demographic age ranges during the age of fertility 18- 40 years, middle ages 41 -65 years, and retirement ages over the age of 65 years. You will gather raw data from twenty surveys from one of the three specified demographics. Questions will include:
1. What is your age?
2. Number of times, on average, you have sought medical assistance (which includes questions about a medical condition to getting actual help from a medical practitioner) in the past six months?
3. How often in the last six months have you been ill but not sought medical assistance?
4. How often have you missed work in the last six months due to personal illness?
5. The number of different prescription medications being taken during the past six months?
6. The number of over-the-counter drugs taken during the past six months?
7. Aside from medical assistance, what other methods do you use to prevent illnesses? Please list all methods.
8. Aside from medical assistance, what other methods do you use to combat illness (after you become ill)? Please list all methods.
Input all information collected from the twenty surveys in a spreadsheet and analyse the data. Using the spreadsheet program create graphs (multiple graphs) and perform a statistical analysis on the data (mean, median and mode).
Answers collected so far
Interview #1:
-19
-once
-once
-zero
-four
-two
-wash my hands , take vitamin C, hand sanitizer
-stay in my bed and sleep
Interview #2:
20 going on 21,
-twice,
-zero,
-zero,
-1,
-Tylenol
-4 times,
dress warmly…eat fruits n veggies…wash hands frequently, hot tea…warm bath…sleeping.
Interview #3:
-25
-0
-0
-0
-0
-0
-exercise, healthy diet, self care (ex; dressing appropriately for weather conditions, avoiding people who are sick, etc)
Interview #4:
#1 Age 32
#2 none
#3 once with the flu. No need to check a dr
#4 none
#5 none
#6 two. Cataflam and panadol multi symptom
#7 Diet and exercise
#8 garlic tea. Honey and lime.
Interview #5:
-What is your age? 19
-Number of times, on average, you have sought medical assistance (which includes questions about a medical condition to getting actual help from a medical practitioner) in the past six months? 2 times
-How often in the last six months have you been ill but not sought medical assistance? Maybe 3 times ; I don’t usually seek medical assistance for the flu
-How often have you missed work in the last six months due to personal illness? I don’t work but I’ve missed school once
-The number of different prescription medications being taken during the past six months?
I haven’t taken any
-The number of over-the-counter drugs taken during the past six months? One, robitussin
-Aside from medical assistance, what other methods do you use to prevent illnesses? Please list all methods.
I just take vitamins, it helps 85% of the time
-Aside from medical assistance, what other methods do you use to combat illness (after you become ill)? Please list all methods.
I usually just sweat it out or take robitussin
Part B – Reporting Results
This part of the activity will focus on the transfer of your findings in Part A to a real-life application of statistical findings.
Items to submit for Part B:
· Newspaper article 200 words in length;
· Two advertisements (related to the article topic); and
· A graph based on the data collected from Part A related to the article written.
Write a front page for a newspaper where you comment on the health care use for your chosen population (from Part A). Include two advertisements that relate to the health care use for your chosen population and that would also be of interest to your chosen population. Hint: Using programs such as Microsoft Publisher reduces the time with document creation because ready-made templates are easily accessible.
The subject of the story is the information collected from the interviews. The article should be 200 words in length and include a graph created from a spreadsheet program that represents a piece of data referred to in your article.
This is a multi-layered assignment and I suggest you work through all of the content and get started as soon as possible.
>Sheet :
:
:
:
:
:
19 20 19 32 25 31 18 39 1 2 0 0 2 3 0 2 1 4 0 2 2 3 1 1 0 0 2 0 1 0 0 1 3 0 0 2 0 1 3 2 0 0 0 0 3 1 2 2 0 0 0 0 1 1 0 0 0 2 0 1 2 1 2 0 0 0 2 0 4 1 0 0 0 2 0 1 0 2 1 1 1 0 2 1 0 0 2 1 2 4 0 2 1 2 1 3 1 4 1 2 2 2 0 0 2 2 3 4 Exercise, healthy diet, self care (ex; dressing appropriately for weather conditions, avoiding people who are sick, etc)
2
1
Survey Question
Interview #1:
Interview #2:
Interview #
3
Interview #
4
Interview #5:
Interview #6:
Interview #7:
Interview #8:
Interview #9:
Interview #1
0
Interview #11:
Interview #12:
Interview #13:
Interview #14:
Interview #15:
Interview #16:
Interview #17:
Interview #
18
Interview #
19
Interview #
20
1. What is your age?
25
32
39
27
40
29
36
31
38
28
26
23
2. Number of times, on average, you have sought medical assistance (which includes questions about a medical condition to getting actual help from a medical practitioner) in the past six months?
3. How often in the last six months have you been ill but not sought medical assistance?
4. How often have you missed work in the last six months due to personal illness?
5. The number of different prescription medications being taken during the past six months?
6. The number of over-the-counter drugs taken during the past six months?
7. Aside from medical assistance, what other methods do you use to prevent illnesses? Please list all methods.
Wash my hands , take vitamin C, use hand sanitizer
Dress warmly, eat fruits and veggies, wash hands frequently
Exercise, healthy diet, self care (ex; dressing appropriately for weather conditions, avoiding people who are sick, etc)
Diet and exercise
I just take vitamins
Wash hands
8. Aside from medical assistance, what other methods do you use to combat illness (after you become ill)? Please list all methods
Stay in my bed and sleep
Take hot tee, warm bath and sleeping
Garlic tea, Honey and lime
I usually just sweat it out or take robitussin
Sheet2
Sheet3
