it is on excel i have excel data please help me

H Centennial College 12. From the frequency table generated for each categorical variable, Course: Introduction to Quantitative Research Methods determine the mode. Course Code: INTD 718 13. Generate cross tables for each pair of categorical variables. Session: January- April 2023 14. After adding a filter to the crosstabs generated. Instructor: Waldo Beausejour C. Computing summary statistics In-Class assignment/Home assignment: 15. Calculate the central tendency measures for each variable: mean, A. Getting to know the data and the variables of the data set. median, and mode. 1. Rename the sheet: "Survey data" 16. Calculate the spread for each variable: variance, standard deviation, and 2. Determine the number of variables in the dataset. range 3. Determine the number of observations contained in the dataset. 17. For each quantitative variable, provide the summary statistics (using data 4. What are the quantitative and qualitative variables? analysis tab} 5. Identify the variables that are measured on a ratio scale, interval scale, ordinal 18 Calculate the covariance and correlation between each pair of scale, and nominal scale. quantitative variables. 6. What are the categories of the variable "Sex_Household_Head", 19. Generate an ordinal variable for age and income: "age_range", Marital_Status_Head_Household income_range. 7. How many categories does the variable Educ_level_Household Head have? 20. Generate a crosstab for age_range and income range. Can you calculate Primary_income_source? the correlation between these two variables? Why? 8. For each variable, insert a note to describe the variable. 9. Sort the data household size (ascending order) 10. Sort the data by education level. B. Exploring the distribution of each variable 11. Generate a frequency table for each categorical variable