OverviewTime estimate:\u00a0Approximately 6 hours.
Project data:\u00a0Students use\u00a0Excel\u00a0to analyze the data. It involves all major airline domestic flights departing from Oregon airports in 2016.
Project\u00a0Idea: 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: \u201cHow can we better understand our data?\u201d In order to really understand these tools, we will repeatedly ask the question, \u201cWhat patterns can we find in this Oregon flight data?\u201d
Project Procedure:\u00a0For each project, you will be asked to use a different tool or approach\u00a0on the same data\u00a0and prepare a report. By the end of the course, you will have used every tool we have to better understand this data.
XLSTAT (upgrade your XLSTAT-Free to a paid version for FREE): Please follow Step 5 at the bottom of this page\u00a0Required Software, which has been updated on 6\/29\/2021.\u00a0
\u00a0
InstructionsDownload the data linked below.
Use\u00a0Excel\u00a0or other software tool 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.
TurnItIn is turned on. Be sure to submit your own report.
\u00a0
DataDownload here:\u00a0Oregon Flight Data\u00a0download
More information about the data:\u00a0Airline On-Time Performance Data.\u00a0(Links to an external site.)\u00a0We are working on\u00a0Reporting Carrier On-Time Performance (1987-present).\u00a0To decipher carrier codes, click on this PDF document:\u00a0Carrier Codes\u00a0download
\u00a0
QuestionsPlease do NOT copy these questions into your report. Just number your answers.
(1) What is this data \u201call about\u201d?
\u00a0
(2) How many rows and columns? What does each row represent? What can you tell about the data from the column headers?
\u00a0
(3) Is this data quantitative, qualitative, or both? Why?
\u00a0
(4) Randomly pick one column. Summarize in a clear and complete English sentence, and explain what this column tells us. Comment about the average and the spread (i.e., standard deviation) of the column. Be sure to include any necessary units.
Hint: In Excel, use\u00a0\u00a0=average()\u00a0\u00a0and\u00a0\u00a0=stdev(). If you have difficulties with using Excel, please watch “Excel Tips” video in Module 1’s required lecture videos.\u00a0
\u00a0
(5) What is the average delay in departures (Column AF\u00a0DepDelay, not Column AG\u00a0DepDelayMinutes) from Oregon Airports? Be sure to include the unit of this quantity.\u00a0
\u00a0
We have a pretty cool data set and can see all departures by major carriers in the given time frame. What if instead we just measured a few flights? Measure 3 different \u201crandom\u201d sets of data. For ease, pick 3 random flights and calculate the average of your 3 flights.
Check the instructor’s video tutorial on how to randomly select rows using XLSTAT:\u00a0\u00a0How to create a random sample using XLSTAT?
To randomly select rows using Excel:\u00a0How to create a random sample using Excel?
(6) What is the average departure delay of your 3 randomly selected flights?
\u00a0
Your answer to (6) probably wasn’t that close to the true average (although you might have gotten lucky). Let’s consider what would happen if you do the same thing but using an average of 30 flights. Now, pick 30 random flights.\u00a0
(7) What is the average departure delay of these randomly selected 30 flights?\u00a0\u00a0
\u00a0
(8) Do you see evidence of the Central Limit Theorem at play? Was the average of a larger sample closer to the truth? Do you think\u00a0all\u00a0of your classmates will find the same thing? Why or why not?
\u00a0
Submission DetailsAfter you use Excel and analyze the data, you will then create a report that responds to the 8 questions listed above (include the numbers and answer in complete sentences). Please include your numbered responses, but do not copy the questions into your document.
In your word document, you may insert any relevant charts or tables to support your argument. Then submit your responses as a file upload (DOC, DOCX, PDF) here in Canvas.\u00a0
\u00a0
Grading CriteriaTotal 20 points: 4 points each for questions (3) and (8), and 2 points each for the remaining, for answering the questions correctly, clearly, and succinctly. Partial points for partial answers.
One Extra Credit (5%) for any submission turned in 3 days before the due date.\u00a0 <\/p>\n","protected":false},"excerpt":{"rendered":"
OverviewTime estimate:\u00a0Approximately 6 hours. Project data:\u00a0Students use\u00a0Excel\u00a0to analyze the data. It involves all major airline domestic flights departing from Oregon airports in 2016. Project\u00a0Idea: 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[33],"class_list":["post-10964","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-mathematics"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/10964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=10964"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/10964\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=10964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=10964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=10964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}