Your manager has given you an Excel file that contains the names of the company\

Question

Your manager has given you an Excel file that contains the names of the company's 500 employees and has asked you to sample 50 employees from the list. You decide to take your sample as follows. First, you assign a random number to each employee using Excel's random number function Rand (). Because the random number is volatile (it recalculates itself whenever you modify the file), you freeze the random numbers using the Copy-Past Special-Values feature. You then sort by random numbers in ascending order. Finally, you take the first 50 sorted employees as your sample. Does this approach constitute a statistical or a nonstatistical sample?

Explanation / Answer

The approach presented above constitutes a statistical sampling method. This method allows every item in the frame to have an equal amount of chance of being selected. As the random numbers are volatile in excel, so each row has a chance of getting to the top 50.

Hence, there is no biasness in sampling.and so its a statistical sampling.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.