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 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 D elay 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? Numerical Discrete Nominal, Ratio In which cabin do you normally travel: First Class, Business Class, or Economy Class? Categorical No Nominal, Interval Please select your age group from the following options: 18 – 29 yrs, 30 – 39 years, 40 – 49 years, 50 – 59 years, 60+ years Numerical Continuous Nominal, Ratio Rate the quality of inflight entertainment as Excellent, Good, Fair, Poor, or Very Poor. Categorical No Ordinal, Ratio How long does it take you to travel from your home to the airport you normally use? Numerical Continuous Nominal, Ratio 2. Data File Active Pilots contains data on the number of active pilots by state as of 31 December 2007.
Background image of page 1
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.
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Great question... View the full answer

547521_MATH.xlsx

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%...

Sign up to view the full answer

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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online