Statistical analysis of Access Data? SPSS? SAS? Add-In?

[ryguy7272]

I will be using MS Access to capture and manage data for patients at a local
hospital. We need to perform various statistical analyses on the data; we
are thinking of incorporating SPSS into the process. As an alternative, I
guess we could use SAS. Finally, I would consider an Access Add-In, just as
long as it is capable of doing somewhat advanced statistical analyses. Any
ideas on this? I will develop and manage the MS Access DB. I'm fairly
proficient with Access; somewhat less proficient with statistical analyses,
but I do know a little about this stuff (post-MBA).

Thanks,
Ryan---

 

[John W. Vinson]

I will be using MS Access to capture and manage data for patients at a local
hospital. We need to perform various statistical analyses on the data; we
are thinking of incorporating SPSS into the process. As an alternative, I
guess we could use SAS. Finally, I would consider an Access Add-In, just as
long as it is capable of doing somewhat advanced statistical analyses. Any
ideas on this? I will develop and manage the MS Access DB. I'm fairly
proficient with Access; somewhat less proficient with statistical analyses,
but I do know a little about this stuff (post-MBA).

Thanks,
Ryan---

I haven't used the package myself, but FMS Inc. has a Total Access Statistics
package. I've been very impressed with their other offerings; check it out at
their website
http://www.fmsinc.com/Products/index.html

 

[Piet Linden]

I will be using MS Access to capture and manage data for patients at a local
hospital.  We need to perform various statistical analyses on the data;we
are thinking of incorporating SPSS into the process.  As an alternative, I
guess we could use SAS.  Finally, I would consider an Access Add-In, just as
long as it is capable of doing somewhat advanced statistical analyses.  Any
ideas on this?  I will develop and manage the MS Access DB.  I'm fairly
proficient with Access; somewhat less proficient with statistical analyses,
but I do know a little about this stuff (post-MBA).

Thanks,
Ryan---

If I remember right, SPSS can read Access queries, so you could
"flatten" your relationships in queries, and then use SPSS to do
whatever statistics you needed.

 

[aaron.kempf]

SQL Server Analysis Services = 'Pivot Tables on Steroids'

You can look at www.olapreport.com/market.htm and you can see that SQL
Server Analysis Services has completely taken over the world-- it
rocks!

Furthermore, it supports a lot of Excel functions that are not to be
found in most statistical / analysis tools.

-Aaron

 

[aaron.kempf]

uh, I guess I'm not familiar with this functionality Piet-- do you
mind helping me to understand a little more?

I basically swore off Access / Sharepoint integration because of
performance problems a couple of years back, it took like an hour to
import 10,000 records into an empty list, and they were only ~~8
columns wide!

-Aaron