"sampling - input range must be a contiguous reference"

A

Andreas

Using the Data Analysis add-in, I'm trying to take a
random sample of a batch of records. Unfortunately, using
the Sampling tool, I keep getting the error message
above. There is no documentation of what this means in
the online help. Any idea what I can do to make this
thing work? I really don't want to have to use the
RANDBETWEEN function for a sample of this size.

Thanks!
Andreas
 
A

Anon

Andreas said:
Using the Data Analysis add-in, I'm trying to take a
random sample of a batch of records. Unfortunately, using
the Sampling tool, I keep getting the error message
above. There is no documentation of what this means in
the online help. Any idea what I can do to make this
thing work? I really don't want to have to use the
RANDBETWEEN function for a sample of this size.

Thanks!
Andreas
Click to expand...

A1,A2,A3 or A1:B10 are contiguous ranges, whereas A1,A3,A5 or A1:A3,B4 are
not. In simple language, the cells in the range must be next to each other,
in a simple block.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Correlation tool says Input range must be contiguous reference. 1
Formula numbers and text Trying to pull a random sampling 1
Sampling 5
Tools-Data Analysis-Error 0
Need help modifying code 0
Sampling 1
Error Message - Input Range must be a contiguous Reference Help!!! 0
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1

Top