Practice Prob 4). You are an analyst for the Port of Freeport (POF), TX. Your boss, Velma Pham, asks you to do an analysis of the number of hours needed to unload anticipated shipments of coffee on a daily basis. The POF has decided to compete with the Port of New Orleans, LA, which is the No. 2 port for the importation of coffee. Velma has spoken with Hamburg Sud (a large shipping firm with routes in Latin America) that has routes from Colombia and could make Freeport a port of call. These shipments are relatively uncertain, but there is data related to their uncertainty. Two types of containers are used in shipping coffee-ventilated and unventilated-and they are handled in different areas of the port. Treat the ship calls of the two types of containers as independent of one another; that is, the arrival of one type of container ship has no relationship to the arrival of the other. The port works 7 days a week, 24 hours a day. -Number of ventilated containers arriving on a container ship: normally distributed with a mean of 50 and a standard deviation of 7.5- N(50,2.5). -ship calls of ventilated containers arriving per day: a uniform distribution of 0 to 2. -Unloading time for each ventilated container: normally distributed with a mean of 12 minutess and standard deviation 2-N(12,2). -Unventilated containers arriving on a container ship: Normally Distributed with a mean of 55 and a standard deviation of 8-N(55,3). -Ship calls of unventilated containers arriving per day: a uniform distribution of 0 to 2. -Unloading time for each unventilated container: Normally distributed with mean of 9 minutes and standard deviation 1.5-N(9,1.5). -The number of all types of ship calls (given the information above) is a minimum of 0 (0+0) and a maximum of 4 (2+2) during a day. a) Velma would like for you to build a model that estimates the operation of a week of arrivals and the related number of hours of unloading required. Additionally, she wants you conduct an experiment in which you replicate the model that you have constructed for that week 1000 times. b) Provide summary statistics for the replications of the experiment-mean, stdev.s (sample standard deviation), max, min, and median. Also, create a frequency distribution for unloading hours (a Risk Profile) with increments of 20 hrs. c) What is the approximate probability of there being zero unloading hours in a week? d) What is the probability of there being 400 or more unloading hours? (Hint: use the frequency distribution created for the risk profile. Create a column of Cumulative Frequency %-Cumulative Frequency/1000, or you can simply use a countif[].) Practice Prob 4). You are an analyst for the Port of Freeport (POF), TX. Your boss, Velma Pham, asks you to do an analysis of the number of hours needed to unload anticipated shipments of coffee on a daily basis. The POF has decided to compete with the Port of New Orleans, LA, which is the No. 2 port for the importation of coffee. Velma has spoken with Hamburg Sud (a large shipping firm with routes in Latin America) that has routes from Colombia and could make Freeport a port of call. These shipments are relatively uncertain, but there is data related to their uncertainty. Two types of containers are used in shipping coffee-ventilated and unventilated-and they are handled in different areas of the port. Treat the ship calls of the two types of containers as independent of one another; that is, the arrival of one type of container ship has no relationship to the arrival of the other. The port works 7 days a week, 24 hours a day. -Number of ventilated containers arriving on a container ship: normally distributed with a mean of 50 and a standard deviation of 7.5- N(50,2.5). -ship calls of ventilated containers arriving per day: a uniform distribution of 0 to 2. -Unloading time for each ventilated container: normally distributed with a mean of 12 minutess and standard deviation 2-N(12,2). -Unventilated containers arriving on a container ship: Normally Distributed with a mean of 55 and a standard deviation of 8-N(55,3). -Ship calls of unventilated containers arriving per day: a uniform distribution of 0 to 2. -Unloading time for each unventilated container: Normally distributed with mean of 9 minutes and standard deviation 1.5-N(9,1.5). -The number of all types of ship calls (given the information above) is a minimum of 0 (0+0) and a maximum of 4 (2+2) during a day. a) Velma would like for you to build a model that estimates the operation of a week of arrivals and the related number of hours of unloading required. Additionally, she wants you conduct an experiment in which you replicate the model that you have constructed for that week 1000 times. b) Provide summary statistics for the replications of the experiment-mean, stdev.s (sample standard deviation), max, min, and median. Also, create a frequency distribution for unloading hours (a Risk Profile) with increments of 20 hrs. c) What is the approximate probability of there being zero unloading hours in a week? d) What is the probability of there being 400 or more unloading hours? (Hint: use the frequency distribution created for the risk profile. Create a column of Cumulative Frequency %-Cumulative Frequency/1000, or you can simply use a countif[].)