Question: EXCEL must be used for question #4. Hand calculation using formulas are not accepted for this question. Do not forget to include the Boxplot for
EXCEL must be used for question #4. Hand calculation using formulas are not accepted for this question. Do not forget to include the Boxplot for question 4-9. Results from computations should be rounded off to two decimal places where appropriate. 4. An entrepreneur faces many bureaucratic and legal hurdles when starting a new business The World Bank collects information about starting businesses throughout the world. It has determined the time, in days to complete all the procedures required to start a business. Data for 187 countries are included in the data set. TTS. For this section, we examine data. rounded to integers, for a sample of 23 of these countries. a) Find the mean time to start a business for 23 countries in our data set: (lp) b) Find the median time to start a business for 23 countries in our data set: (10) c) Which measure do you prefer for describing the center of this distribution? Explain your answer. (2p) d) Compute the quartiles (Q1, Q2, Q3), and find the IQR for these data. Are there outliers in the time to start a business data set? If so, identify and name any outliers, Gp) Compute the standard deviation of time to start a business for 23 countries in the data set: (1p) 1) Which measure do you prefer for describing the spread of this distribution? Explain your answer. (1p) g) Make a boxplot for these data show the five-number summary in the boxplot, and explain & describe the distribution using only the information in the boxplot. (p) EXCEL must be used for question #4. Hand calculation using formulas are not accepted for this question. Do not forget to include the Boxplot for question 4-9. Results from computations should be rounded off to two decimal places where appropriate. 4. An entrepreneur faces many bureaucratic and legal hurdles when starting a new business The World Bank collects information about starting businesses throughout the world. It has determined the time, in days to complete all the procedures required to start a business. Data for 187 countries are included in the data set. TTS. For this section, we examine data. rounded to integers, for a sample of 23 of these countries. a) Find the mean time to start a business for 23 countries in our data set: (lp) b) Find the median time to start a business for 23 countries in our data set: (10) c) Which measure do you prefer for describing the center of this distribution? Explain your answer. (2p) d) Compute the quartiles (Q1, Q2, Q3), and find the IQR for these data. Are there outliers in the time to start a business data set? If so, identify and name any outliers, Gp) Compute the standard deviation of time to start a business for 23 countries in the data set: (1p) 1) Which measure do you prefer for describing the spread of this distribution? Explain your answer. (1p) g) Make a boxplot for these data show the five-number summary in the boxplot, and explain & describe the distribution using only the information in the boxplot. (p)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
