Search

# All articles with 'rand()' Tag

## How to select a random sample from all your data [trick]

Published on Jan 31, 2014 in Excel Howtos

The other day, I got a text message (SMS) from one of our readers. It read,

So today, let us learn a very easy trick to select random sample from your data.

Continue »

## Learn Statistics & Probability using MS Excel

Published on Feb 13, 2012 in excel apps, Excel Howtos, Learn Excel, simulation, VBA Macros

One of the most dreaded courses during my under-graduation is Probability, Statistics & Queuing Theory. We called it PSQT. I struggled to understand the significance and concept of this course as I could barely concentrate in the class. We had a professor, who is probably a genius, but the moment he started the class, I would magically fall in to one of my after-noon naps. When I woke up, we are either in the middle of an elaborate t-test or going thru intricacies of a Markovian queue.

This was all 11 years ago. Later in life, I have embraced the world of probability & statistics. I still fear queues. May be I will get there one day. 😉

A good understanding of statistics & probability theory is necessary if you want to model complex real-life problems using Excel or similar tools. Naturally, Excel has several functions, features & supported add-ins to help you in this area.

Today, I want to share some of this with you. This article is broken down in to 3 parts.

1. Learning Statistics & Probability using Excel
2. Downloadable Excel Workbooks to understand
3. Full blown models & simulations in Excel
Continue »

## Dummy Data – How to use the Random Functions

Published on May 4, 2011 in excel apps, Excel Howtos, Huis, Learn Excel, Posts by Hui

Don’t know which way to go ?
Can’t make up your mind between alternatives?

Using collected or known data is the best when developing Excel models, but from time to time this may not be available when you are developing your model. This post will look at some options for setting up Dummy Data using Excels Random number functions.

Continue »

## Office 2010 Contest Winners are here!!!

Published on Jun 25, 2010 in blogging, Excel Howtos

Okay folks, sorry I took quite awhile to post this. But I was busy with excel school and getting my kids buzz cut. So here you go. Contest winners – India Paresh shah (website) Abhishek Jain Rahul Mulchandani (website) Contest winner – International Tom (this Tom) Congratulations Winners. You will very soon hear from me […]

Continue »

## How to pick a random date? [Formulas]

Published on Dec 8, 2009 in Excel Howtos

Often when you need to generate a sample from large data set, you may want to pick data from a random date. In such cases, you can use excel’s RAND() and RANDBETWEEN() formulas to pick a random date. Here I have included few examples,

Continue »

## Generating Random Phone Numbers

Published on Nov 20, 2008 in Analytics, Learn Excel

Often when you are writing code or testing an application, it might be helpful to have random phone numbers generated for you. Here is an excel formula that I use: =value(left(substitute(rand(),”0.”,””),10)) try these 2 instead (thanks to John) =RAND()*(9999999999-1000000000)+1000000000 =RANDBETWEEN(1000000000,9999999999) [needs analysis toolpack add-in or excel 2007] Even though it works most of the time […]

Continue »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.

#### Downloads

© All rights reserved.