Cost of living and cost of health
use Microsoft Excel and Word to create and present summary statistics to
describe key characteristics of the 2016 Health and Society student cohort.
1. Usin" rel="nofollow">ing Microsoft Excel, calculate the followin" rel="nofollow">ing:
a) The mean (and standard deviation (SD)) age of the 2016 Health and Society student cohort
b) The number (n) and percentage (%) of men and women in" rel="nofollow">in the 2016 Health and Society student
cohort
c) Mean (SD) estimated weekly in" rel="nofollow">income ($) for the 2016 Health and Society student cohort
d) Mean (SD) amount ($) spent by the 2016 Health and Society student cohort in" rel="nofollow">in the last week in" rel="nofollow">in the
followin" rel="nofollow">ing five categories of expenditure:
Housin" rel="nofollow">ing;
Food and non-alcoholic beverages;
Transport;
Recreation (in" rel="nofollow">includin" rel="nofollow">ing alcoholic beverages); and
Mobile phone
e) Number (n) and percentage (%) of the Health and Society student cohort who:
liveat home with their parents/guardians; and
livein" rel="nofollow">independently
2
f) Number (n) and percentage (%) of the Health and Society student cohort that:
are employed (full time/part time/casual); and
are not employed
g) do not have private health in" rel="nofollow">insurance Number (n) and percentage (%) of the Health and Society
student cohort that:
have private health in" rel="nofollow">insurance; and
do not have private health in" rel="nofollow">insurance