Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Submit your completed Word document (as a doc, docx or pdf file) and your Excel file (2 points), showing your pivot table and the calculations for # of hours of sleep per night
Submit your completed Word document (as a doc, docx or pdf file) and your Excel file (2 points), showing your pivot table and the calculations for # of hours of sleep per night.
1. Complete this table using the data in the Excel included with this homework assignment. The data are from this study (https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0239397). You will need to do some calculations and create Pivot tables. Remember that missing values should not be included in the denominator for percentages (4 points)
Table 1: Characteristics of the sample
|
Total number of participants |
|
||||
|
|
Mean |
median |
Minimum |
Maximum |
|
|
# of animals (animal_amount) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
n |
% |
|||
|
Gender |
|
|
|||
|
Female |
|
|
|||
|
Male |
|
|
|||
|
|
|
|
|||
|
Age (years) |
|
|
|||
|
18-24 |
|
|
|||
|
24-34 |
|
|
|||
|
35-44 |
|
|
|||
|
45-54 |
|
|
|||
|
55-64 |
|
|
|||
|
65-70 |
|
|
|||
|
>70 |
|
|
|||
|
|
|
|
|||
|
Occupation |
|
|
|||
|
Self-employed |
|
|
|||
|
Employed outside the home |
|
|
|||
|
Employed from home |
|
|
|||
|
Furloughed due to Covid-19 |
|
|
|||
|
Laid off due to Covid-19 |
|
|
|||
|
Unemployed |
|
|
|||
|
Retired |
|
|
|||
|
Student |
|
|
|||
|
Other |
|
|
|||
|
|
|
|
|||
|
How often you are currently in contact with family members and friends that do not live with you? |
|
|
|||
|
Many times per day |
|
|
|||
|
At least once per day |
|
|
|||
|
At least every other day |
|
|
|||
|
At least twice per week |
|
|
|||
|
At least once per week |
|
|
|||
|
Less than once per week |
|
|
|||
|
|
|
|
|||
|
Have you been in social isolation since the outbreak (e.g. due to a suspected Covid-19 infection or because you are at risk of infection)? |
|
|
|||
|
No |
|
|
|||
|
Yes |
|
|
|||
|
|
|
|
|||
|
My animal helps me cope emotionally with the Covid-19 situation |
|
|
|||
|
Strongly agree |
|
|
|||
|
Somewhat agree |
|
|
|||
|
Somewhat disagree |
|
|
|||
|
Strongly disagree |
|
|
|||
|
Don’t know |
|
|
|||
2. Write a 100-150 word description of the characteristics of this sample. You may want to look at the results section of some epidemiology research articles for examples of how to do this. Your answer will be graded on content, writing style, and grammar. (4 points)
Expert Solution
Buy This Solution
For ready-to-submit work, please order a fresh solution below.
