As a result of the study you designed, you and your research team sampled Alzheimer's Association-affiliated caregivers of dementia patients who received services within the last six months. Using Qualtrics, you administered 300 surveys to a stratified random sample of child and spouse caregivers, asking them about themselves and their stress levels (using the Perceived Stress Scale). After a month-long follow-up, you have received back 97 surveys for a response rate of 32% - not too shabby! Now it's time to look at the data to determine trends and possible relationships. Develop results for the prompts shown using the SOCW 3600 Collaborative Challenge #2 Database (make a copy for analysis) and the code book below. Use the analysis functions found in Excel to analyze (this will be reviewed in class).

1. Identify the level of measurement for each variable (please note that Case ID is not a variable but a case identifier for each respondent).

2. Calculate the mode, median, and mean (as appropriate for each variable).

3. Calculate the range and standard deviation for all ratio-level data.

4. Develop a narrative on descriptive results, including an interpretation of the meaning of standard deviation.

5. State acomparative research question and possible hypothesis using this data set. What would be used to test the hypothesis?

see code info below:

Variable 1: Age

Self-Reported age in # of years

Variable 2: Caregiver Status

Self-report of relationship Patient with Dementia

1 = Child of Pt w/ Dementia Diagnosis

2= Spouse of Pt w/ Dementia Diagnosis

3= Other (relative or non-relative) caregiver to Pt w/ Dementia Diagnosis

Variable 3: Gender

Self-report of gender identity

1= Biologically female

2= Biologically male

3= Transgender female

4= Transgender male

5= Non Binary

Variable 4: Patient Location

Self-report of primary patient location for last 6 month period

1= Home

2= LTC facility

3= Assisted Living Facility

4= Skilled Nursing

Variable 5: Hours Week Caregiving

Self-report of average # of hours spent providing caregiving activities for Pt w/ dementia per week.

Variable 6: Perceived Stress Total

Total numerical score on the Perceived Stress Scale = 0-40

Variable 7: Perceived Stress Level

Level of Stress based upon categorical ranges as defined by PSS:

1= Low Stress is defined as a Total PSS Score of 0-13

2= Moderate Stress is defined as a Total PSS Score of 14-26

3= High Stress is defined as a Total PSS Score of 27-40