Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Get a Random Sample in Excel

11/15/2011 07:22 by MikeChin

First answer posted by SharonJohn at 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
3 Answers
  • SharonJohn
    1. Start Microsoft Excel 2007 and open a workbook from your files that contains data you want to use to get a random sample.

    2. Verify that column A is empty, so you can use it to generate random numbers into. If you have data in column A, then you will need to add a number column so column A becomes empty and can be used to store the random numbers.

    3. Click and drag to select the cells in column A that correspond with the records in the other cells. You want to select an empty cell for each row of information you have in the spreadsheet.

    4. Type "=RAND()" (no quotes) in the "Formula" textbox. Press the "Enter" key on your keyboard to generate the random numbers into column A.

    5. Select all of the data in your spreadsheet along with the corresponding random numbers. Do not select any titles or headings.

    6. Use the "Data" tab at the top of the screen and click the "Sort" button from the "Sort and Filter" group in the "Data" ribbon. The "Sort" dialog box will open onto the screen.

    7. Choose "Column A" from the "Sort by Column" drop-down list and "Smallest to Largest" from the "Sort by Order" drop-down list. Click the "OK" button to close the dialog box and return to your spreadsheet. Choose the top number of rows to make up your random sample.

  • Was this answer helpful? 00 · 11/15/2011 07:22
  • Anonymous user
  • look it up on Google
  • Was this answer helpful? 00 · 04/16/2013 22:34
  • Anonymous user
  • dfsfdsfds dfsdf

    sfdsfdsf

    sdfsdfsdfs

  • Was this answer helpful? 00 · 09/28/2013 20:29
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:What is the Differences Between Microsoft Excel 2007 & Earlier Versions

A:Microsoft Excel 2007 is a spreadsheet program that is part of the Office suite of productivity software. Excel has been around for years, but ...(more)

Q:How to Merge Cell Contents in Excel 2007

A: Open the Excel worksheet. Click the "Home" tab on the command Ribbon. Click and drag on the two or more cells to merge. A heavy black ou...(more)

Q:How to Plot Data Points in Excel 2007

A: Type your data points into two columns. One column will be the x-values and the other column will be the corresponding y-values. Click on ...(more)

Q:How to Check the Search Volume of a Keyword

A: Open your Web browser and go to either Google's Insights for Search, Trellian's Search Term Suggestion Tool or Wordtracker (see Resources). ...(more)

Q:How to Connect Microsoft Outlook & Excel 2007

A:Connect Excel 2007 to Outlook 2007 Make sure you have installed Microsoft Outlook 2007 and Microsoft Excel 2007 on your computer. Click on...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Excel Viewer 2003

open, view, and print Excel workbooks, even if you have example excel formula.
Latest version:1.0
License:Freeware
OS:Windows 2003,Windows XP,Windows 2000
Total downloads:445,228
Rank:1 in Spreadsheets
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!

×

Are you sure to delete your answer?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×