A study of bone density on 5 random women at a hospital produced the following results. Age 45 49 53 57 73 Bone Density 355 340 325 320 315 Step 1 of 3 : Calculate the correlation coefficient, r. Round your answer to six decimal places.

Respuesta :

Correlation is the measure of the degree to which any two variables vary together.

If one variable tends to increase as the other variable decreases , the correlation is said to negative or inverse.

From the correlation we assess the strength of the relationship of two variables.

A  numerical measure of strength in the linear relationship between the two variables is called co efficient of simple correlation.

The  co efficient of simple correlation r is a pure number and assumes values from+1 to -1 .

r= -0.837295

The sign of r indicates the direction of the relationship or correlation.

It can be determined by finding the COV (X,Y)/ √Var (X) Var(Y)

In the given question it is calculated by using the excel sheet.

The correlation tab is found in the statistical column of the formula tab.

After entering the data in the excel the correlation tab is clicked and the rows cells are entered and the answer is obtained.

Another way is use the data analysis tab and click the correlation tab.

For both ways the following result is obtained .

r= -0.83729481

rounded to 6 places gives

r= -0.837295

https://brainly.com/question/18054482

https://brainly.com/question/24169114

Ver imagen akiran007
ACCESS MORE
ACCESS MORE
ACCESS MORE
ACCESS MORE