**Correlation of
the Airport Data
**

In this activity you will be performing a correlation analysis of airport flight data to determine whether or not there is a statistical relationship between two variables; the number of enplaned passengers and the number of performed departures. The data was collected from 135 airports across the United States. It consists of the name of the airport, the city, the performed departures, and the number of passengers flying. The name of the airport is included in the data set for reference.

Using the data set in Excel, perform a correlation analysis to see if there is a statistical relationship between the number of enplaned passengers and the number of performed departures. Then create a scatter plot of the two variables to analyze the data graphically.

1. What is the correlation coefficient between
the number of enplaned passengers and the number
of performed departures?

2.
Is the correlation coefficient positive
or negative?

3.
What does
this tell you about the relationship between
the two variables?

4.
Explain how the scatter plot represents
graphically the correlation you found between the
enplaned passengers and the number of departures.

5.
Perform a follow-up regression
analysis to predict the departures of an airport servicing
20,000,000 passengers.

Original work on this document was done by Central Virginia Governor's School students Kristine Salm, Stephanie Thornton and Jon Tucker (Class of '04).

Copyright © 2011 Central Virginia Governor's School for Science and Technology Lynchburg, VA