You are a business analyst working for a logistics company i…

You are a business analyst working for a logistics company in Mumbai. The company is planning a report on the on-time delivery rate of their packages. To provide accurate information to your clients, your supervisor has asked you to estimate the proportion of packages that are delivered on time. You have collected a sample data set from various deliveries in Mumbai. Using this data, estimate the proportion of packages that are delivered on time. Use a 90% confidence level for your estimate and round your answers to four decimal places.   Here is the sample data you collected (“on time” indicates on-time delivery, “late” indicates late delivery):   on time, on time, on time, late, on time, late, late, on time, late, late, on time, on time, late, late, on time, on time, on time, on time, late, late, late, late, on time, on time, late, on time, on time, late, late, late   HELPFUL NOTE: Copy and paste the data into an Excel workbook. If it jams it all into a single cell, use the “text to columns” function in the Data ribbon to tell it to split it into individual cells using a comma delimiter. Left bound = [leftbound] Right bound = [rightbound]

The height of adult males in a certain population follows a…

The height of adult males in a certain population follows a normal distribution with a mean of 175 cm and a standard deviation of 7 cm. What is the probability that an adult male’s height will be between 167 cm and 189 cm? Select the correct Excel function statements to calculate this probability.