Question: Your manager has given you an Excel file that contains the names of the companys 500 employees and has asked you to sample 50 employees

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—Paste Special—Values feature. You then sort by the 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?

Step by Step Solution

3.44 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

This is a statistical sample Every employee ha... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

645-M-S-D-A (5193).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!