Generate Random Data in an Excel Spreadsheet
Вставка
- Опубліковано 16 лип 2024
- Learn how to generate random data in an Excel spreadsheet using =RAND(), a probability table and =VLOOKUP.
Download the practice file here:
tinyurl.com/yxzzwf32
Get on the Tiger mailing list for advance notice of live streams:
tinyurl.com/y6jtnlk2
Thanks a lot for a great and a productive video!!! cheers!
You're welcome - please check out the other videos on the channel
great!!, thank you very much for this beneficial video, good luck
Thank you Hameed - good luck to you too, please check out the other videos on the channel.
This really helps, the only thing was challenging to me- where we are copying/ applying the formula to all drop down cells. while double clicking on bottom-right corner (+sign) formula was changing the range and was increasing 1 cell for every time.
where as i don't want to change the range in formula. In this case you mentioned about using table name- but i was not sure how to create a table for given values in cells and specify that table name in vlookup formula.
Thank you for all the videos , those are really helpful and very easy to understand after following your steps.
Deepa - thank you for the comment. I am not absolutely sure what you mean, but here are some ideas:
If autofill down (ie. double clicking the bottom right square to copy down) is problematic, try a simple copy / paste. You could use pastespecial / formulas.
Otherwise, you may need absolute references in the formulae to ensure they point to the right cells. Good luck!
Hi I know the answer might be too late but you can select all the columns (by shift clicking A,B,C etc) then click on format as a table. And then under design you can give the table a name and the problem will be solved. As to why it increases 1 everytime even I dont have an answer.
That was very helpful, thanks
Thank you and welcome to the channel!
How did you turn the coordinates into the vtable reference?
Hi there. Can I generate a set of data which will exhibit certain characteristics ? For example, I need a data set where the number of observations is 226, mean is 344 and std.dev. is 106.
Hi there, I would recommend having a look at the random number generation facility in Excel. I think you have to have the Analysis Toolpack installed to be able to access it, Google will tell you how. Good luck!
What if I want example some nationalities column, employee column staff1, staff 2, etc, depts/agency column, management/positions column, Gender column. Race column(example Japanese, Korea, Filipino, etc would be Asian group that will the Race Column. So the goal is to see which nationality or group is being hired within each Agency, and which gender is hired. So I need data pretending I am collecting an Annual Statistical employment. So can I get data to practice to do the project like getting data, cleaning and reformatting data, summary, pivot ables, power pivot, charts, etc. I just need the data.
It's all possible with this technique - this is the exact way I generate the kind of dataset you're talking about. It will take some practice, but is perfectly possible - good luck!
Sir,how that range value is automatically entered whenever you entered a value like 0.2,0.4 and so on.
Looking for a quick reply
I am not absolutely sure what you mean Neeraj - can you explain?
I think my answer will be too late, but here it goes: =Cell&" - "&Cell, in the video it was, for the first row of range: =B4&" - "&B5
way too fast to follow, we are not experts
half speed?
it's an age difference I'm watching this at 2x speed playback and I'm 17