Step 2: Calculate the Correlation Matrix

bullet

Excel - “Tools - Data Analysis… - Correlation”

bullet

Identify the factors that are correlated - high coefficient of correlation

Assumed Equation

Import Data to Excel

Correlation Matrix?

Transform into Linear

Prepare Data Table

Regression by Excel

Quality Analysis

No

Yes

Previous slide Next slide Back to first slide View graphic version