statistics in Access

[JMG]

Is there a way that ACCESS can do a Principal component analysis (PCA) or
Factor Analysis? I have a huge table of data and I would like to create a
script that does that analysis. This would mean I would not have to export
the data into SPSS for the calculation and then re-import the results to
produce a report.

Please advise and thanks in advance for any suggestions.

Rgs
M Gordon

 

[Douglas J. Steele]

While I'm not sure exactly what you're looking for, see whether Total Access
Statistics, from FMS, is of any use to you:
http://www.fmsinc.com/products/statistics/index.html

 

[PC Datasheet]

Take a look at:
http://www.resample.com/xlminer/

XLMiner is an Excel add-in that does PCA. Check if XLMiner has an object
model. If it does you could write automation code from Access to do your
analysis with XLMiner and import the results into Access to create your
report.

 

[PC Datasheet]

If you need outside help, contact me at my email address below. My fees are
very reasonable.

 

[StCyrM]

Good evening

The following site will shed some insight into Principal Component Analysis

http://www.fon.hum.uva.nl/praat/manual/Principal_component_analysis.html

Best regards

Maurice St-Cyr
Micro Systems Consultants, Inc.