AVIATION APPLICATIONS PROBLEM SET I

This is the first of three aviation applications problem sets that you will complete for Math 211. It is worth 100 points or 10% of your course grade.

To complete the assignment, first save this Word document on your computer or memory device. Then complete each of the problems or questions by answering the problem or question in the Word document you saved.

Where appropriate, you must show your work and you must clearly indicate your answer. In some cases, showing your work can be done by pasting appropriate Excel or PHStat output into the Word file. Don’t just paste the Excel or PHStat output into the document—also clearly indicate your answer.

When you complete the assignment, save it, and then turn it in using the Blackboard Assignment Tool. If you have questions, please ask your instructor.

You will need the following Excel data files to complete this problem set:

• Active Pilots
• Delay Causes
• US GA Accidents and Rates
• US GA Accidents and Hours Flown
• ATL Taxi Times

1. There are a number of airline customer satisfaction surveys available on the web. (For example, see http://www.passengersurveys.com/ .) Suppose the items in the first column of the table below are items from an airline satisfaction survey. Complete the remaining columns of the table by classifying responses to the items as numerical or categorical, discrete or continuous, and nominal, ordinal, interval, or ratio.

   Item	Numerical or Categorical	Discrete or Continuous	Nominal, Ordinal, Interval, or Ratio
   How many flights you have taken in the past twelve months?
   In which cabin do you normally travel: First Class, Business Class, or Economy Class?
   Please select your age group from the following options: 18 – 29 yrs, 30 – 39 years, 40 – 49 years, 50 – 59 years, 60+ years
   Rate the quality of inflight entertainment as Excellent, Good, Fair, Poor, or Very Poor.
   How long does it take you to travel from your home to the airport you normally use?

2. Data File Active Pilots contains data on the number of active pilots by state as of 31 December 2007.

1. Construct a frequency distribution and cumulative percentage distribution for the number of active pilots by state. Use class widths of 5000 so that the first class is 0 < X <= 5,000; the second is 5,000 < X <= 10,000; the third is 10,000 < X <= 15,000; continuing as high as needed to include all the data.
2. Construct a histogram and cumulative percentage polygon for the frequency distribution you constructed in part a.
3. Based on the histogram, do the data appear to be left skewed, right skewed, or symmetric? Explain your reasoning.

1. Data Set Delay Causes gives the causes of airline arrival delays throughout the U.S. for a recent month.

1. Construct a bar chart, pie chart, and Pareto diagram for this data.
2. Which of the three diagrams do you prefer? Why?

Note: Data downloaded June 13, 2008 from http://www.transtats.bts.gov/OT_Delay/ ot_delaycause1.asp?pn=1&periodfrom=24100&periodto=24100 .

1. Data File US GA Accidents and Rates gives the total number of accidents, total hours flown, and accident rate per 100,000 flying hours from 1990 through 2006.

1. Construct a time series graph of the accident rate per 100,000 flying hours.
2. Are there any significant trends apparent from the data?

Note: Data downloaded June 13, 2008 from http://www.aopa.org/whatsnew/stats/safety.html .

1. Data File US GA Accidents and Hours Flown contains data on the total General Aviation hours flown and the total number of accidents from 1977 through 2006.

1. Construct a scatter diagram with total hours flown on the horizontal axis and the number of accidents on the vertical axis.
2. Describe the relationship between total hours flown and the number of accidents. Is it what you expected? Explain.

1. With rising fuel costs, the amount of time it takes for an airliner to taxi from the departure gate to takeoff is a concern. Data File ATL Taxi Times gives taxi times for random samples of 100 taxi flights in July 2000 and in July 2007 at the Atlanta Hartsfield Airport.

1. Complete the following table. Round your answers to two decimal places where necessary.

   	July 2000	July 2007
   Mean
   Median
   Mode
   Range
   Standard Deviation

2. How do the July 2000 and July 2007 data compare? Based on the data, does there appear to be an increase in taxi times between July 2000 and July 2007?

Note: Data downloaded June 16, 2008 from http://www.transtats.bts.gov/ .

With rising fuel costs, the amount of time it takes for an airliner to taxi from the departure gate to takeoff is a concern. Data File ATL Taxi Times gives taxi times for random samples of 100 flights in July 2000 and in July 2007 at the Atlanta Hartsfield Airport.

Compute five-number summaries for the two sets of data. Complete the following table.

Construct box-and-whisker plots for the two sets of data on the same set of axes.

Based on your answers to parts a and b, how do July 2000 and July 2007 taxi times compare? Describe the shape of each data set.

Note: Data downloaded June 16, 2008 from http://www.transtats.bts.gov/ .

Suppose that the number of passengers carried per month by Alaska Airlines out of the Anchorage Airport is normally distributed with a mean of 108,685 and a standard deviation of 29,440 (based on actual data from 2007).

1. Find the z-score for a value of 100,000. Round to three decimal places.
2. Find the z-score for a value of 150,000. Round to three decimal places.

Price: $25.53

Solution: The downloadable solution consists of 15 pages, 1053 words and 8 charts.
Deliverable: Word Document