Estimate the probability of American and Delta reaching the yields of 16, 17, and 18 using only the mean and standard deviation data derived from the descriptive statistics.
January 16, 2024January 16, 2024
Discipline: Excel
Question 1: Management observes that United had a yield exceeding 16 in 2019. Yields of 16 and beyond are envisioned to be ideal. Estimate the probability of American and Delta reaching the yields of 16, 17, and 18 using only the mean and standard deviation data derived from the descriptive statistics.
Question 2: One of the team members learned that due to severe macroeconomic conditions, one of the airlines on the list is projecting a yield of 8 for the next year. Using mean and standard deviation data from each airline, which airline is most likely to be the one achieving a yield of 8 or less?
***This assignment requires a standard deviation bell curve to be shown from question 1***
All required data is in the attached excel spread sheet, more specifically data for the two airliners is in the passenger yield tab.
Ace Your Assignments! 🏆 - Hire a Professional Essay Writer Now!
Complete the order form by providing as much information as possible, and then click the submit button.
Choose writer
Select your preferred writer for the project, or let us assign the best writer for you.
Add funds
Allocate funds to your wallet. You can release these funds to the writer incrementally, after each section is completed and meets your expected quality.
Ready
Download the finished work. Review the paper and request free edits if needed. Optionally, rate the writer and leave a review.