Hi Vikas, One way to do this would be using a function =RANDBETWEEN( min_value, max_value). For example if you insert a column in which you put this function =RANDBETWEEN(1, 100) it will generate random numbers between 1 and 100 then you can apply a filter on that column and select values below 80. It will give you about 70-75% of your data and you can use it then. This will essentially be a trial and error method and you won't get exact 70:30 ratio but if you could provide a sample file someone in the group can come up with a better solution.
Hope that helps, Anand Kumar On Dec 24, 4:16 pm, Vikash Chandra <vks.chan...@gmail.com> wrote: > Hi Team, I am facing problem in breaking my data set into two random > sample,which i need for model validation.means i wanted to break my > entire row in two sample of say 70-30 ratio,in which the observations > should be taken randomly from the original observations.Is there any > function or macro we can write for this? Please help me out. > > Thanks & Regards, > Vikash Chandra > Bangalore > 9902622922 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
