The following is a description of the variables in the "Census" Sheet: Column Variable Name Description of Variable 1 City Name of City 2 Group Household total income group 3 Count The total number of households in a particular income group The data for Column 1 to 3 were obtained for the year 2015 from Statistics Canada Website, httpsffwww12.statcangc.cafcensusrecensementhO15r'dppdfdttdiindexeng.c:n. The website offers census data for the year 2015 (even though the Census was conducted in 2016). The following is a description of the variables in the "Sample" Sheet: Column Variable Name Description of Variable 1 Household The household number 2 City Name of City where the household lives 3 Income The household total income group the household belongs to. Answer the following questions using the data: 1. According to the Census data in 2015 provided by Statistics Canada: they have divided the income groups into 20 different income groups? but since the marketing company is only interested in observing the distribution of 3 income groups (group 1: households with income under $50,000; group 2: households with income between $50,000 and $99.999; group 3: households with income $100,000 and overL a) nd the distribution of the 3 income groups for Edmonton? Comment briey. 13-) nd the distribution of the 3 income groups for Calgary? Comment briey. c) Compare the two cities' distributions. 2. Looking at the study design1 can you generalize the results of the study to Edmonton andfor Calgary? Explain briey. Now let's discuss the data in the \"Sample" Sheet Identify the identier variable: comment briey. What is (are) categorical and numerical variable(s) in the data, if any? 3. Using the "Sample" Sheet. you will use the PivotTable Motion to create 'equency tables (showing both frequency and relative frequency) to summarize the distribution of income groups for households in Edmonton. 3) Obtain the appropriate relative frequency table to answer the question. Paste the table into your report. Comment briey on the distribution. Is the distribution of household income groups in Edmonton uniform? Compare this sample distribution with the distribution of the 3 income groups for Edmonton in the census 'om question 1a. Tips: Use the Pivot Tobie feature to obtain both the frequency and relative frequency column