Q1: (50 points) Based on the data file "DanoPizza_assign2.xIsx" and survey questionnaire "DanoPizza_survey.pdf", please respond with the following for each variable Edu, Pizza_Freq, Age, satis_food, Gender, Income, LikeRecom 1. 10 points Look at the data file and the survey file, and then identify how the following variables have been coded. For each of these variables you are supposed to provide the numerical representation of each of the response categories. Edu: Pizza_Freq: Age: satis_food: . Gender: . Income: . LikeRecom: 2. 10 points Using NOIR classification, identify and note data type for each of the following variables. Edu: . Pizza_Freq: Age: satis food: . Gender: Income: LikeRecom:3. 30 points Please provide the most suitable descriptive analyses (measures of central tendency and dispersion) one could use for the variables mentioned in the table below. (Remember that the type of descriptive analyses depends on data type - so refer to your responses to Part 2 of this question to answer this question) Central Computed Dispersion Computed Tendency Value of the measure value of the measure selected selected Variable central dispersion tendency measure measure Edu Pizza_Freq Age satis_food Gender Income LikeRecom Q2: (30 points) Now create a new variable by splitting age into the following three categories: 25 or below, 26-35, and 36 or above. Then create a bar chart that shows the number of respondents for each age group category (i.e., 25 or below, 26-35, and 36 or above). Please present the histogram below. Which age group has the highest number of respondents/observations