Data Analysis with Microsoft Excel: Updated for Office 2007

313

Chapter 8

REGRESSION AND CORRELATION

Objectives

In this chapter you will learn to:

Fit a regression line and interpret the coeffi cients

Understand regression statistics

Use residuals to check the validity of the assumptions needed for

statistical inference

Calculate and interpret correlations and their statistical signifi cance

Understand the relationship between correlation and simple

regression

Create a correlation matrix and apply hypothesis tests to the

correlation values

Create and interpret a scatter plot matrix

▶ ▶ ▶ ▶ ▶ ▶ ▶