Your temporary usage period for IBM SPSS Statistics will expire in 14 days.
NEW FILE.
DATASET NAME DataSet1 WINDOW=FRONT.
GET DATA /TYPE=XLSX /FILE='C:\Users\Sarah73\Desktop\Holmes\Statistic\DATA for Assignment 02.xlsx' /SHEET=name 'Sheet1' /CELLRANGE=full /READNAMES=on /ASSUMEDSTRWIDTH=32767.
EXECUTE.
DATASET NAME DataSet2 WINDOW=FRONT.
SAVE OUTFILE='C:\Users\Sarah73\Desktop\Untitled3.sav' /COMPRESSED.
FREQUENCIES VARIABLES=HI001FINALEXAM HI001ASSIGNMENT01 HI001ASSIGNMENT02 HI002FINALEXAM HI002ASSIGNMENT01 HI002ASSIGNMENT02 HI003ASSIGNMENT02 /STATISTICS=STDDEV MINIMUM MAXIMUM MEAN /ORDER=ANALYSIS.
Frequencies
Notes
Output Created
22-JAN-2015 18:13:57
Comments
Input
Data
C:\Users\Sarah73\Desktop\Untitled3.sav
Active Dataset
DataSet2
Filter
<none>
Weight
<none>
Split File
<none>
N of Rows in Working Data File
98
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=HI001FINALEXAM HI001ASSIGNMENT01 HI001ASSIGNMENT02 HI002FINALEXAM HI002ASSIGNMENT01 HI002ASSIGNMENT02 HI003ASSIGNMENT02 /STATISTICS=STDDEV MINIMUM MAXIMUM MEAN /ORDER=ANALYSIS.
Resources
Processor Time
00:00:00.03
Elapsed Time
00:00:00.04
[DataSet2] C:\Users\Sarah73\Desktop\Untitled3.sav
Statistics
HI001 FINAL EXAM
HI001 ASSIGNMENT 01
HI001 ASSIGNMENT 02
HI002 FINAL EXAM
HI002 ASSIGNMENT 01
N
Valid
98
98
98
98
98
Missing
0
0
0
0
0
Mean
31.43
17.21
15.46
26.50
17.82
Std. Deviation
7.472
1.991
2.312
5.910
3.441
Minimum
0
8
8
0
4
Maximum
45
22
21
40
22
Statistics
HI002 ASSIGNMENT 02
HI003 ASSIGNMENT 02
N
Valid
98
98
Missing
0
0
Mean
12.42
13.54
Std. Deviation
1.989
1.760
Minimum
4
8
Maximum
16
20
Frequency Table
HI001 FINAL EXAM
Frequency
Percent
Valid Percent
Cumulative Percent
Valid
0
3
3.1
3.1
3.1
20
1
1.0
1.0
4.1
23
3
3.1
3.1
7.1
24
5
5.1
5.1
12.2
25
2
2.0
2.0
14.3
26
3
3.1