Re: "Anti-Excel" reference needed: American Statistical Association

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: "Anti-Excel" reference needed: American Statistical Association

Eva Goldwater
There is another discussion, with examples, at
http://www.umass.edu/statdata/software/handouts/excel.html.


--
Eva Goldwater                   email: [hidden email]
Biostatistics Consulting        Phone: (413) 545-2949
418 Arnold House                Fax:   (413) 545-1645
715 North Pleasant Street
University of Massachusetts
Amherst, MA 01003-9304

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: "Anti-Excel" reference needed: American Statistical Association

Albert-Jan Roskam
Hi Eva,

Thank you! The amount of information and reasons not to do statistics in excel is overwhelming indeed. The only safe way to do it may be to use RExcel. That's an Excel add-on which passes data from Excel to R, where the statistical analyses are done. See: http://rcom.univie.ac.at/.

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--- On Thu, 4/29/10, Eva Goldwater <[hidden email]> wrote:

From: Eva Goldwater <[hidden email]>
Subject: Re: [SPSSX-L] "Anti-Excel" reference needed: American Statistical Association
To: [hidden email]
Date: Thursday, April 29, 2010, 4:43 PM

There is another discussion, with examples, at
http://www.umass.edu/statdata/software/handouts/excel.html.


--
Eva Goldwater                   email: goldwater@...
Biostatistics Consulting        Phone: (413) 545-2949
418 Arnold House                Fax:   (413) 545-1645
715 North Pleasant Street
University of Massachusetts
Amherst, MA 01003-9304

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Reply | Threaded
Open this post in threaded view
|

Automatic reply: "Anti-Excel" reference needed: American Statistical Association

Genevieve Odoom
Hello,
Thank you for your email. I will be out of the office on Friday, April 30th, returning on Wednesday, May 5th and will respond to your email upon my return.

Thanks!
Genevieve Odoom
Policy and Program Analyst
OANHSS
Suite 700 - 7050 Weston Rd. Woodbridge,
ON L4L 8G7
Tel: (905) 851-8821 x 241 Fax: (905) 851-0744
[hidden email]
www.oanhss.org

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: "Anti-Excel" reference needed: American Statistical Association

Art Kendall
In reply to this post by Albert-Jan Roskam
The only safe way to do it may be to use RExcel.
SPSS and the other packages also can input excel data.  If one is interested in cluster analysis, R procedures contain a warning that they have not been completely checked out.  


Art

On 4/29/2010 3:42 PM, Albert-Jan Roskam wrote:
Hi Eva,

Thank you! The amount of information and reasons not to do statistics in excel is overwhelming indeed. The only safe way to do it may be to use RExcel. That's an Excel add-on which passes data from Excel to R, where the statistical analyses are done. See: http://rcom.univie.ac.at/.

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--- On Thu, 4/29/10, Eva Goldwater [hidden email] wrote:

From: Eva Goldwater [hidden email]
Subject: Re: [SPSSX-L] "Anti-Excel" reference needed: American Statistical Association
To: [hidden email]
Date: Thursday, April 29, 2010, 4:43 PM

There is another discussion, with examples, at
http://www.umass.edu/statdata/software/handouts/excel.html.


--
Eva Goldwater                   email: goldwater@...
Biostatistics Consulting        Phone: (413) 545-2949
418 Arnold House                Fax:   (413) 545-1645
715 North Pleasant Street
University of Massachusetts
Amherst, MA 01003-9304

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

64 bit Windows 7 and SPSS ODBC

Roberts, Michael-2

Good Morning list,

 

I am trying to find out if anyone on the list has any experience with Windows 7 (64 bit) and accessing either Oracle (11.0) or SQL databases directly with SPSS v.17.  I have just migrated to a Windows 7, 64 bit platform, and am having difficulty getting the native SPSS Oracle driver to recognize the database.  I tried the SPSS 64 bit ODBC Oracle drivers without any success as well.  Does anyone have any idea whether it is even possible to go this route with ver. 17?

 

TIA

Sincerely

 

Michael

Reply | Threaded
Open this post in threaded view
|

Re: 64 bit Windows 7 and SPSS ODBC

Bob Walker-2

Hi Michael,

 

A documented problem, and to my knowledge, no simple workaround exists. Microsoft has made available a redistributable 64-bit driver for Office 2010 at…

 

http://www.microsoft..com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

 

…but instructs you to uninstall previous versions of Office before doing so (!), installing the new driver, and then reinstalling Office. A bit daunting… I haven’t done it. I continue to use an “old” machine running Win XP Pro so I won’t upset my existing programs.

 

I had posted on this back in March (ODBC Error In Win7 64 Bit) but to my knowledge there has been no progress. Maybe someone else has had some success?

 

Best regards.

 

Bob Walker
Surveys & Forecasts, LLC
www.safllc.com

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Roberts, Michael
Sent: Tuesday, May 18, 2010 9:12 AM
To: [hidden email]
Subject: 64 bit Windows 7 and SPSS ODBC

 

Good Morning list,

 

I am trying to find out if anyone on the list has any experience with Windows 7 (64 bit) and accessing either Oracle (11.0) or SQL databases directly with SPSS v.17.  I have just migrated to a Windows 7, 64 bit platform, and am having difficulty getting the native SPSS Oracle driver to recognize the database.  I tried the SPSS 64 bit ODBC Oracle drivers without any success as well.  Does anyone have any idea whether it is even possible to go this route with ver. 17?

 

TIA

Sincerely

 

Michael






=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.18, Virus/Spyware Database: 6.15020)
http://www.pctools.com
=======






=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.18, Virus/Spyware Database: 6.15020)
http://www.pctools.com
=======
Reply | Threaded
Open this post in threaded view
|

Re: 64 bit Windows 7 and SPSS ODBC

Roberts, Michael-2

Bob,

 

Thank you very, very much for your response.  Knowing this, I can find some other solution –possibly running a virtual machine with the 32-bid OS to run my queries from SPSS. 

 

Again, thank you for taking the time to respond!

 

Michael

 

From: Bob Walker [mailto:[hidden email]]
Sent: Tuesday, May 18, 2010 11:56 AM
To: Roberts, Michael; [hidden email]
Subject: RE: 64 bit Windows 7 and SPSS ODBC

 

Hi Michael,

 

A documented problem, and to my knowledge, no simple workaround exists. Microsoft has made available a redistributable 64-bit driver for Office 2010 at…

 

http://www.microsoft..com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

 

…but instructs you to uninstall previous versions of Office before doing so (!), installing the new driver, and then reinstalling Office. A bit daunting… I haven’t done it. I continue to use an “old” machine running Win XP Pro so I won’t upset my existing programs.

 

I had posted on this back in March (ODBC Error In Win7 64 Bit) but to my knowledge there has been no progress. Maybe someone else has had some success?

 

Best regards.

 

Bob Walker
Surveys & Forecasts, LLC
www.safllc.com

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Roberts, Michael
Sent: Tuesday, May 18, 2010 9:12 AM
To: [hidden email]
Subject: 64 bit Windows 7 and SPSS ODBC

 

Good Morning list,

 

I am trying to find out if anyone on the list has any experience with Windows 7 (64 bit) and accessing either Oracle (11.0) or SQL databases directly with SPSS v.17.  I have just migrated to a Windows 7, 64 bit platform, and am having difficulty getting the native SPSS Oracle driver to recognize the database.  I tried the SPSS 64 bit ODBC Oracle drivers without any success as well.  Does anyone have any idea whether it is even possible to go this route with ver. 17?

 

TIA

Sincerely

 

Michael






=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.18, Virus/Spyware Database: 6.15020)
http://www.pctools.com
=======






=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.18, Virus/Spyware Database: 6.15020)
http://www.pctools.com
=======