0% found this document useful (0 votes)
7 views36 pages

SPSS Data Import and Analysis Guide

The document contains SPSS commands for data manipulation, including loading datasets and altering variable types. It reports errors related to file access and execution commands due to missing or incorrectly specified files. Additionally, it provides frequency statistics for demographic variables such as age, gender, occupation, and income from a dataset with 200 valid entries.

Uploaded by

183099
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
7 views36 pages

SPSS Data Import and Analysis Guide

The document contains SPSS commands for data manipulation, including loading datasets and altering variable types. It reports errors related to file access and execution commands due to missing or incorrectly specified files. Additionally, it provides frequency statistics for demographic variables such as age, gender, occupation, and income from a dataset with 200 valid entries.

Uploaded by

183099
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd

GET

FILE='C:\Users\Rishi\Downloads\[Link]'.

Warning # 5281. Command name: GET FILE


SPSS Statistics is running in Unicode encoding mode. This file is encoded in
a locale-specific (code page) encoding. The defined width of any string
variables are automatically tripled in order to avoid possible data loss.
You
can use ALTER TYPE to set the width of string variables to the width of the
longest observed value for each string variable.
ALTER TYPE ALL(A=AMIN).

Alter Type

Notes

Output Created 07-JUL-2025 22:06:26


Comments
Input Data C:\Users\Rishi\Downloads\
[Link]
Filter <none>
Weight <none>
Split File <none>
Syntax ALTER TYPE ALL(A=AMIN).
Resources Processor Time 00:00:00.02

Elapsed Time 00:00:00.01

C:\Users\Rishi\Downloads\[Link]

Altered Types

Celebrity A60 AMIN

DATASET NAME DataSet1 WINDOW=FRONT.

GET DATA /TYPE=TXT


/FILE="C:\Users\Rishi\Downloads\ReadzGlobal_ConsumerSurvey_Responses_Final
(2).csv"
/ENCODING='Locale'
/DELCASE=LINE
/DELIMITERS=" ,"
/ARRANGEMENT=DELIMITED
/FIRSTCASE=1
/IMPORTCASE=ALL
/VARIABLES=
V1 A12
V2 A6
V3 A13
V4 A10
V5 A9
V6 A13
V7 A16
V8 A15
V9 A17
V10 A16
V11 A11
V12 A11
V13 A28
V14 A28
V15 A28
V16 A28
V17 A28
V18 A28
V19 A28
V20 A28
V21 A28
V22 A11
V23 A5
V24 A28
V25 A4
V26 A6
V27 A9
V28 A7
V29 A5
V30 A2
V31 A2
V32 A2
V33 A2
V34 A2
V35 A2
V36 A4
V37 A7
V38 A12
V39 A15
V40 A12
V41 A15
V42 A15
V43 A14
V44 A15
V45 A15
V46 A21
V47 A15
V48 A15
V49 A15
V50 A15
V51 A15
V52 A15
V53 A15
V54 A9
V55 A9
V56 A9
V57 A9
V58 A9.

Error. Command name: GET DATA


(2269) Failure opening file: C:\Users\Rishi\Downloads\
ReadzGlobal_ConsumerSurvey_Responses_Final (2).csv
Execution of this command stops.
CACHE.
EXECUTE.

Error # 105. Command name: EXECUTE


This command is not valid before a working file has been defined.
Execution of this command stops.
DATASET NAME DataSet2 WINDOW=FRONT.

GET DATA /TYPE=TXT


/FILE="C:\Users\Rishi\Downloads\ReadzGlobal_ConsumerSurvey_Responses_Final
(2).csv"
/ENCODING='Locale'
/DELCASE=LINE
/DELIMITERS=","
/QUALIFIER="'"
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES=
Age COMMA12.0
Gender A17
Occupation A13
Income A16
State F2.0
Subscribed A16
ReadingFrequency A10
PreferredFormat A4
IntentToSubscribe A18
PriceWillingness A17
ReadzGlobal A18
Magzter A28
KindleNewsstand A5
TimesGroupTOIPlus A28
GoogleNewsAppleNews F1.0
DirectPublisherWebsite F1.0
Other F1.0
Q1 F1.0
Q2 F1.0
Q3 F1.0
Q4 F1.0
Q5 F1.0
Q6 F1.0
Q7 F1.0
Q8 F1.0
Q9 F1.0
Q10 F1.0
Q11 F1.0
Q12 F1.0
Q13 F1.0
Q14 F1.0
Q15 F1.0
MissingFeature F1.0
ImprovementSuggestion F1.0
V35 A40
V36 A53
V37 A40
V38 A53.
CACHE.
EXECUTE.
DATASET NAME DataSet3 WINDOW=FRONT.
DATASET ACTIVATE DataSet1.
DATASET CLOSE DataSet3.
DATASET ACTIVATE DataSet2.
DATASET CLOSE DataSet1.
GET DATA /TYPE=XLSX
/FILE='C:\Users\Rishi\Downloads\ReadzGlobal_ConsumerSurvey_SPSSReady.xlsx'
/SHEET=name 'Sheet1'
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
EXECUTE.
DATASET NAME DataSet5 WINDOW=FRONT.
FREQUENCIES VARIABLES=Age Gender Occupation Income
/BARCHART FREQ
/ORDER=ANALYSIS.

Frequencies

Notes

Output Created 07-JUL-2025 22:57:10


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.
Cases Used Statistics are based on all cases with
valid data.
Syntax FREQUENCIES VARIABLES=Age
Gender Occupation Income
/BARCHART FREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:01.76

Elapsed Time 00:00:00.69

[DataSet5]

Statistics

Age Gender Occupation Income

N Valid 200 200 200 200

Missing 0 0 0 0

Frequency Table

Age

Cumulative
Frequency Percent Valid Percent Percent

Valid 18–24 72 36.0 36.0 36.0

25–34 50 25.0 25.0 61.0

35–44 40 20.0 20.0 81.0

45–54 21 10.5 10.5 91.5

55–64 12 6.0 6.0 97.5

65 and above 5 2.5 2.5 100.0

Total 200 100.0 100.0


Gender

Cumulative
Frequency Percent Valid Percent Percent

Valid Female 77 38.5 38.5 38.5

Male 111 55.5 55.5 94.0

Other 6 3.0 3.0 97.0

Prefer not to say 6 3.0 3.0 100.0

Total 200 100.0 100.0

Occupation

Cumulative
Frequency Percent Valid Percent Percent

Valid Employed 87 43.5 43.5 43.5

Homemaker 7 3.5 3.5 47.0

Retired 7 3.5 3.5 50.5

Self-employed 53 26.5 26.5 77.0

Student 46 23.0 23.0 100.0

Total 200 100.0 100.0

Income

Cumulative
Frequency Percent Valid Percent Percent

Valid ₹10,00,001 to ₹15,00,000 33 16.5 16.5 16.5

₹2,50,001 to ₹5,00,000 63 31.5 31.5 48.0

₹5,00,001 to ₹10,00,000 55 27.5 27.5 75.5

Above ₹15,00,000 6 3.0 3.0 78.5

Up to ₹2,50,000 43 21.5 21.5 100.0

Total 200 100.0 100.0


Bar Chart
FREQUENCIES VARIABLES=Age Gender Occupation Income
/BARCHART FREQ
/ORDER=ANALYSIS.
Frequencies

Notes

Output Created 07-JUL-2025 22:59:44


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.
Cases Used Statistics are based on all cases with
valid data.
Syntax FREQUENCIES VARIABLES=Age
Gender Occupation Income
/BARCHART FREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:00.77

Elapsed Time 00:00:00.44

Statistics

Age Gender Occupation Income

N Valid 200 200 200 200

Missing 0 0 0 0
Frequency Table
Age

Cumulative
Frequency Percent Valid Percent Percent

Valid 18–24 72 36.0 36.0 36.0

25–34 50 25.0 25.0 61.0

35–44 40 20.0 20.0 81.0

45–54 21 10.5 10.5 91.5

55–64 12 6.0 6.0 97.5

65 and above 5 2.5 2.5 100.0

Total 200 100.0 100.0

Gender

Cumulative
Frequency Percent Valid Percent Percent

Valid Female 77 38.5 38.5 38.5

Male 111 55.5 55.5 94.0

Other 6 3.0 3.0 97.0

Prefer not to say 6 3.0 3.0 100.0

Total 200 100.0 100.0

Occupation

Cumulative
Frequency Percent Valid Percent Percent

Valid Employed 87 43.5 43.5 43.5

Homemaker 7 3.5 3.5 47.0

Retired 7 3.5 3.5 50.5

Self-employed 53 26.5 26.5 77.0

Student 46 23.0 23.0 100.0

Total 200 100.0 100.0


Income

Cumulative
Frequency Percent Valid Percent Percent

Valid ₹10,00,001 to ₹15,00,000 33 16.5 16.5 16.5

₹2,50,001 to ₹5,00,000 63 31.5 31.5 48.0

₹5,00,001 to ₹10,00,000 55 27.5 27.5 75.5

Above ₹15,00,000 6 3.0 3.0 78.5

Up to ₹2,50,000 43 21.5 21.5 100.0

Total 200 100.0 100.0

Bar Chart
FREQUENCIES VARIABLES=Age Gender Occupation Income
/PIECHART PERCENT
/ORDER=ANALYSIS.
Frequencies

Notes

Output Created 07-JUL-2025 23:01:01


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.
Cases Used Statistics are based on all cases with
valid data.
Syntax FREQUENCIES VARIABLES=Age
Gender Occupation Income
/PIECHART PERCENT
/ORDER=ANALYSIS.
Resources Processor Time 00:00:00.75

Elapsed Time 00:00:00.43

Statistics

Age Gender Occupation Income

N Valid 200 200 200 200

Missing 0 0 0 0

Frequency Table

Age
Cumulative
Frequency Percent Valid Percent Percent

Valid 18–24 72 36.0 36.0 36.0

25–34 50 25.0 25.0 61.0

35–44 40 20.0 20.0 81.0

45–54 21 10.5 10.5 91.5

55–64 12 6.0 6.0 97.5

65 and above 5 2.5 2.5 100.0

Total 200 100.0 100.0

Gender

Cumulative
Frequency Percent Valid Percent Percent

Valid Female 77 38.5 38.5 38.5

Male 111 55.5 55.5 94.0

Other 6 3.0 3.0 97.0

Prefer not to say 6 3.0 3.0 100.0

Total 200 100.0 100.0

Occupation

Cumulative
Frequency Percent Valid Percent Percent

Valid Employed 87 43.5 43.5 43.5

Homemaker 7 3.5 3.5 47.0

Retired 7 3.5 3.5 50.5

Self-employed 53 26.5 26.5 77.0

Student 46 23.0 23.0 100.0

Total 200 100.0 100.0

Income

Cumulative
Frequency Percent Valid Percent Percent
Valid ₹10,00,001 to ₹15,00,000 33 16.5 16.5 16.5

₹2,50,001 to ₹5,00,000 63 31.5 31.5 48.0

₹5,00,001 to ₹10,00,000 55 27.5 27.5 75.5

Above ₹15,00,000 6 3.0 3.0 78.5

Up to ₹2,50,000 43 21.5 21.5 100.0

Total 200 100.0 100.0

Pie Chart
FREQUENCIES VARIABLES=Age Gender Occupation Income
/PIECHART PERCENT
/FORMAT=AFREQ
/ORDER=ANALYSIS.

Frequencies

Notes

Output Created 07-JUL-2025 23:01:38


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.
Cases Used Statistics are based on all cases with
valid data.
Syntax FREQUENCIES VARIABLES=Age
Gender Occupation Income
/PIECHART PERCENT
/FORMAT=AFREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:00.50

Elapsed Time 00:00:00.42

Statistics

Age Gender Occupation Income

N Valid 200 200 200 200

Missing 0 0 0 0

Frequency Table

Age

Cumulative
Frequency Percent Valid Percent Percent

Valid 65 and above 5 2.5 2.5 2.5

55–64 12 6.0 6.0 8.5

45–54 21 10.5 10.5 19.0

35–44 40 20.0 20.0 39.0


25–34 50 25.0 25.0 64.0

18–24 72 36.0 36.0 100.0

Total 200 100.0 100.0

Gender

Cumulative
Frequency Percent Valid Percent Percent

Valid Other 6 3.0 3.0 3.0

Prefer not to say 6 3.0 3.0 6.0

Female 77 38.5 38.5 44.5

Male 111 55.5 55.5 100.0

Total 200 100.0 100.0

Occupation

Cumulative
Frequency Percent Valid Percent Percent

Valid Homemaker 7 3.5 3.5 3.5

Retired 7 3.5 3.5 7.0

Student 46 23.0 23.0 30.0

Self-employed 53 26.5 26.5 56.5

Employed 87 43.5 43.5 100.0

Total 200 100.0 100.0

Income

Cumulative
Frequency Percent Valid Percent Percent

Valid Above ₹15,00,000 6 3.0 3.0 3.0

₹10,00,001 to ₹15,00,000 33 16.5 16.5 19.5

Up to ₹2,50,000 43 21.5 21.5 41.0

₹5,00,001 to ₹10,00,000 55 27.5 27.5 68.5

₹2,50,001 to ₹5,00,000 63 31.5 31.5 100.0

Total 200 100.0 100.0


Pie Chart
DESCRIPTIVES VARIABLES=Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15
/STATISTICS=MEAN STDDEV MIN MAX.

Descriptives

Notes

Output Created 07-JUL-2025 23:02:42


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User defined missing values are treated
as missing.
Cases Used All non-missing data are used.
Syntax DESCRIPTIVES VARIABLES=Q1 Q2
Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12
Q13 Q14 Q15
/STATISTICS=MEAN STDDEV MIN
MAX.
Resources Processor Time 00:00:00.02

Elapsed Time 00:00:00.00

Descriptive Statistics

N Minimum Maximum Mean Std. Deviation

Q1 200 2 5 3.87 .816


Q2 200 1 5 3.75 .843
Q3 200 1 5 3.83 .796
Q4 200 2 5 3.78 .844
Q5 200 2 5 3.68 .826
Q6 200 1 5 3.79 .836
Q7 200 2 5 3.82 .721
Q8 200 2 5 3.81 .839
Q9 200 1 5 3.78 .828
Q10 200 2 5 3.85 .809
Q11 200 1 5 3.77 .930
Q12 200 2 5 3.72 .862
Q13 200 2 5 3.77 .802
Q14 200 2 5 3.75 .843
Q15 200 1 5 3.80 .908
Valid N (listwise) 200

DESCRIPTIVES VARIABLES=Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15


/STATISTICS=MEAN STDDEV MIN MAX KURTOSIS SKEWNESS.
Descriptives

Notes

Output Created 07-JUL-2025 23:03:39


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User defined missing values are treated
as missing.
Cases Used All non-missing data are used.
Syntax DESCRIPTIVES VARIABLES=Q1 Q2
Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12
Q13 Q14 Q15
/STATISTICS=MEAN STDDEV MIN
MAX KURTOSIS SKEWNESS.
Resources Processor Time 00:00:00.00

Elapsed Time 00:00:00.00

Descriptive Statistics

Minimu Maximu Std.


N m m Mean Deviation Skewness

Std.
Statistic Statistic Statistic Statistic Statistic Statistic Error

Q1 200 2 5 3.87 .816 -.204 .172


Q2 200 1 5 3.75 .843 -.311 .172
Q3 200 1 5 3.83 .796 -.288 .172
Q4 200 2 5 3.78 .844 -.132 .172
Q5 200 2 5 3.68 .826 -.033 .172
Q6 200 1 5 3.79 .836 -.264 .172
Q7 200 2 5 3.82 .721 .123 .172
Q8 200 2 5 3.81 .839 -.206 .172
Q9 200 1 5 3.78 .828 -.321 .172
Q10 200 2 5 3.85 .809 -.400 .172
Q11 200 1 5 3.77 .930 -.311 .172
Q12 200 2 5 3.72 .862 -.102 .172
Q13 200 2 5 3.77 .802 -.140 .172
Q14 200 2 5 3.75 .843 -.362 .172
Q15 200 1 5 3.80 .908 -.407 .172
Valid N
200
(listwise)

Descriptive Statistics

Kurtosis

Statistic Std. Error

Q1 -.630 .342
Q2 .062 .342
Q3 -.027 .342
Q4 -.700 .342
Q5 -.603 .342
Q6 -.238 .342
Q7 -.745 .342
Q8 -.621 .342
Q9 -.106 .342
Q10 -.211 .342
Q11 -.582 .342
Q12 -.714 .342
Q13 -.507 .342
Q14 -.368 .342
Q15 -.390 .342
Valid N (listwise)

CROSSTABS
/TABLES=Age BY IntentToSubscribe
/FORMAT=AVALUE TABLES
/STATISTICS=CHISQ
/CELLS=COUNT COLUMN
/COUNT ROUND CELL
/BARCHART.
Crosstabs

Notes

Output Created 07-JUL-2025 23:14:24


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.
Cases Used Statistics for each table are based on all
the cases with valid data in the
specified range(s) for all variables in
each table.
Syntax CROSSTABS
/TABLES=Age BY IntentToSubscribe
/FORMAT=AVALUE TABLES
/STATISTICS=CHISQ
/CELLS=COUNT COLUMN
/COUNT ROUND CELL
/BARCHART.
Resources Processor Time 00:00:00.19

Elapsed Time 00:00:00.13

Dimensions Requested 2

Cells Available 524245

Case Processing Summary

Cases

Valid Missing Total


N Percent N Percent N Percent

Age * IntentToSubscribe 200 100.0% 0 0.0% 200 100.0%

Age * IntentToSubscribe Crosstabulation

IntentToSubscribe

Maybe No Yes Total

Age 18–24 Count 28 12 32 72

% within IntentToSubscribe 32.6% 38.7% 38.6% 36.0%

25–34 Count 24 6 20 50

% within IntentToSubscribe 27.9% 19.4% 24.1% 25.0%

35–44 Count 15 9 16 40

% within IntentToSubscribe 17.4% 29.0% 19.3% 20.0%

45–54 Count 13 2 6 21

% within IntentToSubscribe 15.1% 6.5% 7.2% 10.5%

55–64 Count 5 0 7 12

% within IntentToSubscribe 5.8% 0.0% 8.4% 6.0%

65 and above Count 1 2 2 5

% within IntentToSubscribe 1.2% 6.5% 2.4% 2.5%


Total Count 86 31 83 200

% within IntentToSubscribe 100.0% 100.0% 100.0% 100.0%

Chi-Square Tests

Asymptotic
Significance (2-
Value df sided)

Pearson Chi-Square 11.091a 10 .350


Likelihood Ratio 12.274 10 .267
N of Valid Cases 200

a. 6 cells (33.3%) have expected count less than 5. The minimum


expected count is .78.
MULT RESPONSE GROUPS=$platformUsed (readzglobal magzter kindlenewsstand
timesgrouptoiplus
googlenewsapplenews directpublisherwebsite other (1))
/FREQUENCIES=$platformUsed.

Multiple Response

Notes

Output Created 07-JUL-2025 23:18:32


Comments
Input Active Dataset DataSet5
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
200
File
Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.
Cases Used Statistics for each table are based on all
the cases with valid data in the
specified range(s) for all variables in
each table.
Syntax MULT RESPONSE
GROUPS=$platformUsed (readzglobal
magzter kindlenewsstand
timesgrouptoiplus
googlenewsapplenews
directpublisherwebsite other (1))
/FREQUENCIES=$platformUsed.
Resources Processor Time 00:00:00.00

Elapsed Time 00:00:00.00

Case Summary

Cases

Valid Missing Total

N Percent N Percent N Percent


a
$platformUsed 185 92.5% 15 7.5% 200 100.0%

a. Dichotomy group tabulated at value 1.

$platformUsed Frequencies

Responses Percent of
N Percent Cases

$platformUseda Readz Global 46 11.3% 24.9%

Magzter 67 16.4% 36.2%

Kindle Newsstand 55 13.5% 29.7%


Times Group / TOI Plus 43 10.5% 23.2%

Google News / Apple News 68 16.7% 36.8%

Direct Publisher Website 59 14.5% 31.9%

Other 70 17.2% 37.8%


Total 408 100.0% 220.5%

a. Dichotomy group tabulated at value 1.

You might also like