all data is for arrival data. please help me explain these can someone help me a
ID: 3070532 • Letter: A
Question
all data is for arrival data. please help me explain these
can someone help me answer these questions and tell me how to put them in excel.thanx in advance
1. Define a random variable (X) so that your chosen data set represents values of X.
2. Is your chosen random variable discrete or continuous? Explain how you know
3. Would the Normal or Binomial distribution be a good fit for the underlying sample distribution of X? If one of them is a good fit, state how you would approximate the distribution parameters.
4. Calculate the probability that a flight will depart early or on time.
(8). Calculate the probability that a flight will arrive late.
6. Calculate the probability that a flight departs late or arrives early.
7. Assume now that the random variable X=Arrival Time is exactly normally distributed with mean m= -2.5 and standard deviation s= 23. Compute the probability of a flight arriving late based on this new information. Does this contradict your answer from Part 8?
Your Histogram
Mean
-3.138
Standard Deviation (s)
9.66093
Lowest Score
-29
Highest Score
26
Distribution Range
55
Total Number of Scores
500
Number of Distinct Scores
53
Lowest Class Value
-30
Highest Class Value
32
Number of Classes
7
Class Range
9
data set
All calculations must be performed in Excel. The Excel file must be submitted as part of the report. Preferred method is pasting your Excel calculations into this paper instead of including a separate file.
Dep Delay Arr Delay q1 -13 -9 q3 1 3 IQR 14 12 stdev 9.211846 9.660933 negative 291 zero 39 positive 170 total (should be 500) 500Explanation / Answer
1. Define a random variable (X) so that your chosen data set represents values of X.
Here X is the Arrival Time of the flight
2. Is your chosen random variable discrete or continuous? Explain how you know
Here the random variable is continous. Here the value is continous because it takes any value, not some specific value so that shows continuity.
3. Would the Normal or Binomial distribution be a good fit for the underlying sample distribution of X? If one of them is a good fit, state how you would approximate the distribution parameters.
Here the normal distirbution would be a better fit because binomial distribution is a discrete one.
Here the distribution parameters are
mean = -3.138 min
standard deviation = 9.661 min
4. Calculate the probability that a flight will depart early or on time.
Here we have to put the data array in excel and calculate the number of values that are less than or equal to zero.
P(On time) = (291 + 39)/500 = 330/500 = 0.66
(8). Calculate the probability that a flight will arrive late.
P(Late flight) = 170/500 = 0.34
6. Calculate the probability that a flight departs late or arrives early.
Pr(flight departs late of arrives early) = 1 - Pr(Not coming on time) = 1 - 39/500 = 0.922
7. Assume now that the random variable X=Arrival Time is exactly normally distributed with mean m= -2.5 and standard deviation s= 23. Compute the probability of a flight arriving late based on this new information. Does this contradict your answer from Part 8?
Here now we use Excel here
Put the formula
P(aarival late) = 1 - Pr(x < 0 ; -2.5; 23) = 1 - NORMDIST(0, -2.5, 23, true) = 1- 0.5433 = 0.4567
yes this probability is much higher than the probability we observe.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.