The data for travel time, demand and weather condition per bus trip for a bus route in the city of Calgary is given (see CSV file posted on D2L under Assignment section). Based on this dataset, answer the following questions: A) What is the mean and standard deviation of the travel time and demand for different weather conditions? B) Find the best fitted distributions to travel time and demand for different weather conditions Use uniform, normal, lognormal and exponential distributions. Compare the distribution of travel time and demand under different weather conditions. C) The City decides to build a new bus route with the same characteristics of the existing route but with a different length. The existing route has a length of 17 km, while the new route has a length of 12 km Hint: convert route demand and travel times to per unit distance, obtain coefficient of variation (CV), then obtain the new mean based on per unit distance and the variance based on calculated CV. Using the same coefficient of variations, generate travel time and demand for this new route for at least 1000 trips for a good weather condition D) The roundtrip time of the bus is an important variable for the agency in order to do proper schedule planning (frequency of service and fleet size determination). The roundtrip time is calculated based on the following equation: Roundtrip time = travel time one direction + travel time on the return direction + layover time at the terminal Considering variability on travel time on both directions, in addition to variability in layover time, calculate the probability of roundtrip time of the new bus being less than 110 minutes. Assume for each bus the layover time is a random variable lognormally distributed with mean of the distribution as 10 and standard deviation of 5. E) What is the probability of demand being more than 30 passengers/bus? The data for travel time, demand and weather condition per bus trip for a bus route in the city of Calgary is given (see CSV file posted on D2L under Assignment section). Based on this dataset, answer the following questions: A) What is the mean and standard deviation of the travel time and demand for different weather conditions? B) Find the best fitted distributions to travel time and demand for different weather conditions Use uniform, normal, lognormal and exponential distributions. Compare the distribution of travel time and demand under different weather conditions. C) The City decides to build a new bus route with the same characteristics of the existing route but with a different length. The existing route has a length of 17 km, while the new route has a length of 12 km Hint: convert route demand and travel times to per unit distance, obtain coefficient of variation (CV), then obtain the new mean based on per unit distance and the variance based on calculated CV. Using the same coefficient of variations, generate travel time and demand for this new route for at least 1000 trips for a good weather condition D) The roundtrip time of the bus is an important variable for the agency in order to do proper schedule planning (frequency of service and fleet size determination). The roundtrip time is calculated based on the following equation: Roundtrip time = travel time one direction + travel time on the return direction + layover time at the terminal Considering variability on travel time on both directions, in addition to variability in layover time, calculate the probability of roundtrip time of the new bus being less than 110 minutes. Assume for each bus the layover time is a random variable lognormally distributed with mean of the distribution as 10 and standard deviation of 5. E) What is the probability of demand being more than 30 passengers/bus