HLT 362V Module 5 Correlation Regression and Chi Square Excel Worksheet
HLT 362V Module 5 Correlation Regression and Chi Square Excel Worksheet
HLT362V
SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES
The following table represents systolic and diastolic blood pressure measurements of 40 females.
- A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
- B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.
- C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?
HLT 362V Exercise 20
HLT362V
- Which patient scored the highest on the preoperative CVLT Acquisition? What was his or her T score?
- Which patient scored the lowest on postoperative CVLT Retrieval? What was this patient’s T score?
- Did the patient in Question 2 have more of a memory performance decline than average on the CVLT Retrieval? Provide a rationale for your answer.
- What is the mean ( ) and standard deviation (SD) for preoperative T score for CVLT Acquisition?
- Is the preoperative Retrieval T score for Patient 5 above or below the mean for the norm of the group? Provide a rationale for your answer.
- Assuming that the distribution of the preoperative CVLT Retrieval T scores is normal, the middle 68% of the patients had T scores between what two values?
- Assuming that the distribution of scores for the postoperative CVLT Retrieval T scores is normal, the middle 68% of the patients had T scores between what two values?
- The researchers state that it appears that the functional integrity of the left temporal lobe, despite evidence of structural abnormality, plays a considerable role when it comes to memory outcomes following left ATL. Can the findings from this study be generalized to a larger population? Provide a rationale for your answer.
- If a patient had a raw score = 30, what would his/her postoperative CVLT Retrieval T score be?
- Did patients demonstrate more postoperative memory declines among CVLT Retrieval T scores than CVLT Acquisition T scores? Provide a rationale for your answer.
