Consider the frame of 40 families (with income) as the population being studied. We want to choose
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider the frame of 40 families (with income) as the population being studied. We want to choose a simple random sample of size 10 from this frame using Excel?s random number function, RAND().
- Start Excel and open the file Sampling With Excel. Select the RandSample worksheet.
- Select cell B5 and enter the formula =AVERAGE(B10:B49)
- Select cell C5 and enter the formula =STDEVP(B10:B49)
- Select cell C10 and enter the formula =RAND()
- Copy the formula in cell C10 down to cells C11 to C49. WARNING: Excel?s RAND() function is sensitive in the sense that whenever you do something else on the worksheet such as copy a formula or enter a formula, Excel generates new set of random numbers. So if this happens, don?t panic!
- You should be able to see generated random numbers. Now, to enable sorting we must ?freeze? the random numbers (see warning in(vi)). In other words, we must replace the formulas with their values. To do this, select and copy the range C10:C49, and then select C10, right click and select Paste Special. Then, check the Values option and click OK.
- Now, copy the range A10:C49 to the range E10:G49.
- To select a random sample of 10 families, you may do the following: Select G10 and click the Sort button. Then the 10 smallest random numbers are the ones in the sample.
- Type in the formulas =AVERAGE(F10:F19) to cell B6 and=STDEV(F10:F19) to C6. Observe and compare the population statistics with the sample statistics.
- To obtain more random samples of size 10 (for comparison), we need to go through the above process repeatedly.
- Be sure to save the file, as you?ll be submitting it at the end of the lab as well.
- To complete this portion of the lab, you will need the worksheet RandSample in the file Sampling with Excel
Related Book For
Marketing Research
ISBN: 978-1118156636
11th edition
Authors: David A. Aaker, V. Kumar, Robert Leone, George S. Day
Posted Date: