note :Do not merge Solve for each column separately And the solution is in Word

Submission Date: 25/3/2021 (Thursday) Subject: Selected Topics (439 ISM) Exploratory Data Analysis Name: ID: Instructions: 1. Late submission of assignment will be mark as absent. 2. I will not accept any assignment in course message, watsapp and Gmail account. 3. Submit assignment through assignment links only. 4. If you have any problem in assignment or its submission contact with me through Mail before closing date. Use the following data set to calculate the measures that follow. Student id Semester (50%) Final (50%) Total mark 1. 47 44 91 2. 46 39 85 44 33 3. 4. 40 33 77 73 95 70 5. 48 42 47 28 6. 7. 48 47 95 42 82 8. 9. 10. 40 44 38 82 39 36 75 For semester, final and total marks, calculate the following metrics. 1. Mean 2. Median 3. Mode 4. Variance 5. Standard deviation