{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Class_Example_Correlation

# Class_Example_Correlation - Output Range and OK The linear...

This preview shows page 1. Sign up to view the full content.

ME 382 Class Example Problem - Correlation J. M. Cimbala Data point 1 0 0.356 2 2 0.679 3 4 0.478 4 6 0.564 5 8 0.390 6 10 0.581 7 15 0.805 8 20 0.723 Column 1 Column 2 Column 1 1 Column 2 0.66 1 0.66 x (mm) P (kPa) To calculate the linear correlation coefficient, use Tools -Data Analysis -Correlation . In Office 2007 - Data -Data Analysis (in Anaylsis area)-Correlation . Select both columns of data (in this case x and P ) as the Input Range . Select a cell for the top-left corner of the output as the
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Output Range , and OK . The linear correlation coefficient r xy is calculated and displayed in a table, as shown below: The value shown in the lower left corner of the resulting table is the linear correlation coefficient, r xy . Here, r xy = 2 4 6 8 10 12 14 16 18 20 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 x ∆ Π...
View Full Document

• Spring '08
• staff
• Correlation and dependence, Pearson product-moment correlation coefficient, Spearman's rank correlation coefficient, linear correlation coefficient

{[ snackBarMessage ]}

Ask a homework question - tutors are online