Business research methods

Quantitativeresearch involves the analysis of data. Often there are databasesavailable or government data available for free on the internet. Thereare also proprietary databases that can provide data as well. For thisassignment, you will collect data and begin the analysis of the data.NOTE: save the data collected because you will continue to performadditional analysis of the data as the term progresses. Hint: forcollecting data, try the Research and Innovative TechnologyAdministration, Bureau of Transportation Statistics website. You willhave to do some searching to find the data. Look around the referencewebsite, the data are there. For the first module,you need to collect cumulative data for all U.S. major carriers for thetime period of January 2006 through December 2012. The data you collectshould include monthly load factors, monthly revenue passenger miles,and monthly available seat miles (Domestic flights only).Onceyou have collected the data, clean the data as necessary (i.e.sometimes monthly data will include a total for each year in the dataset). If you keep the annual total in the data set it could skew some ofyour results. Also, remember the question asks for domestic data only.For the period in question calculate the following summary statisticsfor each data item collected:MeanMedianModeStandard DeviationVarianceMinimum and maximumIn addition to data for all U.S. carriers collect the same data of asingle U.S. airline, clean the data, and calculate the same summarystatistics for the particular airline you selected.Create ascatter plot for all of the US airline data with revenue passenger mileson the y-axis and load factor on the x-axis. Do the same for theindividual airline you have selected. Make sure your scatter plotincludes a title of the plot, labels the x and y-axis with appropriatetitles, and uses appropriate scales for each axis (refer to yourtextbooks for examples).After completing the above items,prepare a brief (three to four paragraph) discussion of the summarystatistics, perceived relation between load factor and revenue passengermiles (if any), how your selected airline appears to be performingrelative to the industry, and any other information you can glean fromthe data collected. Your write-up should also include a brief discussionidentifying where the data was obtained from. Ensure sources are citedand formatted in accordance with current APA format. Thisassignment is intended to get you to start thinking about what your datamay or may not be telling you. Certainly, this early in the term wehave not discussed the tools necessary to draw strong inferences.However, there are items which may appear to be apparent that can bediscussed.Be sure to include summary tables of summarystatistics, the scatterplots, and the excel spreadsheet with the data inaddition to the brief write-up. When you submit your assignment, usethe 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 Rubric beforesubmitting your completed assignment. Read through the rubric carefullyand note that spread sheets must include the formulas where applicable.Within a cell with a result, the formula should be visible if the cellis selected. Formulas are not necessary in summary tables, which shouldjust include the results.