I need help with these questions on Week 6 Correlations exercise.

PART 1

1.What is the strongest correlation in the matrix? (Provide correlation value and names of variables)

2.What is the weakest correlation in the matrix? (Provide correlation value and names of variables)

3.How many original correlations are present on the matrix?

6.Which variable is most strongly correlated with body mass index? What is the correlational coefficient? What is the sample size for this relationship?

7.What is the mean and standard deviation for BMI and doctor visits

On PART II

1. What is the mean and standard deviation for weight and bmi

Note: The SPSS output information attachment is the statistical data that has already been run to answer the questions. Just not sure what to pull from to answer these questions? Help!

Week 6 Correlations Exercises Correlations are used to describe the strength and direction of a relationship between two variables. A correlation between two variables is known as a bivariate correlation. In this module, the Pearson Product-Moment Correlation will be used when running a correlation matrix. The Pearson correlation coefficient ranges from a value of -1.0 to 1.0. A correlation coefficient is never above 1.0 or below -1.0. A perfect positive correlation is 1.0, and a perfect negative correlation is -1.0. The size of the coefficient determines the strength of the relationship and the sign (i.e., + or -) determines the direction of the relationship. The closer the value is to zero, the weaker the relationship, and the closer the value is to 1.0 or -1.0, the stronger the relationship. A correlation coefficient of zero indicates no relationship between the variables. A scatterplot is used to depict the relationship between two variables. The general shape of the collection of points indicates whether the correlation is positive or negative. A positive relationship will have the data points group into a cluster from the lower lefthand corner to the upper right-hand corner of the graph. A negative relationship will be depicted by points clustering in the lower right-hand corner to the upper left-hand corner of the graph. When the two variables are not related, the points on the scatterplot will be scattered in a random fashion. Part I Using Polit2SetB data set, create a correlation matrix using the following variables: Number of visits to the doctor in the past 12 months (docvisit), body mass index (bmi), Physical Health component subscale (sf12phys), and Mental Health component subscale (sf12ment). Run means and descriptives for each variable, as well as the correlation matrix. Follow these steps using SPSS: 1. 2. 3. 4. Click on Analyze, then correlate, then bivariate. Select each variable and move them into the box labeled \"Variables.\" Be sure the \"Pearson and two-tailed\" box is checked. Click on the Options tab (upper-right corner) and check \"means and standard deviations.\" The \"Exclude cases pairwise\" box should also be checked. Click on Continue. 5. Click on OK. To run descriptives for docvisit, bmi, sf12phys, and sf12ment, do the following in SPSS: 1. Click on Analyze, then click on Descriptives Statistics, then Descriptives. 2. Click on the first continuous variable you wish to obtain descriptives for (docvisit) and then click on the arrow button and move it into the Variables box. Then click on bmi, and then click on the arrow button and move it into the Variables box. Then click on sf12phys, and then click on the arrow button and move it into the Variables box. Then click on sf12ment, and then click on the arrow button and move it into the Variables box. 3. Click on the Options button in the upper right corner. Click on mean and standard deviation. 4. Click on Continue and then click on OK. Assignment: Answer the following questions about the correlation matrix. 1. What is the strongest correlation in the matrix? (Provide correlation value and names of variables) 2. What is the weakest correlation in the matrix? (Provide correlation value and names of variables) 3. How many original correlations are present on the matrix? 4. What does the entry of 1.00 indicate on the diagonal of the matrix? 5. Indicate the strength and direction of the relationship between body mass index and physical health component subscale. 6. Which variable is most strongly correlated with body mass index? What is the correlational coefficient? What is the sample size for this relationship? 7. What is the mean and standard deviation for BMI and doctor visits? Part II Using Polit2SetB data set, create a scatterplot using the following variables: x-axis = body mass index (bmi) and the y-axis = weight-pounds (weight). Follow these steps in SPSS: 1. Click on Graphs, then click on Legacy Dialogs, then click on Scatter/Dot. 2. Click on Simple Scatter and then click on Define. 3. Click on weight-pounds and move it to the y-axis box and then click on body mass index and move it to the x-axis box. 4. Click on OK. To run descriptives for bmi and weight, do the following in SPSS: 5. Click on Analyze, then click on Descriptives Statistics, then Descriptives. 6. Click on the first continuous variable you wish to obtain descriptives for (body mass index), and then click on the arrow button and move it into the Variables box. Then click on weight-pounds, and then click on the arrow button and move it into the Variables box. 7. Click on the Options button in the upper-right corner. Click on mean and standard deviation. 8. Click on Continue and then click on OK. Assignment: 1. What is the mean and standard deviation for weight and bmi? 2. Describe the strength and direction of the relationship between weight and bmi. 3. Describe the scatterplot. What information does it provide to a researcher? Week 6 - Correlations SPSS Outputs Descriptive Statistics Mean Number of doctor visits, past Std. Deviation N 6.80 12.720 997 29.2226 7.37893 970 45.11422 10.840059 893 46.82843 10.806477 893 12 mo Body Mass Index SF12: Physical Health Component Score, standardized SF12: Mental Health Component Score, standardized Correlations SF12: Physical Health Health Component Number of SF12: Mental Component doctor visits, 12 mo Score, Index standardized standardized Pearson Correlation 997 ** .131 .131** -.316** -.133** .000 1 Sig. (2-tailed) N Body Mass Index Score, past 12 mo Number of doctor visits, past Pearson Correlation Body Mass .000 .000 967 890 890 1 ** -.078* .000 .022 -.134 Sig. (2-tailed) .000 N 967 970 866 866 ** ** 1 .168** SF12: Physical Health Pearson Correlation -.316 Component Score, Sig. (2-tailed) .000 .000 standardized N 890 866 893 893 ** * ** 1 Pearson Correlation Component Score, Sig. (2-tailed) .000 .022 .000 standardized N 890 866 893 *. Correlation is significant at the 0.05 level (2-tailed). -.078 .000 SF12: Mental Health **. Correlation is significant at the 0.01 level (2-tailed). -.133 -.134 .168 893 Scatterplot Descriptive Statistics Mean Body Mass Index Std. Deviation N 29.2226 970 171.4624 Weight-pounds 7.37893 45.44083 971 Correlations Body Mass Index Body Mass Index Pearson Correlation Weight-pounds 1 Sig. (2-tailed) N Weight-pounds Pearson Correlation .937** .000 970 970 ** 1 .937 Sig. (2-tailed) .000 N 970 **. Correlation is significant at the 0.01 level (2-tailed). 971