Access and Statistics

[Guest]

I am an Access Novice...

I have a database of 100,000.00 records. Can Access select a sample from
this dataset that will enable me to perform lognormal statistical analysis ?

What sql can I use to selest the sample data ?

Thank you in advance.

 

[Douglas J. Steele]

I'm not sure that Access has any built-in functionality that will help with
lognormal statistical analysis. You might want to take a look at Total
Access Statistics, from FMS Inc.
http://www.fmsinc.com/products/statistics/index.html

For how to construct a query that returns a random set of records, take a
look at http://www.mvps.org/access/queries/qry0011.htm at "The Access Web"

 

[susiedba]

if you were to use Access Data Projects; keep your data in SQL Server--
then you could use 'Analysis Services'

SSAS has some GREAT statistical functions

MDB is for lamers

-Susie

 

[punjab_tom]

Susie;

Analysis Services is hard for beginners-- but the best route to go.

Do you have any resources for Doug?

-Tom

 

[David F Cox]

ah, my favorite, a .00 records statistician. I love precision. -<)

you can obtain a random selection of records using WHERE RND([yourfield])

.whatever

you have to use a dummy positive field to ensure that the RND function gets
called for each record, or sort the table on RND([yourfield]) and select TOP
N.