There are a large number of air carriers in the United
States. Most people have never heard of many of them.
To answer the assignment questions, follow these steps:
Download the dataPreview the documentView in a new window
(.xls) set and save it to your computer.
Complete all of your work and answer the following questions
in Excel to the right of the data set.
You will need the Data Analysis Toolkit that you should have
installed in Module 8.
Delete all of the airlines (rows) that flew zero passengers.
a. This may be easier if you sort the data from lowest to
highest.
Using the Data Analysis Toolkit, select the Descriptive
Statistics feature.
a. Don’t forget to check the box that says Summary
Statistics. (Recall the histogram video in module 8 used this feature in
Excel.)
Select an output range next to the data set so Excel knows
where to place this new information.
Use Descriptive Statistics to answer the following questions:
What is the minimum and maximum number of passengers flown
by these carriers and which carriers flew the most and fewest passengers?
Are there any outliers in this data set? If you find an outlier, delete it and
recalculate the descriptive statistics without the outlier. Explain your actions and thoughts. What effect did this outlier have on the
data?
a. Hint: Visit www.smokeybayair.com (Links to an external
site.).
What is the total number of passengers flown by all of these
air carriers?
What is the average (mean) number of passengers flown by
these air carriers?
What do the median and mode tell us about this data set and
why does it differ so greatly from the mean?
What is the standard deviation and what does that tell you
about the data set?
What does the skewness tell you about the shape of the
data? Is the data skewed? If so, which direction and why is it skewed?
View this abbreviated examplePreview the documentView in a
new window (.xls) of what the output should look like.
Hint: If you need assistance with using Excel for this
assignment, access Lynda.com via ERNIE and search for a course titled
“Excel 2007: Business Statistics with Curt Frye”. You do not need to
watch the entire tutorial. Scroll down below the presentation and watch the
brief module that applies to the assignment. Module 4, Summarizing Data Using
Descriptive Statistics seems most useful here. This module is not required for
this assignment and no completion certificate is required but may be useful to
students who are not proficient with Excel.
Prior to submitting your assignment, please use the
following naming convention for your file: Lastname_Activityname (e.g.
Smith_EBM_Bibliography).
Review the Problem Set (Quantitative Only) Rubric below. It
will be used to evaluate this activity.
