Statistik-Tutorial Forum Foren-Übersicht

Statistik-Tutorial Forum

SPSS- und Statistik-Forum
 
 FAQFAQ   SuchenSuchen    RegistrierenRegistrieren
 ProfilProfil   Einloggen, um private Nachrichten zu lesenEinloggen, um private Nachrichten zu lesen   LoginLogin 
FAQSPSS & Statistik Buchtipps FAQAuf dieser Seite werben!

-Anzeige-

How to input data/copy multiple excel sheets into SPSS

 
Neues Thema eröffnen   Neue Antwort erstellen    Statistik-Tutorial Forum Foren-Übersicht -> SPSS-Forum

How to input data/copy multiple excel sheets into SPSS

Autor Nachricht
rubicond1
Gast





BeitragVerfasst am: 11.08.2007, 02:44    Titel: How to input data/copy multiple excel sheets into SPSS

Greetings, and sorry for writing in English (you can reply in German). I have a similar problem than peter.neu:

I have a list of about 200 crops on a column, and for each crop I have 6 information (income, amount of land, season, etc.) in the following columns. I have this information for about 100 households in 6 villages.

I am now starting to put these info in the computer, and it is an enourmous task. I thought that one way to do it is to input the data into Excel, and have one file per village, and in each file one sheet for each household (I could name each sheet after the household head). I then want to analyse the data at the household level for each village, and also analyse the data at the village level (after calculating village averages).

My question is: Can I transfer easily the files to SPSS, and use SPSS to compare the different households?

I read the help menu in the SPSS software, and it seems to me that SPSS automatically selects only the first sheet from an excel file with many sheets? Is that really so?

Alternatively, shall I enter the data in SPSS or in Access? I haven't started entering the data, so I can still select the software I want.

If anybody can help, I would be very grateful. This is actually very urgent, because I am going to pay somebody to do it, but I have to tell her how to do it over the week-end. Thank you very much!!
Nach oben
administrator
Site Admin


Anmeldedatum: 17.01.2006
Beiträge: 48

BeitragVerfasst am: 11.08.2007, 04:40    Titel:

Hi,

The import of data into SPSS should work (there is an "iimport wizard" in the newer versions). If there are some problems, ypu can try exporting your data from excel into .csv files and import them that way into SPSS. The data should make no problems but sometimes it can be necessary to edit the names of the variables by hand after that.

As far as I understood your question you should be able to do the comparison with SPSS. With access I have no experience and can't help you here.

Edit: Your user account has accidentily been deleted during my "spam cleaning" process this night Embarassed . If you want to reply you have to register again... Sorry for that.

Regards

Patrick
Nach oben
rubicond1



Anmeldedatum: 12.08.2007
Beiträge: 1

BeitragVerfasst am: 12.08.2007, 04:19    Titel:

Thank you very much (I re-registered).

What 'newer versions' are you talking about? I have SPSS 13, but it seems to me that I can't input different sheets of the same excel file. Are you talking about SPSS 14, or should I look harder to figure out how to do it with SPSS 13?

Thank you very much for your help!
Nach oben
administrator
Site Admin


Anmeldedatum: 17.01.2006
Beiträge: 48

BeitragVerfasst am: 12.08.2007, 07:03    Titel:

I don't know if its possible to import single sheets but I dont't think so. You can try to export into different files and import them one after another.

The best way is maybe to export your sheets to .csv files, merge that files into one big file and import that one into spss. Variables have to be the same in every sheet of course.
Nach oben
bannerwerbung statistik-tutorial.de-Anzeige-
Anzeigen:Statistik und SPSS: BücherStatistik für DummiesSPSS für Dummies
Beiträge der letzten Zeit anzeigen:   
Neues Thema eröffnen   Neue Antwort erstellen    Statistik-Tutorial Forum Foren-Übersicht -> SPSS-Forum Alle Zeiten sind GMT
Seite 1 von 1

 
Gehe zu:  
Sie können keine Beiträge in dieses Forum schreiben.
Sie können auf Beiträge in diesem Forum nicht antworten.
Sie können Ihre Beiträge in diesem Forum nicht bearbeiten.
Sie können Ihre Beiträge in diesem Forum nicht löschen.
Sie können an Umfragen in diesem Forum nicht teilnehmen.


Powered by phpBB © 2001, 2005 phpBB Group
Deutsche Übersetzung von phpBB.de
   Impressum