Introduction to SPSS for Quantitative Analysis

profileJoshuaah
RES-831-RS-ExampleIntroSPSSAssignment.docx

College of Doctoral Studies

RES-831 Example: Introduction to SPSS for Quantitative Analysis

This is for example purposes only. The questions below have been modified so they do not exactly match what is in the actual assignment. The number of variables and the data are not identical to your data set for Census.sav; this example is for illustrative purposes only. Note that appropriate tables and charts are copied from the SPSS output into the Word document under each question to support the written answer. This is how statistical results are reported and then supported with the data in the results sections of dissertations and journal articles.

Learning Activity 3.9 – Example Solution 1. Run the Frequencies procedure on the following variable: race. What is the scale of measurement for this variable? Request appropriate summary statistics and charts.

Answer: Variable “race” is categorical” and the summary table below provides the frequency for each race and the associated visual pie chart for categories.

RACE OF RESPONDENT

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

WHITE

1559

77.1

77.1

77.1

BLACK

281

13.9

13.9

91.0

OTHER

183

9.0

9.0

100.0

Total

2023

100.0

100.0

2. For the variable “race” is it appropriate to use the median? What conclusions can you draw about the distributions of this variable?

Answer: This variable is categorical, so median is not a good summary statistic to use. This variable is not normally distributed

3. What percent of respondents were living with their both mother and father with they were 16 years old?

Answer: 68.0% of respondents were living with both their mother and father when they were 16 years old, as highlighted in the table and bar chart below.

LIVING WITH PARENTS WHEN 16 YRS OLD

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

OTHER

67

3.3

3.3

3.3

MOTHER & FATHER

1375

68.0

68.0

71.3

FATHER & STPMOTHER

25

1.2

1.2

72.5

MOTHER & STPFATHER

119

5.9

5.9

78.4

FATHER

50

2.5

2.5

80.9

MOTHER

300

14.8

14.8

95.7

MALE RELATIVE

12

.6

.6

96.3

FEMALE RELATIVE

36

1.8

1.8

98.1

M AND F RELATIVES

39

1.9

1.9

100.0

Total

2023

100.0

100.0

Copy/Paste and Insert the Full SPSS Output for this assignment here. See Example Below:

This is what the output in SPSS looks like:

Click on the Edit tab, and then “Select All”. After you select all, then click on the “Copy” button. This will allow you to select your entire output and then copy it to your computer clipboard. Then open a new word document and “Paste” the output into your word document. You may have to “Paste Special” depending on your version of Word. Scroll down to see what the output will look like in word.

Output in Word using the following sequence

1. In SPSS: After you run your analysis and the output comes up then click Edit>Select All>Copy

2. Then In Word, in a new document, click past and your output will show up below.

GET

FILE='C:\Users\Cynthia\Downloads\Drinks (2).sav'.

DATASET NAME DataSet1 WINDOW=FRONT.

FREQUENCIES VARIABLES=price cost calories sodium alcohol

/STATISTICS=STDDEV VARIANCE MINIMUM MAXIMUM MEAN MEDIAN MODE

/HISTOGRAM NORMAL

/ORDER=ANALYSIS.

Frequencies

Notes

Output Created

19-JAN-2015 19:07:34

Comments

Input

Data

C:\Users\Cynthia\Downloads\Drinks (2).sav

Active Dataset

DataSet1

File Label

SPSS/PC+

Filter

<none>

Weight

<none>

Split File

<none>

N of Rows in Working Data File

35

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=price cost calories sodium alcohol

/STATISTICS=STDDEV VARIANCE MINIMUM MAXIMUM MEAN MEDIAN MODE

/HISTOGRAM NORMAL

/ORDER=ANALYSIS.

Resources

Processor Time

00:00:02.12

Elapsed Time

00:00:01.92

[DataSet1] C:\Users\Cynthia\Downloads\Drinks (2).sav

Statistics

Price per 6-pack

Cost per 12 Fluid Ounces

Calories per 12 Fluid Ounces

Sodium per 12 Fluid Ounces in mg

Alcohol by Volume (in %)

N

Valid

35

35

35

35

35

Missing

0

0

0

0

0

Mean

3.0274

.5057

139.77

14.66

4.5771

Median

2.6500

.4400

147.00

15.00

4.7000

Mode

2.59

.43

144

7a

4.70

Std. Deviation

1.12343

.18732

24.447

6.145

.60298

Variance

1.262

.035

597.652

37.761

.364

Minimum

1.59

.27

68

6

2.30

Maximum

7.19

1.20

175

27

5.50

a. Multiple modes exist. The smallest value is shown

Frequency Table

Price per 6-pack

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

1.59

1

2.9

2.9

2.9

1.69

1

2.9

2.9

5.7

1.79

2

5.7

5.7

11.4

2.15

1

2.9

2.9

14.3

2.29

2

5.7

5.7

20.0

2.39

1

2.9

2.9

22.9

2.49

2

5.7

5.7

28.6

2.55

1

2.9

2.9

31.4

2.59

5

14.3

14.3

45.7

2.63

1

2.9

2.9

48.6

2.65

2

5.7

5.7

54.3

2.73

1

2.9

2.9

57.1

2.75

1

2.9

2.9

60.0

2.79

1

2.9

2.9

62.9

2.89

1

2.9

2.9

65.7

2.99

2

5.7

5.7

71.4

3.15

1

2.9

2.9

74.3

3.35

1

2.9

2.9

77.1

3.65

1

2.9

2.9

80.0

4.22

1

2.9

2.9

82.9

4.39

1

2.9

2.9

85.7

4.55

1

2.9

2.9

88.6

4.59

2

5.7

5.7

94.3

4.75

1

2.9

2.9

97.1

7.19

1

2.9

2.9

100.0

Total

35

100.0

100.0

Cost per 12 Fluid Ounces

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

.27

1

2.9

2.9

2.9

.28

1

2.9

2.9

5.7

.30

2

5.7

5.7

11.4

.36

1

2.9

2.9

14.3

.38

2

5.7

5.7

20.0

.40

1

2.9

2.9

22.9

.42

2

5.7

5.7

28.6

.43

6

17.1

17.1

45.7

.44

3

8.6

8.6

54.3

.46

2

5.7

5.7

60.0

.47

1

2.9

2.9

62.9

.48

1

2.9

2.9

65.7

.50

2

5.7

5.7

71.4

.53

1

2.9

2.9

74.3

.56

1

2.9

2.9

77.1

.61

1

2.9

2.9

80.0

.70

1

2.9

2.9

82.9

.73

1

2.9

2.9

85.7

.76

1

2.9

2.9

88.6

.77

2

5.7

5.7

94.3

.79

1

2.9

2.9

97.1

1.20

1

2.9

2.9

100.0

Total

35

100.0

100.0

Calories per 12 Fluid Ounces

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

68

1

2.9

2.9

2.9

72

1

2.9

2.9

5.7

97

1

2.9

2.9

8.6

99

1

2.9

2.9

11.4

102

1

2.9

2.9

14.3

113

1

2.9

2.9

17.1

135

1

2.9

2.9

20.0

136

1

2.9

2.9

22.9

140

1

2.9

2.9

25.7

144

5

14.3

14.3

40.0

145

3

8.6

8.6

48.6

147

2

5.7

5.7

54.3

149

4

11.4

11.4

65.7

150

1

2.9

2.9

68.6

151

1

2.9

2.9

71.4

152

2

5.7

5.7

77.1

153

1

2.9

2.9

80.0

154

2

5.7

5.7

85.7

155

1

2.9

2.9

88.6

157

1

2.9

2.9

91.4

162

1

2.9

2.9

94.3

170

1

2.9

2.9

97.1

175

1

2.9

2.9

100.0

Total

35

100.0

100.0

Sodium per 12 Fluid Ounces in mg

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

6

2

5.7

5.7

5.7

7

4

11.4

11.4

17.1

8

3

8.6

8.6

25.7

10

2

5.7

5.7

31.4

11

2

5.7

5.7

37.1

13

2

5.7

5.7

42.9

14

1

2.9

2.9

45.7

15

4

11.4

11.4

57.1

17

4

11.4

11.4

68.6

18

2

5.7

5.7

74.3

19

3

8.6

8.6

82.9

21

1

2.9

2.9

85.7

23

1

2.9

2.9

88.6

24

2

5.7

5.7

94.3

27

2

5.7

5.7

100.0

Total

35

100.0

100.0

Alcohol by Volume (in %)

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

2.30

1

2.9

2.9

2.9

2.90

1

2.9

2.9

5.7

3.70

1

2.9

2.9

8.6

4.10

1

2.9

2.9

11.4

4.20

2

5.7

5.7

17.1

4.30

1

2.9

2.9

20.0

4.40

1

2.9

2.9

22.9

4.50

2

5.7

5.7

28.6

4.60

4

11.4

11.4

40.0

4.70

9

25.7

25.7

65.7

4.90

4

11.4

11.4

77.1

5.00

5

14.3

14.3

91.4

5.10

1

2.9

2.9

94.3

5.20

1

2.9

2.9

97.1

5.50

1

2.9

2.9

100.0

Total

35

100.0

100.0

Histogram

© 2020. Grand Canyon University. All Rights Reserved.