Hello All,
I am working on an AP STATS project, I need to have randomized values in the A1 column in order to sort the data and select 200 data points, making it truly randomized. I was using this tutorial: http://www.wikihow.com/Create-a-Random-Sample-in-Excel. Unfortunately it won't let me copy + paste the function =RAND() to the selected rows. I have attached some images.
Thank you
despacito.PNG
swavaswavacito.PNG
Not knowing what you're doing makes it hard to speculate.
Put the formula in one cell and copy down?
Entia non sunt multiplicanda sine necessitate
The error message is telling you that the area you are trying to paste to is not contiguous. What range are you selecting for the paste? Your image doesn't show all of it. Click on A2 (which appears to have your formula), hold the SHIFT key and then press the Down Arrow to highlight the cells you want to put the formula in. Then click CTRL+d to fill down.
Basically I have 41833 rows of data that I need random numbers for, of which I will sort from lowest to greatest and pick 200 entries from the top. The problem I face is that I can't copy and paste the function =RAND() for each of those rows. I get those two errors.
EDIT: @6StringJazzer the CTRL+d method worked for me, thank you so very much for your help! FYI my stats project is finding the significance of the difference in the wage gap between asian and white women in corporate America. Thx for pitching in!
Last edited by khairlines; 05-21-2017 at 09:28 PM.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
I have done this for you this time because you are new.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks