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.

1. A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
2. B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.
3. 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

1. 1. What demographic variables were measured at least at the interval level of measurement?
   2. What statistics were used to describe the length of labor in this study? Were these appropriate?
   3. What other statistic could have been used to describe the length of labor? Provide a rationale for your answer.
   4. Were the distributions of scores similar for the experimental and control groups for the length of labor? Provide a rationale for your answer.
   5. Were the experimental and control groups similar in their type of feeding? Provide a rationale for your answer.
   6. 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.
   7. 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.
   8. Can the findings from this study be generalized to Black women? Provide a rationale for your answer.
   9. 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?
   10. Was the sample for this study adequately described? Provide a rationale for your answer.
   11. HLT 362V Complete Course Latest Assignment

MORE INFO 

Correlation Regression and Chi Square

Introduction

Correlation is a measure of how closely two variables move together. The closer they are, the more strongly they are related. For example, if you have two sets of numbers and one increases while the other decreases, then the change in each set will be positively correlated with each other (if one group increases then so will the other).

EXPLAIN CORRELATION

Correlation is a measure of how two variables change together. It can be positive, negative or zero—the higher the correlation coefficient, the more closely the two variables are related. The correlation between two variables X and Y is defined by:

Correlation = [X_i] – [Y_i]/[X_j] + [Y_j]/[X_i](1-corr)(2)

EXPLAIN REGRESSION

In this section, you’ll learn about correlation and regression. You’ll also see how to do a regression analysis, interpret the results of a regression analysis, and compare multiple regression with simple linear models.

A correlation coefficient measures the strength of association between two variables. For example: if we have two variables x1 and x2 that are both measured on a scale from 0-1 (0 being “no” or “less than”, 1 being “more than”), then their correlation coefficient would be given by r = (x1 – x2)/(σ x1 + σ x2). If one variable is dependent upon another then its value can only change when the other changes too; this means that one has no independent meaning unless paired with another variable whose own value isn’t tied directly to anything else—it’s just an abstract measure of similarity between two things!

EXPLAIN CHI SQUARE

The chi-square test of independence is used to determine if two or more variables are independent. It can be used when you have categorical data (such as gender, race and religion) that can be classified into one of many categories.

The chi-square value is calculated by taking the product of the frequencies in each cell and dividing this product by their sum:

1n(n-1)/n = n(n-1)+c2 where c2 = total number of cells in an n × k table with 2k rows/columns; n = sample size; k = number of independent variables; n(i)-i=total counts for all i th groups {i}

Takeaway:

We started this section with a simple example: if you want to know how likely it is that one variable influences another, you can use a correlation coefficient. This tells you the strength of association between two variables. In this case, we’re looking at whether education affects job performance. A high correlation coefficient would mean there’s a very strong relationship between those two variables; low correlation would mean there isn’t much connection between them at all.

Correlation is one type of statistical measure that helps us understand relationships within data sets such as those collected in surveys or experiments (like the one we ran earlier). Correlations are often used when researchers want to test hypotheses about how two things relate together—for instance, whether obesity causes high blood pressure or vice versa—or if they want to compare different groups’ levels of health status over time (elderly people tend not have higher rates than young adults do).

Conclusion

In this post, we’ve explored some of the main types of statistical tests that you can use to evaluate data and understand it. We’ve touched on the concepts of correlation, regression, and chi square.

We also looked at how these methods work and why they are useful for analyzing relationships between variables in your data set.

Finally, we discussed how these tools can be used with different types of data sets like linear regression (which involves finding a line through points) or non-linear regression (which involves finding a curve through points).

I think you should now have a better understanding of how correlation works. In particular: You know what causes one variable to go up or down compared to another; You understand why correlation coefficients are useful; And finally…how to choose which method is best suited for your needs!