BUSINESS CORE - DATA ANALYTICS MODULE 1 QUIZ – TO – MODULE 5

BUSINESS CORE - DATA ANALYTICS MODULE 1 QUIZ – TO – MODULE 5 QUIZ 1) The data set below shows annual healthcare expenditures for 192 countries. Cr eate a histogram of the data using the bins provided in column D. 2) Suppose you actually want to calculate the mean annual healthcare expenditures of the 192 countries. Which of the following Excel functions calculates the mean? SELECT ALL THAT APPLY. =MEAN(B2:B193) we removed these companies from the data set, what would happen to the standard deviation? The standard deviation would remain the same. 5) The following data set provides the percent of students from the top 100 ranked U.S. MBA programs that are employed upon graduation. Create a histogram to visualize the data. Use the bins provided in column C. 9) The data below show the number of hours 60 fifth-grade students reported reading last week and each student’s gender. Use the AVERAGEIF function to calculate the average number of hours spent reading last week for boys, and the average number of hours spent reading last week for girls. 10) The following data set provides the average driving distance for 185 members of the Professional Golf Association (PGA) Tour. Use the descriptive statistics tool to calculate the summary statistics for the average driving distance. Make sure to set the output range to cell D1 so your table is graded accurately. 11) Which of the following formulas would calculate the statistic that is MOST APPROPRIATE for comparing the variability of two data sets with different distributions? Mean/Standard Deviation 13) The data set below provides information about 125 randomly selected companies from the Standard and Poor’s (S&P) 1500. Calculate the average number of employees for technology companies. 14) The following data set provides the 2012 revenue (in billions of dollars) for the top 75 companies as declared by the Fortune 500 rankings. What amount do 60% of the companies earn equal to or less than? 15) The following data set provides the acceptance rate of the top 100 U.S. MBA programs and the percent of students that are employed upon graduation. Create a scatter plot to illustrate the relationship between the acceptance rate at MBA programs and the percent of students that are employed upon graduation. Place “Percent Employed” on the y-axis and “Acceptance Rate” on the x-axis. 17) What can be concluded from the fact that the correlation coefficient between the acceptance rate at the top 100 U.S. MBA programs and the percent of students in those programs who are employed upon graduation is -0.32? 20) Which of the following is an example of a hidden variable? 1) Categorize which of the following questions are biased and which are unbiased. 1) For a standard normal distribution (µ=0, σ=1), the area under the curve less than 1.25 is 0.894. What is the approximate percentage of the area under the curve less than -1.25? 3) Several probability expressions for a normal distribution are provided below. Drag the correct percentage to each probability expression. P(μ-2σ≤x≤μ) 6) If the mean weight of all students in a class is 165 pounds with a variance of 234.09 square pounds, what is the z-value associated with a student whose weight is 140 pounds? 1.63 7) If the mean of a normally distributed population is -10 with a standard deviation of 2, what is the likelihood of obtaining a value less than or equal to -7? 8) A store owner is interested in opening a second shop. She wants to estimate the true average daily revenue of her current shop to decide whether expanding her business is a good idea. The store owner takes a random sample of 60 days over a six-month period and finds that the mean revenue of those days is 3,472.00 dollars with variance 315,900.20 square dollars. Calculate a 95% confidence interval to estimate the true average daily revenue. 9) A curious student in a large economics course is interested in calculating the percentage of his classmates who scored lower than he did on the GMAT; he scored 490. He knows that GMAT scores are normally distributed and that the average score is approximately 540. He also knows that 95% of his classmates scored between 400 and 680. Based on this information, calculate the percentage of his classmates who scored lower than he did. 10) A researcher wants to select a random sample of consumers for a study. Generate a random ID number between 0 and 1,000 for each consumer in the spreadsheet. 12) A college student is interested in investigating the TV-watching habits of her classmates and surveys 20 people on the number of hours they watch per week. The results are provided below. Calculate the 80% confidence interval of the true average number of hours of TV watched per week.