# Question

This problem illustrates an interesting variation of simple random sampling.

a. Open a blank spreadsheet and use the RAND() function to create a column of 1000 random numbers. Don’t freeze them. This is actually a simple random sample from the uniform distribution between 0 and 1. Use the COUNTIF function to count the number of values between 0 and 0.1, between 0.1 and 0.2, and so on. Each such interval should contain about 1/10 of all values. Do they?

b. Repeat part a, generating a second column of random numbers, but now generate the first 100 as uniform between 0 and 0.1, the next 100 as uniform between 0.1 and 0.2, and so on, up to

0.9 to 1. Again, use COUNTIF to find the number of the 1000 values in each of the intervals, although there shouldn’t be any surprises this time. Why might this type of random sampling be preferable to the random sampling in part a?

a. Open a blank spreadsheet and use the RAND() function to create a column of 1000 random numbers. Don’t freeze them. This is actually a simple random sample from the uniform distribution between 0 and 1. Use the COUNTIF function to count the number of values between 0 and 0.1, between 0.1 and 0.2, and so on. Each such interval should contain about 1/10 of all values. Do they?

b. Repeat part a, generating a second column of random numbers, but now generate the first 100 as uniform between 0 and 0.1, the next 100 as uniform between 0.1 and 0.2, and so on, up to

0.9 to 1. Again, use COUNTIF to find the number of the 1000 values in each of the intervals, although there shouldn’t be any surprises this time. Why might this type of random sampling be preferable to the random sampling in part a?

## Answer to relevant Questions

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 ...The file P02_10.xlsx contains midterm and final exam scores for 96 students in a corporate finance course. For this problem, assume that these 96 students represent a sample of the 175 students taking the course, and that ...Calculate the following quantities using Excel. a. Find the value of x such that P(t10 > x) = 0.75, where t10 has a t distribution with 10 degrees of freedom. b. Find the value of y such that P(t100 > y) = 0.75, where t100 ...Auditors of a particular bank are interested in comparing the reported value of all 2265 customer savings account balances with their own findings regarding the actual value of such assets. Rather than reviewing the records ...The file P08_06.xlsx contains data on repetitive task times for each of two workers. John has been doing this task for months, whereas Fred has just started. Each time listed is the time (in seconds) to perform a routine ...Post your question

0