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

Subject:MS ExcelPrice:19.99 Bought3

Share With

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)