The following is a description of the variables in the "Census' Sheet: Column Variable Name Description of Variable 1 City Name of City Group Household total income group w t 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, https://www 12.statcan.gc.ca/census-recensement/2016/dp-pd/dt-td/index-eng.cfm . 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 Household The household number W N - City Name of City where the household lives 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 over), 1) find the distribution of the 3 income groups for Edmonton? Comment briefly. b ) find the distribution of the 3 income groups for Calgary? Comment briefly. Compare the two cities' distributions. 2. Looking at the study design, can you generalize the results of the study to Edmonton and/or Calgary? Explain briefly. Now let's discuss the data in the "Sample" Sheet. Identify the identifier variable, comment briefly. What is (are) categorical and numerical variable(s) in the data, if any? 3. Using the "Sample" Sheet, you will use the PivotTable function to create frequency tables (showing both frequency and relative frequency) to summarize the distribution of income groups for households in Edmonton. a) Obtain the appropriate relative frequency table to answer the question. Paste the table into your report. Comment briefly 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 from question la. Tips: Use the Pivot Table feature to obtain both the frequency and relative frequency column