DATA MANAGEMENT Assignment 5 Develop a data analysis using spss for eMobilis a tech company in the world that offer IT services. The nal document should be saved in pdf format. Students GENDE Attendanc Assignme Projec Total 2 3 4 5 6 62 7 62 8 75 9 50 10 75 11 70 12 71 13 67 14 Male Absent 60 15 0015 56 16 0015 49 17 0017 50 18 0013 75 This shows the exam scores for a class of mentees each mentee has a percentage mark for Assignment added to attendance to sum up 75% and the project 25%. Compute a new variable, named total, to calculate their total score out of 100. 1. We wish to compute the average (mean) mark over the two marks for each student. Compute a new variable, average, calculating this information. 2. Create the following value labels for the Attendance variable: 3. 5. 6. 1 =Present 2 = Absent Create a Frequencies command with a bar chart to find the following: o The highest and the lowest score. a How many subjects are male, and how many female? 0 What percentage of respondents are female (gender)? Create a Frequencies command for the two hormone level variables (i.e. before and after). Include the following in the output: 0 Do not display the actual frequency tables. 0 A histogram with a normal curve superimposed for each variable. 0 Produce values for the mean, mode and median from the total. Generate a line graph to assess the mentor's satisfaction levels given the graduation score is 80%. Generate a boxplot to explore the distribution of scores of all the mentees. Total Marks: 5