Embry MBAA522 Module 1.4 Assignment
Follow Below Link to
Download File
Email us for original
and Plagiarism Free Work At ( info.homeworklance@gmail.com ) or order us at (https://homeworklance.com/custom-order/ )
Quantitative research
involves the analysis of data. Often there are databases available or
government data available for free on the internet. There are also proprietary
databases that can provide data as well. For this assignment, you will collect
data and begin the analysis of the data. NOTE: save the data collected because
you will continue to perform additional analysis of the data as the term
progresses. Hint: for collecting data, try the Research and Innovative
Technology Administration, Bureau of Transportation Statistics website. You
will have to do some searching to find the data. Look around the reference
website, the data are there.
For the first module,
you need to collect cumulative data for all U.S. major carriers for the time
period of January 2006 through December 2012. The data you collect should
include monthly load factors, monthly revenue passenger miles, and monthly
available seat miles (Domestic flights only).
Once you have
collected the data, clean the data as necessary (i.e. sometimes monthly data
will include a total for each year in the data set). If you keep the annual
total in the data set it could skew some of your results. Also, remember the
question asks for domestic data only. For the period in question calculate the
following summary statistics for each data item collected:
Mean
Median
Mode
Standard Deviation
Variance
Minimum and maximum
In addition to data
for all U.S. carriers collect the same data of a single U.S. airline, clean the
data, and calculate the same summary statistics for the particular airline you
selected.
Create a scatter plot
for all of the US airline data with revenue passenger miles on the y-axis and
load factor on the x-axis. Do the same for the individual airline you have
selected. Make sure your scatter plot includes a title of the plot, labels the
x and y-axis with appropriate titles, and uses appropriate scales for each axis
(refer to your textbooks for examples).
After completing the
above items, prepare a brief (three to four paragraph) discussion of the
summary statistics, perceived relation between load factor and revenue
passenger miles (if any), how your selected airline appears to be performing
relative to the industry, and any other information you can glean from the data
collected. Your write-up should also include a brief discussion identifying
where the data was obtained from. Ensure sources are cited and formatted in
accordance with current APA format.
This assignment is
intended to get you to start thinking about what your data may or may not be
telling you. Certainly, this early in the term we have not discussed the tools
necessary to draw strong inferences. However, there are items which may appear
to be apparent that can be discussed.
Be sure to include
summary tables of summary statistics, the scatterplots, and the excel
spreadsheet with the data in addition to the brief write-up. When you submit
your assignment, use the following naming convention:
Lastname.Firstname.Course.Activity.fileextension.
For example, I would have two documents to turn in: Mau.Ron.MBAA522.1.4.docx.
and Mau.Ron.MBAA522.1.4.xlsx.
Review the Data
Assignment RubricPreview the documentView in a new window before submitting
your completed assignment. Read through the rubric carefully and note that
spread sheets must include the formulas where applicable. Within a cell with a
result, the formula should be visible if the cell is selected. Formulas are not
necessary in summary tables, which should just include the results.
Comments
Post a Comment