This should be an excel project and I have input theinformation and came up with

Question

This should be an excel project and I have input theinformation and came up with the probability of 1.1333E-158 This is what shows up in A1 on excel and this is the probability Igot by using a binomial calculator. I am not sure what theE-158 means. Or what this should look like on the spreadsheet. Seems like there should be more. Thenthe project asks what would be the maximum number ofreservations that you can make to make the probability lessthan0.05.                      This should be an excel project and I have input theinformation and came up with the probability of 1.1333E-158 This is what shows up in A1 on excel and this is the probability Igot by using a binomial calculator. I am not sure what theE-158 means. Or what this should look like on the spreadsheet. Seems like there should be more. Thenthe project asks what would be the maximum number ofreservations that you can make to make the probability lessthan0.05.                      1.1333E-158

Explanation / Answer

So we need the probability of each person showing up for theflight to determine if we will overbook a flight by making 200reservations for 182 seats. So all we need is for at least183 people to show up. E-158 means 10^-158. So 1.1333E-158 = 1.3333 * 10 ^-158. (which pretty much is 0). So to make the probability less than .05 - you need to look ata binomial cumulative distribution, where 95% falls under 182, withx reservations.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.