# HLT 362V Correlation Regression and Chi Square Excel Worksheet

**HLT 362V Correlation Regression and Chi Square Excel Worksheet**

**HLT 362V Correlation Regression and Chi Square Excel Worksheet**

**HLT 362V Correlation Regression and Chi Square Excel Worksheet**

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 11 Questions to be Graded**

- What demographic variables were measured at least at the interval level of measurement?
- What statistics were used to describe the length of labor in this study? Were these appropriate?
- What other statistic could have been used to describe the length of labor? Provide a rationale for your answer.
- Were the distributions of scores similar for the experimental and control groups for the length of labor? Provide a rationale for your answer.
- Were the experimental and control groups similar in their type of feeding? Provide a rationale for your answer.
- What was the marital status mode for the subjects in the experimental and control groups? Provide both the frequency and percentage for the marital status mode for both groups.
- Could a median be determined for the education data? If so, what would the median be for education for the experimental and the control groups? Provide a rationale for your answer.
- Can the findings from this study be generalized to Black women? Provide a rationale for your answer.
- If there were 32 subjects in the experimental group and 36 subjects in the control group, why is the income data only reported for 30 subjects in the experimental group and 34 subjects in the control group?
- Was the sample for this study adequately described? Provide a rationale for your answer.

**HLT 362V EXERCISE 18 Questions to be Graded**

- In comparing men and women, which group had higher body image scores? Provide a rationale for your answer.
- Men had higher variability in weight change over the last 12 months when compared to women. Is this statement true or false? Provide a rationale for your answer.
- What are the X_and SD values for men’s body weight ratio?
- Assuming that the distribution of scores is normal, calculate the scores where 95% of values around the mean lie for women with weight change over the last 3 months. Round your answer to two decimal places.
- Assuming that the distribution of body weight ratio is a normal curve, 95% of the men lie between which two values of body weight ratio around the mean? Round your answer to two decimal places.
- Assuming that the distribution of womens’s body image scores is normal, 99% of women’s body image scores around the mean lie between what two values? Round your answer to two decimal places.
- Assuming that the distribution is a normal curve, 99% of men were between what ages? Round your answer to two decimal places.
- Assuming that the distribution is a normal curve, 95% of men were between what ages? Round your answer to two decimal places.
- Did HIV-positive participants have signifi cantly higher body image scores than those with AIDS? Provide a rationale for your response.

**HLT 362V Exercise 20**

- 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.

Get a

Use the following coupon code :

TOPCLASS

**10 %**discount on an order above**$ 50**Use the following coupon code :

TOPCLASS