View the step-by-step solution to:

# MATH 211 AVIATION APPLICATIONS PROBLEM SET I This is the first of three aviation applications problem sets that you will complete for Math 211. It is...

could you help me configure Excel to answer question #2a? I have the spreadsheet information, but cannot attach both documents.
MATH 211 a. 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. b. Construct a histogram and cumulative percentage polygon for the frequency distribution you constructed in part a. c. Based on the histogram, do the data appear to be left skewed, right skewed, or symmetric? Explain your reasoning. 3. Data Set Delay Causes gives the causes of airline arrival delays throughout the U.S. for a recent month. a. Construct a bar chart, pie chart, and Pareto diagram for this data. b. 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 . 4. 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. a. Construct a time series graph of the accident rate per 100,000 flying hours. b. Are there any significant trends apparent from the data? Note: Data downloaded June 13, 2008 from http://www.aopa.org/whatsnew/stats/safety.html . 5. 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. a. Construct a scatter diagram with total hours flown on the horizontal axis and the number of accidents on the vertical axis. b. Describe the relationship between total hours flown and the number of accidents. Is it what you expected? Explain. Note: Data downloaded June 13, 2008 from http://www.aopa.org/whatsnew/stats/safety.html . 6. 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.
Show entire document

Great question... View the full answer

Frequencies (7119)
7119
Frequency
Percentage
Cumulative %
1011
1
2.04%
2.04%
1284
1
2.04%
4.08%
1351
1
2.04%
6.12%
1510
1
2.04%
8.16%
1787
1
2.04%
10.20%
1840
1
2.04%
12.24%
2142
1
2.04%
14.29%...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents