Class_Example_Correlation - Output Range , and OK . The...

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

View Full Document Right Arrow Icon
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
Background image of page 1
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

This note was uploaded on 07/23/2008 for the course ME 345 taught by Professor Staff during the Spring '08 term at Pennsylvania State University, University Park.

Ask a homework question - tutors are online