Data analysis in SPSS Paper - 3300 Words

Data analysis in SPSS (Statistics Project Sample) Content: Statistics: Data analysis in SPSSNameInstitutionActivity 01:Enter all data from the spreadsheet "Data for Assignment 2à ¢Ã¢â€š ¬Ã‚ into SPSS. You will need to set up the variable view with the following 11 variables and then enter the data in data view: * Student_ID, * Year_Enrolled, * HI001_Final_Exam, * HI001_Assignment_01, * HI001_Assignment_02, * HI002_Final_Exam, * HI002_Assignment_01, * HI002_Assignment_02, * HI003_Final_Exam, * HI003_Assignment_01, * HI003_Assignment_02.Activity 02: * Do a frequency table, histogram, normal Q à ¢Ã¢â€š ¬ Q and the de-trended normal Qà ¢Ã¢â€š ¬Q for each one of the 11 variables. * Frequency tablesTable 1Frequency table for the year of student enrolmentYear Enrolled Frequency Percent Valid Percent Cumulative Percent Valid 2012 30 30.6 30.6 30.6 2013 34 34.7 34.7 65.3 2014 34 34.7 34.7 100.0 Total 98 100.0 100.0 Table 2Frequency table for the student_IDStudent ID Frequency Percent Valid Percent Cumulative Percent Valid A 1 1.0 1.0 1.0 AA 1 1.0 1.0 2.0 AB 1 1.0 1.0 3.1 AC 1 1.0 1.0 4.1 AD 1 1.0 1.0 5.1 AE 1 1.0 1.0 6.1 AF 1 1.0 1.0 7.1 AG 1 1.0 1.0 8.2 AH 1 1.0 1.0 9.2 AI 1 1.0 1.0 10.2 AJ 1 1.0 1.0 11.2 AK 1 1.0 1.0 12.2 AL 1 1.0 1.0 13.3 AM 1 1.0 1.0 14.3 AN 1 1.0 1.0 15.3 AO 1 1.0 1.0 16.3 AP 1 1.0 1.0 17.3 AQ 1 1.0 1.0 18.4 AR 1 1.0 1.0 19.4 AS 1 1.0 1.0 20.4 AT 1 1.0 1.0 21.4 AU 1 1.0 1.0 22.4 AV 1 1.0 1.0 23.5 AW 1 1.0 1.0 24.5 AX 1 1.0 1.0 25.5 AY 1 1.0 1.0 26.5 AZ 1 1.0 1.0 27.6 B 1 1.0 1.0 28.6 BA 1 1.0 1.0 29.6 BB 1 1.0 1.0 30.6 BC 1 1.0 1.0 31.6 BD 1 1.0 1.0 32.7 BE 1 1.0 1.0 33.7 BF 1 1.0 1.0 34.7 BG 1 1.0 1.0 35.7 BH 1 1.0 1.0 36.7 BI 1 1.0 1.0 37.8 BJ 1 1.0 1.0 38.8 BK 1 1.0 1.0 39.8 BL 1 1.0 1.0 40.8 BM 1 1.0 1.0 41.8 BN 1 1.0 1.0 42.9 BO 1 1.0 1.0 43.9 BP 1 1.0 1.0 44.9 BQ 1 1.0 1.0 45.9 BR 1 1.0 1.0 46.9 BS 1 1.0 1.0 48.0 BT 1 1.0 1.0 49.0 BU 1 1.0 1.0 50.0 BV 1 1.0 1.0 51.0 BW 1 1.0 1.0 52.0 BX 1 1.0 1.0 53.1 BY 1 1.0 1.0 54.1 BZ 1 1.0 1.0 55.1 C 1 1.0 1.0 56.1 CA 1 1.0 1.0 57.1 CB 1 1.0 1.0 58.2 CC 1 1.0 1.0 59.2 CD 1 1.0 1.0 60.2 CE 1 1.0 1.0 61.2 CF 1 1.0 1.0 62.2 CG 1 1.0 1.0 63.3 CH 1 1.0 1.0 64.3 CI 1 1.0 1.0 65.3 CJ 1 1.0 1.0 66.3 CK 1 1.0 1.0 67.3 CL 1 1.0 1.0 68.4 CM 1 1.0 1.0 69.4 CN 1 1.0 1.0 70.4 CO 1 1.0 1.0 71.4 CP 1 1.0 1.0 72.4 CQ 1 1.0 1.0 73.5 CR 1 1.0 1.0 74.5 CS 1 1.0 1.0 75.5 CT 1 1.0 1.0 76.5 D 1 1.0 1.0 77.6 E 1 1.0 1.0 78.6 F 1 1.0 1.0 79.6 G 1 1.0 1.0 80.6 H 1 1.0 1.0 81.6 I 1 1.0 1.0 82.7 J 1 1.0 1.0 83.7 K 1 1.0 1.0 84.7 L 1 1.0 1.0 85.7 M 1 1.0 1.0 86.7 N 1 1.0 1.0 87.8 O 1 1.0 1.0 88.8 P 1 1.0 1.0 89.8 Q 1 1.0 1.0 90.8 R 1 1.0 1.0 91.8 S 1 1.0 1.0 92.9 T 1 1.0 1.0 93.9 U 1 1.0 1.0 94.9 V 1 1.0 1.0 95.9 W 1 1.0 1.0 96.9 X 1 1.0 1.0 98.0 Y 1 1.0 1.0 99.0 Z 1 1.0 1.0 100.0 Total 98 100.0 100.0 Table 3Frequency table for H1001_Final examHI001 FINAL EXAM à ¢Ã¢â€š ¬ (scores out of 50) Frequency Percent Valid Percent Cumulative Percent Val id 20 1 1.0 1.0 1.0 23 3 3.1 3.1 4.1 24 5 5.1 5.1 9.2 25 2 2.0 2.0 11.2 26 3 3.1 3.1 14.3 28 2 2.0 2.0 16.3 29 11 11.2 11.2 27.6 30 8 8.2 8.2 35.7 31 8 8.2 8.2 43.9 32 5 5.1 5.1 49.0 33 6 6.1 6.1 55.1 34 10 10.2 10.2 65.3 35 3 3.1 3.1 68.4 36 6 6.1 6.1 74.5 37 8 8.2 8.2 82.7 38 8 8.2 8.2 90.8 40 3 3.1 3.1 93.9 41 2 2.0 2.0 95.9 43 1 1.0 1.0 96.9 45 1 1.0 1.0 98.0 MC 2 2.0 2.0 100.0 Total 98 100.0 100.0 Table 4Frequency table for H1001_Assignment_01HI001 ASSIGNMENT 01 à ¢Ã¢â€š ¬ (scores out of 30) Frequency Percent Valid Percent Cumulative Percent Valid 8 1 1.0 1.0 1.0 10 1 1.0 1.0 2.0 14 2 2.0 2.0 4.1 15 9 9.2 9.2 13.3 16 18 18.4 18.4 31.6 17 19 19.4 19.4 51.0 18 32 32.7 32.7 83.7 19 7 7.1 7.1 90.8 20 5 5.1 5.1 95.9 21 2 2.0 2.0 98.0 22 2