Excel Excel 2003 Data Analysis Tool

C

cakzhh

Joined
Mar 3, 2009
Messages
2
Reaction score
0
Hi,
I am new to this forum and new to the Data Analysis Tool in Excel 2003.
I have a file consisting of 11,294 rows of data in 6 columns. 5 of the columns contain text and one column contains SSN that I have converted to the
Number format. I am trying to get 114 periodic samples out of this population.

When I use the Data Analysis Tool, I put in the input range
$a$1:$f$11294, I select periodic and put in 100 for the interval of
sampling and I want to put it into my Audit Sample worksheet.
Everytime, I do this I get the message: "Sampling - input range
contains non-numeric data".

I tried to do the Copy of one and Paste special but I still get the
same message.
Is this not the correct tool to easily pull out every 100
sample from my file or am I using it incorrectly? Please any help would greatly be appreciated!
 
I believe your using it incorrectly. I've tested it and it worked for me. If you would like send me the file via e-mail and I will look at it for you unless you already figured it out.

Cheers.

Point
(e-mail address removed)
 
Back
Top