Fnds of statistical inference

Project Overview
Project data: Students will be expected to use Excel and XLSTAT to analyze the data. It involves all major airline domestic flights departing from Oregon airports in June of 2020.

Project Idea: We try to use all the statistical tools discussed in this class to analyze this dataset. The purpose of any statistics class is to better understand the world through data. Although we have many tools, all of them come back to one question: How can we better understand our data? In order to really understand these tools, we will repeatedly ask the question, What patterns can we find in this Oregon flight data?

Project Procedure: For each project, you will be asked to use a different tool or approach on this same data and prepare a report. By the end of the course, you will have used every tool we have to better understand this data.

Instructions
Download the data from Canvas.
Use XLSTAT and Excel to analyze the data.
Answer the questions listed below.
Do not include the original dataset in your report. Your answers should be in complete sentences. Insert necessary tables or graphs to support your arguments and comments in the report. Do not attach a bunch of computer printouts.
The plagiarism checker is turned on. Be sure to submit your own report.
Check the rubric for the number of points each question is worth.

Open your data (in Excel) and answer the following questions in the provided template: BA 275 Project 1 template.docxPreview the document

What is this data all about?
How many rows and columns are there? What does each row represent? What can you tell about the data from the column headers?
Last year in the month of June, there were 6755 flights that had departed Oregon airports. How does that compare to this year? Does that surprise you, or not so much?
Is this data quantitative, qualitative, or both? Why?
Use Excels =average() and =stdev.p() to say something about one of the columns. Summarize in a clear English sentence something this column tells us.
Try sampling from one of the quantitative variables in the flight data using XLSTAT. Report your sample of size 50 at the end of the project.
Now that we’re starting to have a good time, let’s dabble with a bit of plotting/graphing! Use XLSTAT to create a histogram of your random sample. Be sure to update the horizontal axis and title of the graph rather than using the abbreviated variable name.
Use XLSTAT to create a boxplot of your random sample. As before, update the horizontal axis and title of the graph rather than using the abbreviated variable name.
How would you describe the shape of your graph? Some adjectives you might include would be: symmetric, skewed, unimodal, bimodal, uniform, bell-shaped, etc.
Did your random sample include any outliers? Explain.

Leave a Reply

Your email address will not be published. Required fields are marked *