Check the excel spreadsheet "Data set" variables comprising the data are as follows: Age Exam Marks (for a maximum of 100) Paper Marks (for a maximum of 100) Gender (M=Male, F=Female) Year in College Word document including the below requirements. Excel sheet for the data updated based on the below requirements. 1. Get the data ready for analysis a. Data Coding: Assign numbers to responses that are not in numerical form (Gender and year in college). Provide frame code in a separate word document. b. Data Entry: Update the excel sheet with the codes. c. Data Editing: Deal with illogical, inconsistent, or illegal data – if any. Deal with missing data – if any (provide detailed explanation how you managed to correct missing data). • IQ Requirements: You need to submit the following: 2. Get the feel of the data - Descriptive statistics a. Classify the scale type of each variable (Nominal, Ordinal, Interval, Ratio). b. For each of the variables, calculate the central tendency (mean or median, or mode), and dispersion (range or variance and standard deviation). c. Create a pie-chart for each of: i. Year in College ii. Gender d. Create a histogram for each of: i. IQ ii. Exam marks iii. Paper marks e. Make a scatter plot with IQ on the x-axis and exam grade on the y-axis. What do you conclude? f. Make a scatter plot with gender on the x-axis and IQ on the y-axis. What do you conclude? g. Compute the mean IQ for males and for females. Conclusion? 3. Choosing the right test - Inferential statistics Recommend the appropriate test to analyze the following questions: t-tests, ANOVA, Correlation, and Regression. Mention the test name for each question and your justification why you chose it a. Are there significant differences in the exam grade for men and women? b. Are there significant differences in the exam grade among students from different years in college? c. Is there a relationship between IQ and exam grades? Bonus 2% - construct a theoretical framework that best describes this data set Response R1 R2 R3 R4 R5 R6 R7 R8 R9 R10 R11 R12 R13 R14 R15 R16 R17 R18 R19 R20 R21 R22 R23 R24 Age HANNANNAAANNNN 21 19 23 21 21 20 26 26 30 21 19 17 19 35 27 21 27 21 21 19 32 19 Exam Marks 87 N/A 85 81 81 67 75 92 78 89 72 81 75 76 N/A 75 85 79 90 97 90 87 95 68 Paper Marks 83 80 86 75 N/A 68 88 78 92 95 80 65 77 85 83 60 80 75 93 95 N/A 86 90 57 Gender M M M F F F F F M F N/A M M F F F M M F M ΣΣΗΣυ M M F Year in College Sophomore Freshman N/A Freshman Junior Junior Sophomore Senior Senior Junior Freshman Sophomore Freshman N/A Junior Sophomore Junior Senior Junior Junior Sophomore Junior Sophomore Junior IQ 80 100 98 76 82 N/A 120 115 126 129 86 80 70 99 99 60 89 70 140 N/A 115 119 N/A 89