MSIS 111 PROBABILITY EXCEL
Alibrea Tuskata
ExcelCh6LabDemoProfessor.xlsxPart A
| 0.2647439683 | x= 3.60 | ||
| 0.6670632181 | x = 5.00 | ||
x= 3.60 X= 5.00 Mean = 4.43 Sigma = 1.32
Part B
| 0.7450813035 | x= 5.30 | ||
| 0.9415806468 | x= 6.50 | ||
| 0.1964993433 | |||
x= 5.30 X= 6.50 Mean = 4.43 Sigma = 1.32
Part C
| -0.6501427768 | NORM.S.INV | |||
x= 40 mean = 44 Sigma = Unknown Use Norm.S. INV
Q 13
| 13-Part A | What is the probability that the port handles less than million tons of cargo per week (to 4 decimals)? | |
| 0.6879330506 | ||
| 0.0238517643 | ||
| 0.6640812862 | ||
| Part B | b. What is the probability that the port handles or more million tons of cargo per week (to 4 decimals)? | |
| 0.8887675626 | ||
| 0.6984682125 | solution | |
| 0.1902993501 | ||
Norm.S.Dist You may use the Z table in the book or the excel formula to find the solutions for this series of questions Asks for Z value Determineif cumulative function: true or false
