Forum Discussion
Trouble with statistical functions and excel
JoeUser2004 You pretty much already have everything I've got concerning information.
I can't provide you with the pdf, but the following is copied directly from the assignment without any edits from my side and the excel file from my original post is also unedited:
An airport wants to have an analysis of its processes. They gave you the number of starts and landings for every hour of April 2021.
a) Create a distribution function, which gives you an appropriate probability of one of the values of the record.
b) Develop your distribution from a) by adding a normally distributed error term with a standard deviation of 12 aircrafts to be able to draw as well meaningful (!) values apart from the record. Show the airport cases of three simulated months (October, November, December) in hours in a histogram.
c) The airport knows that between 4% and 9% of all aircrafts can’t start because of an engine failure, so they have to stay in a predetermined area. Assume the share of Lufthansa of all aircrafts is beta-distributed with 𝛼=2 and 𝛽=5. Simulate the number of Lufthansa aircrafts, which can’t start for 500 hours, and visualize your results in a boxplot diagram.
d) Each airline has an own predetermined area for their aircrafts that can’t start because of an engine failure. The area for the Lufthansa is limited to three aircrafts. Report the share of hours, when this limit is no sufficient for all aircrafts, which can’t start. How many aircrafts should have space in this area, if you want to cover the demand at 95% of all hours?
We (mainly someone from my group) solved the entire assignment and I understand it now, so *cough *cough if you need any information on how we solved it feel free to ask.
Also if your wondering, my professors aren't native english speakers, thus some mistakes/vague tasks.
Mmrtlm wrote: ``my professors aren't native english speakers, thus some mistakes/vague tasks.``
That is what I thought. Thanks for the confirmation.
You wrote: ``We (mainly someone from my group) solved the entire assignment and I understand it now, so *cough *cough if you need any information on how we solved it feel free to ask. ``
I would appreciate it if you posted an Excel file with your solutions. It might help me understand how to interpret the assignment.
(If you prefer, you can send the Excel file to me directly: joeu20045 "at" gmail.com.)
Thanks.