# Question

Another type of random sample is called a bootstrap sample. Given a data set with n observations, a bootstrap sample, also of size n, is when you randomly sample from the data set with replacement. To do so, you keep choosing a random integer from 1 to n and include that item in the sample.

The “with replacement” part means that you can sample the same item more than once. For example, if n = 4, the sampled items might be 1, 2, 2, and 4. Using the data in the file Accounts Receivable.xlsx, illustrate a simple method for choosing bootstrap samples with the RANDBETWEEN and VLOOKUP functions. For each bootstrap sample, find the mean and standard deviation of Days and Amount, and find the counts in the different size categories. How do these compare to the similar measures for the original data set?

The “with replacement” part means that you can sample the same item more than once. For example, if n = 4, the sampled items might be 1, 2, 2, and 4. Using the data in the file Accounts Receivable.xlsx, illustrate a simple method for choosing bootstrap samples with the RANDBETWEEN and VLOOKUP functions. For each bootstrap sample, find the mean and standard deviation of Days and Amount, and find the counts in the different size categories. How do these compare to the similar measures for the original data set?

## Answer to relevant Questions

A manufacturing company’s quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The data are in the file ...Create a simulation similar to the one in the Wheel of Fortune Similation.xlsx file. However, suppose that the outcome of each spin is no longer uniformly distributed between $0 and $1000. Instead, it is the number of 7s you ...A manufacturing company’s quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The data are in the file ...Suppose you are gambling on a roulette wheel. Each time the wheel is spun, the result is one of the outcomes 0, 1, and so on through 36. Of these outcomes, 16 are red, 16 are black, and 1 is green. On each spin you bet $5 ...The director of a university’s career development center is interested in comparing the starting annual salaries of male and female students who recently graduated from the university and commenced fulltime employment. The ...Post your question

0