# Excel’s __________ function can be used to compute the sample correlation coefficient

Question 33 Excel’s NORMSINV function can be used to compute Answer cumulative probabilities for a standard normal z value the standard normal z value given a cumulative probability cumulative probabilities for a normally distributed x value the normally distributed x value given a cumulative probability Question 34 A control chart that is used to monitor the range of the measurements in a sample is Answer a p chart an x-bar chart an R chart an np chart Question 35 A population consists of 500 elements. We want to draw a simple random sample of 50 elements from this population. On the first selection, the probability of an element being selected is Answer 0.100 0.010 0.001 0.002 Question 36 The expression used to compute an interval estimate of m may depend on any of the following factors except Answer the sample size whether the population standard deviation is known whether the population has an approximately normal distribution whether there is sampling error Question 37 Exhibit 10-10 A local department store is studying the shopping habits of its customers. They think that the longer customers spend in the store the more they buy. Their study resulted in the following information regarding the amount of time women and men spent in a store. Women Men Mean 6 minutes 12 seconds 5 minutes 46 seconds Population Standard deviation 4 seconds 5 seconds Sample size 32 50 Refer to Exhibit 10-10. At 95% confidence, what is the conclusion for this study? Answer There is a significant difference in the time spent in the store between men and women. There is no significant difference in the time spent in the store between men and women. It is impossible to make a decision on the basis of the information given. The sample sizes must be equal in order to answer this question. Question 38 Independent simple random samples are taken to test the difference between the means of two populations whose variances are not known. The sample sizes are n1 = 32 and n2 = 40. The correct distribution to use is the Answer binomial distribution t distribution with 72 degrees of freedom t distribution with 71 degrees of freedom t distribution with 70 degrees of freedom Question 39 Excel’s __________ function can be used to compute the sample correlation coefficient. Answer MAX COVAR VAR CORREL Question 40 Which of the following is an example of quantitative data? Answer the player’s number on a baseball uniform the serial number on a one-dollar bill the part number of an inventory item the number of people in a waiting line