SPSS Descriptive Statistics Assignment

SPSS DESCRIPTIVE 1

SPSS Descriptive Statistics Assignment

Deborah R. Davis

Liberty University

The purpose of this document is to provide a response to the first SPSS assignment, that for descriptive statistics. The research scenario was given as a part of the assignment, and presumes leaders of colleges and universities are seeking ways to develop and maintain online and blended programs (Szapkiw, 2014, p. 2). This particular assignment required the use of SPSS to “explore the data using measures of central tendency, measures of dispersion, and measures of relative position” (Szapkiw, 2014, p. 5).

Structure

In that there are four sections to this assignment and it is a small college paper, it will only use the first two levels of headings, and it will be separated by assignment section.

Results part 1

This particular assignment required elements to be presented from the data set provided. An SPSS analysis of the mean, median, standard deviation variance, and range for the perceived learning variable was performed.

Table 1.

Descriptive Statistics for the Perceived Learning Variable (N = 40)

M / median / SD / V / Range
37.43 / 42.5 / 13.864 / 192.199 / 42

Results part 2

The second part of the assignment was to use SPSS to formulate a histogram for this variable with purple bars and normal curve displayed. Being colorblind, acquiring purple bars was a trying ordeal, and the reality of the result may be curious.

Table 2.

Histogram for perceived learning variable with purple bars and normal curve displayed

Results part 3

The requirement for the third part represented some challenges as the various descriptive statistics were to be calculated considering gender. Also, the interquartile ranges were to be included. In these charts, note the total N = 40 which each subset is isolated.

Table 3a.

Descriptive Statistics for the Perceived Learning Variable (N = 40)

n / M / median / SD / V / Range
Females / 20 / 42.24 / 47.00 / 10.818 / 117.039 / 29
Males / 20 / 32.60 / 34.50 / 15.115 / 228.463 / 42

Table 3b.

Interquartile Ranges for Descriptive Statistics for the Perceived Learning Variable (N = 40)

n / 1st / 2nd / 3rd / 95%
Females / 20 / 29.75 / 47.00 / 50.75 / 54
Males / 20 / 16.50 / 34.50 / 46.50 / 53.90

Results part 4

The last piece of the assignment required the P10, P20, P30, P40, and P95 for total perceived learning variable and an interpretation of the meaning of P95.

Table 5.

Various Required Percentages for the Perceived Learning Variable (N = 40)

P10 / P20 / P30 / P40 / P95
16.00 / 22.60 / 27.00 / 33.20 / 54.00

To interpret the 95th percentile is to say that score is at or above 95 percent of the other scores in the distribution. Conversely, one could say that five percent of the distribution was a score above 54.00.

References

Szapkiw, A. (2014). Spss assignment instructions. In Lynchburg, VA: Liberty University. Retrieved from

Appendix

SPSS Output

GET

FILE='C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav'.

DATASET NAME DataSet1 WINDOW=FRONT.

FREQUENCIES VARIABLES=Perceived_CAP_Learning_Scale

/NTILES=4

/NTILES=10

/PERCENTILES=95.0

/STATISTICS=STDDEV VARIANCE RANGE MEAN MEDIAN MODE

/ORDER=ANALYSIS.

Frequencies

Notes
Output Created / 21-JAN-2014 13:23:37
Comments
Input / Data / C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav
Active Dataset / DataSet1
Filter / <none>
Weight / <none>
Split File / <none>
N of Rows in Working Data File / 40
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=Perceived_CAP_Learning_Scale
/NTILES=4
/NTILES=10
/PERCENTILES=95.0
/STATISTICS=STDDEV VARIANCE RANGE MEAN MEDIAN MODE
/ORDER=ANALYSIS.
Resources / Processor Time / 00:00:00.02
Elapsed Time / 00:00:00.08

[DataSet1] C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav

Statistics
Perceived_CAP_Learning_Scale
N / Valid / 40
Missing / 0
Mean / 37.43
Median / 42.50
Mode / 45
Std. Deviation / 13.864
Variance / 192.199
Range / 42
Percentiles / 10 / 16.00
20 / 22.60
25 / 25.50
30 / 27.00
40 / 33.20
50 / 42.50
60 / 46.20
70 / 48.00
75 / 50.00
80 / 50.80
90 / 53.00
95 / 54.00
Perceived_CAP_Learning_Scale
Frequency / Percent / Valid Percent / Cumulative Percent
Valid / 12 / 1 / 2.5 / 2.5 / 2.5
14 / 1 / 2.5 / 2.5 / 5.0
15 / 1 / 2.5 / 2.5 / 7.5
16 / 2 / 5.0 / 5.0 / 12.5
18 / 1 / 2.5 / 2.5 / 15.0
19 / 1 / 2.5 / 2.5 / 17.5
22 / 1 / 2.5 / 2.5 / 20.0
25 / 2 / 5.0 / 5.0 / 25.0
27 / 3 / 7.5 / 7.5 / 32.5
29 / 2 / 5.0 / 5.0 / 37.5
32 / 1 / 2.5 / 2.5 / 40.0
35 / 1 / 2.5 / 2.5 / 42.5
40 / 3 / 7.5 / 7.5 / 50.0
45 / 4 / 10.0 / 10.0 / 60.0
47 / 3 / 7.5 / 7.5 / 67.5
48 / 2 / 5.0 / 5.0 / 72.5
50 / 3 / 7.5 / 7.5 / 80.0
51 / 2 / 5.0 / 5.0 / 85.0
52 / 1 / 2.5 / 2.5 / 87.5
53 / 2 / 5.0 / 5.0 / 92.5
54 / 3 / 7.5 / 7.5 / 100.0
Total / 40 / 100.0 / 100.0

* Chart Builder.

GGRAPH

/GRAPHDATASET NAME="graphdataset" VARIABLES=Perceived_CAP_Learning_Scale MISSING=LISTWISE REPORTMISSING=NO

/GRAPHSPEC SOURCE=INLINE.

BEGIN GPL

SOURCE: s=userSource(id("graphdataset"))

DATA: Perceived_CAP_Learning_Scale=col(source(s), name("Perceived_CAP_Learning_Scale"))

GUIDE: axis(dim(1), label("Perceived_CAP_Learning_Scale"))

GUIDE: axis(dim(2), label("Frequency"))

ELEMENT: area(position(summary.count(bin.rect(Perceived_CAP_Learning_Scale))), missing.wings())

ELEMENT: line(position(density.normal(Perceived_CAP_Learning_Scale)), color("Normal"))

END GPL.

* Chart Builder.

GGRAPH

/GRAPHDATASET NAME="graphdataset" VARIABLES=Perceived_CAP_Learning_Scale MISSING=LISTWISE REPORTMISSING=NO

/GRAPHSPEC SOURCE=INLINE.

BEGIN GPL

SOURCE: s=userSource(id("graphdataset"))

DATA: Perceived_CAP_Learning_Scale=col(source(s), name("Perceived_CAP_Learning_Scale"))

GUIDE: axis(dim(1), label("Perceived_CAP_Learning_Scale"))

GUIDE: axis(dim(2), label("Frequency"))

ELEMENT: interval(position(summary.count(bin.rect(Perceived_CAP_Learning_Scale))), shape.interior(shape.square))

ELEMENT: line(position(density.normal(Perceived_CAP_Learning_Scale)), color("Normal"))

END GPL.

GGraph

Notes
Output Created / 21-JAN-2014 13:27:43
Comments
Input / Data / C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav
Active Dataset / DataSet1
Filter / <none>
Weight / <none>
Split File / <none>
N of Rows in Working Data File / 40
Syntax / GGRAPH
/GRAPHDATASET NAME="graphdataset" VARIABLES=Perceived_CAP_Learning_Scale MISSING=LISTWISE REPORTMISSING=NO
/GRAPHSPEC SOURCE=INLINE.
BEGIN GPL
SOURCE: s=userSource(id("graphdataset"))
DATA: Perceived_CAP_Learning_Scale=col(source(s), name("Perceived_CAP_Learning_Scale"))
GUIDE: axis(dim(1), label("Perceived_CAP_Learning_Scale"))
GUIDE: axis(dim(2), label("Frequency"))
ELEMENT: interval(position(summary.count(bin.rect(Perceived_CAP_Learning_Scale))), shape.interior(shape.square))
ELEMENT: line(position(density.normal(Perceived_CAP_Learning_Scale)), color("Normal"))
END GPL.
Resources / Processor Time / 00:00:00.30
Elapsed Time / 00:00:00.31

[DataSet1] C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav

USE ALL.

COMPUTE filter_$=(Sex = 1).

VARIABLE LABELS filter_$ 'Sex = 1 (FILTER)'.

VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.

FORMATS filter_$ (f1.0).

FILTER BY filter_$.

EXECUTE.

FREQUENCIES VARIABLES=Perceived_CAP_Learning_Scale

/NTILES=4

/NTILES=10

/PERCENTILES=95.0

/STATISTICS=STDDEV VARIANCE RANGE MEAN MEDIAN MODE

/ORDER=ANALYSIS.

Frequencies

Notes
Output Created / 21-JAN-2014 13:29:35
Comments
Input / Data / C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav
Active Dataset / DataSet1
Filter / Sex = 1 (FILTER)
Weight / <none>
Split File / <none>
N of Rows in Working Data File / 20
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=Perceived_CAP_Learning_Scale
/NTILES=4
/NTILES=10
/PERCENTILES=95.0
/STATISTICS=STDDEV VARIANCE RANGE MEAN MEDIAN MODE
/ORDER=ANALYSIS.
Resources / Processor Time / 00:00:00.00
Elapsed Time / 00:00:00.20

[DataSet1] C:\Users\Ken\Documents\liberty\educ712\SPSS_Assignment_Data_Set.sav

Statistics
Perceived_CAP_Learning_Scale
N / Valid / 20
Missing / 0
Mean / 42.25
Median / 47.00
Mode / 25a
Std. Deviation / 10.818
Variance / 117.039
Range / 29
Percentiles / 10 / 25.20
20 / 27.40
25 / 29.75
30 / 32.90
40 / 45.00
50 / 47.00
60 / 48.00
70 / 50.00
75 / 50.75
80 / 52.60
90 / 53.90
95 / 54.00
a. Multiple modes exist. The smallest value is shown
Perceived_CAP_Learning_Scale
Frequency / Percent / Valid Percent / Cumulative Percent
Valid / 25 / 2 / 10.0 / 10.0 / 10.0
27 / 2 / 10.0 / 10.0 / 20.0
29 / 1 / 5.0 / 5.0 / 25.0
32 / 1 / 5.0 / 5.0 / 30.0
35 / 1 / 5.0 / 5.0 / 35.0
45 / 2 / 10.0 / 10.0 / 45.0
47 / 2 / 10.0 / 10.0 / 55.0
48 / 2 / 10.0 / 10.0 / 65.0
50 / 2 / 10.0 / 10.0 / 75.0
51 / 1 / 5.0 / 5.0 / 80.0
53 / 2 / 10.0 / 10.0 / 90.0
54 / 2 / 10.0 / 10.0 / 100.0
Total / 20 / 100.0 / 100.0

USE ALL.

COMPUTE filter_$=(Sex = 2).

VARIABLE LABELS filter_$ 'Sex = 2 (FILTER)'.

VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.

FORMATS filter_$ (f1.0).

FILTER BY filter_$.

EXECUTE.